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 solution will be implemented to have hardware configurations obtained.
The hardware configuration obtained should include the number of processors on a computer and the processor type of all SQL Server
2008 computers. The requirements listed below should be satisfied by the solution.
The solution should be hosted on the central computer. And the hardware configurations for multiple servers should be verified by
the solution.
A technology should be selected to satisfy the requirements, and the least amount of development effort should be utilized.
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 infrastructure is managed by you.
A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01.
There is a sales team in your company, and their task is to finish purchase orders for customer requests.
The sales team updates data regularly in a local database by utilizing their portable computers.
When the central site is connected by portable computers, a database named Sales will be synchronized with the local
database. A duplication model will be created to duplicate the local database to the Sales database.
The requirements listed below should be satisfied by the duplication model.
First, when the same data is updated by multiple users independently, there should be no data conflicts.Secondly, sensitive data such
as product price cannot be updated by the sales team.Thirdly, the data should be synchronized by the
sales team not only at scheduled times but also on demand.
The best model should be identified to have data duplicated, and you should be reduced the development efforts to the least.
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. Your company wants to enforce naming standards for the database objects.
A solution should be designed by you to enforce naming standards, and the least amount of administrative and programming efforts should be utilized.
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 database solution is managed by you, and the solution is log-shipped for high-availability purposes.
The data files of the database reside on drive D, while the transaction log files of the database reside on drive E.
A restoring test plan should be implemented to satisfy the requirements listed below for the log-shipping solution.
First, the secondary database is brought online in the shortest time.Secondly, the data is in a consistent state.
Thirdly, the data loss is reduced to the least.
The first step for the recovery test plan should be identified in the event of drive D failure.
Which step should be performed?

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?