Which column should appear in the WHERE statement clause of the query?

Posted by: Pdfprep Category: 70-767 Tags: , ,

You are designing a warehouse named DW1.

A table named Table1 is partitioned by using the following partitioning scheme and function.

Reports are generated from the data in Table1.

You need to ensure that queries to DW1 return results as quickly as possible.

Which column should appear in the WHERE statement clause of the query?
A . AccountNumber
B . MyId
C . DueDate
D . OrderDate

Answer: D

Leave a Reply

Your email address will not be published.