Qlik QSDA2024 問題集

質問 1：
Exhibit.

A chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis.
The date format for the source data field "Common Date" is M/D/YYYY. This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built.
Which expression should the data architect use to fix this issue?
A. Date(MonthsStart([Common Date]),'VMM-YYYY')
B. Date(MonthStart([Common Date]),'MMM-YYYY')
C. Date([Comraon Date],'MMM-YYYY')
D. Date(InMontht[Common Date]),'MMM-YYYY')
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A data architect receives an error while running script.
What will happen to the existing data model?
A. The data model will be replaced with the tables that were successfully loaded before the error.
B. The latest error-free data model will be maintained.
C. The data model will be removed from the application.
D. Newly loaded tables will be merged with the existing data model until the error is resolved.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A data architect wants reflect a value of the variable in the script log for tracking purposes. The variable is defined as:

Which statement should be used to track the variable's value?
A.

B.

C.

D.

正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Exhibit.

Refer to the exhibit.
The data architect needs to build a model that contains Sales and Budget data for each customer. Some customers have Sales without a Budget, and other customers have a Budget with no Sales.
During loading, the data architect resolves a synthetic key by creating the composite key.
For validation, the data architect creates a table that contains Customer, Month, Sales, and Budget columns.
What will the data architect see when selecting a month?
A. Customer Names and Sales records for the selected month but with only non-null values in Budget column
B. Customer Names and Budaets records for the selected month. Sales column can contain null or non-null values
C. All Customer Names for both Sales and Budget records for the selected month
D. Customer Names and Sales records for the selected month, Budgets column can contain null or non-null values
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Exhibit.

A large electronics company re-assigns sales people once per year from one Department to another.
SPID is the Salesperson ID; the SPID for each individual sales person Name remains constant. The Department for a SPID may change; each change is stored in the Dynamic Dimension data.
Four tables need to be linked correctly: a transaction table, a dynamic salesperson dimension, a static salesperson dimension, and a department dimension.
Which script prefix should the data architect use?
A. Merge
B. Partial Reload
C. IntervalMatch
D. Semantic
正解：C
解説: (Topexam メンバーにのみ表示されます)