You are a professional level SQL Sever 2008 Database Administrator.
They are respectively named Ins01, Ins02, Ins03 and Ins04. A single database application is hosted by each instance. All four instances should be removed to a new SQL Server failover cluster. You can see the configuration of the four instances from the table listed below:

All the four instances are sufficiently optimized, and there are no spare CPU cycles or extra memory in
the instances.
All four databases will be hosted by the new cluster on a single virtual cluster IP address.
Since you are the technical support, you are required to set the new cluster to handle the workload of all the database applications with the least amount of hardware resources.
From the four cluster configuration, which one should be utilized?

• A. Four-node active/active/active/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory are contained by each node.
• B. Two-node active/passive cluster should be utilized and a minimum of 18 processors and a 50-GB memory are contained by each node.
• C. Two-node active/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory are contained by each node.
• D. Four-node active/active/active/passive cluster should be utilized and a minimum of 18 processors and a 50-GB memory are contained by each node.

You are a professional level SQL Sever 2008 Database Administrator.
A large database is hosted by the instance. High volumes of queries and transactions that are
processor intensive
are experienced by the database. An incremental backup strategy should be designed for the database.
In addition,
backup compression will be utilized.
Since you are the technical support of the company, you are required to reduce the impact from the backup
jobs
on the performance of the server to the least.
Which action will you perform to achieve the goal?

• A. To achieve the goal, database snapshots should be utilized.
• B. To achieve the goal, the Affinity I/O Mask configuration option should be reconfigured.
• C. To achieve the goal, the database backup should be spread across multiple backup devices.
• D. To achieve the goal, the Resource Governor should be utilized.

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named
Wiikigo.
There is a team of database administrators in your company.
SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared
project by a team of application developers. A fixed cache file is required by one of the packages.
The company will deploy the packages to the production server on completion of development.
The production server is available only to the database administrators.
Since you are the technical support, you need to confirm that the project can be deployed
successfully to the production server by the application developers.
Which action will you perform to achieve the goal?

• A. To achieve the goal, a deployment utility should be created for the SSIS project.
• B. To achieve the goal, the Import and Export Wizard should be utilized to save packages.
• C. To achieve the goal, an indirect package configuration should be created for all packages.
• D. To achieve the goal, a direct package configuration should be created for each package.

You are a professional level SQL Sever 2008 Database Administrator.
A database is hosted by the instance, and sensitive data is included in the database.
A database backup strategy will be implemented for the database.
You need to have all backups of the database encrypted.
The backups should not be accessed by unauthorized users.
Which action will you perform?

• A. Windows BitLocker Drive Encryption technology should be utilized.
• B. The BACKUP statement should be utilized along with the PASSWORD option.
• C. Transparent database encryption should be utilized.
• D. The BACKUP statement should be utilized along with the MEDIAPASSWORD option.

You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated.
You need to ensure the successful recovery of any single database from a catastrophic failure without requiring a backup data center in a different location.
Which three tasks should you include? (Each correct answer presents part of the solution. Choose three.)

• A. Store all backup media offsite.
• B. Document the administrative processes and application access requirements.
• C. Maintain one list of all Windows logins and passwords.
• D. Script SQL login accounts and credentials.
• E. Install all SQL Server instances on a failover cluster.