Labour Day Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

  1. Home
  2. Qlik
  3. Qlik Sense Data Architect
  4. QSDA2021
  5. Qlik Sense Data Architect Certification Exam - February 2021 Release Questions and Answers

QSDA2021 Qlik Sense Data Architect Certification Exam - February 2021 Release Questions and Answers

Questions 4

QSDA2021 Question 4

A Human Resources Director needs an app to analyze organizational structure. The Directory is particularly interested in the longest levels of line management.

Two table loads are required. Both use the same basic structure.

QSDA2021 Question 4

Which two table load prefixes are needed?

Options:

A.

•HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure)

•HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth)

B.

• HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)

• Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure ‘/’Depth)

C.

• Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth)

• HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth ‘/')

D.

• HierarchyBelongs.To(EmployeeID,ManagerlD, Name ManagerlD, Manager, Depth)

Buy Now
Questions 5

QSDA2021 Question 5

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?

Options:

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

Buy Now
Questions 6

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 7

A data architect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.

What is the minimum number of data connections required?

Options:

A.

Two

B.

Five

C.

Four

D.

Three

Buy Now
Exam Code: QSDA2021
Exam Name: Qlik Sense Data Architect Certification Exam - February 2021 Release
Last Update: May 1, 2024
Questions: 50

PDF + Testing Engine

$66.4  $165.99
buy now QSDA2021 pdf + testing engine

Testing Engine

$46  $114.99
buy now QSDA2021 testing engine

PDF (Q&A)

$42  $104.99
buy now QSDA2021 pdf