Qlik Exam QSDA2018 Topic 1 Question 2 Discussion

Actual exam question for Qlik's QSDA2018 exam

Question #: 2
Topic #: 1

[All QSDA2018 Questions]

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 business analyst must see a currency conversion rate for any given date in a chart

Which technique should the data architect use to meet this requirement?

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

B* Use IterNo and autogenerate to create a new calendar from max and min dates of the currency conversion table
* Force concatenate with 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 IntervalMatch to load the currency conversion rate between dates the conversion changed
* Inner Join the resultant table back into the master calendar

Show Suggested Answer

Suggested Answer: A

by Buddy at May 05, 2022, 10:42 AM

Limited Time Offer

25%

Off

Get Premium QSDA2018 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!