Qlik Exam QSDA2022 Topic 1 Question 18 Discussion

Actual exam question for Qlik's QSDA2022 exam

Question #: 18
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

by Raylene at Feb 11, 2024, 04:12 PM

Limited Time Offer

25%

1 years ago

I think the data architect should use Option B.

upvoted 0 times

...