QSDA2021最も有効な質問と解答で勉強

Qlik Sense Data Architect Certification Exam - February 2021 Releaseは業界で広く認知された資格であり、取得はキャリアの信頼性を高める確かな一歩となります。Tech4ExamのQSDA2021問題集は50問を収録し、公式の出題範囲に沿って学習を組み立てられます。

Qlik QSDA2021 試験概要:

Qlik QSDA2021 試験シラバストピック:

Qlik Sense Data Architect Certification Exam - February 2021 Releaseに関するよくあるご質問

Qlik Sense Data Architect Certification Exam - February 2021 Release 認定 QSDA2021 試験問題：

問題 #1

Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately
* The dates need to be analyzed separately by Year Month, and Quarter
The data architect realizes the data model has issues that must be fixed.
Which steps should the data architect perform?

A. 1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
B. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate
C. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3 Delete the ProductID and OrderlD in the Shipments table
4. Concatenate Orders and OrderDetails
D. 1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD in the Shipmi
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

問題 #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?

A. Section access and sheet properties
B. QMC security rules and custom properties
C. Section access and set analysis
D. QMC security rules and section access

問題 #3

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?
1. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
2. 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?

A. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
B. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components
C. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
D. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values
E. In the SUBFIELD function, replace the '- with a '|' or '-' character
F. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character

問題 #4

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) , 1) , Salesperson) =1, Salesperson) , ' ')
B. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )
C. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
D. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

問題 #5

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. LTRIM (SUBFIELD (Key, ' ', 2), 2)
B. LEFT(SUBFIELD(Key, ' ', 2), 2)
C. RIGHT(SUBFIELD (Key,' ', 2), 3)
D. MID ( SUBFIELD (Key , ' ', 2), 3)

解説：