QSDA2018 practice

Q1 Single choice

Refer to the exhibit.

A data architect loads order data for a global sales organization. The Order Details contains 100 million rows. The data architect must load only the data for the North America division.

Which WHERE clause should the data architect use in the Order Details LOAD script?

A
WHERE Division = `North America";
B
WHERE Exists(OrderNum);
C
WHERE OrderNum = [Order Header].[OrderNum];
D
WHERE Exists(`North America');