QSDA2019 Online Practice Questions and Answers

Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error What should be done to make sure the script runs correctly?

A. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table

B. Add the line lib connect to ' SQL (abc_qs9rvi.es) ` ;before the LOAD for the Order Detail table

C. Give the data architect the Read rights on the data connections in the QMC

D. Make the data architect the owner of the app in the QMC

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

Refer to the exhibit.

A company has different departments Executive and Sales should always be the first values in a

Department filter pane.

Which script must the data architect use to meet this requirement?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

Refer to the exhibits.

Executives need to see the total sales by region for the current year. The data architect inherits App1 from a former employee who tried to address this requirement. Two Excel spreadsheets, Region and Employee, are used as the data source. The data architect creates a table and identifies errors in the amount of sales per region.

How should the data architect resolve the errors?

A. In the data manager split the Region table and associate by EmployeelD

B. In the data manager split the Region table and associate by Region.ID

C. In the data load editor, concatenate the Region and Employee tables

D. In the data manager, concatenate the Region table and associate by Region.ID

Refer to the exhibit.

A business analyst reports that the 'CompanyAge' field does NOT display for users The data architect examines the LOAD script and wants to place the breakpoint in the script to check the field name. Which line number should the data architect use?

A. 242 because field name appears in the output Panel of the debugger

B. 251 because the field name appears in the Variable panel of the debugger

C. 251 because the field name appears in the Qlik Log files

D. 251 because the field name appears in the Output panel of the debugger

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

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.

Refer to the exhibit.

An app has been built to analyze salesperson performance by department. Salespeople often move

between departments. There is a strict business rule which states a salesperson must be associated with

ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect.

The KPI showing the total sales shows the correct result.

How should the data architect modify the data model to correct the issue?

A. Create a bridge table between the Departments and Salespeople tables to resolve the many-to- many relationship

B. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to- many relationship

C. Join the Transactions and Salespeople tables to resolve the many-to-many relationship

D. Join the Departments and Salespeople tables to resolve the many-to-many relationship

Refer to the exhibit.

A data architect has a data model that includes historical order fulfillment centers. The order fulfillment

centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per

location basis.

Which scripting function should the data architect use to meet this data modeling requirement?

A. IntervalMatch

B. Peek

C. ApplyMap

D. Inner Join

Refer to the exhibit.

This table contains information about the number of admissions and discharges of patients in a hospital.

The values can be positive or negative. The data architect needs to create an extra column that contains

the number of patients that are currently in the hospital.

Which script should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D