单选题You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The t

第1题：

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. 

第2题：

You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）

• A、Increase the value of table_definition_cache
• B、Increase the value of table_open_cache_instances
• C、Decrease the value of table_open_cache_instances
• D、Increase the value of table_open_cache
• E、Decrease the value of table_definition_cache
• F、Decrease the value of table_open_cache

第3题：

In what view are you likely to see the following output？（）   SID SERIAL# EVENT SECONDS_IN_WAIT  121 269 RMAN backup & recovery I/O 2  129 415 SQL*Net message from client 63 130 270 SQL*Net message from client  

• A、 V$SESSION_EVENT
• B、 V$SESSION
• C、 V$WAITS
• D、 V$WAITSTAT
• E、 V$SYSSTAT

第4题：

Your network contains a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).  You create a domain account named Admin1. You need to configure the security for Admin1 to meet the following requirements: Allow Admin1 to monitor events in the system event log and the application event logAllow Admin1 to create and view counter logs in Performance MonitorMinimize the user rights assigned to Admin1 To .which group should you add Admin1?（）

• A、Power Users.
• B、Administrators.
• C、Performance Log Users.
• D、Performance Monitor Users.

第5题：

You are a systems administrator responsible for managing a Windows Server 2008 SMTP server.Recently， users have complained that a Web application running on the same server is experiencing performance problems at specific times of the day. You suspect that the problem might be related to loadplaced on the SMTP Server service. Which of the following methods should you use to monitor theperformance of an SMTP virtual server over time？（）

• A、The Current Sessions section of IIS 6.0 Manager
• B、SMTP Server counters collected by Performance Monitor
• C、Windows Event Viewer： Application Log
• D、Windows Event Viewer： System Log

第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. More than a month ago， the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore， you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view （DMV）， you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition， the impact on database users should e cut to the least.  Which action should be performed to achieve the goal？（）

• A、To achieve the goal， the UPDATE STATISTICS command should be excuted.
• B、To achieve the goal， the SQL Server Service should be restarted.
• C、To achieve the goal， the SQL Server computer should be restarted.
• D、To achieve the goal， the statistics in the dynamic management view （DMV） should be reset.

第7题：

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）

• A、It detects any configuration change that caused a performance difference in both time periods.
• B、It identifies any workload change that caused a performance difference in both time periods.
• C、It detects the top wait events causing performance degradation.
• D、It shows the resource usage for CPU, memory, and I/O in both time periods.
• E、It shows the difference in the size of memory pools in both time periods.
• F、It gives information about statistics collection in both time periods.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

• A、Database replay
• B、SQL Tuning Advisor
• C、SQL Access Advisor
• D、SQL Performance Analyzer
• E、Automatic Workload Repository compare reports

第14题：

When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）  

• A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
• B、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
• C、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
• D、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

第15题：

Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2.You have a server named Server1 that hosts shared documents. Users report extremely slow response times when they try to open the shared documents on Server1.You log on to Server1 and observe real-time data indicating that the processor is operating at 100 percent of capacity.You need to gather additional data to diagnose the cause of the problem. What should you do?（）

• A、In the Performance Monitor console, create a counter log to track processor usage.
• B、In Event Viewer, open and review the application log for Performance events.
• C、In Resource Monitor, use the Resource View to see the percentage of processor capacity used by each application.
• D、In Performance Monitor, create performance counter alert that will be triggered when processor usage exceeds 80 percent for more than five minutes on Server1.

第16题：

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.

第17题：

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). 

第18题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time.  So in the options below, which dynamic management view should you choose to use?（）  

• A、sys.dm_os_wait_stats 
• B、sys.dm_exec_requests 
• C、sys.dm_exec_sessions 
• D、sys.dm_exec_query_stats

第19题：

第20题：

第21题：

第22题：

第23题：