Question 1.
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?

A. Snapshot replication.
B. Transactional replication.
C. Merge replication.
D. Peer-to-peer replication

Answer: A

Explanation:

Question 2.
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?

A. A Loopback endpoint.
B. A database mirroring endpoint.
C. A Remote endpoint.
D. A Soap endpoint.

Answer: B

Explanation:

Question 3.
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?

A. The Snapshot agent.
B. The Transactional agent.
C. The Merge agent.
D. The Peer-to-peer agent.

Answer: C

Explanation:

Question 4.
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.)

A. The AlwaysOn Availability Groups feature supports availability replicas in excess of 5.
B. The AlwaysOn Availability Groups feature supports up to 5 availability replicas.
C. The AlwaysOn Availability Groups feature supports a number of availability-group failover forms.
D. The AlwaysOn Availability Groups feature only supports planned manual failover.

Answer: B, C

Explanation:

Question 5.
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.)

A. Only user databases can be mirrored.
B. All databases, including the master, msdb, tempdb, or model databases, can be mirrored.
C. Database mirroring is supported with cross-database transactions and distributed transactions.
D. A mirrored database cannot be renamed during a database mirroring session.

Answer: A, D

Explanation:

Question 6.
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?

A. It allows the user to perform all configuration and maintenance activities on the database, and can also drop the database.
B. It allows the user to modify role membership and manage permissions.
C. It allows the user to add or remove access to the database for Windows logins.
D. It allows the user to run any Data Definition Language (DDL) command in a database.

Answer: A

Explanation:

Question 7.
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.)

A. Users are prevented from updating the information in contained objects directly.
B. It is isolated from other databases and from the instance of SQL Server that hosts the database.
C. The MSDB database is an example of a contained database.
D. It includes all the settings and metadata necessary to define the database and has no configuration dependencies on the instance of the SQL Server Database Engine where the  database is installed.

Answer: B, D

Explanation:

Question 8.
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.)

A. DTA is able to add or drop unique indexes or indexes that enforce PRIMARY KEY or UNIQUE constraints.
B. DTA is able to analyze databases and makes recommendations that you can use to optimize  query performance.
C. DTA is able to analyze a database that is set to single-user mode.
D. Database Engine Tuning Advisor stores tuning session data and other information in the msdb database.

Answer: B, D

Explanation:

Question 9.
You work as a 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 a database that hosts highly classified information. You have received instructions to configure page level encryption for the database files. Your solution should also allow for transaction log files to be encrypted. You start by creating a master key. You then create a certificate in the master database, which is protected by the master key.

Which of the following actions should you take NEXT?

A. You should consider creating a database encryption key in the master database.
B. You should consider creating a database encryption key in the user database.
C. You should consider creating a symmetric encryption key in the master database.
D. You should consider creating a symmetric encryption key in the user database.

Answer: B

Explanation:

Question 10.
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 a recovery model that does not make use of log backups.

Which of the following is the recovery model being discussed?

A. The Full Recovery Model.
B. The Simple Recovery Model.
C. The Bulk-Logged Recovery Model.
D. The MDS model.

Answer: B

Explanation:

	Web www.certsbraindumps.com