QSDA2019 Online Practice Questions and Answers

A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past two years. Users very rarely access the transaction-level data for a specific date. Only the past two years of data must be loaded which is 720 GB of data Which method should a data architect use to meet these requirements?

A. Load only two years of data in an aggregated app and create a separate transaction app for occasional use

B. Load only two years of data and use best practices in scripting and visualization to calculate and display aggregated data

C. Load only aggregated data for two years and use Direct Discovery for transaction data

D. Load only aggregated data for two years and use ODAG for transaction data

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 table is generated resulting from the following script

When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date? A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

A data architect needs to write the expression for a measure on a KPI to show the sales person with the

highest sales. The sort order of the values of the fields is unknown. When two or more sales people have

sold the same amount, the expression should return all of those sales people.

Which expression should the data architect use?

A. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')

B. FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))

C. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')

D. FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

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 wants to combine data on present and historic sales performance. The historic data is

stored in a de-normalized archive, and the present data is maintained in a database. The output must be

contained in a single table.

Which script should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D

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

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 clothing retailer wants to review their product pricing strategy. A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.

Which feature should the data architect use to meet these requirements?

A. IntervalMatch and use variables

B. Nested IFs in a calculated dimension

C. Class function in a calculated dimension

D. Class function in the script and use variables

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.

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';

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