You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2.
ABC.com has two servers, named ABC-SR13 and ABC-SR14, which has SQL Server 2008 R2
installed. Both of these servers hosts a copy of a database, named ABCProducts. You have
configured transactional replication for ABCProducts between ABC-SR13 and ABC-SR14 with a
latency of 1 minute. You have also configure a backup strategy for ABCProducts as follows:
•A daily full backup after business hours.
•Transaction log backups every 30 minutes during business hours.
When ABCProducts on ABC-SR14 fails and cannot fix it, you verify that the ABCProducts
database located on ABC-SR13 is operating as normal.
You are then instructed to restore the ABCProducts database on ABC-SR14 with the least
possible data loss, in the shortest amount of time. The process should also have the least effect
on users of ABC-SR13 and ABC-SR14.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
You have been informed that a database designer, named Andy Reid, requires the necessary
permissions to view the definitions of all database objects in a database. You are also informed
that you will be assigning the same permissions to other designers in the near future.

You want to make sure that the entire process requires as little Transact-SQL statements as
possible.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.
ABC.com has introduced a new security to allow members of a Windows group, called ABC_Prod,
to build new links to the SQL Server instance. The ABC_Prod group should only be able to build
these links from 10 AM to 10 PM. The new policy will be hosted by a table, called
RestrictedTester.
You are then informed that the implementation of the security policy should also allow for other
ABC.com users to access the instance at any time.
You realize that to achieve this, you have to create a logon trigger that prevents the ABC_Prod
group from accessing the instance outside of the allotted hours.
Which of the following options are TRUE with regards to logon triggers? (Choose all that apply.)

You work as a database administrator at ABC.com.ABC.com makes use of SQL Server 2008 R2.
ABC.com has a SQL Server 2008 R2 instance that includes a database, named ABC_DB, which
hosts the ProductItems table.
You have been instructed to implement a Replication topology to ensure that the ProductItems
table is replicated to the SQL Server instances running on mobile workstations. Even though the
ProductItems table is constantly refreshed, the ProductItems table should only be refreshed when
a mobile user connects to the ABC.com network.
Your solution should allow for the Replication topology to run in conjunction with the Subscription
type, while keeping the amount of bandwidth consumed to a minimum.
Which of the following options should you include in your strategy? (Choose all that apply.)

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
The database allows for the processing of predefined and informal queries. There is, however, a
suspicion that some queries will consume too much of the available resources. You want to
identify the queries that consume the majority of the resources.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com makes use of SQL Server 2008 R2.
ABC.com has a SQL Server 2008 R2 cluster made up of physical servers and a virtual server. You
have been instructed to make sure that between the physical servers and the virtual server is
encrypted.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_Sales. The database contains a Sales table.
You have developed a Merge Replication topology and a Publication that is configured to keep
data for 25 days. This configuration allows for the Sales table to be replicated to remote SQL
Server instances.
You have received a report from a ABC.com user, named Mia Hamm, regarding ABC_Sales not
including the latest information. Mia Hamm has informed you that she has been on holiday for
more than 25 days.
You are required to make sure that Mia Hamm has the latest information in her database as soon
as possible. Your solution should also allow for further modifications to the database information to
be replicated properly.

Which of the following actions should you take? (Choose all that apply.)

You work as a database administrator at ABC.com.ABC.com contains a server, named ABCDB01, which has SQL Server 2008 R2 installed and includes multiple instances of SQL Server
2008 R2.
These multiple instances of SQL Server2008 R2 should be able to link up to the dedicated
administrative link as part of ABC.com’s disaster recovery strategy. During testing you are able to
hook up to the link on ABC-DB01’s default instance, but you are unable to hook up to the
dedicated link on the other two instances.
You have received the following instructions:
•Make sure that the instances are executing.
•Make sure that the client applications can approach the instances.
•Prevent other administrators from hooking up to any dedicated links on ABC-DB01.
•Ensure that you are able to hook up to the dedicated link on all of the instances.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
The SQL Server 2008 R2 instance contains a database, named ABC_Prod, which are log shipped
to a remote SQL Server 2008 R2 server. Subsequent to rebooting the primary SQL Server
instance, you notice that the log shipping is no longer functioning.
You have been tasked with finding the reason for the log shipping not functioning.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
Subsequent to installing an important cluster, which necessitates continuous accessibility, on a
pair of cluster-ready nodes, you are instructed to make sure that the disruption of the service is
reduced.
Which of the following actions should you take?