You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a
reporting database. The transactional database is updated through a web application 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 reporting database fails at 16:40 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 web application 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 transactional database. 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 web application 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
on the reporting database. 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 instance. The instance contains a database that
supports a retail sales application. The application generates hundreds of transactions per second
and is online 24 hours per day and 7 days per week. You plan to define a backup strategy for the
database. You need to ensure that the following requirements are met:
• No more than 5 minutes worth of transactions are lost.
• Data can be recovered by using the minimum amount of administrative effort.
What should you do? Choose all that apply.

DRAG DROP
You administer a Microsoft SQL Server database. Service accounts for SQL Agent are configured to
use a local user. A Microsoft SQL Server Integration Services (SSIS) job step has been created within a
SQL Server Agent job. The SSIS package accesses a network share when exporting data from a SQL
Server database. When you execute the SQL Server Agent job, it fails due to a permissions failure on
a share on a remote server. You need to ensure that the SQL Server Agent job can execute the SSIS
package. Which four 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.)

DRAG DROP
You administer a Microsoft SQL Server instance. You use a two-node SQL Server failover cluster.
Node B is primary, and Node A is secondary. You need to install a security patch on both nodes. 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.)

DRAG DROP
You administer a Microsoft SQL Server 2012 clustered instance that has two nodes named Node 1
and Node2. Node 1 fails and the cluster fails over to Node 2. You need to replace Node 1 and add it
to the cluster. Which four 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.)

DRAG DROP
You administer a Microsoft SQL Server 2012 database. The database is backed up according to the
following schedule:
• Daily full backup at 23:00 hours.
• Differential backups on the hour, except at 23:00 hours.
• Log backups every 10 minutes from the hour, except on the hour.
The database uses the Full recovery model. A developer accidentally drops a number of tables and
stored procedures from the database between 22:40 hours and 23:10 hours. You perform a
database restore at 23:30 hours to recover the dropped table. You need to restore the database by
using the minimum amount of administrative effort. You also need to ensure minimal data loss.
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.)

DRAG DROP
You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server
2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012. The
development team develops a new application that uses the SQL Server 2012 functionality. You are
planning to migrate a database from SQL2005 to SQL2012 so that the development team can test
their new application. You need to migrate the database without affecting the production
environment. 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 instance named SQL2012 that hosts an OLTP database
of 1 terabyte in size. The database is modified by users only from Monday through Friday from 09:00
hours to 17:00 hours. Users modify more than 30 percent of the data in the database during the
week. Backups are performed as shown in the following schedule:
The Finance department plans to execute a batch process every Saturday at 09:00 hours. This batch
process will take a maximum of 8 hours to complete. The batch process will update three tables that
are 10 GB in size. The batch process will update these tables multiple times. When the batch process
completes, the Finance department runs a report to find out whether the batch process has
completed correctly. You need to ensure that if the Finance department disapproves the batch
process, the batch operation can be rolled back in the minimum amount of time. What should you
do on Saturday?