QlikView QSDA2024 Qlik Sense Data Architect Certification Exam - 2024 Online Training

Question #1

A data architect receives an error while running script.

What will happen to the existing data model?

A . The data model will be removed from the application.
B . The latest error-free data model will be maintained.
C . Newly loaded tables will be merged with the existing data model until the error is resolved.
D . The data model will be replaced with the tables that were successfully loaded before the error.

Question #2

Refer to the exhibit.

A data architect needs to build a dashboard that displays the aggregated sates for each sales representative. All aggregations on the data must be performed in the script.

Which script should the data architect use to meet these requirements?

A)

B)

C)

D)

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

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

The goal is to display the aggregated sales for each sales representative, with all aggregations being performed in the script. Option C is the correct choice because it performs the aggregation correctly using a Group by clause, ensuring that the sum of sales for each employee is calculated within the script.

Data Load:

The Data table is loaded first from the Sales table. This includes the OrderID, OrderDate, CustomerID, EmployeeID, and Sales.

Next, the Emp table is loaded containing EmployeeID and EmployeeName.

Joining Data:

A Left Join is performed between the Data table and the Emp table on EmployeeID, enriching the data with EmployeeName.

Aggregation:

The Summary table is created by loading the EmployeeName and calculating the total sales using the sum([Sales]) function.

The Resident keyword indicates that the data is pulled from the existing tables in memory, specifically the Data table.

The Group by clause ensures that the aggregation is performed correctly for each EmployeeName, summarizing the total sales for each employee.

Key Qlik Sense Data Architect

Reference: Resident Load: This is a method to reuse data that is already loaded into the app’s memory. By using a Resident load, you can create new tables or perform calculations like aggregation on the existing data.

Group by Clause: The Group by clause is essential when performing aggregations in the script. It groups the data by specified fields and performs the desired aggregation function (e.g., sum, count).

Left Join: Used to combine data from two tables. In this case, Left Join is used to enrich the sales data with employee names, ensuring that the sales data is associated correctly with the respective employee.

Conclusion: Option C is the most appropriate script for this task because it correctly performs the necessary joins and aggregations in the script. This ensures that the dashboard will display the correct aggregated sales per employee, meeting the data architect’s requirements.

Question #3

Refer to the exhibit.

What does the expression sum< [orderMetAmount ]) return when all values in LineNo are selected?

A . 1590
B . 1490
C . 690
D . 1810

Reveal Solution Hide Solution

Question #4

A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection.

What should the data architect do?

A . Recreate the SQL Statement with the correct parameters
B . Use the REST Connector with pagination mechanism
C . Use pagination of the REST Connector to create a template of the desired data
D . Use With Connection to pass a parameter to the REST URL

Reveal Solution Hide Solution

Question #5

Refer to the exhibit.

On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue. The script runs successfully but the resulting table is not correct.

What should the data architect do?