Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 70-432무료 덤프문제 풀어보기
You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
Rebuilds indexes.
Checks database integrity.
Writes a report to a text file.
You need to ensure that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.
---
What should you modify?
You have an existing database maintenance plan that performs the following tasks:
Rebuilds indexes.
Checks database integrity.
Writes a report to a text file.
You need to ensure that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.
---
What should you modify?
정답: B
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database named
AdventureWorks2008R2 that hosts a credit card-processing application.
You need to implement transparent data encryption.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the correct order.)
You administer a Microsoft SQL Server 2008 R2 database named
AdventureWorks2008R2 that hosts a credit card-processing application.
You need to implement transparent data encryption.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the correct order.)
정답:
You are mastering the company database, with SQL Server 2008 computer named SQLTEST1The master database on SQLTEST1 is down. Some SQL Server Agent jobs should be included in the SQLTEST1.The whole database should be backed up every day. You rebuild and restore the master database. You should make sure that SQLTEST1 functions as it did before the database lost. Which is the correct answer?
정답: A
You maintain a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database contains a table named OrderSpecs. The OrderSpecs table has a clustered primary key named OrderId on the OrderId column. The OrderSpecs table has a single XML column named ProductSpecs that stores XML data, and there is an XML index on the same XML column.
You add a new column named ProductId to the OrderSpecs table.
You need to include ProductId in the primary key.
What should you do?
The AdventureWorks database contains a table named OrderSpecs. The OrderSpecs table has a clustered primary key named OrderId on the OrderId column. The OrderSpecs table has a single XML column named ProductSpecs that stores XML data, and there is an XML index on the same XML column.
You add a new column named ProductId to the OrderSpecs table.
You need to include ProductId in the primary key.
What should you do?
정답: C
DRAG DROP
You administer a Microsoft SQL Server 2008 R2 instance by using a database named AdventureWorks2008R2.
You need to implement transparent data encryption for a database hosted by the server.
Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
You administer a Microsoft SQL Server 2008 R2 instance by using a database named AdventureWorks2008R2.
You need to implement transparent data encryption for a database hosted by the server.
Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)
정답:
You maintain a SQL Server 2008 instance that contains a database named Finance. The most recent full backup was taken at 13:00 horns, a differential backup was taken at
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The backups and the database snapshots are stored on a different disk from the database files. The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The backups and the database snapshots are stored on a different disk from the database files. The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?
정답: C
You administer two SQL Server 2008 instances on separate servers named Server1 and Server2.
The AdventureWorks database is set up for synchronous mirroring between the two instances.
You need to configure the database to support automatic failover.
What should you do?
The AdventureWorks database is set up for synchronous mirroring between the two instances.
You need to configure the database to support automatic failover.
What should you do?
정답: C
You have a server that contains a default SQL Server 2005 instance. You need to install a SQL Server 2008 instance for a new application on the same server. The new application requires SQL Server 2008 functionality.
You need to ensure that both database instances are available for their respective certified third-party applications. The existing application environments remain unchanged.
What should you do?
You need to ensure that both database instances are available for their respective certified third-party applications. The existing application environments remain unchanged.
What should you do?
정답: D
You administer a Microsoft SQL Server 2008 R2 instance. You need to check the physical consistency of the database. What should you do?
정답: F
You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?
You need to configure mirroring between two servers in high-performance mode.
What should you do?
정답: D
You administer a Microsoft SQL Server 2008 R2 instance.
The database has been marked as suspect.
You need to place the database into an EMERGENCY state for troubleshooting.
What should you do?
The database has been marked as suspect.
You need to place the database into an EMERGENCY state for troubleshooting.
What should you do?
정답: I
You maintain a SQL Server 2008 instance.
You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night. You need to enforce a mail retention policy to delete copies of automatically generated
mails after 60 days. Which process should you use?
You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night. You need to enforce a mail retention policy to delete copies of automatically generated
mails after 60 days. Which process should you use?
정답: A
You maintain a SQL Server 2008 instance.
The SQL Server instance is configured to use the -T1222 and -T1204 trace flags during
startup.
You need to ensure that your failure recovery plan backs up the use of the trace flags.
What should you do?
The SQL Server instance is configured to use the -T1222 and -T1204 trace flags during
startup.
You need to ensure that your failure recovery plan backs up the use of the trace flags.
What should you do?
정답: C
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?
You need to ensure that no suspect pages have been detected in your database.
What should you do?
정답: B