Qlik Exam QSDA2021 Topic 8 Question 28 Discussion

Actual exam question for Qlik's QSDA2021 exam

Question #: 28
Topic #: 8

[All QSDA2021 Questions]

Refer to the exhibit.

Refer to the exhibits.

The first table shows the source table (Original table).

This data represents the stocks stored every month for each product:

* The relevant fields are productid, qty, and date.

* The date field represents the calendar months using

* The qty field shows the product stock fluctuation from the current month versus the previous month. If there is no fluctuation between months, there are no new entries in the table.

The second table shows a Pivot table visualization the data analyst needs to create in the app displaying per each product the monthly trend of available stock.

For performance reasons, the data analyst requests the data architect to calculate the running stock quantity of each product for every month in the script.

Which approach should the data architect use?

A1 Generate a Cartesian JOIN between productid and date in a Combined table
2 RIGHT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUS() and RANGESUMQ functions to create the running quantity totals for each product for every month

B1. Generate a Cartesian JOIN between productid and date in a Combined table
2. LEFT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUSO and SUM() functions to create the running quantity totals for each product for every month

C1. Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. RIGHT JOIN the Calendar table back to the Original table to populate the missing qty values
3. Use PEEK() and RANGECOUNTO functions to create the running quantity totals for each product for every month

D1 Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. LEFT JOIN the Calendar table back to the Original table to populate the missing qty values

Show Suggested Answer

Suggested Answer: A, D

by Tran at May 13, 2024, 12:02 AM

Limited Time Offer

25%

Off

Get Premium QSDA2021 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!