QlikView QlikView Certifications QSDA2022 Questions & Answers

• Question 31:

  Refer to the exhibit.

  

  A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis. Which scripting function should the data architect use to meet this data modeling requirement?

  A. IntervalMatch

  B. Peek

  C. ApplyMap

  D. Inner Join

  Correct Answer: C

  Explanation: In this scenario, the data architect needs to track the history of order fulfillment centers on a per center, per location basis. This means that the data architect needs to match the historical order fulfillment center data with the

  current order fulfillment center data, based on the center and location.

  The ApplyMap function allows you to create a mapping between the data in one table and the data in another table, based on a common field. The data architect can use ApplyMap to create a mapping between the historical order fulfillment

  center data and the current order fulfillment center data, based on the center and location fields.

• Question 32:

  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. Use dynamic script generation with variables

  B. Denormalize the schema

  C. Make sure any Ul variables are preceded by '='

  D. Use flags in the data model to simplify set analysis

  E. Create master items for all complex expressions

  Correct Answer: AD

• Question 33:

  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. Create an app for each sales manager with Qlik GeoAnalytics

  B. Use section access and include a service account in the table

  C. Use On-Demand App Generation (ODAG) and section access

  D. Use section access to restrict sales manager access by region

  Correct Answer: D

• Question 34:

  A table is generated resulting from the following script

  

  When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date? A)

  

  B)

  

  C)

  

  D)

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 35:

  Refer to the exhibit.

  

  A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam. The data architect selects the field "StudentID" from the Students table and sees the following:

  

  A data architect needs to fix this anomaly.

  What should the data architect do to ensure data integrity?

  A. Update the Students table and add 16.7% of the missing records

  B. Remove records from the Exams table where StudentID is null

  C. Update the Exams table and add 33.4% of the missing records

  D. In the LOAD script, add DISTINCT before the Students and Exams tables

  Correct Answer: D

• Question 36:

  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. 3

  B. 1

  C. 6

  D. 4

  Correct Answer: D

• Question 37:

  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?

  A. All Customers, all Budget and all Sales records

  B. Customer and Sales records for that month, but missing values for Budget

  C. Customer and Budget records for that month, but missing values for Sales

  D. Customer, Sales, and Budget records for that month

  Correct Answer: D

• Question 38:

  Refer to the exhibit.

  

  A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?

  A. A circular reference with one table disconnected

  B. A synthetic table with two synthetic keys

  C. A synthetic table with three synthetic keys

  D. A synthetic table and one synthetic key

  Correct Answer: A

• Question 39:

  Refer to the exhibit.

  

  A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is

  extracted into three QVDs.

  A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.

  Which technique should the data architect use to create the Region field?

  A. Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source

  B. Create a Region field in the Employee table and populate using the LTrim function on the EmployeelD

  C. Create a Region field in the Employee table and populate using the SubField function on the EmployeelD

  D. Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table

  Correct Answer: A

• Question 40:

  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

  B. Publish

  C. Owner Publish, Read

  D. Publish, Read

  Correct Answer: A

  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.