Free Microsoft 70-432 Exam Dumps Questions & Answers

You administer a SQL Server 2008 instance.
You need to find out the number of users who access the SQL Server instance by using Windows System Monitor.
Which performance object should you capture?

• A.SQLServenBuffer Manager
• B.SQLServer:Exec Statistics
• C.SQLServer:General Statistics
• D.SQLServer:Access Methods

You administer a SQL Server 2008 instance. The server contains a very large database that is used by an application that is constantly available.
Users report that the server performance has degraded.
You need to use the Database Engine Tuning Advisor to improve the performance of the application.
You also need to ensure that the performance of the production server is unaffected while analyzing the workload.
What should you do?

• A.Enable the XP_MSVER stored procedure on the remote server.
• B.Configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file.
• C.Use the dta.exe utility on the production server along with an XML input file.
• D.Enable the XP_MSVER stored procedure on the local server.

You administer a SQL Server 2008 instance.
A SQL Server Agent job executes every 2 minutes. The job logs information to a text file named SQL1.log located on the E: drive.
Users report that the server is unresponsive. You discover the following problems:
- The SQL Server Agent job no longer functions.
- The SQL Server Agent service does not run.
You need to find out the cause of the SQL Server Agent service failure.
Which log should you examine?

• A.SQLAGENT.OUT
• B.ERRORLOG
• C.SQL1.log
• D.log_xx.trc

You maintain a SQL Server 2008 instance.
You plan to deploy an instance of SQL Server Reporting Services (SSRS) to the same machine.
You need to ensure that by default. SSRS maintains version histories of all deployed reports.
What should you do?

• A.Install the SSRS instance by using the Internet Information Services default Web site.
• B.Configure the SSRS database to use Native mode.
• C.Install the SSRS instance by using the http.sys listener.
• D.Configure the SSRS database to use SharePoint integrated mode.

You administer a SQL Server 2008 instance.
You need to configure the instance to use a single thread for queries that have an estimated execution cost less than 3.
Which sp_configure configuration option should you set?

• A.priority boost
• B.precompute rank
• C.max worker threads
• D.query governor cost limit
• E.cost threshold for parallelism