Black Friday Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

 
Home > Qlik > Qlik Sense Data Architect > QSDA2022

QSDA2022 Qlik Sense Data Architect Certification Exam-2022 Question and Answers

Question # 4

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that 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 total sales KPI shows the correct result.

How should the data architect modify the data model to correct this 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 Departments and Salespeople tables to resolve the many-to-many relationship

D.

Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Full Access
Question # 5

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.

Use the data manager

B.

Load a calendar island

C.

Create a canonical calendar

D.

Create five master calendars

Full Access
Question # 6

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

Full Access
Question # 7

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

Full Access
Question # 8

Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.

The data architect runs the following script to resolve this issue:

A.

3

B.

1

C.

6

D.

4

Full Access
Question # 9

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

FileSize, IF, THEN, END IF

B.

FilePath, IF, THEN. Drop

C.

FileExists, FOR EACH, IF

D.

FilePath, FOR EACH, Peek, Drop

Full Access
Question # 10

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

Full Access
Question # 11

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

Full Access
Copyright myexamcollection.com. All Right Reserved.