Microsoft
70-451 · Question #41
70-451 Question #41: Real Exam Question with Answer & Explanation
Sign in or unlock 70-451 to reveal the answer and full explanation for question #41. The question stem and answer options stay visible for context.
Question
You are a database developer. You plan to design a database solution by using SQL Server 2008. The database has a table named Sales. The Sales table contains 10 million rows. You discover that the following query takes a long time to execute. SELECT s.sale_id,... FROM Sales AS s JOIN Country AS c ON s.Country_id = c.Country_id AND c.Country_name = 'USA' A summary of the execution plan is as shown in the following code segment. |--Hash Match(Inner Join, HASH: ([s].[Country_id]) = ([c].[Country_id]) |--Clustered Index Scan(OBJECT:([Country].[PK_Country_Country_id] AS [c]) |--Clustered Index Scan(OBJECT:([Sales].[PK_Sales_Sale_id] AS [s])) You need to ensure that the query retrieves data in minimum possible time. What should you do?
Options
- AModify the query to use a loop join hint.
- BModify the query to use a merge join hint.
- CCreate a nonclustered index in the Country_id column of the Sales table.
- DCreate a nonclustered index in the Country_name column of the Country table.
Unlock 70-451 to see the answer
You've previewed enough free 70-451 questions. Unlock 70-451 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.