070-450 試験問題を無料オンラインアクセス

You are a professional level SQL Sever 2008 Database Administrator.
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 Database Engine Tuning Advisor.
• B.To finish the task, you should utilize Extended Events.
• C.To finish the task, you should utilize Resource Governor.
• D.To finish the task, you should utilize Performance Monitor (SYSMON).

You administer four SQL Server 2008 instances. Each instance hosts a single database application.
You plan to migrate all four instances to a new SQL Server failover cluster. The four instances are configured as shown in the following table.
Instance Name Configuration:
Instance 1 8 processors that have 16-GB RAM Instance 2 4 processors that have 8-GB RAM Instance 3 2 processors that have 16-GB RAM Instance 4 4 Processors that have 8-GB RAM
The four instances are fully optimized and have no spare CPU cycles or extra memory. The new cluster will host all four databases on a single virtual cluster IP address. You need to ensure that the new cluster is configured to handle the workload of all the database applications by using the minimum amount of hardware resources.
Which cluster configuration should you use?

• A.Two-node active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
• B.Four-node active/active/active/active cluster that has each node containing a minimum of 9 processors and a 25-GB memory
• C.Two-node active/passive cluster that has each node containing a minimum of 18 processors and a 50GB memory
• D.Four-node active/active/active/passive cluster that has each node containing a minimum of 18 processors and a 50-GB memory

You administer a SQL Server 2008 instance.
Your company security policy is designed to prevent changes to the server to the server configuration. You plan to use Policy-Based Management Framework to implement the security policy.
You need to ensure that the policy is configured to meet the security requirement.
What should you do?

• A.Use a domain account for the SQLAgent service.
• B.Use the Local Service account for the SQLAgent service.
• C.Disable the nested triggers server configuration.
• D.Enable the nested triggers server configuration option.

You administer a SQL Server 2008 infrastructure.
You plan to design a maintenance strategy for a mission-critical database that includes a large table named Orders. The design plan includes index maintenance operations.
You must design the strategy after considering the following facts:
The Orders table in the database is constantly accessed.
New rows are frequently added to the Orders table.
The average fragmentation for the clustered index of the Orders table is less than 2 percent.
The Orders table includes a column of the xml data type.
You need to implement the strategy so that the performance of the queries on the table is optimized.
What should you do?

• A.Drop the clustered index of the Orders table.
• B.Rebuild the clustered index of the Orders table offline once a month.
• C.Exclude the clustered index of the Orders table from scheduled reorganizing or rebuilding operations.
• D.Reorganize the clustered index of the Orders table by decreasing the fill factor.

You administer a SQL Server 2008 infrastructure.
The instance contains a database required for the day-to-day business of your company. Users experience slow response time when they execute reports.
You plan to design a performance monitoring strategy that captures and stores the following data:
Executed Transact-SQL statements and query activity.
Blocking and deadlock information.
Counters for disk, CPU, and memory.
You need to implement the monitoring process by using the minimum amount of administrative effort.
What should you do?

• A.Use the data collector
• B.Use the System Monitor counter log trace.
• C.Use the dynamic management views.
• D.Use the client-side profiler trace.