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?

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 on the 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?