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

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 client-side profiler trace.
• B.Use the dynamic management views.
• C.Use the data collector
• D.Use the System Monitor counter log trace.

You administer a SQL Server 2008 instance.
The instance is one of three servers in a peer-to-peer transactional replication topology.
The publication contains a table named Orders. The Orders table contains 200 GB of data
across multiple partitions. A batch process bulk loads 10 GB of data to the Orders table periodically.
You need to design a replication strategy to minimize latency.
What should you do?

• A.Use the BULK INSERT command in multiple staging tables. Switch partitions into the Orders table.
• B.Explanation/Reference:
  ---Jeff---
• C.Configure the Distributor agent to replicate transactions continually.
• D.Configure the Distributor agent to change the commit batch threshold.
• E.Disable the Distributor agent. Use the BULK INSERT command in the Orders table. Reinitialize the publication.

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 Performance Monitor (SYSMON).
• B.To finish the task, you should utilize Extended Events.
• C.To finish the task, you should utilize Database Engine Tuning Advisor.
• D.To finish the task, you should utilize Resource Governor.

You administer a SQL Server 2008 infrastructure.
An instance runs on a computer that has eight quad-core processors and 128-GB RAM.
Four different applications use the instance.
The instance experiences a low number of CXPACKET waits.
The instance also experiences a large number of lazy writer waits.
You need to optimize the performance of the instance.
What should you do?

• A.Configure the Resource Governor.
• B.Configure the Windows System Resource Manager.
• C.Configure software non-uniform memory access (soft-NUMA).
• D.Configure an increase in the maximum degree of parallelism option.

You are a professional level SQL Sever 2008 Database.
A new database application is hosted by the instance. The security requirements should be designed for the application. A unique login to the SQL Server 2008 server is assigned to each application user. Stored procedures are included by the application database to execute stored procedures in the MSDB database. SQLAgent jobs are scheduled by the stored procedures in the MSDB database.
Since you are the technical support, you are required to confirm that the stored procedures in the MSDB database should be executed by utilizing the security context of the application user.
Which action should you perform?

• A.The new database should be set to utilize the TRUSTWORTHY option, and then each user should be added to the MSDB database.
• B.Each user should be added to the db_dtsltduser database role in the MSDB database.
• C.The MSDB database should be set to utilize the TRUSTWORTHY option, and then each user should be added to the MSDB database.
• D.Each user should be added to the public role in the MSDB database.