[Q18-Q33] QSDA2021認定で究極のガイド [2024年更新]

Share

QSDA2021認定で究極のガイド [2024年更新]

QSDA2021練習試験と学習ガイドは厳密検証された

質問 # 18
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. FirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )
  • B. FirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )
  • C. Concat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')
  • D. Concat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

正解：D


質問 # 19
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 is composed 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. MID ( SUBFIELD (Key , ' ', 2), 3)
  • B. RIGHT(SUBFIELD (Key,' ', 2), 3)
  • C. LTRIM (SUBFIELD (Key, ' ', 2), 2)
  • D. LEFT(SUBFIELD(Key, ' ', 2), 2)

正解：D

解説：
This expression will extract the unique code from the key by using the SUBFIELD function to separate the key into its components, and then using the LEFT function to extract the first two characters of the second component. Source: Qlik


質問 # 20
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. Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.
  • C. Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table
  • D. Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables

正解：D

解説：
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.


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

正解：B


質問 # 22
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 two parameters after the Mapping load
  • C. ApplyMap with three parameters after the Mapping load
  • D. Enter "Missing description" in the blank rows for Description xlsx then Mapping Load

正解：C

解説：
This strategy involves using the ApplyMap function with three parameters after the Mapping load. This will allow the data architect to add the department descriptions or a default value when the department does not have a description. Source: Qlik


質問 # 23
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.


質問 # 24
A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes The areas will be color coded based on the number of vendors in the location.
Which GeoAnalytics operation should the data architect use?

  • A. Simplify
  • B. Intersect
  • C. AddressLookup
  • D. Binning

正解：D

解説：
Binning is a GeoAnalytics operation that can be used to arrange data into hexagonal areas based on postal codes. The areas can then be color coded based on the number of vendors in the location. Source: Qlik Binning is a GeoAnalytics operation that allows data points to be grouped into hexagonal areas based on a geographic field, such as postal codes. The data architect can use binning to group the location points by postal code and then color code the resulting hexagonal areas based on the number of vendors in each location.
This operation is useful for visualizing spatial data and identifying patterns or trends in the data.


質問 # 25
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)

B)

C)

D)

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

正解：C


質問 # 26
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?

  • A.
  • B.
  • C.
  • D.

正解：B


質問 # 27
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 Concatenate before loading the Stores table
  • B. Use where exists (ID, StorelD)
  • C. Use where exists (ID)

正解：C


質問 # 28
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. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
  • B. Rename the Category field in the ProductPriceLis 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 combine ProductPriceList with ProductDetails

正解：B


質問 # 29
Refer to the exhibit.

A Human Resources Director needs an app to analyze organizational structure. The Directory is particularly interested in the longest levels of line management.
Two table loads are required. Both use the same basic structure.

Which two table load prefixes are needed?

  • A. * HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)
    * Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure '/' Depth)
  • B. * HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure)
    * HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD, Manager, Depth)
  • C. * Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V, Depth)
    * HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth '/')
  • D. * HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)

正解：D


質問 # 30
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 FOR loop to load to the MasterSports table creating the values for the Sport field
  • B. Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field
  • C. Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport

正解：A


質問 # 31
Refer to the exhibit.

A customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?

  • A.
  • B.
  • C.
  • D.

正解：A


質問 # 32
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 Generic Load in the Product table and a For loop to left join each Generic table
  • B. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together
  • C. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table

正解：A


質問 # 33
......

究極のガイドはQSDA2021最新時間限定！今すぐダウンロード！：https://www.goshiken.com/Qlik/QSDA2021-mondaishu.html

2024年最新のな厳密検証されたQSDA2021学習合格ガイドでベズトお試しセット：https://drive.google.com/open?id=1i43iy8vwcAmWWnlWoPMC_nQV7JqTodwb

関するブログ

もっと
QSDA2021無料問題集