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?

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?

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 Piecemeal restore strategy.
Which of the following is TRUE with regards to this strategy? (Choose all that apply.)

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 copying data between data sources.
Which of the following is the simplest method of achieving this?

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 indexes that sort and store the data rows in a table or view based on their key values.
Which of the following is the index 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 the use of the DENY SELECT ON Schema Transact-SQL statement.
Which of the following is the purpose of this Transact-SQL statement?

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 the DENY SELECT ON Object Transact-SQL statement.
Which of the following is the purpose of this Transact-SQL statement?

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 the REVOKE SELECT ON Object Transact-SQL statement.
Which of the following is the purpose of this Transact-SQL statement?

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 the REVOKE SELECT ON Schema Transact-SQL statement.
Which of the following is the purpose of this Transact-SQL statement?

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 DIFFERENTIAL backup strategy.
Which of the following is TRUE with regards to this strategy? (Choose all that apply.)