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

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