070-464 무료 덤프문제 온라인 액세스

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?

• A.Replace LEFT(name,3) = 'smi' by using name like 'smi%'
• B.Replace LEFT(name,3) = 'smi' by using substring(name,l,3) = 'smi'
• C.Recreate IX Name as a clustered index
• D.Recreate IX_Name as a unique index

You create a view by using the following code:

Several months after you create the view, users report that the view has started to return unexpected results.
You discover that the design of Table2 was modified since you created the view.
You need to ensure that the view returns the correct results.
Which code segment should you run?

• A.Option D
• B.Option B
• C.Option A
• D.Option C

You are testing disaster recovery procedures.
You attempt to restore DB1 to a different server and you receive the following error message: "Msg 33111.
Level 16, State 3, Line 1
Cannot find server certificate with thumbprint
,0xA694FBEA88C9354E5E2567C30A2A69E8FB4C44A9\
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally."
You need to ensure that you can restore DB1 to a different server.
Which code segment should you execute?

• A.Option D
• B.Option B
• C.Option A
• D.Option C

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?

• A.Option D
• B.Option B
• C.Option A
• D.Option C

You have a Microsoft SQL Azure database that contains a table named Customers.
You have a table-valued function named TopCustomers that returns a list of all the customers that have purchased items during the last 12 months. The ID of the customer is passed as an argument to the TopCustomers function.
You need to create a query that returns a list of all the Customer names and the purchase dates.
The solution must return only customers that have purchased an item during the last 12 months.
What should you add to the query?

• A.CROSS JOIN
• B.OUTER APPLY
• C.CROSS APPLY
• D.OUTER JOIN