Qlik QSDA2021 Quiz 1 Topic 8 Questions 1-5

Question: 1

ITALY IT001 HR

GERMANY DE002 HR

SPAIN SP03 FINANCE

FRANCE FRO04 SALES

Refer to the exhibit

A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

ALTRIM (SUBFIELD (Key, ' ', 2), 2)

BMID ( SUBFIELD (Key , ' ', 2), 3)

CRIGHT(SUBFIELD (Key,' ', 2), 3)

DLEFT(SUBFIELD(Key, ' ', 2), 2)

Show Answer

Question: 2

A company has a stream with multiple apps One of the apps is a multi-regional sales app.

A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.

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

ASection access and set analysis

BQMC security rules and section access

CQMC security rules and custom properties

DSection access and sheet properties

Show Answer

Question: 3

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?

AFirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

BConcat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')

CFirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

DConcat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

Show Answer

Question: 4

Refer to the exhibit.

q4_QSDA2021

Refer to the exhibits.

The first table shows the source table (Original table).

This data represents the stocks stored every month for each product:

* The relevant fields are productid, qty, and date.

* The date field represents the calendar months using

* The qty field shows the product stock fluctuation from the current month versus the previous month. If there is no fluctuation between months, there are no new entries in the table.

The second table shows a Pivot table visualization the data analyst needs to create in the app displaying per each product the monthly trend of available stock.

For performance reasons, the data analyst requests the data architect to calculate the running stock quantity of each product for every month in the script.

Which approach should the data architect use?

A1 Generate a Cartesian JOIN between productid and date in a Combined table
2 RIGHT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUS() and RANGESUMQ functions to create the running quantity totals for each product for every month

B1. Generate a Cartesian JOIN between productid and date in a Combined table
2. LEFT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUSO and SUM() functions to create the running quantity totals for each product for every month

C1. Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. RIGHT JOIN the Calendar table back to the Original table to populate the missing qty values
3. Use PEEK() and RANGECOUNTO functions to create the running quantity totals for each product for every month

D1 Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. LEFT JOIN the Calendar table back to the Original table to populate the missing qty values

Show Answer

Question: 5

Refer to the exhibit.

q5_QSDA2021

The Section Access security table for an app is shown. User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns.

What is the result?

AThe user gets a 'Field not found' error.

BThe table is removed from the user interface.

CThe user gets an 'incomplete visualization' error

DThe table is displayed without the LEVEL column.

Show Answer

Qlik QSDA2021 Quiz:1 Topic:8 Questions:1-5