Microsoft 70-450 Exam : PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu

You are a professional level SQL Sever 2008 Database Administrator.
Your company wants to enforce naming standards for the database objects.
A solution should be designed by you to enforce naming standards,
and the least amount of administrative and programming efforts should be utilized.
Which action should you perform?

• A. DDL triggers should be created for one of the instances, and then Microsoft SQL Server Management Studio (SSMS) should be utilized to script the definition of the DDL triggers. At last, the script should be run on all instances by utilizing the registered server??s node from SSMS.
• B. Policy-Based Management policies should be created, and then the policies should be distributed by utilizing a configuration server.
• C. Event notifications should be utilized to handle the DDL events.
• D. DDL triggers should be created for one of the instances, and then SQL Server Management Objects (SMO) should be utilized to script the definition of the DDL triggers. At last, the script should be run by utilizing Microsoft Windows PowerShell on all instances.

You are a professional level SQL Sever 2008 Database Administrator.
The capacity planning information is required by your company. A long-term infrastructure monitoring strategy should be implemented.
Which two actions should be contained in the strategy? (Choose more than one)

• A. After deployment of the production databases, the system should be basedlined.
• B. The system log and the application log should be cleared every hour.
• C. System monitor counters should be reviewed regularly.
• D. All databases should be backed up every day.
• E. A maintenance plan that rebuilds indexes every week should be created.

You are a professional level SQL Sever 2008 Database Administrator.
A solution will be implemented to have hardware configurations obtained. The hardware configuration obtained should include the number of processors on a computer and the processor type of all SQL Server 2008 computers. The requirements listed below should be satisfied by the solution. The solution should be hosted on the central computer. And the hardware configurations for multiple servers should be verified bythe solution.
A technology should be selected to satisfy the requirements, and the least amount of development effort should be utilized.
Which action should you perform to finish the task?

• A. To finish the task, you should utilize the ExecuteSql function to define policies based on conditions.
• B. To finish the task, you should utilize the Windows Management Instrumentation (WMI) provider for the server events.
• C. To finish the task, you should utilize the ExecuteWQL function to define policies based on conditions.
• D. To finish the task, you should utilize the Invoke-Sqlcmd cmdlet in SQL Server PowerShell cmdlet.

You are the database administrator for a SQL Server that hosts an application defined as follows:
The database consists of 4 data files and one log file.
The physical server has 16 CPUs and 64 GB of memory.
Hardware non-uniform memory access (NUMA) is not available on this server platform.
Users of the application report that it is responding slowly. You use SQL Server Profiler to find out that the I/
O
performance issue is related to the lazywriter process.
You need to improve the performance of the application by reducing the I/O performance issue.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Configure a CPU affinity mask on the server to limit the instance of SQL Server to four CPUs
• B. Add additional data files to the database.
• C. Add additional RAM to the server.
• D. Configure four software non-uniform memory access (soft NUMA) nodes on the server.

You are a professional level SQL Sever 2008 Database Administrator.
An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance. The performance of the instance should be optimized.
Which action will you perform to accomplish the goal?

• A. To accomplish the goal, an increase should be configured in the maximum degree of parallelism option.
• B. To accomplish the goal, the Resource Governor should be configured.
• C. To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.
• D. To accomplish the goal, the Windows System Resource Manager should be configured.