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?

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

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

You are implementing a SQL Server 2012 five-node failover cluster.
You need to choose a quorum configuration.
Which configuration should you use?

HOTSPOT
You administer two Microsoft SQL Server 2012 databases named Contoso and
ContosoWarehouse.
You plan to replicate tables from the Contoso database to the ContosoWarehouse database.
Indexes will be added to the tables in ContosoWarehouse to improve the performance of
reports.
You need to ensure that the following requirements are met:
• Indexes are not modified when the subscriptions are reinitialized.
• Only the clustered index from Contoso will be replicated.
• Minimal transaction log activity during the reinitialization.
What should you do? Choose the correct option(s).