You have a database named database1.
Database developers report that there are many deadlocks.
You need to implement a solution to monitor the deadlocks. The solution must meet the
following requirements:
Support real-time monitoring.
Be enabled and disabled easily.
Support querying of the monitored data.
What should you implement?
More than one answer choice may achieve the goal. Select the BEST answer.

You execute the following code:

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

You need to prevent the key lookup.

What should you modify?
More than one answer choice may achieve the goal. Select the BEST answer.

DRAG DROP
You have a table named Table1. Table1 has 1 million rows.
Table1 has a columnstore index for a column named Column1.
You need to import data to Table1. The solution must minimize the amount of time it takes to
import the data.
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 have a database for a mission-critical web application. The database is stored on a SQL
Server 2012 instance and is the only database on the instance.
The application generates all T-SQL statements dynamically and does not use stored
procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?

DRAG DROP
You are designing two stored procedures named Procedure1 and Procedure2.
You identify the following requirements:
Procedure1 must take a parameter that ensures that multiple rows of data can pass into the
stored procedure.
Procedure2 must use business logic that resides in a Microsoft .NET Framework assembly.
You need to identify the appropriate technology for each stored procedure.
Which technologies should you identify?
To answer, drag the appropriate technology to the correct stored procedure in the answer
area. (Answer choices may be used once, more than once, or not at all.)

You have an application that uses a view to access data from multiple tables.

You need to ensure that you can insert rows into the underlying tables by using the view.
What should you do?

You have a database that contains a user-defined function named Schema1.Udfl and two
tables named Schema1.Table1 and Schema1.Table2.
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as
shown in the following table.

Schema1.Udf1 was defined by using the following code:

You need to write a query that will contain the following columns:
Country
CountryID
CustomerName
The solution must meet the following requirements:
Rows must be returned only if the function returns data.
The amount of time it takes the query to execute must be minimized.
Which query should you use?

You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference only.)

You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?

You have a Microsoft SQL Azure database.
You have the following stored procedure:

You discover that the stored procedure periodically fails to update HR.Employees.
You need to ensure that HR.Employees is always updated when up_employees executes.
The solution must minimize the amount of time required for the stored procedure to execute
and the number of locks held.
What should you do?

DRAG DROP
You are planning two stored procedures named SProc1 and SProc2. You identify the
following requirements:
SProc1 must return a table.
SProc2 must return a status code.
You need to identify which options must be implemented to meet each stored procedure
requirement.
Which options should you identify?
To answer, drag the appropriate option to the correct requirement in the answer area.
(Answer choices may be used once, more than once, or not at all.)