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

You are a professional level SQL Sever 2008 Database Administrator.
A new database should be deployed, and the capacity requirements listed below should be satisfied.
There should be 275 GB for the database data file, while there should be 50 GB for the transaction log file. There are six 100-GB disk drives which are accessible for the database in the storage array. The six disks are attached to a redundant array of independent disks (RAID) controller, and the controller supports
RAID levels 0, 1, 5, and 10.
Since you are the technical support, you are required to maximize the write performance of the transaction
log. In addition, you should protect the database and transaction log files,
when a drive fails.
The storage system should be designed.
From the following four storage configuration, which one should you utilize?

• A. A single RAID 10 volume should be utilized.
• B. A RAID 1 volume and a RAID 5 volume should be utilized.
• C. A single RAID 5 volume should be utilized.
• D. A RAID 0 volume and a RAID 5 volume should be utilized.

You are a professional level SQL Sever 2008 Database Administrator.
A thirdparty database application will be deployed to the instance. Stored procedures are utilized by the application, and the procedures are developed by utilizing SQL CLR integration. You should set the application to have
the
EXTERNAL_ACCESS code access security setting enabled. Since you are the technical support of the
company,
you should deploy the application to the instance with no loss of functionality.
Which action will you perform first?

• A. Readwrite non-static fields in the code should be replaced with static fields.
• B. The peverify.exe PEVerify tool should be utilized to confirm whether the type-safety requirements are satisfied by the code.
• C. The regasm.exe assembly registration tool should be utilized to have the assembly registered on the server before deployment.
• D. Read-only static fields in the code should be replaced with readwrite static fields.

You are a professional level SQL Sever 2008 Database Administrator.
The largest table in a database is partitioned into four equal-sized parts.
The first two partitions are seldom queried, while the third partition is regularly queried by several reports. Meanwhile, the fourth partition is heavily queried and regularly modified.
The disk space of the table should be cut to the least and the query performance should be with the least impact.
What will you do? (Choose more than one.)

• A. ROW compression should be enabled for the last partition.
• B. PAGE compression should be enabled for the third partition.
• C. PAGE compression should be enabled for the first two partitions.
• D. PAGE compression should be enabled for the last partition.
• E. ROW compression should be enabled for the first two partitions.
• F. ROW compression should be enabled for the third partition.

You are a professional level SQL Sever 2008 Database Administrator.
A mission-critical database is shared by the five sites.
According to the business requirements, the users at each site should be enabled to access and change data on all sites with minimal latency. In addition, data loss should be minimized if a server fails. A high-availability solution should be designed, and the business requirements should be satisfied.
Which action should be included in your solution?

• A. Failover clustering should be included.
• B. Asynchronous database mirroring without a witness server should be included.
• C. Log shipping to servers at two of the sites to offer read-only replications of data should be included.
• D. Peer-to-Peer replication should be included.

You are a professional level SQL Sever 2008 Database Administrator.
A large financial database is hosted by the instance. The backup strategies listed below are contained by
the database:
First, the performance of a full database backup is implemented once a week.
Secondly, the performance of a differential backup is implemented every day.
Thirdly, the performance of a transaction log backup is implemented every hour.
An end-of-year batch process should be implemented, and the process takes two hours to run.
About five percent of data within the database will be changed by the batch process.
Since you are the technical support, you are required to make sure that the batch operation can be rolled
back
in the shortest time, if the batch process is not approved by the Finance department.
What should you do first before start the batch process?

• A. You should create a database snapshot.
• B. You should record the time before the batch operation. And then you should perform a transaction log
• C. You should perform a differential backup.
• D. You should create a marked transaction. And then you should perform a transaction log backup.