QSDA2022 Online Practice Questions and Answers

Refer to the exhibit

A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe

The script runs successfully, but the Stores table does not have any values.

What should the data architect do?

A. Use where exists (ID, StorelD)

B. Use where exists (ID)

C. Use Concatenate before loading the Stores table

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.

The medical record system does NOT calculate re-admission data The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission" Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

Which action should the data architect perform first to meet these requirements?

A. Sequence patient records by hospital account ID and patient ID using the Peek function

B. Sequence patient records by patient ID using the Peek function

C. Calculate the days since previous discharge using admission date and discharge date

D. Order patient records by patient ID and admission date

Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis. Which feature should the data architect use to meet these requirements?

A. Class function in the script and use variables

B. Class function in a calculated dimension

C. Nested IFs in a calculated dimension

D. IntervalMatch and use variables

Refer to the exhibit.

USER1 has an app protected using this Section Access statement. Which countries can USER1 see in the app''

A. Germany. Italy, United Kingdom, The Netherlands

B. Italy, The Netherlands

C. Italy, United Kingdom, The Netherlands

D. Germany Italy, The Netherlands

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 preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field

C. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table. Which script code should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D

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.)

A. 1. 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

B. 1. 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

C. 1 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

D. 1 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

E. 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

Refer to the exhibit.

A data architect is loading the tables and a synthetic key is generated.

How should the data architect resolve the synthetic key?

A. Create a composite key using OrderlD and LineNo

B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

C. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

D. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

The Section Access security table for an app is shown. User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns. What is the result?

A. The user gets a "Field not found" error.

B. The table is removed from the user interface.

C. The user gets an "incomplete visualization" error

D. The table is displayed without the LEVEL column.

Refer io the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.)

Which script should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D