070-459 試験問題を無料オンラインアクセス

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?

• A.Define the view by using the SCHEMABINDING option.
• B.Materialize the view.
• C.Define the view by using the CHECK option.
• D.Create an INSTEAD OF trigger on the view.

DRAG DROP
You have two existing tables, one named COUNTRY and the other named STATES. The tables are defined as follows:

You need to set up a rule that every STATE.Country_Abbr must match an existing record in the COUNTRY table.
Develop the solution by selecting and arranging the required code blocks in the correct order.
You may not need all of the code blocks.

正解：

You need to modify the usp.DetectSuspiciousActivity stored procedure.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

• A.Option C
• B.Option D
• C.Option E
• D.Option F
• E.Option B
• F.Option A

You execute the following code:

You create a nonclustered index named IXCustomerName on the CustomerName column. You execute the following query:

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

• A.Replace LEFT(CustomerName ,1) = 'a' with SUBSTRING(CustomerName ,1,1) - 'a'.
• B.Replace IX_CustomerName with a clustered index.
• C.Replace LEFT(CustomerName ,1) = 'a' with CustomerName LIKE 'a%'.
• D.Partition the table and use the CustomerName column for the partition scheme.

You need to recommend a solution to improve the performance of usp_UpdateInventory. The solution must minimize the amount of development effort.
What should you include in the recommendation?

• A.a cursor
• B.a table variable
• C.a common table expression
• D.a subquery