Free Microsoft 070-432 Exam Dumps Questions & Answers

You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Tuesday at
09:00 hours.
You need to restore the backup.
What should you do?

• A.  Restore the backups taken on Wednesday, Thursday, and Friday.
• B.  Restore the backups taken on Wednesday and Friday.
• C.  Restore the backups taken on Sunday and Monday.
• D.  Restore the backup taken on Wednesday only.
• E.  Restore the backups taken Wednesday, Friday, and Saturday.
• F.  Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
  18:00
  hours.
• G.  Restore the backup taken on Sunday only.
• H.  Restore the backups taken on Wednesday and Thursday at 09:00 hours.

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales management application.
Occasionally, users of the application report that they receive a deadlock error. You plan to troubleshoot this error.
You need to ensure that the instance is configured to capture troubleshooting information that will create an XML document detailing the deadlock condition.
Which two actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

You administer a SQL Server 2008 instance. You use an internal application based on SQL Server 2008. The application uses Analysis Services and Reporting Services. Company security policy requires that the surface area for all the deployed components of SQL Server 2008 be configured.
You need to implement the security policy and devise a method to evaluate the security policy against other database servers.
What should you do?

• A.  Edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured
• B.  Create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to rim the script against a server group that includes the database servers that need to be configured
• C.  Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.
• D.  Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers. Implement the recommendations of the BPA.

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. There is an Internet Information Services application. This application will use anonymous access to access the SSAS instance.
You must make sure that the application can access the SSAS instance.
What should you do?

• A.  The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration.
• B.  The Security\RequireClientAuthentication server configuration should be set to True.
• C.  The Kerberos Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration
• D.  The Security\RequireClientAuthentication server configuration should be set to False

You are a database administrator for your company. The company uses a SQL Server 2008 database that includes a table named Inventory.
The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation.
Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?

• A.  You should develop a view which rolls back changes to the Price column which breaks company policy.
• B.  You should develop a stored procedure which allows changes to the Price column which breaks company policy.
• C.  On the Price column, you should develop a primary key constraint to a table which includes valid prices.
• D.  You should develop a trigger which rolls back changes to the Price column which breaks company policy.