<< Prev Question Next Question >>

Question 10/23

Refer to the exhibits.

A business analyst must see a currency conversion rate for any given date in a chart. The currency conversion rate data is held in a separate table in the database and only contains a record when the rate changes. An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

A. Join the calendar with the currency conversion table
Order by date and use the Peek function to fill in the blank values

B. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar

C. Use a For loop between the start date and end date of the master calendar Use the Match function to add the currency conversion rates to the master calendar

D. Use IterNo and autogenerate to create a new calendar max and min dates of the currency conversion table Force concatenate with the master calendar

Question 10/23

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File