You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline?（）A、response times for frequently used queriesB、database b

第1题：

You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）  

• A、 V$SYSSTAT
• B、 V$SESSSTAT
• C、 V$RSRC_PLAN
• D、 V$RSRC_CONSUMER_GROUP

第2题：

You are a database administrator for your company. The company runs a popular database-driven Web site against a SQL Server 2005 computer named SQL2. You need to ensure a quick response time and appropriate audit trail in the event that SQL2 experiences excessive traffic due to denial-of-service （DoS） attacks. Which two actions should you perform？（）

• A、Create a new performance alert to monitor the Current Bandwidth counter.
• B、Create a new performance alert to monitor the Bytes Total/sec counter.
• C、Configure the new performance alert to start a SQL Server Profiler trace.
• D、Configure the new performance alert to start a Network Monitor capture.

第3题：

You have created a baseline metric， DISK_IO_BL， for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics？（）

• A、The baseline， once created， cannot be removed.
• B、Disable the baseline metrics in the Database Control Manage Metrics page.
• C、The baseline will be automatically removed once the database performance has been optimized.
• D、Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.

第4题：

You need to recommend a monitoring solution for the file servers in the main office. The solution must meet the company’s technical requirements.    What should you include in the recommendation？（）

• A、File Server Resource Manager （FSRM） active file screens
• B、File Server Resource Manager （FSRM） passive file screens
• C、Performance Monitor alerts
• D、Performance Monitor logs

第5题：

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. After a regular test, you find that performance degradation is experienced by an instance for the three reasons: Excessive CPU usage, Server processes paging and Deadlocks. A monitoring solution should be implemented to provide data, monitor and troubleshoot performance issues. And detailed deadlock information should be contained in the provided data. You should utilize the least amount of administrative effort to finish the task.    Which tool will you utilize to finish the task?（） 

• A、To finish the task, you should utilize Resource Governor. 
• B、To finish the task, you should utilize Database Engine Tuning Advisor.
• C、To finish the task, you should utilize Extended Events. 
• D、To finish the task, you should utilize Performance Monitor (SYSMON). 

第6题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）

• A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.
• B、In a query execution plan， you should look for queries with missing or out-of-date statistics.
• C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.
• D、In a query execution plan， you should look for queries with a large number of table scans.

第7题：

You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） 

• A、Create the database by using a single data file and a single log file.
• B、Create the database by using a single data file and multiple log files.
• C、Create the database by using a single log file and multiple filegroups.
• D、Create the database by using a single log file and a filegroup that has multiple data files.

第8题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） 

• A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. 
• B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. 
• C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. 
• D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances. 

第9题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? （） 

• A、You should use database snapshots 
• B、You should use database backup and restore 
• C、You should use database backup and restore along with compression 
• D、You should use schema-bound views in a read-only database. The database resides on the same instance.

第10题：

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. There is a database in the instance, and the day-to-day business of your company requires the database. When reports are executed, slow response time will be experienced by Users. A performance monitoring strategy will be implemented by you so as to have three aspects of data captured and stored: Blocking and deadlock information,  Executed Transact-SQL statements  Query activity and Counters for disk, CPU, and memory. You are required to utilize the least amount of administrative effort to implement the monitoring process.     Which action will you perform to finish the task?（）

• A、To finish the task, the client-side profiler trace should be utilized. 
• B、To finish the task, the dynamic management views should be utilized.
• C、To finish the task, the data collector should be utilized. 
• D、To finish the task, the System Monitor counter log trace should be utilized.