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 application is hosted by the instance.
The data security strategy should be designed for the application.
The data should be duplicated to another instance of SQL Server 2008 by utilizing the
Snapshot duplication. Since you are the technical support of the company, you should make sure that all
stored data should be encrypted, and the minimum amount of administrative effort should be utilized.
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.
Two SQL Server 2008 instances are managed by you, and they are respectively called Ins01 and Ins02.
The Sales database is included in Ins01, while the Accounts database is contained by Ins02.
A transaction is started by A procedure in the Sales database. And then, the Sales.dbo.Order table and the Accounts.dbo.
OrderHistory table are updated by the procedure through a linked server.
Since you are the technical support of the company, you are required to make sure that a two-phase commit is utilized by the transaction.
Which action will 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 Reporting Services (SSRS) instance is managed by you.
An authentication method should be designed for SSRS reports that SQL Server data connections are utilized.
Since you are the technical support of the company, you are required to make
sure that all SSRS reports utilize the Kerberos authentication protocol to communicate to the SQL Server instance.
Which action should 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 instance is managed by you. And a large database is hosted by the instance.
High volumes of queries and transactions that are processorintensive 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?

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.
The instance is one of three servers, and the three servers are in a peer-to-peer transactional replication
topology. A table named Orders is included by the publication. 200 GB of data across multiple partitions
are contained by the Orders table.
10 GB of data is loaded to the Orders table periodically by a batch process bulk.
A replication strategy should be designed to have latency minimized.
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 instance should be managed by you. A new database will be deployed to the instance.
Regular inserts and updates should be subjected by the database. There will be multiple schemas on the database.
A great number of read-only reference data should be contained by one of the schemas.
The physical database structure should be designed for optimal backup performance.
Which action should 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 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?