Online Access Free 070-432 Exam Questions

You administer a SQL Server 200S instance. A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked. Which tool should you use?

• A.The Database Engine Tuning Advisor tool
• B.The Activity Monitor tool in Microsoft SQL Server Management Studio
• C.The Job Activity Monitor tool in Microsoft SQL Server Management Studio
• D.The Windows System Monitor tool

You maintain a SQL Server 2008 instance that contains a database named Finance. In your absence, a user with a login named Rob will maintain the database snapshots. You need to giant the appropriate permissions to the user to delete the database
snapshots for the Finance database. Which database permission should you giant?

• A.CONTROL
• B.DROP DATABASE
• C.ALTER ANY DATASPACE
• D.DELETE

You are mastering the company database, you should check the log of the SQL Server 2008 Enterprise Edition everyday, and you get the information on the torn page errors of the database. In order to fine the solution of the torn page, which is the correct answer?

• A.You should utilize the latest database backup to restore only the torn page. Then restore any transaction logs which have been made since the full backup.
• B.You should reserve the database from the newest database snapshot.
• C.You should operate DBCC CHECKDB.
• D.You should reserve the newest database backup and then reserve any transaction logs which have been made since the past backup.

You administer a SQL Server 2008 instance that contains a database named Ad venture Works.
You are log shipping the Adventureworks database to a remote SQL Server 2008 instance.
During the weekend, the primary SQL Server instance required a restart. After the weekend, you discover that log shipping has stopped working.
You need to troubleshoot log shipping of the Adventureworks database.
What should you do?

• A.Execute a DBCC CHECKDB statement on the AdventureWorks database by using the EXTENDED_LOGICAL_CHECKS option.
• B.Verify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server.
• C.Verify whether the AdventureWorks database uses the Simple recovery model.
• D.Verify whether the SQL Server Agent is started on the primary server.

You administer a Microsoft SQL Server 2008 R2 instance. You need to check the physical consistency of the database. What should you do?

• A.Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
• B.Execute DBCC CHECKD
• C.Execute sp_helpfile.
• D.Restore the database from the most recent full backup. Apply any differential and log backups.
• E.Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
• F.Examine the msdb..suspect_pagestable.
• G.Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any differential and log backups. Create a new log backup and then restore the new log backup.
• H.Execute DBCC CHECKDB along with the REPAIR_REBUILDcla.se
• I.Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.