You administer a Microsoft SQL Server 2012 database.
You configure Transparent Data Encryption (TDE) on the Orders database by using the following
statements:

You attempt to restore the Orders database and the restore fails. You copy the encryption file to the
original location.
A hardware failure occurs and so a new server must be installed and configured.
After installing SQL Server to the new server, you restore the Orders database and copy the
encryption files to their original location. However, you are unable to access the database.
You need to be able to restore the database.
Which Transact-SQL statement should you use before attempting the restore?

DRAG DROP
You administer a Microsoft SQL Server 2012 server that has multiple databases.
You need to ensure that users are unable to create stored procedures that begin with sp_.
Which three actions should you perform in sequence? (To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)

You administer a Microsoft SQL Server 2012 database.
You provide temporary securityadmin access to User1 to the database server.
You need to know if User1 adds logins to securityadmin.
Which server-level audit action group should you use?

You administer a Microsoft SQL Server 2012 instance.
You need to stop a blocking process that has an SPID of 64 without stopping other processes
What should you do?

DRAG DROP
You administer a Microsoft SQL Server 2012 server.
A variety of issues occur from time to time in the production environment. You need to identify the
appropriate tool for each issue.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the correct
issue or issues in the answer area. Each tool may be used once, more than once, or not at all. You
may need to drag the split bar between panes or scroll to view content.)

You administer a Microsoft SQL Server 2012 database.
Users report that an application that accesses the database displays an error, but the error does not
provide meaningful information. No entries are found in the SQL Server log or Windows event logs
related to the error.
You need to identify the root cause of the issue by retrieving the error message.
What should you do?

You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports a
highly active OLTP application.
Users report abnormally long wait times when they submit data into the application.
You need to identify which queries are taking longer than 1 second to run over an extended period
of time.
What should you do?

DRAG DROP
You administer a Microsoft SQL Server database that is used by an application.
Users of the application report performance issues.
You need to choose the appropriate tool for performance-tuning of SQL Server databases.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to their
corresponding task or tasks in the answer are

You administer a Microsoft SQL Server 2012 database.
You need to ensure that the size of the transaction log file does not exceed 2 GB.
What should you do?

You administer a Microsoft SQL Server 2012 server. The MSSQLSERVER service uses a domain
account named CONTOSO\SQLService.
You plan to configure Instant File Initialization.
You need to ensure that Data File Autogrow operations use Instant File Initialization.
What should you do? Choose all that apply.