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.

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.

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

A data architect needs to efficiently prepare a data model for a meeting in an hour. The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD). The app is NOT going to be published. It will only be used for this meeting and a single user's ad-hoc analysis. What should the data architect do to meet these requirements?

A. Create a canonical calendar

B. Load a calendar island

C. Use the data manager

D. Create five master calendars

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

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

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

A. Define Location as a master item, and set the tag to Sgeodata

B. Add GeoProject{' Point' , LatandLong) AS Point to the preceding load

C. Add GeoKakePoint (Lat, Long} as Point to Location's preceding load

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

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

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 Readmission"

•

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.

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 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?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

Refer to the exhibit.

The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table.

Which script should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D

A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and CustomerKey.

Which scripts should be used to load the data while maintaining the correct associations?

A. Option A

B. Option B

C. Option C

D. Option D

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