Qlik QSDA2019 Exam Questions Instant Access

Question 1

A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze dat

a. Some fields must NOT appear in any field list.

How should a data architect meet these requirements?

AUse HidePrefix variable

BAdd fields to master items

CUse security rules

DUse HideField variable

Answer : A

Question 2

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 3

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?

ASequence patient records by hospital account ID and patient ID using the Peek function

BSequence patient records by patient ID using the Peek function

CCalculate the days since previous discharge using admission date and discharge date

DOrder patient records by patient ID and admission date

Answer : A

Question 4

A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

It must be clear to the end user that this is geographic dat

a. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

ADefine Location as a master item, and set the tag to Sgeodata

BAdd GeoProject{' Point' , Lat&Long) AS Point to the preceding load

CAdd GeoKakePoint (Lat, Long} as Point to Location's preceding load

DAdd the following to the end of the script:
TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;

EAdd the following to the end of the script:
TAG FIELD LocationName With 'Sgeoname', *@relates_Pt';
TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';

Answer : C, D

Question 5

Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{})>} Customer ID)

Which option shows the resulting table after the expression is applied?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 6

A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".

Which syntax should the data architect use?

ANullAsValue*; Set NullValues = 'Missing Value';

BNullasNull *;
Set NullValues = 'Missing Value';

CNullasNull *;
Set NullValue = 'Missing Value';

DNullAsValue*;
Set NullValue = 'Missing Value';

Answer : C

Question 7

A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?

ASave the unconverted objects as extensions and import them into Qlik Sense

BRemove the set analysis statements from the unconverted objects

CRe-create the unconverted objects

DSave the unconverted objects as master items

Answer : A

Qlik Sense Data Architect QSDA2019 Exam Questions