You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS)
installed. You plan to deploy new SSIS packages to the server. The SSIS packages use the Project
Deployment Model together with parameters and Integration Services environment variables. You
need to configure the SQL Server environment to support these packages. What should you do?

You administer a Microsoft SQL Server database named Sales. The database is 3 terabytes in size.
The Sales database is configured as shown in the following table.

You discover that all files except Sales_2.ndf are corrupt. You need to recover the corrupted data in
the minimum amount of time. 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:

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 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.)

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 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.)