QUESTION: 17

Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team.
What is the most likely cause?

An Omit field has been applied
Section access restricts too many records
A security rule has been applied to the sheet object
The affected users were NOT added to the Section table

Answer(s): B

Explanation:

Section access restricts access to certain records, and if too many records are restricted, it can lead to incomplete visualizations. Source: Qlik
Section access is used to control access to the data in an app. If the section access settings are too restrictive, they can prevent certain users or teams from seeing all of the data they need, resulting in incomplete visualizations.
It is possible that the affected team has been assigned a section access that is too restrictive, preventing them from seeing all of the necessary data. This could be a misconfiguration or an oversight in the section access settings.

Reveal Solution Next Question

QUESTION: 18

Refer to the exhibit.

A data architect is loading the tables and a synth key is generated. How should the data architect resolve the synthetic key?

Remove the LineNo field from Shipments and use the AutoNumber function on the
Create a composite key using OrdertD and LineNo
Remove the LineNo field from both tables and use the AutoNumber function on the OrderlC field
Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments

Answer(s): D

Reveal Solution Next Question

QUESTION: 19

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.
Which method should the data architect use to manage the modifications in all apps?

Create a variable repository and load them using INCLUDE statements in the apps where needed
Create a selection app with all the master items and use an on-demand app generation method.
Create a core app with all the master items needed and use a BINARY load in the other apps.
Create only a single app with all the master items needed and protect it with SECTION ACCESS.

Answer(s): A

Explanation:

This method allows the data architect to store the KPIs in a single repository and then use INCLUDE statements to load them into the other apps. This makes it easy to modify the KPIs in one place and have the changes reflected in all the apps. Source: Qlik A variable repository is a central location where all of the master items used in the apps can be stored and managed. By creating a variable repository and loading the master items into each app using INCLUDE statements, the data architect can make modifications to the master items in one place, and the changes will be automatically propagated to all of the apps that use the master items. This method allows for easy management of the master items and eliminates the need to make changes to each app individually, which can be time-consuming and prone to errors.

Reveal Solution Next Question

QUESTION: 20

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)