Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Qlik QSDA2022 - Qlik Sense Data Architect Certification Exam-2022

Qlik QSDA2022 Premium Access     Download Demo    
Page: 2 / 3
Total 77 questions

Refer to the exhibits.

The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.

In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.

What should the data architect do in the data load editor?

A.

Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport

B.

Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field

C.

Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

Refer to the exhibit.

A data architect is loading the tables and a synth key is generated.

How should the data architect resolve the synthetic key?

A.

Remove the LineNo field from Shipments and use the AutoNumber function on the

B.

Create a composite key using OrdertD and LineNo

C.

Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field

D.

Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments

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 Mapping Load

D.

ApplyMap with three parameters after the Mapping load

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

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?

A.

The user gets a "Field not found" error.

B.

The table is removed from the user interface.

C.

The user gets an "incomplete visualization" error

D.

The table is displayed without the LEVEL column.

Refer to the exhibit.

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 script is valid to load the tables and maintain the correct association?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

A data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional data. The app must have minimal impact on already limited server resources.

Which approach should the data architect use?

A.

Loop and Reduce

B.

QVDs

C.

In-memory

D.

ODAG

A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.

Which script code should the data architect use?

A)

B)

C)

D)

A.

Option

B.

Option

C.

Option

D.

Option

Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales

During loading, the data architect resolves a synthetic key by creating the composite key

For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.

What does the data architect see when selecting a month?

A.

All Customers, all Budget and all Sales records

B.

Customer and Sales records for that month, but missing values for Budget

C.

Customer and Budget records for that month, but missing values for Sales

D.

Customer, Sales, and Budget records for that month

Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.

In the process of separating a concatenated key into two parts, some split results are missing data

What should the data architect do?

A.

Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components

B.

In the SUBFIELD function, replace the ‘_’ with a ‘|’ or ‘_’ character.

While debugging an app, a developer loads data from an application layer QVD file.

In the process of separating a concatenated key into two parts, some split results are missing data

What should the data architect do?

C.

Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components

D.

In the SUBFIELD function, replace the '- with a ‘|’ or '-’ character

E.

Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

F.

Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character

G.

Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field