[2023年10月30日]QSDA2021試験問題集を試そう！ベストQSDA2021試験問題 [Q18-Q41]

[2023年10月30日]QSDA2021試験問題集を試そう！ベストQSDA2021試験問題

検証済みのQSDA2021テスト問題集で正確な50問題と解答

質問 # 18
Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.
The data architect runs the following script to resolve this issue:

• A. 0
• B. 1
• C. 2
• D. 3

正解：C

質問 # 19
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 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
• B. 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
• C. 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
• 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

正解：A

質問 # 20
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. FilePath, IF, THEN. Drop
• B. FileExists, FOR EACH, IF
• C. FileSize, IF, THEN, END IF
• D. FilePath, FOR EACH, Peek, Drop

正解：C

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

正解：C

質問 # 22
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. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
• C. 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
• 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

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

正解：C

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

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

正解：A

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

質問 # 27
A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The app is NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?

• A. Use the data manager
• B. Create a canonical calendar
• C. Create five master calendars
• D. Load a calendar island

正解：B

質問 # 28
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

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

質問 # 30
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

質問 # 31
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

質問 # 32
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. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
• C. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date

正解：B

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

正解：A

質問 # 34
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. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
• B. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
• C. Join the Departments and Salespeople tables to resolve the many-to-many relationship
• D. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

正解：D

質問 # 35
A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field.
All existing records are exported into a QVD file. The data architect wants to load the records into Qlik Sense efficiently.
Which steps should the data architect take to meet these requirements?

• A. 1 Load the existing data from the QVD
  2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
  3. Load all records from the key field from the database and use an INNER JOIN on the previous table
• B. 1. Load the existing data from the QVD
  2. Load new and updated data from the database Concatenate with the table loaded from the QVD.
  3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records
• C. 1 Load the new and updated data from the database.
  2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
  3. Load all records from the key field from the database and use an INNER JOIN on the previous table.
• D. 1. Use a partial LOAD to load new and updated data from the database.
  2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
  3. Use the PEEK function to remove the deleted rows

正解：C

質問 # 36
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)

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

正解：B

質問 # 37
Refer to the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A.
(For example, only the row containing A, 1, 456 should be loaded from Table_B.)
Which script should the data architect use?

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

正解：A

質問 # 38
......

QSDA2021認証試験は、QLIKの意味でデータモデルの設計、開発、管理の経験があるデータアーキテクト向けに設計されています。これは、データモデリング、データ統合、データセキュリティ、データガバナンスなど、幅広いトピックをカバーする包括的な試験です。この試験は、QLIKセンスデータアーキテクチャにおける個人の知識、スキル、能力を評価する方法で構成されています。

 

Qlik QSDA2021テストエンジンPDFで全問 無料問題集：https://www.goshiken.com/Qlik/QSDA2021-mondaishu.html

手に入れよう！最新QSDA2021認定有効な試験問題集解答：https://drive.google.com/open?id=1M-DnKwz541xF2B34WPctwwt0xqFeiYST