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

質問 1：
Refer to the exhibit.

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, contains the 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 data architect 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

質問 2：
Refer to the exhibit.

Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping dat a. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?
A. Create a Month field for each of the three dates in the fact table and use that in the chart
B. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
C. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
正解：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. Data island
B. Canonical calendar
C. Generic load
D. Multiple calendars
E. Link table
正解：B,E
解説: (Pass4Test メンバーにのみ表示されます)

質問 4：
Multiple department fields in a dataset require a description
A data architect needs to add the department descriptions or a default value when the department does NOT have a description Which strategy should the data architect use to meet these requirements?
A. Left Join between tables and Description xlsx in every Department table
B. ApplyMap with three parameters after the Mapping load
C. Enter "Missing description" in the blank rows for Description xlsx then Mapping Load
D. ApplyMap with two parameters after the Mapping load
正解：B
解説: (Pass4Test メンバーにのみ表示されます)

質問 5：
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