You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance is managed by you. 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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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.
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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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.
Four SQL Server 2008 instances are managed by you. And 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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance is managed by you. And 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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance is managed by you.
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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance is managed by you. A 32-bit version is utilized by the instance on a Windows Server 2008 64-bit server.
You activate the awe enabled option. A predictable increase in query activity will be experienced by the instance.
You are required to figure out the most proper and beneficial time to have the databases migrated to a 64-bit SQL Server 2008
server on the same hardware.
A data collector type that proper information is provided should be identified.
What kind of collector should you utilize?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance of your company is managed by you.
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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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. SQL Server 2008 servers on a single site are managed by
you. Two SQL Server 2008 instances are contained by the site. One is an Enterprise Edition server, and it
is on a server that has a redundant array of independent disks (RAID) 10 disk system The other is a
Standard Edition server, and it is on a server that has a RAID 5 disk system. A single application is hosted
by each instance. A high-availability solution should be recommended for the site to satisfy the business
requirements listed below.
First, the solution can be implemented on the current systems.
Secondly, the database is available with least downtime.
Thirdly, Data loss should be cut to the least.
Fourthly, the existing system should be with least impact.
Which solutions should be utilized to finish the task? (Choose more than one)

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 instance is managed by you. 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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. 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 corporate backup and recovery strategy that has to be validated is designed.
You are required to make sure that any single database can be restored successfully from a severe failure, and during the
restoration, a backup data center should not be required in a different location.
Which three actions should be contained by your solution? (Choose more than one)