[Q46-Q65] QSDA2022リアル試験問題解答は更新された[2024年01月16日]

QSDA2022リアル試験問題解答は更新された[2024年01月16日]

お手軽に合格させる最新Qlik QSDA2022問題集には78問があります

質問 # 46
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. 0
C. Null
D. D

正解：D

質問 # 47
A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.
Which statement should the data architect use?

A. $<Include=lib://TextFiles/Variables.txt);
B. $(Must_Include=lib://TextFiles/Variables.txt);
C. (Includs=lib://TextFiles/Variables.txt);
D. (Must_Include=lib://TextFiies/Variables.txt);

正解：B

解説：
Explanation
The MustInclude statement provides an error if the include fails and is used when including files in Qlik Sense.
The other statements do not provide an error if the include fails.
qlik-sense-certification-exam-study-guide-en.pdf
https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study-guide-en.pdf?la=en Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ
https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from-QlikView-to Certifications & Qualifications | Qlik
https://www.qlik.com/us/services/training/certifications-and-qualifications The $(Must_Include) statement is used to load a file or a set of files and generate an error if the load fails. The
"Must_Include" function will stop the script execution if the file is not found or cannot be loaded. The correct syntax for using the "Must_Include" statement is $(Must_Include=lib://TextFiles/Variables.txt);

質問 # 48
Refer to the exhibit.

The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?
A)

B)

C)

D)

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

正解：D

質問 # 49
A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

A. Owner Publish, Read
B. Owner Publish
C. Publish, Read
D. Publish

正解：B

解説：
Explanation
The Owner Publish permission allows the colleague to publish apps on behalf of the manager, allowing the HR team to continue to publish apps while the manager is away. The other options, Publish, Owner Publish, Read, and Publish, Read, do not provide the colleague with the necessary permissions to publish apps on behalf of the manager.

質問 # 50
A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

It must be clear to the end user that this is geographic data. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

A. Add GeoKakePoint (Lat, Long} as Point to Location's preceding load
B. Add GeoProject{' Point' , Lat&Long) AS Point to the preceding load
C. Add the following to the end of the script:
TAG FIELD LocationName With 'Sgeoname', *@relates_Pt';
TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden';
D. Add the following to the end of the script:
TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;
E. Define Location as a master item, and set the tag to Sgeodata

正解：B、C

質問 # 51
Refer to the exhibit.

USER1 has an app protected using this Section Access statement.
Which countries can USER1 see in the app''

A. Italy, United Kingdom, The Netherlands
B. Italy, The Netherlands
C. Germany Italy, The Netherlands
D. Germany. Italy, United Kingdom, The Netherlands

正解：A

質問 # 52
A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies
* Source 1 Contains frequently updated data and must be refreshed hourly
* Source 2 Contains data that is transferred from a partner and must be refreshed weekly Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?

A. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs
B. 1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs
C. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs
D. 1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

正解：B

解説：
Explanation
This option ensures that the data in the two data sources is always up-to-date by scheduling the data refresh tasks to run at the appropriate frequencies. Task 1 runs hourly to refresh data from Source 1, and Task 2 is dependent on Task 1 so that it runs only after Task 1 is completed. This ensures that the data from Source 2 is loaded only after the most current data from Source 1 is loaded.

質問 # 53
Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure.
Count<{<Year={'2 018'}, CustomerID=P({<Year={'2019*}>})>} Customer ID)
Which option shows the resulting table after the expression is applied?
A)

B)

C)

D)

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

正解：D

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

正解：D

質問 # 55

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. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
C. Join theDepartments and Salespeople tables to resolve the many-to-many relationship
D. Join the Transactions and Salespeople tables to resolve the many-to-many relationship

正解：A

質問 # 56

The Section Access security table for an app is shown. User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns.
What is the result?

A. The user gets an "incomplete visualization" error
B. The table is removed from the user interface.
C. The user gets a "Field not found" error.
D. The table is displayed without the LEVELcolumn.

正解：A

質問 # 57
A data architect executes the following script:

What will Field_1 contain after this script is executed?

A. abcd
B. Abed, abed, ABCD
C. Abcd, abcd
D. Abed, abed, ABCD, ABCDABCD

正解：B

質問 # 58
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. 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
B. OUTER JOIN the calendar with the currency conversion table
ORDER BY the date and use the PEEK function to fill in blank values
C. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table
D. Utilize INTERVALMATCH to load the currency conversion rate between dates theconversation changed INNER JOIN the resultant table back into the master calendar

正解：B

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

正解：D

質問 # 60
Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately
* The dates need to be analyzed separately by Year Month, and Quarter
The data architect realizes the data model has issues that must be fixed.
Which steps should the data architect perform?

A. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3 Delete the ProductID and OrderlD in the Shipments table
4. Concatenate Orders and OrderDetails
B. 1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails
4. Left join Orders andOrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate
C. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in theOrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate
D. 1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD in the Shipmi
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDateand ShipmentDate

正解：A

質問 # 61
A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?

A. Save the unconverted objects as extensions and import them into Qlik Sense
B. Re-create the unconverted objects
C. Save the unconverted objects as master items
D. Remove the set analysis statements from the unconverted objects

正解：B

解説：
Explanation
After migrating an app from QlikView to Qlik Sense, there may be some unconverted objects. In this case, the data architect should re-create the unconverted objects in order to ensure that the app works properly in Qlik Sense. The other options will not work, as saving the unconverted objects as extensions or master items will not ensure that the app works properly, and removing set analysis statements will not help either.
qlik-sense-certification-exam-study-guide-en.pdf
https://www.qlik.com/us/-/media/files/training/global-us/qlik-sense-certification-exam-study-guide-en.pdf?la=en Talk to Experts Tuesday - Migrating from QlikView to Qlik Sense FAQ
https://community.qlik.com/t5/Support-Knowledge-Base/Talk-to-Experts-Tuesday-Migrating-from-QlikView-to Certifications & Qualifications | Qlik
https://www.qlik.com/us/services/training/certifications-and-qualifications

質問 # 62
A data architect needs to develop a script to export tables from a model based upon rules from an independent file. Thestructure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to existin the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?

A. Two loopswithout any conditional statement
B. One loop and two IF statements
C. Two loops and one IF statement
D. One loop and one SELECT CASE statement

正解：D

解説：
Explanation
The data architect will need to use a single loop to iterate through the rows of the independent filecontaining the export rules. Within the loop, they will need to use a SELECT CASE statement to determine which table in the model to export based on the TableToExport value in the current row of the independent file. They can then use the StoreAsFilenamevalue to determine the target root filename, and the NumberOfCopies value to determine the number of copies to export.
This approach makes use of a single loop to iterate through the rows of the independent file, and a SELECT CASE statement to determine which table to export based on the TableToExport value in the current row. It is the most efficient way to accomplish the task with minimal scripting.
You can find the Qlik scripting documentation for Store statement
here:https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Store.htman SELECT CASE statement here:https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

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

正解：B

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

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