Online Access Free QSDA2019 Practice Test

A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.
Which script should the data architect use?
A)

B)

C)

D)

• A.Option B
• B.Option C
• C.Option D
• D.Option A

A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and CustomerKey. Which scripts should be used to load the data while maintaining the correct associations?
A)

B)

C)

D)

• A.Option B
• B.Option C
• C.Option D
• D.Option A

Refer to the exhibit.

A company has different departments Executive and Sales should always be the first values in a Department filter pane Which script must the data architect use to meet this requirement^ A)

B)

C)

D)

• A.Option B
• B.Option C
• C.Option D
• D.Option A

Refer to the exhibit.

A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.
Which scripting function should the data architect use to meet this data modeling requirement?

• A.IntervalMatch
• B.ApplyMap
• C.Peek
• D.Inner Join

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.Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar
• B.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
• C.Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in blank values
• 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