You have a server that has SQL Server 2012 installed.
You need to identify which parallel execution plans are running in serial.
Which tool should you use?

You have a SQL Server 2012 database named DB1. You have a backup device named
Device1.
You discover that the log file for the database is full.
You need to ensure that DB1 can complete transactions. The solution must not affect the
chain of log sequence numbers (LSNs).
Which code segment should you execute?

DRAG DROP
You plan to create a new table that will contain a column named Salary. Salary will contain
highly sensitive data.
Salary must meet the following requirements:
Contain numeric data.
Contain only encrypted data that remains encrypted in memory.
You need to identify which encryption type and data type must be used for Salary.
Which encryption type and data type should you identity?
To answer, drag the appropriate encryption type and data type to the correct identifier in the
answer area.

You have a Microsoft SQL Azure database named DBAzure1.
You create a table in DBAzure1 by using the following script:

You need to recommend a solution to ensure that each combination of CustomerContact
and CustomerDetails is not duplicated.
What should you recommend creating?

DRAG DROP
Your network contains a SQL Server 2012 instance named SQL1. SQL1 contains a
database named DB1. DB1 contains three tables.
The tables are configured as shown in the following table.

You plan to create indexes for the tables.
You need to identify which type of index must be created for each table. The solution must
minimize the amount of time required to return information from the tables.
Which type of index should you create for each table? To answer, drag the appropriate index
type to the correct table in the answer area.

DRAG DROP
You create a table that contains the following script:

You need to prevent duplicate values in the EmployeeID field.
Which five code segments should you use?
To answer, move the appropriate code segments from the list of code segments to the
answer area and arrange them in the correct order.

You plan to create a new table that has the following requirements:
Uses a GUID data type as the primary key.
Uses a clustered index as the primary key.
Minimizes fragmentation.
You need to recommend which option to include in the CREATE statement.
Which option should you include?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2012 instance named SQL\Instance1. Instance1 contains a
database named Database1.
You need to recommend an index defragmentation solution for an index named
ContentIndex. ContentIndex must meet the following requirements:
Remain online during the defragmentation.
Update distribution statistics.
Perform defragmentation as quickly as possible.
Which type of index defragmentation solution should you include in the recommendation?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Azure database.
You need to identify which keyword must be used to create a view that will be indexed.

Which keyword should you identify?

You have a SQL Server 2012 database named Database1. Database1 contains a table
named OrderDetails.
For a given sales order, you need to retrieve the OrderID, Quantity, and LineTotal columns
for all of the items in the OrderDetails table. The solution must ensure that the results can be
joined to other tables.
Which code segment should you execute?