Microsoft 070-450 Exam : PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu

You administer a SQL Server 2008 infrastructure.
Several production databases use Transparent database encryption.
You perform full database backups of the production databases as part of your backup strategy.
You need to ensure that the database backups can be restored on another SQL Server 2008 instance if the original host server fails.
What should you do?

• A. Back up the database master key.
• B. Back up the resource database.
• C. Ensure that the instances use the same service account.
• D. Back up the server master key.

You are a professional level SQL Sever 2008 Database Administrator.
An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance. The performance of the instance should be optimized.
Which action will you perform to accomplish the goal?

• A. To accomplish the goal, the Windows System Resource Manager should be configured.
• B. To accomplish the goal, the Resource Governor should be configured.
• C. To accomplish the goal, an increase should be configured in the maximum degree of parallelism option.
• D. To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.

You administer two SQL Server 2008 instances named Instance1 and Instance2. Instance1 contains the Sales database, and Instance2 contains the Accounts database.
A procedure in the Sales database starts a transaction. The procedure then updates the Sales.dbo.Order table and the Accounts.dbo.OrderHistory table through a linked server.
You need to ensure that the transaction uses a two-phase commit.
What should you do?

• A. Configure a Service Broker to enable the appropriate transaction control.
• B. Ensure that the linked server is appropriately configured for delegation.
• C. Configure the linked server to use distributed transactions.
• D. Ensure that the linked server is appropriately configured for impersonation.

You are a professional level SQL Sever 2008 Database Administrator.
A database is hosted by the instance and the database is configured by utilizing high-safety mirroring operation mode along with a witness server. A memory failure is experienced by the witness server; therefore the server will be offline for five hours. The mirroring strategy should be reset to cut the risk of database unavailability to the least level.
Which action should you perform to finish the task?

• A. To finish the task, database mirroring should be removed.
• B. To finish the task, asynchronous operating mode should be utilized.
• C. To finish the task, the witness server should be moved from the mirroring session.
• D. To finish the task, database mirroring should be paused.

You are a professional level SQL Sever 2008 Database Administrator.
You are experienced in managing databases in an enterprise-level organization,optimizing and sustaining
the
database life cycle. In the company, your job is to implement solutions on security, troubleshooting,
deployment
and optimization. A SQL Server 2008 infrastructure is managed by you.
A database is utilized by the instance, and the database is utilized by a Web-based application. 15,000
transactions
are processed by the application every minute. A column is contained by a table in the database, and the
column is
utilized only by the application. Sensitive data is stored in this column. The sensitive data should be stored
with the
highest security level. In addition, the least amount of memory space and processor time should be
utilized.
From the following four encryption types, which one should you utilize?

• A. Certificate-based encryption should be utilized.
• B. Transparent data encryption should be utilized.
• C. Asymmetric key encryption should be utilized.
• D. Symmetric key encryption should be utilized.