C_TADM53_70 Question #13: Real Exam Question with Answer & Explanation

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?