You are a professional level SQL Sever 2008 Database Administrator. Log shipping should
be implemented for several databases on three SQL Server instances. The logs are
migrated to a fourth SQL Server instance. A manual failover will be implemented. You need
to ensure that the database applications utilize the secondary server after failover. Since
you are the technical support, you are required to confirm that the latest data should be
available to users. Which actions should you perform to achieve the goal? (Choose more
than one)

You are a professional level SQL Sever 2008 Database Administrator. A maintenance
strategy should be designed for a mission-critical database, and a large table named Orders
is contained by the database. Index maintenance operations are contained in the design
plan. When you design the strategy, the facts listed below should be taken into
consideration. First, the users continuously access to the Orders table in the database.
Secondly, a column of the xml data type is contained by Orders table. Thirdly, the new rows
are regularly added to the Orders table. Fourthly, the average fragmentation for the
clustered index of the Orders table is no more than 2 percent. A strategy should be
designed to have the performance of the queries on the table optimized. Which action will
you perform?

You are a professional level SQL Sever 2008 Database Administrator. A database is
included by an instance. And a large table named OrderDetails is included by the database.
Only DML statements on the last three months data are executed by the application
queries. Administrative audits are managed monthly on data which is longer than four
months. The performance problems listed below are found by you in the database. The
performance of the application queries against the OrderDetail table is poor. It takes a long
time to perform the maintenance tasks against the database, index defragmentation is
contained. The performance problems should be solved with on impact on the server
performance. Which action will you perform?

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