You administer a Microsoft SQL Server 2012 databasethat has Trustworthy set to On.
You create a stored procedure that returns database-level information from Dynamic Management Views.
You grant User1 access to execute the stored procedure.
You need to ensure that the stored procedure returns the required information when User1 executes the stored
procedure.
You need to achieve this goal by granting the minimum permissions required. What should you do? (Each
correct answer presents a complete solution. Chooseall that apply.)

You are migrating a database named Orders to a new server that runs Microsoft SQL Server 2012.
You attempt to add the [Corpnet\User1] login to thedatabase. However, you receive the following error
message:
“User already exists in current database.”
You need to configure the [Corpnet\User1] login to be able to access the Orders database and retain the
original permissions.
You need to achieve this goal by using the minimum required permissions.Which Transact-SQL statement
should you use?

You administer a Microsoft SQL Server 2012 database. You configure Transparent Data Encryption (TDE) on
the Orders database by using the following statements:
<code>
CREATE MASTER KEY ENCRYPTION BY PASSWORD = ‘MyPassword1!’;
CREATE CERTIFICATE TDE_Certificate WITH SUBJECT = ‘TDE Certificate’;
BACKUP CERTIFICATE TDE_Certificate TO FILE = ‘d:\TDE_Certificate.cer’
WITH PRIVATE KEY (FILE = ‘d:\TDE_Certificate.key’, ENCRYPTION BY PASSWORD =
‘MyPassword1!’);
CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_256
ENCRYPTION BY SERVER CERTIFICATE TDE_Certificate;
ALTER DATABASE Orders SET ENCRYPTION ON;
</code>
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 encryptionfiles to
their original location. However, you are unable toaccess the database.
You need to be able to restore the database.
Which Transact-SQL statement should you use before attempting the restore?

You administer a Microsoft SQL Server 2012 database.
You provide temporary securityadmin access to User1to 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?

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 byretrieving 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?

You administer a Microsoft SQL Server 2012 database.
You need to ensure that the size of the transactionlog 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 namedCONTOSO\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.

You administer a Microsoft SQL Server 2012 failovercluster that contains two nodes named Node A and Node