ベストQlik QSDA2021学習ガイドと問題集は2024年更新 [Q13-Q28]

ベストQlik QSDA2021学習ガイドと問題集は2024年更新

トップクラスQlik QSDA2021試験最先端学習ガイド！練習問題バージョン

質問 # 13
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. Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables
• B. Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense
• 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 use the CALL function to insert the variables.

正解：A

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

質問 # 14
Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
1. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
2. In the SUBFIELD function, replace the '_' with a '|' or '_' character.
While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?

• A. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
• B. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character
• C. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components
• D. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
• E. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values
• F. In the SUBFIELD function, replace the '- with a '|' or '-' character

正解：B

質問 # 15
Refer to the exhibit.

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

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

正解：A

質問 # 16
A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.
The OrderDate and ShipmentDate are located in different tables.
The user needs to identify the data type and must be able to:
* Show trends for orders and shipments
* Use a single filter for both date fields
* Analyze data over fiscal periods
Which steps should the data architect take to build the data model?

• A. 1. Load the Shipments and Orders table via the data manager
  2. Create a single filter using fields from the Orders table
• B. 1. Create a master calendar table as a data island
  2. Create a single filter using fields from the master calendar
• C. 1. Create a master calendar and join into the Shipments and Orders table
  2. Create a single filter using fields from the Shipments table
• D. 1. Create a link table with master calendar fields
  2. Create a single filter using fields from the master calendar

正解：D

質問 # 17
Refer to the exhibit.

Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.
The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.
How should the data architect modify the data model to correct this issue?

• A. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
• B. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
• C. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
• D. Join the Departments and Salespeople tables to resolve the many-to-many relationship

正解：A

質問 # 18
A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. If the file exists, upload it Otherwise, skip to the next piece of code The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.
Which option should the data architect use to meet these requirements?

• A. FileExists, FOR EACH, IF
• B. FilePath, FOR EACH, Peek, Drop
• C. FilePath, IF, THEN. Drop
• D. FileSize, IF, THEN, END IF

正解：D

質問 # 19
A data architect needs to revise an existing app.
The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections Which two methods should be used to improve performance? (Select two.)

• A. Create master items for all complex expressions
• B. Use flags in the data model to simplify set analysis
• C. Use dynamic script generation with variables
• D. Make sure any Ul variables are preceded by '='
• E. Denormalize the schema

正解：B、C

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

正解：A

質問 # 21
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. Data island
• C. Generic load
• D. Multiple calendars
• 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

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

正解：C

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

質問 # 23
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 A
• B. Option B
• C. Option C
• D. Option D

正解：C

質問 # 24
Refer to the exhibit.

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?
A)

B)

C)

D)

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

正解：A

質問 # 25
Refer to the exhibits.

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

• A. Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar
• B. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
• C. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
• D. OUTER JOIN the calendar with the currency conversion table
  ORDER BY the date and use the PEEK function to fill in blank values

正解：D

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

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

有効なQSDA2021試験最新問題で2024年最新の学習ガイド：https://www.goshiken.com/Qlik/QSDA2021-mondaishu.html

QSDA2021認定で究極のガイド：https://drive.google.com/open?id=1M-DnKwz541xF2B34WPctwwt0xqFeiYST