Qlik QSDA2024 問題集

質問 1：
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.
Which function should the data architect use?
A.

B.

C.

D.

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

質問 2：
A company generates l GB of ticketing data daily. The data is stored in multiple tables. Business users need to see trends of tickets processed for the past 2 years. Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded, which is 720 GB of data.
Which method should a data architect use to meet these requirements?
A. Load only 2 years of data in an aggregated app and create a separate transaction app for occasional use
B. Load only aggregated data for 2 years and apply filters on a sheet for transaction data
C. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data
D. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data
正解：D

質問 3：
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 メンバーにのみ表示されます)

質問 4：
A startup company is about have its Initial Public Offering (IPO) on the New York Stock Exchange.
This startup company has used Qlik Sense for many years for data-based decision making for Sales and Marketing efforts, as well as for input into Financial Reporting. The startup's Qlik Sense applications use variables that have different values at different points in time.
Due to the increased rigor required in record keeping for public companies, these variables must be clearly recorded in the script reload logs of the Qlik Sense applications. These logs are refreshed daily.
The data architect wants to have the variables names, with their current values,writteninto the script reload logs. Which script statement should the data architect use?
A. Tag
B. REM
C. Trace
D. LogDetail
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
A data architect executes the following script:

Which values does the OrderDate field contain after executing the script?
A. 20210131, 2020/01/31, 31/01/2019, 0
B. 20210131, 2020/01/31, 31/01/2019
C. 20210131, 2020/01/31, 31/01/2019, 9999
D. 20210131, 2020/01/31, 31/01/2019, 31/12/2022
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Exhibit.

Refer to the exhibit.
A business analyst informs the data architect that not all analysis types over time show the expected data.
Instead they show very little data, if any.
Which Qlik script function should be used to resolve the issue in the data model?
A. Date(OrderDate) AS OrderDate in both the table "Orders" and "Master Calendar"
B. TimeStamp(OrderDate) AS OrderDate in both the table "Orders" and "Master Calendar"
C. DatefFloor(OrderDate)) AS OrderDate in both the table "Orders" and "Master Calendar"
D. TimeStamp#(OrderDate, 'M/D/YYYY hh.mm.ff') AS OrderDate in both the table "Orders" and "Master Calendar"
正解：A
解説: (Topexam メンバーにのみ表示されます)