C_TADM53_70 · Question #13
While monitoring and analyzing expensive SQL statements, you identify an expensive statement which looks like the following: SELECT A, B FROM T WHERE C= <VALUE1> AND D=<VALUE2> Here, T is the…
Sign in or unlock C_TADM53_70 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Question
While monitoring and analyzing expensive SQL statements, you identify an expensive statement which looks like the following:
SELECT A, B FROM T WHERE C= <VALUE1> AND D=<VALUE2> Here, T is the relevant database table and A, B, C, D are its columns; each of them containing data that can be sorted. Although a clustered index and several non-clustered indexes already exist for this table, none of them is optimal, because none of them includes the columns C and D as key columns. You want to create a new index to tune the mentioned statement in an optimal way. What is the best solution?
Options
- AOption D
- BOption A
- COption B
- DOption C
Unlock C_TADM53_70 to see the answer
You've previewed enough free C_TADM53_70 questions. Unlock C_TADM53_70 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.