Microsoft
70-459 · Question #94
You administer an instance of SQL Server 2014. You are tasked with tuning a common set of queries. You have the results of several test executions, along with query plans. The schema and the data…
The correct answer is B. The queries would perform worse if the index named AccountNumber included the D. The object Account is a table, with an index havinga leading column of AccountNumber. See the full explanation below for the reasoning.
Question
You administer an instance of SQL Server 2014. You are tasked with tuning a common set of queries. You have the results of several test executions, along with query plans. The schema and the data for all database object(s) used remain unchanged between executions. The QueryTime column is defined as a computed column that uses the GETDATEO system function. The query plans and results are shown below: You need to make an initial diagnosis of the situation, based solely on this input. Which two statements can you make about the performance characteristics of this query? Each correct answer presents a complete solution. Choose two.
Exhibits
Options
- AThe queries would perform better if the index named AccountNumber included the
- BThe queries would perform worse if the index named AccountNumber included the
- CThe queries would perform better if the index named AccountNumber included the
- DThe object Account is a table, with an index havinga leading column of AccountNumber
- EThe object Account is an indexed view, with an index having a leading column of
- FThe object Account is a view, joining the Account-AccountNumber and Account.PKAccount
How the community answered
(53 responses)- A6% (3)
- B81% (43)
- C2% (1)
- E2% (1)
- F9% (5)
Community Discussion
No community discussion yet for this question.