Qlik QSDA2019 Exam Practice Test Instant Access

Question 1

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?

AIn the data manager split the Region table and associate by EmployeelD

BIn the data manager split the Region table and associate by Region.ID

CIn the data load editor, concatenate the Region and Employee tables

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

Answer : B

Question 2

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?

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

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

CGive the data architect the Read rights on the data connections in the QMC

DMake the data architect the owner of the app in the QMC

Answer : A

Question 3

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?

A26 values for Sales Rep are null in CustomerMaster

B40.7% of the Sales Rep have CustomerMaster information

C59.3% of the Sales Rep have CustomerMaster information

DDensity is 100% while Total Distinct and Present Distinct are NOT the same

Answer : D

Question 4

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^

AOption A

BOption B

COption C

DOption D

Answer : C

Question 5

A data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional dat

a. The app must have minimal impact on already limited server resources.

Which approach should the data architect use?

ALoop and Reduce

BQVDs

CIn-memory

DODAG

Answer : A

Question 6

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?

AIntervalMatch

BPeek

CApplyMap

DInner Join

Answer : A

Question 7

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?

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

BUse 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

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

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

Answer : A

Qlik Sense Data Architect QSDA2019 Exam Practice Test