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 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?

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

You have a database named Database1. Database1 has two stored procedures named
Proc1 and Proc2 and a table named Table1. Table1 has millions of rows.
Proc1 updates data in Table1. Proc2 reads data from Table1.
You discover that when Proc1 is executed to update more than 4,000 rows, Proc2 is
blocked. The book affects all rows, including those that are not being updated by Proc1.
You need to ensure that when Proc1 is executing, Proc2 can access the data in Table1 that
Proc1 is not updating.
What should you change Proc1 to do?
More than one answer choice may achieve the goal. Select the BEST answer.

You need to implement a solution that meets the data recovery requirements.
You update each stored procedure to accept a parameter named @transactionID.
What should you add next to the beginning of each stored procedure?

You plan to create a database that has multiple tables. The tables will contain product
information. Each product has a stock-keeping unit (SKU).
You need to recommend a solution to ensure that each SKU starts with the letters “ADV”
and is followed by 10 digits.

The solution must minimize the amount of development effort required.
What should you include in the recommendation?