Online Access Free QSDA2021 Exam Questions

Refer to the exhibit.

A customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?

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

A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)

B)

C)

D)

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

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?

• A.1. 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
• B.1 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
• C.1. 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
• D.1 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

A data architect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.
What is the minimum number of data connections required?

• A.Five
• B.Four
• C.Two
• D.Three

Refer to the exhibit.

Refer to the exhibits.
The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.
In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.
What should the data architect do in the data load editor?

• A.Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport
• B.Apply a FOR loop to load to the MasterSports table creating the values for the Sport field
• C.Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field