Qlik Sense Data Architect Certification Exam - February 2021 Releaseは専門性の高い試験として知られ、十分な準備なしに臨むには不安が残ります。JPNTestのQSDA2021練習問題は本試験の出題範囲に沿った50の問題で構成されており、2026年の試験対策にも対応しています。

Qlik QSDA2021 試験概要:

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

QSDA2021試験についてよくあるご質問

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

問題 #1

Refer to the exhibit.

Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping dat a. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?

A. Create a Month field for each of the three dates in the fact table and use that in the chart
B. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
C. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

問題 #2

Refer to the exhibit.

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. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
C. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
D. Join the Departments and Salespeople tables to resolve the many-to-many relationship

問題 #3

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. FilePath, IF, THEN. Drop
B. FilePath, FOR EACH, Peek, Drop
C. FileExists, FOR EACH, IF
D. FileSize, IF, THEN, END IF

問題 #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) , 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) )

問題 #5

Refer to the exhibit.

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?
A)

B)

C)

D)

A. Option D
B. Option B
C. Option C
D. Option A

解説：