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?

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 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 transaction log file does not exceed 2 GB.
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 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.

You administer a Microsoft SQL Server 2012 failover cluster that contains two nodes named Node A
and Node B. A single instance of SQL Server is installed on the cluster.
An additional node named Node C has been added to the existing cluster.
You need to ensure that the SQL Server instance can use all nodes of the cluster.

What should you do?

DRAG DROP
You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes
named Node A and Node B. The instance is currently running on Node
A
You want to patch both Node A and Node B by using the most recent SQL Server Service Pack.
You need to ensure that the following requirements are met:
Both nodes receive the update.
Downtime is minimized.
No data is lost.
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.
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 instance. After a routine shutdown, the drive that
contains tempdb fails.
You need to be able to start the SQL Server.
What should you do?