[2023年12月25日] 完全版最新の問題集でPDFで最新QSDA2021試験問題と解答 [Q26-Q49]

[2023年12月25日] 完全版最新の問題集でPDFで最新QSDA2021試験問題と解答

無料で使えるQSDA2021試験問題集で100%合格できる試験簡単に合格させるFast2test

Qlik QSDA2021（Qlik Sense Data Architect Certification Exam - February 2021 Release）試験は、Qlik Sense Data Architectにおけるスキルと知識を検証したいデータアーキテクト、データモデラー、およびデータベースプロフェッショナルを対象とした上級レベルの認定試験です。試験は、Qlik Senseを使用したデータモデリング、データ取得、およびデータ変換の専門知識をテストするように設計されています。

質問 # 26
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, 9999
C. 20210131, 2020/01/31, 31/01/2019, 31/12/20
D. 20210131,2020/01/31,31/01/2019

正解：C

質問 # 27
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 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
B. 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
C. 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
D. 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

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

正解：A、E

解説：
A canonical calendar should be used to create a single date selector that can be used to show all dates, even those with no activity. A link table should be used to join the seven date fields from different tables, which will minimize the impact on server resources and performance. Source: Qlik

質問 # 29
A data architect needs to develop multiple apps for various departments. More departments are requesting apps over time The company uses specific requirements for the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.
The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new app is created. The data architect prefers to use the least amount of script in Qlik Sense.
How should the data architect meet these requirements?

A. Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense
B. Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table
C. Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables
D. Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.

正解：C

解説：
This method involves saving the script for the number interpretation variables in a separate text file, and then using the INCLUDE function to insert the variables into each new app script that is created. This reduces the need to copy and paste the number interpretation variables each time a new app is created and allows the data architect to use the least amount of script in Qlik Sense.
The INCLUDE function is a script statement that allows you to insert the contents of one script file into another script file. This can be used to insert common scripts, such as the number interpretation variables, into multiple app scripts.

質問 # 30
Refer to the exhibit.

Which changes on the database will the script capture?

A. Insert. Update, and Remove rows
B. Insert and Update rows
C. Update and Remove rows
D. Insert and Remove rows

正解：A

質問 # 31
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people Which expression should the data architect use?

A. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
B. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')
C. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
D. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

正解：B

質問 # 32
A data architect executes the following script:

What will be the result of Table A?
A)

B)

C)

D)

A. Option A
B. Option B
C. Option D
D. Option C

正解：C

質問 # 33
A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to exist in the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?

A. One loop and one SELECT CASE statement
B. Two loops without any conditional statement
C. Two loops and one IF statement
D. One loop and two IF statements

正解：A

解説：
The data architect will need to use a single loop to iterate through the rows of the independent file containing the export rules. Within the loop, they will need to use a SELECT CASE statement to determine which table in the model to export based on the TableToExport value in the current row of the independent file. They can then use the StoreAsFilename value to determine the target root filename, and the NumberOfCopies value to determine the number of copies to export.
This approach makes use of a single loop to iterate through the rows of the independent file, and a SELECT CASE statement to determine which table to export based on the TableToExport value in the current row. It is the most efficient way to accomplish the task with minimal scripting.
You can find the Qlik scripting documentation for Store statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Store.htm and SELECT CASE statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

質問 # 34
A data architect executes the following script:

What will Field_1 contain after this script is executed?

A. Abed, abed, ABCD
B. abcd
C. Abcd, abcd
D. Abed, abed, ABCD, ABCDABCD

正解：A

質問 # 35
Refer to the exhibit.

A data architect is creating an app using three tables. After executing the script, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)

A. insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails
B. Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).
C. Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).
D. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.

正解：C

質問 # 36
Refer to the exhibit.

A data architect is loading the tables and a synth key is generated.
How should the data architect resolve the synthetic key?

A. Create a composite key using OrdertD and LineNo
B. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
C. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments
D. Remove the LineNo field from Shipments and use the AutoNumber function on the

正解：C

質問 # 37
Refer to the exhibit.

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 Load in 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

質問 # 38
A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.
Which script should the data architect use?
A)

B)

C)

D)

A. Option C
B. Option A
C. Option D
D. Option B

正解：A

質問 # 39
Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately
* The dates need to be analyzed separately by Year Month, and Quarter
The data architect realizes the data model has issues that must be fixed.
Which steps should the data architect perform?

A. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3 Delete the ProductID and OrderlD in the Shipments table
4. Concatenate Orders and OrderDetails
B. 1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD in the Shipmi
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
C. 1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
D. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

正解：A

質問 # 40
Refer to the exhibit.

A data architect executes the script.
What will be the value of the first row for Field_1?

A. A
B. 0
C. Null
D. D

正解：D

質問 # 41
A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.
Which script code should the data architect use?

正解：C

質問 # 42
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. MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
B. RENAME FIELDS USING Associations;
C. APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
D. MAP EmloyeeKey USING Associations;

正解：D

解説：
The MAP function maps the EmployeeKey in the Sales system to the EmployeeKey in the HR system using the Associations table. This allows the data architect to join the data from the Sales system and the HR system using the same key, ensuring that the associations are valid.
Using the MAP function also optimizes the performance of the data model as it eliminates the need for multiple joins between the data from the Sales and HR systems.
This solution also supports multiple tables added, as the MAP function can be applied to any table that needs to be joined with the HR system data.

質問 # 43
Refer to the exhibit.

Refer to the exhibit
A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe The script runs successfully, but the Stores table does not have any values.
What should the data architect do?

A. Use where exists (ID)
B. Use where exists (ID, StorelD)
C. Use Concatenate before loading the Stores table

正解：A

質問 # 44
A global retailer has a large database in which millions of sales transactions are added per hour.
Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.
What should a data architect do to meet these requirements?

A. Use section access to restrict sales manager access by region
B. Use section access and include a service account in the table
C. Use On-Demand App Generation (ODAG) and section access
D. Create an app for each sales manager with Qlik GeoAnalytics

正解：A

質問 # 45
A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)

B)

C)

D)