You create a table named Customers by using the following code segment:

You create a non-clustered index named IX_Name on the name column.
You write the following query to retrieve all of the customers that have a name that starts
with the letters SMI:

You discover that the query performs a table scan.
You need to ensure that the query uses the index.
What should you do?

You plan to execute the following code:

You need to identify how many rows will be in dbo.Table1 after you execute the code.
How many rows should you identify?

You plan to design an application that temporarily stores data in a SQL Azure database.
You need to identify which types of database objects can be used to store data for the
application. The solution must ensure that the application can make changes to the schema
of a temporary object during a session.
Which type of objects should you identify?

DRAG DROP
You have a table named Customers that has a clustered index defined on the ID column.
You write a script to create a stored procedure.
You need to complete the script for the stored procedure. The solution must minimize the
number of locks and deadlocks.
What should you do?
To answer, drag the appropriate option to the correct location in the answer area. (Answer
choices may be used once, more than once, or not at all.)

You execute the following code:

You have a stored procedure that includes the following SELECT statement:

You need to create a covering index on UserInfo.
Which code segment should you execute?

You have an index for a table in a SQL Azure database. The database is used for Online
Transaction Processing (OLTP).
You discover that the index consumes more physical disk space than necessary.
You need to minimize the amount of disk space that the index consumes.
What should you set from the index options?

You run the following code:

You need to ensure that the root node of the XML data stored in the Details column is
<Order_Details>.
What should you implement?
More than one answer choice may achieve the goal. Select the BEST answer.

You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a user-defined
function is called to validate the row before the row is added to the table.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a SQL Azure database.
You execute the following code:

The Sales.Customers table will contain 100,000 rows. You expect the FaxNumber column to
contain a null value for 70 percent of the rows.
You need to create an index to support Sales.CustomersByFaxNumber. The solution must
minimize the disk storage requirements.
Which code segment should you execute?

You plan to create a new column in a table. The column must meet the following
requirements:
Be able to store images that are larger than 1 MB each.
Be able to access the images from Microsoft .NET Framework applications.
You need to recommend which data type must be used in the column.
Which data type should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.