QSDA2019 Exam Dumps | Refer to the exhibits. (Exhibit) A business analyst needs to see the currency conversion rate for any

<< Prev Question Next Question >>

Question 11/18

Refer to the exhibits.

A business analyst needs to see the currency conversion rate for any given date in a chart The currency conversion rate data comes from Qlik DataMarket and only contains a record when the rate changes An existing master calendar exists in the data model which contains a full set of dates Which technique should the data architect use to meet this requirement?

A. Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in 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 from max and mm dates of the currency conversion table Force concatenate with the master calendar

Question 11/18

LEAVE A REPLY

Download PDF File