QSDA2021試験は再受験のたびに受験料がかかるため、できれば一度で結果を出したいものです。2026年の最新の出題傾向に対応したGoShikenのQlik Sense Data Architect Certification Exam - February 2021 Release練習問題で、本番前に実力を確認しておきましょう。

Qlik QSDA2021 試験概要:

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

QSDA2021受験者からよく寄せられる質問

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

問題 #1

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.
The Human Resources manager creates a table that maps these keys to another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added
Which solution should the data architect use to meet these requirements?

A. RENAME FIELDS USING Associations;
B. MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
C. MAP EmloyeeKey USING Associations;
D. APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;

問題 #2

Refer to the exhibit.

Refer to the exhibits.
The first table shows the source table (Original table).
This data represents the stocks stored every month for each product:
* The relevant fields are productid, qty, and date.
* The date field represents the calendar months using
* The qty field shows the product stock fluctuation from the current month versus the previous month. If there is no fluctuation between months, there are no new entries in the table.
The second table shows a Pivot table visualization the data analyst needs to create in the app displaying per each product the monthly trend of available stock.
For performance reasons, the data analyst requests the data architect to calculate the running stock quantity of each product for every month in the script.
Which approach should the data architect use?

A. 1 Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. LEFT JOIN the Calendar table back to the Original table to populate the missing qty values
B. 1. Generate a Calendar table with all dates between the minimum and maximum date values in an Original table
2. RIGHT JOIN the Calendar table back to the Original table to populate the missing qty values
3. Use PEEK() and RANGECOUNTO functions to create the running quantity totals for each product for every month
C. 1 Generate a Cartesian JOIN between productid and date in a Combined table
2 RIGHT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUS() and RANGESUMQ functions to create the running quantity totals for each product for every month
D. 1. Generate a Cartesian JOIN between productid and date in a Combined table
2. LEFT JOIN the Combined table with the Original table to populate the missing qty values
3. Use PREVIOUSO and SUM() functions to create the running quantity totals for each product for every month

問題 #3

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 app is 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. Load a calendar island
B. Create five master calendars
C. Create a canonical calendar
D. Use the data manager

問題 #4

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. Multiple calendars
B. Generic load
C. Link table
D. Canonical calendar
E. Data island

問題 #5

Refer to the exhibit.

On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.
What should the data architect do?

A. Create two different mapping tables
B. Use a LEFT JOIN instead of the APPLYMAP
C. Use LOAD DISTINCT on the mapping table
D. Review the values of the source mapping table

解説：