Microsoft
70-459 · Question #94
70-459 Question #94: Real Exam Question with Answer & Explanation
Sign in or unlock 70-459 to reveal the answer and full explanation for question #94. The question stem and answer options stay visible for context.
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
Unlock 70-459 to see the answer
You've previewed enough free 70-459 questions. Unlock 70-459 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.