QSDA2019 Online Practice Questions and Answers

A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails. Which statement should the data architect use?

A. $

B. $(Must_Include=lib://TextFiles/Variables.txt);

C. (Must_Include=lib://TextFiies/Variables.txt);

D. (Includs=lib://TextFiles/Variables.txt);

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 data. Some fields must NOT appear in any field

list.

How should a data architect meet these requirements?

A. Use HidePrefix variable

B. Add fields to master items

C. Use security rules

D. Use HideField variable

A data architect creates a collection of large QVD files that propagate data into their apps This solution works well. However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is

Which two changes should be made to improve load performance? (Select two ) A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

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

A business department is forecasting revenue within an Excel spreadsheet. A data architect needs to

include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

A. 1. Load the Excel spreadsheet using the data load editor

2.

Use the Unpivot function

3.

Use the Sum function to group the forecast by date

4.

Connect to the existing data model

B. 1. Load the Excel spreadsheet using the data load editor

2. Use the Crosstable function to unpivot the table

3 Create a composite key out of the date and region

4 Connect the new table to the data model

C. 1. Load the Excel spreadsheet using the data load editor

2.

Change the sort order by date

3.

Create a composite key out of the forecast and region

4.

Connect to the existing data model

D. 1. Load the Excel spreadsheet into the data manager

2.

Use the Unpivot function

3.

Create a composite key from the date and region

4.

Connect the new table to the data model

E. 1. Load the Excel spreadsheet using the data manager

2.

Rename the ForecastDate field to Date

3.

Disable the Region

4.

Connect to the existing data model

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.

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