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

You administer a Microsoft SQL Server 2012 database. The database contains a Product table created by
using the following definition:

You need to ensure that the minimum amount of disk space is used to store the data in the Product table. What
should you do?

You administer a Microsoft SQL Server 2012 server that hosts a transactional database
and a reporting database.
The transactional database is updated through a webapplication and is operational throughout the day.
The reporting database is only updated from the transactional database.
The recovery model and backup schedule are
configured as shown in the following table:

The differential backup of the reporting database fails.
Then, the reporting database fails at 14:00 hours.
You need to ensure that the reporting database is restored.
You also need to ensure that data loss is minimal.
What should you do?

You administer a Microsoft SQL Server 2012 server that hosts a transactional database
and a reporting database.
The transactional database is updated through a webapplication and is operational throughout the day.
The reporting database is only updated from the transactional database.
The recovery model and backup schedule are configured as shown in the following table:

At 14:00 hours, you discover that pages 71, 520, and 713 on one of the database files are corrupted onthe
reportingdatabase.
You need to ensure that the databases are restored.
You also need to ensure that data loss is minimal.
What should you do?