QSDA2021無料問題集「Qlik Sense Data Architect Certification Exam

質問 1

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）Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

（C）FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

（D）FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

正解：B 解答を投票する

質問 2

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.

（A）LEFT(SUBFIELD(Key, ' ', 2), 2)

（B）RIGHT(SUBFIELD (Key,' ', 2), 3)

（C）MID ( SUBFIELD (Key , ' ', 2), 3)

（D）LTRIM (SUBFIELD (Key, ' ', 2), 2)

正解：A 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 3

Refer to the exhibit.

Refer to the exhibit
A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe The script runs successfully, but the Stores table does not have any values.
What should the data architect do?

（A）Use where exists (ID, StorelD)

（B）Use Concatenate before loading the Stores table

（C）Use where exists (ID)

正解：C 解答を投票する

質問 4

Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team.
What is the most likely cause?

（A）An Omit field has been applied

（B）The affected users were NOT added to the Section table

（C）Section access restricts too many records

（D）A security rule has been applied to the sheet object

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 5

Refer to the exhibit.

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.

Which two table load prefixes are needed?

（A）* Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth)
* HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth '/')

（B）* HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)
* Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure '/' Depth)

（C）* HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure)
* HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth)

（D）* HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)

正解：D 解答を投票する

QSDA2021 無料問題集「Qlik Sense Data Architect Certification Exam - February 2021 Release」

弊社を連絡する

関連リンク

トップ試験