QSDA2019 Online Practice Questions and Answers

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

B. Option B

C. Option C

D. Option D

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

Refer to the exhibit.

Refer to the exhibits.

While using an app, the users report that some Sales Reps do NOT have personal details, like Division or

Address Number A data architect has been called in to investigate. The data architect uses the data model

viewer to determine the relationship between the SalesRepMaster and CustomerMaster tables.

What is the cause of the issue?

A. 26 values for Sales Rep are null in CustomerMaster

B. 40.7% of the Sales Rep have CustomerMaster information

C. 59.3% of the Sales Rep have CustomerMaster information

D. Density is 100% while Total Distinct and Present Distinct are NOT the same

A data architect needs to upload data from ten different sources, but only if there are any changes after the

last reload When data is updated, a new file is placed into a folder mapped to E:\373948870. The data

connection points to this folder.

The data architect plans a script which will:

1.

Verify that the file exists

2.

If the file exists, upload it. Otherwise, skip to the next piece of code. The script will repeat this subroutine for each source.

When the script ends, all uploaded files will be removed with a batch procedure. Which option should the data architect use to meet these requirements?

A. FilePath, IF, THEN, Drop

B. FileSize, IF, THEN, END IF

C. FilePath, FOR EACH, Peek, Drop

D. FileExists, FOR EACH, IF

Multiple department fields in a dataset require a description. A data architect needs to add the department

descriptions or a default value when the department does NOT have a description.

Which strategy should the data architect use to meet these requirements?

A. ApplyMap with two parameters after the Mapping load

B. Left Join between tables and Description.xlsx in every Department table

C. Enter "Missing description" in the blank rows for Description.xlsx, then use Mapping Load

D. ApplyMap with three parameters after the Mapping load

Refer to the exhibits.

A business analyst needs to see the currency conversion rate for any given date in a chart The currency conversion rate data comes from Qlik DataMarket and only contains a record when the rate changes An existing master calendar exists in the data model which contains a full set of dates.

Which technique should the data architect use to meet this requirement?

A. Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in blank values

B. Use a FOR loop between the start date and end date of the master calendar Use the Match function to add the currency conversion rates to the master calendar

C. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar

D. Use IterNo and AutoGenerate to create a new calendar from max and mm dates of the currency conversion table Force concatenate with the master calendar

Refer to the exhibit.

A clothing retailer wants to review their product pricing strategy. 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. IntervalMatch and use variables

B. Nested IFs in a calculated dimension

C. Class function in a calculated dimension

D. Class function in the script and use variables

A data architect needs to load large amounts of data from a database which is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field All existing records are exported into a QVD file. The data architect wants to load the records into Qlik Sense efficiently. Which steps should the data architect take to meet these requirements?

A. 1. Use a partial load to load new and updated data from the database.

2.

Load the existing data from the QVD without the updated rows that have just been loaded from the database. Concatenate with the new and updated records.

3.

Use the Peek function to remove the deleted rows.

B. 1. Load the new and updated data from the database

2.

Load the existing data from the QVD without the updated rows that have just been loaded from the database. Concatenate with the new and updated records.

3.

Load all records from the key field from the database and use an Inner Join on the previous table.

C. 1. Load the existing data from the QVD.

2.

Load the new and updated data from the database without the rows that have just been loaded from the QVD. Concatenate with data from the QVD.

3.

Load all records from the key field from the database and use an Inner Join on the previous table.

D. 1. Load the existing data from the QVD.

2.

Load new and updated data from the database. Concatenate with the table loaded from the QVD.

3.

Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these

records.

A company needs to analyze sales data based on the exchange rate of the different countries every day

About 30 reports must be produced with an average of 20r000 rows each. This process is estimated to

take about three hours.

Reports will be in Excel and distributed to business users according to defined security rules.

Which two products should the data architect use to build this solution? (Select two.)

A. OQIikGeoAnalytics

B. ODAG

C. QIikDataMarket

D. Qlik Storytelling

E. QIik NPrinting

Refer to the exhibit.

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 an "Invalid visualization" error

B. The table is displayed without the LEVEL column

C. The table is removed from the user interface

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