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

You administer three SQL Server 2008 instances named Instance 1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored between Instance 1 and Instance2. Instances acts as the witness. Instance 1 currently acts as the Principal.
You plan to apply a patch to both servers. The patch requires a restart of the server.
You need to find out the sequence of steps necessary to ensure that the following requirements are met:
The patching process is completed in the shortest possible time.
The database is online on the partner that currently does not apply the patch.
The database does not failover to the other partner during this time.
What should you do?
---

• A.Apply the patch to the server that runs Instance2.
  Manually failover the mirroring session.
  Apply the patch to the server that runs Instance1.
• B.Apply the patch to the server that runs Instance2.
  Apply the patch to the server that runs Instance1.
• C.Remove the mirroring session.
  Apply the patch to the server that runs Instance2.
  Apply the patch to the server that runs Instance1.
  Re-establish the mirroring session.
• D.Suspend the mirroring session.
  Apply the patch to the server that rims Instance2.
  Resume the mirroring session.
  Manually failover the mirroring session.
  Apply the patch to the server that runs Instance1.

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.DELETE
• D.ALTER ANY DATASPACE

You are mastering the company database, with SQL Server 2008 computer named SQLDB. The function of the SQLDB is to perform transaction log backups and so on.SQL1 should be reset by another administrator using the tool of SQL Server Surface Area Configuration.
You should see that SQL1 no longer runs the maintenance tasks automatically. On SQLDB, You should make sure the tasks of the maintenance are finished without menWhich is the correct answer?

• A.You should reset operate a full backup of the master database by hand.
• B.You should reset the server so that the SQL Server Agent service starts automatically.
• C.You should reset SQLDB to use Windows Integrated authentication.
• D.You should reset the Web service to log on by using the role of administrator.

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.Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers. Implement the recommendations of the BPA.
• B.Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.
• C.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
• D.Edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured

You configure a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database experiences deadlock problems.
You need to capture the deadlock information to the SQL Server error log.
What should you do?

• A.Configure the data collector to capture the deadlock graphs.
• B.Configure a SQL Profiler trace to capture the deadlock graphs.
• C.Set the appropriate trace flags as a startup parameter and restart the SQL Server instance.
• D.Enable Server Auditing for the AdventureWorks database.