最新なQlik QSDA2022問題集（78題）、真実試験の問題を全部にカバー！

質問 1：
Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the data. Some visualizations showissues in the data set.
* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.
* The Sales monthly trend bar chart does not work with the Month field.
Which two data issues should the data architect fix in the app? (Select two.)
A. The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.
B. In the Orders table, some values in the CustomerlD field do not exist in the Customers table.
C. The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table
D. In the Orders table, some CustomerlD values are null because there are orders with no customer.
and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer
正解：B,C

質問 2：
Refer to the exhibit.

A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?
A. Create a composite key using OrderlD and LineNo
B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
C. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
D. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
正解：A
解説: (Pass4Test メンバーにのみ表示されます)

質問 3：
Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket duringanalysis.
Which feature should the data architect use to meet these requirements?
A. Class function in the script and use variables
B. Class function in a calculated dimension
C. Nested IFs in a calculated dimension
D. IntervalMatch and use variables
正解：B

質問 4：

Refer to the exhibit.
A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.
The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.
Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?
For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?
A. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together
B. Use a Generic Loadin the Product table and a For loop to left join each Generic table
C. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table
正解：B

質問 5：
A company generates 1 GB of ticketing data daily. The data is stored in multipletables 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 ofdata in an aggregated app and create a separate transaction app for occasional use
B. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data
C. Load only aggregated data for 2 years and apply filters on a sheet for transaction data
D. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data
正解：D

質問 6：
A dataarchitect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.
What is the minimum number of data connections required?
A. Two
B. Four
C. Three
D. Five
正解：C

質問 7：
Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.
The data architect runs the following script to resolve this issue:

A. 4
B. 1
C. 3
D. 6
正解：A

質問 8：
ITALY IT001 HR
GERMANY DE002 HR
SPAIN SP03 FINANCE
FRANCE FRO04 SALES
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 iscomposed 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.
A. LEFT(SUBFIELD(Key, ' ', 2), 2)
B. MID ( SUBFIELD (Key , ' ', 2), 3)
C. LTRIM (SUBFIELD (Key, ' ', 2), 2)
D. RIGHT(SUBFIELD (Key,' ', 2), 3)
正解：A
解説: (Pass4Test メンバーにのみ表示されます)