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
reporting database.
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 16:20 hours, you discover that pages 17, 137, and 205 on one of the database files are corrupted onthe
transactionaldatabase.
You need to ensure that the transactional 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:

One of the hard disk drives that stores the reportingdatabase fails at 16:40hours.
You need to ensure that the reporting database is restored.
You also need to ensure that data loss is minimal.
What should you do?

DRAG AND DROP
You administer several Microsoft SQL Server 2012 servers.
Your company has a number of offices across the world connected by using a wide area network (WAN).
Connections between offices vary significantly in both bandwidth and reliability.
You need to identify the correct replication methodfor each scenario.
What should you do? (To answer, drag the appropriate replication method or methods to the correct location or
locations in the answer area. Each replication method may be used once, more than once, or not at all.)
Select and Place: