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

質問 1：
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 and include aservice account in the table
B. Use section access to restrict sales manager access by region
C. Use On-Demand App Generation (ODAG) and section access
D. Create an app for each sales manager with Qlik GeoAnalytics
正解：B

質問 2：
Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error What should be done to make sure the script runs correctly?
A. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table
B. Make the data architect the owner of the app in the QMC
C. Give the data architect the Read rights on the data connections in the QMC
D. Add the line lib connect to ' SQL (abc_qs9rvi.es) ' ;before the LOAD for the Order Detail table
正解：C

質問 3：
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, Sales, and Budget records for that month
C. Customer and Sales records for that month, but missing values for Budget
D. All Customers, all Budget and all Sales records
正解：B

質問 4：
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. 4
C. Null
D. D
正解：D

質問 5：

A data architect is creating an app using three tables. After executing thescript, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)
A. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
B. Rename the Category field in theProductPriceLis table to PnceCategory (line 24).
C. Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line
24).
D. insert "Join (ProductDetails)" in front of the Load statement in line 24 to combineProductPriceList with ProductDetails
正解：B

質問 6：
Refer to the exhibit.

A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is extracted into three QVDs.
A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.
Which technique should the data architect use to create the Region field?
A. Create a Region field in the Employee table and populate using the SubField function on the EmployeelD
B. Create a Region field in the Employee table and populate using the LTrim function on the EmployeelD
C. Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source
D. Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table
正解：C

質問 7：

Refer to the exhibits.
The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, containsthe teams and team members registered for specific sports.
In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.
What should the dataarchitect do in the data load editor?
A. Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport
B. Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field
C. Apply a FOR loop to load to the MasterSports table creating the values for the Sport field
正解：C

質問 8：
Users of a published app report incomplete visualizations. The data architect checks the app multiple timesand cannot replicate the error. The error affects only one team.
What is the most likely cause?
A. A security rule has been applied to the sheet object
B. The affected users were NOT added to the Section table
C. Section access restricts too many records
D. An Omit field has been applied
正解：C
解説: (Pass4Test メンバーにのみ表示されます)