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