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

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

You install a 64-bit version of a SQL Server 2008 instance by using the default setup and configuration settings. You receive the following error message:
"Your SQL Server installation completed with \a: ures.1
You close the error window before noting the location where additional information about the error is recorded.
You need to locate the additional information.
Where should you search?

• A.The Event Viewer System log file
• B.The Event Viewer Application log file
• C.The C:\Program Files\Microsoft SQL Server\MSSQL\LOG folder
• D.The C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ folder

You administer a Microsoft SQL Server 2008 R2 instance.
You need to ensure that no suspect pages have been detected in your database.
What should you do?

• A.Examine the msdb..suspect_pagestable.
• B.Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
• C.Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.
• D.Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
• E.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.
• F.Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
• G.Execute sp_helpfile.
• H.Execute DBCC CHECKD
• I.Restore the database from the most recent full backup. Apply any differential and log backups.

You administer three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored between Instance1 and Instance2. Instance3 is configured as the witness. Instance1 is configured as the Principal. You plan to apply an update to the servers that run Instance1 and Instance2. The update requires a restart.
You need to ensure that the servers meet the following requirements during the update process:
- Complete the update process in the least amount of time possible. - The database must be available on one server during the update of another server. - The update process must not cause an automatic failover of the database.
What should you do?

• A.Remove the mirroring session. Install the update on both servers.
  Re-establish the mirroring session.
• B.Suspend the mirroring session.
  Install the update on the server that runs Instance2.
  Resume the mirroring session.
  Perform a manual failover of the mirroring session.
  Install the update on the server that runs Instance1.
• C.Remove the mirroring session.
  Run the SQL Server 2008 Upgrade Advisor Install the update on both servers.
  Re-establish the mirroring session.
• D.Suspend the mirroring session Install the update on both servers.
• E.Install the update on the server that runs Instance2. Perform a manual failover of the mirroring session. Install the update on the server that runs Instance1.

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 Security\RequireClientAuthentication server configuration should be set to False
• B.The NTLM Security Support Provider Interface (SSPI) provider should be added to the Security\SecurityPackageList server configuration.
• 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 True.