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

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 Web service to log on by using the role of administrator.
• C.You should reset the server so that the SQL Server Agent service starts automatically.
• D.You should reset SQLDB to use Windows Integrated authentication.

You administer a SQL Server 2008 instance that contains a database named Adventure Works. The AdventureWorks database contains the Products table.
You create a Merge Replication topology and a Publication to replicate the Products table to the SQL Server instances at remote locations. The Publication has a 21-day retention period.
When a user returns from a one-month vacation, she discovers that her database does not contain the most recent data. The Windows Event log states the following error message:
"Replication: expired subscription dropped."
You need to obtain the most recent data in the database of the user.
You also need to ensure that future data changes are appropriately replicated.
What should you do?

• A.Upload unsynchronized changes, and then reinitialize the publication.
• B.Recreate the publication.
• C.Reinitialize the publication and immediately generate a new snapshot.
• D.Upload unsynchronized changes.

You administer a SQL Server 2008 instance. You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail stored procedure is used to send a large volume of reports during business hours. The reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?

• A.Change the Account Retry Attempts option of the Database Mail system properties.
• B.Use the (@importance = high parameter when you send the reports to the manager.
• C.Configure a new Database Mail profile to be used for the reports to the manager.
• D.Add another SMTP account to the existing Database Mail profile.

You are mastering the company database, You should check the log of the a SQL Server 2005 Enterprise Edition everyday, 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 reserve the database from the newest database snapshot.
• B.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.
• C.You should reserve the newest database backup and then reserve any transaction logs which have been made since the past backup.
• D.You should operate DBCC CHECKDB.

You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements:
- Enable FILESTREAM for file I/O streaming access.
- Allow remote client computers to have streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
What should you do?

• A.Configure the SQL Server Full Text service.
• B.Modify the Volume Shadow Copy settings.
• C.Configure the SQL Server service.
• D.Modify the Background Intelligent Transfer Service settings.