Qlik QSDA2022 問題集

質問 1：
A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The appis NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?
A. Create five master calendars
B. Load a calendar island
C. Create a canonical calendar
D. Use the data manager
正解：C

質問 2：
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 containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?
A. Customer and Budget records for that month, but missing values for Sales
B. Customer and Sales records for that month, but missing values for Budget
C. Customer, Sales, and Budget records for that month
D. All Customers, all Budget and all Sales records
正解：C

質問 3：
A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.
Requirements:
* A single date selector
* Show all dates, even those with NO activity
* Minimize the impact on server resources and p
Which two solutions should the data architect use? (Select two.)
A. Link table
B. Multiple calendars
C. Canonical calendar
D. Data island
E. Generic load
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies
* Source 1 Contains frequently updated data and must be refreshed hourly
* Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?
A. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
B. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs
C. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs
D. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.
The OrderDate and ShipmentDate are located in different tables.
The user needs to identify thedata type and must be able to:
* Show trends for orders and shipments
* Use a single filter for both date fields
* Analyze data over fiscal periods
Which steps should the data architect take to build the data model?
A. 1. Create a master calendar table as a data island
2. Create a single filter using fields from the master calendar
B. 1. Create a master calendar andjoin into the Shipments and Orders table
2. Create a single filter using fields from the Shipments table
C. 1. Create a link table with master calendar fields
2. Create a single filter using fields from the master calendar
D. 1. Load the Shipments and Orders table via the data manager
2. Create a single filter using fields from the Orders table
正解：C

質問 6：
A data architect needs to revise an existing app.
The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections Which two methods should be used toimprove performance? (Select two.)
A. Denormalize the schema
B. Use dynamic script generation with variables
C. Use flags in the data model to simplify set analysis
D. Make sure any Ul variables are preceded by '='
E. Create master items for all complex expressions
正解：B,C