You have database objects that were created by using the following script:

The dbo.Customers table has 1 million rows.
You discover that usp_GetCustomersByDate takes a long time to complete.

The query plan used by the stored procedure is shown in the exhibit. (Click the Exhibit
button.)

You need to ensure that usp_GetCustomersByDate completes as quickly as possible.
What should you do?

You have a database named DB1.
You plan to configure change data capture on the existing tables in DB1.
The database file settings for the DB1 are shown in the exhibit. (Click the Exhibit button.)

You need to minimize disk contention caused by change data capture.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Server 2012 database named DB1 that is accessed by 650 concurrent
users.

You need to log all of the queries to DB1 that become deadlocked. The solution must
minimize the impact on the server.
What should you create?

You have a database named Database1.
You execute the following code:

You have the following query. (Line numbers are included for reference only.)

Users report that the query takes a long time to complete.
You create a full-text index for the Notes column.
You need to recommend changes to the query to reduce the amount of time it takes for the
query to complete.
Which code segment should you use to replace line 03?

You have a SQL Server 2012 instance.
You plan to create an application that uses spatial data.
You need to create an object that will support the representation of the surface area of all the
oceans.
Which code segment should you use?

You use SQL Server 2012 to store data used by an e-commerce application.

You develop a stored procedure named sp1. Sp1 is used to read the price of all the products
sold on the e-commerce site.
You need to ensure that sp1 can read data even while another transaction is modifying the
price of a product. Sp1 must only read committed data.
Which transaction isolation level should you use in sp1?

DRAG DROP
You have a database named database1. Each table in database1 has one index per column.
Users often report that creating items takes a long time.
You need to perform the following maintenance tasks:
Identify unused indexes.
Identify indexes that need to be defragmented.
What should you use?
To answer, drag the appropriate function to the correct management task in the answer
area. (Answer choices may be used once, more than once, or not at all.)

DRAG DROP
You have a database that contains three tables. The tables are configured as shown in the
following table.

You have the following query:

The execution plan for the query is shown in the exhibit. (Click the Exhibit button.)

You need to create one index to minimize the amount of time it takes to execute the query.
What should you do?
To answer, drag the appropriate columns to the correct locations in the answer area.
(Answer choices may be used once, more than once, or not at all.)

You have a SQL Server 2012 instance that hosts a single-user database.
The database does not contain user-created stored procedures or user-created functions.
You need to minimize the amount of memory used for query plan caching.
Which advanced server option should you modify?

You execute the following code.

After populating the Employees table with 10,000 rows, you execute the following query:

You need to reduce the amount of time it takes to execute the query.
What should you do?