Qlik Exam QSDA2022 Topic 1 Question 3 Discussion

Actual exam question for Qlik's QSDA2022 exam

Question #: 3
Topic #: 1

[All QSDA2022 Questions]

Refer to the exhibit.

A business department is forecasting revenue within an Excel spreadsheet.

A data architect needs to include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

A1. Load the Excel spreadsheet using the data load editor
2. Use the Unpivot function
3 Use the Sum function to group the forecast by date
4 Connect to the existing data model

B1. Load the Excel spreadsheet using the data load editor
2 Use the Crosstable function to unpivot the table
3 Create a composite key out of the date and region
4 Connect the new table to the data model

C1 Load the Excel spreadsheet using the data load editor
2. Change the sort order by date
3. Create a composite key out of the forecast and region 4 Connect to the existing data model

D1 Load the Excel spreadsheet into the data manager
2. Use the Unpivot function
3. Create a composite key from the date and region
4. Connect the new table to the data model
1 Load the Excel spreadsheet using the data manager
2 Rename the ForecastDate field to Date 3. Disable the Region
4 Connect to the existing data model

Show Suggested Answer

Suggested Answer: B, D

Option B involves loading the Excel spreadsheet using the data load editor and then using the Crosstable function to unpivot the table, creating a composite key out of the date and region, and connecting the new table to the existing data model. Option D involves loading the Excel spreadsheet using the data manager, using the Unpivot function, creating a composite key from the date and region, and connecting the new table to the existing data model.

by Jamal at Apr 25, 2023, 08:48 PM

Limited Time Offer

25%

Off

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