You plan to install a Microsoft SQL Server 2012 instance.
The instance will support a database that has the following requirements:
Store Excel workbooks on the file system.
Access the workbooks through Transact-SQL.

Include the workbooks in database backups.
During installation, you need to ensure that the requirements will be met.
Which feature should you use?

You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of
migrating a database from a SQL Server 2008 instance named SQL2008 to the SQL2012 instance.
You have upgraded a database from the SQL2008 instance by using the side-by-side migration
technique.
You need to migrate the SQL Server logins from the SQL2008 instance to the SQL2012 instance.
What should you do?

You administer a Microsoft SQL Server 2012 database instance. You create a new user named UserA
You need to ensure that UserA is able to create SQL Server Agent jobs and execute SQL Server agent
jobs owned by UserA
To which role should you add UserA?

You administer a Microsoft SQL Server 2012 database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step
within the job that requires elevated privileges.
You need to ensure that the job step can run using a different user account.
What should you use?

You install a Microsoft SQL Server 2012 instance.
The instance will store data extracted from two databases running on Windows Azure SQL Database.
You hire a data steward to perform interactive data cleansing and ad hoc querying and updating of
the data.
You need to ensure that the data steward is given the correct client tools to perform these tasks.
Which set of tools should you install?

You administer a Microsoft SQL Server environment. You purchase a new server and plan to migrate
your database from SQL Server 2008 to SQL Server 2012.
You want to evaluate to prepare for possible conflicts and issues that may arise during or after the
migration.
Which SQL Server tool should you use?

DRAG DROP
You are migrating an OLTP database from Windows Azure SQL Database to on-premise. You are
planning the installation of a Microsoft SQL Server 2012 server failover cluster. The server has the
following partitions:

You install the operating system on the C: drive.
The database solution will use row versioning, triggers, and cursors. The tempdb database cannot be
placed on the same disk subsystem as the OLTP database.
The OLTP database needs to be on the fastest disk subsystem possible. The database is currently
200GB in size. It will not substantially increase in size in the next 3 years.

You need to plan the usage of the disk subsystems.
To which hard disk should each database belong? (To answer, drag the appropriate database or
databases to their corresponding hard disk or disks in the answer area. Answer choices may be used
once, more than once, or not at all. Answer targets may be used once or not at all. Additionally, you
may need to drag the split bar between panes or scroll to view content.)

DRAG DROP
You administer several Microsoft SQL Server 2012 servers.
You want to run scheduled checks to confirm that the databases on the servers are not configured to
AutoShrink.
You need to create a policy to check the condition.
What should you do? (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 Windows Azure SQL Database database used for data warehouse operations.

The database contains a table named OrdersHistory, defined as follows:
A weekly ETL (extract-transform-load) runs a large INSERT statement to add data into the
OrdersHistory table. The process is taking a long time to complete. You discover that the bulk of the
process is performing non-clustered index updates on the OrdersHistory table.
You need to improve the performance of the ETL process faster. You need to meet the following
requirements:
Avoid losing existing permissions on existing objects.
Use minimal administrative effort.
What should you do? (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 Enterprise Edition server that uses 64 cores.
You discover performance issues when complex calculations are performed on large amounts of
data under heavy system load.
You need to limit the number of cores that handle the processing.
What should you configure?