70-462 – Administering Microsoft SQL Server 2012/2014 Databases

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

Select and Place:

DRAG DROP

You administer several Microsoft SQL Server 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 method for 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:

HOTSPOT You administer a Microsoft SQL Server database.

The database is in the Simple recovery mode.

You schedule the following backup plan:

Full backup every day at midnight

Differential backups every hour on the hour, except at midnight

The database fails at 20:45 hours.

You need to use SQL Server Management Studio (SSMS) to begin restoring the database with a minimum amount of data loss.

Which options should you select on the Options page of the Restore Database window? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Hot Area: