Which of the following solutions would meet the encryption requirement?
You work as a Systems Administrator at a company named ABC.com. You are in the process of
deploying new servers running SQL Server 2012.
You need to deploy a SQL Server 2012 server to host databases used by the Research and
Development department. The databases used by the Research and Development department
will store sensitive data.
A company security policy states that if Research and Development department database files
and log files are moved to another server, the files must be encrypted.
Which of the following solutions would meet the encryption requirement?
What is the minimum number of servers required for each solution?
You work as a Systems Administrator at a company named ABC.com. You are in the process of
deploying new servers running SQL Server 2012.
You need to implement a highly available solution. You need to ensure that the databases remain
online in the event of a single server failure.
You are evaluating the server requirements for AlwaysOn with automatic failover and mirroring
with automatic failover.
What is the minimum number of servers required for each solution? (Choose two).
Which of the following is the replication type being discussed?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing replication type that distributes data exactly as it appears at a specific moment in time
and does not monitor for updates to the data.
Which of the following is the replication type being discussed?
Which of the following is the required endpoint?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
ABC.com has several instances of SQL server in their environment. You have been instructed to
make sure that AlwaysOn Availability Groups are supported.
You need to configure a certain endpoint on each instance.
Which of the following is the required endpoint?
Which of the following is the replication agent being discussed?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing replication agent that has a “slow link” profile designed for low bandwidth connections.
Which of the following is the replication agent being discussed?
Which of the following is TRUE with regards to the AlwaysOn Availability Groups feature?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of AlwaysOn Availability Groups feature.
Which of the following is TRUE with regards to the AlwaysOn Availability Groups feature? (Choose
all that apply.)
Which of the following is TRUE with regards to the use of a Database mirroring strategy?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of a Database mirroring strategy.
Which of the following is TRUE with regards to the use of a Database mirroring strategy? (Choose
all that apply.)
Which of the following is TRUE with regards to this discussion?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing what the purpose of assigning the db_owner fixed database-level role to a user.
Which of the following is TRUE with regards to this discussion?
Which of the following is TRUE with regards to contained databases?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing contained databases.
Which of the following is TRUE with regards to contained databases? (Choose all that apply.)
Which of the following is TRUE with regards to DTA?
You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the Database Engine Tuning Advisor (DTA).
Which of the following is TRUE with regards to DTA? (Choose all that apply.)