QUESTION: 21

A marketing team needs to display sales for a limited number of products by providing a bar chart that the user can control. The visualization has several requirements:
· Starts with the top five products
· Allows the user to change the number of products displayed · Allows the user to scroll through all products on a mini chart The business analyst creates a bar chat and a variable.
Which steps should the business analyst complete next?

· Add the slider object and use the variable to set its value · Set the number of bars to custom and use the variable to set its value
· Use the variable to fix the limitation
· Add an input box to enable the user to enter the required value
· Use the variable to fix the limitation
· Add a slider object and use the variable to set its value
· Add the slider object and use the variable to set its value · Use the properties to set the number of bars to custom

Answer(s): A

Explanation:

To meet the requirement of controlling the number of products displayed in the bar chart, the business analyst should use a slider object tied to a variable. The variable will store the number of products the user wants to display. In the Appearance section of the bar chart's properties, the analyst can set the number of bars to a custom value using the variable, ensuring that the user can dynamically change the number of displayed products.
Key Concepts:
Slider Object: This provides a user-friendly way for users to adjust the number of products displayed in the bar chart.

Custom Bar Limitation: By setting the number of bars displayed to a custom value controlled by the variable, the business analyst ensures that the user can dynamically adjust how many products are shown.
Why the Other Options Are Less Suitable:
B . Use the variable to fix the limitation and add an input box: While this could work, sliders provide a better, more intuitive user experience than input boxes for adjusting values dynamically. C . Use the variable to fix the limitation and add a slider: This is almost correct, but it misses the step of setting the number of bars to a custom value using the variable. D . Add the slider object and set its value, but without custom bar settings: While adding a slider is correct, not setting the number of bars to custom using the variable means the user wouldn't be able to dynamically control the number of displayed products.
References for Qlik Sense Business Analyst:

Dynamic Control with Variables and Sliders: Qlik Sense best practices recommend using sliders and variables to give users control over visualizations, particularly when it comes to dynamically limiting data displayed.
Thus, adding the slider object and setting the number of bars to a custom value controlled by the variable is the best solution, making A the verified answer.

Reveal Solution Next Question

QUESTION: 22

Exhibit.

Refer to the exhibit.
An app is being developed at a university to monitor student exam attempts- Three core tables are loaded into the app for Students, Exams, and Attempts. Students can attempt the same exam multiple times.
Before building any visualizations, the business analyst needs to know:
· How many students are in the system
· What percentage of students have not yet attempted an exam Which metadata should the analyst focus on to answer these questions?

Total distinct values and Subset ratio for the StudentID field in the Attempts table
Non-null values and Subset ratio for the StudentID field in the Students table
Subset ratio and Present distinct values for the ExamID field in the Attempts table
Present distinct values and Density% for the ExamID field in the Exams table

Answer(s): A

Explanation:

To answer the two questions:
How many students are in the system?
What percentage of students have not yet attempted an exam? The analyst needs to focus on the StudentID field, specifically in relation to the Attempts table. This is because the Attempts table captures all exam attempts made by students, and we can deduce which students have and have not made an attempt by examining the presence of StudentID values in this table.
Key Concepts:
Total Distinct Values: This provides the total number of unique students who have attempted exams. It helps identify how many students have made at least one attempt. Subset Ratio: This compares the values of StudentID between the Students table and the Attempts table. The subset ratio shows how many students in the Students table are represented in the

Attempts table. This ratio helps determine the percentage of students who have not yet attempted any exams.
Why the Other Options Are Less Suitable:
B . Non-null values and Subset ratio for the StudentID field in the Students table: The non-null values in the Students table are not relevant to the question about exam attempts. The focus should be on whether the StudentID is present in the Attempts table. C . Subset ratio and Present distinct values for the ExamID field in the Attempts table: This focuses on exams, not students. The question specifically relates to how many students have attempted exams. D . Present distinct values and Density% for the ExamID field in the Exams table: This focuses on the number of exams and their density, which does not help in determining how many students have attempted or not attempted an exam.
References for Qlik Sense Business Analyst:
Subset Ratio and Distinct Counts: Qlik Sense's data model viewer provides valuable metadata like the distinct count of a field and its subset ratio when compared to related fields in other tables. This is particularly useful for understanding relationships and gaps in the data, such as identifying students who have not yet made an exam attempt.
By focusing on the Total distinct values and Subset ratio for the StudentID field in the Attempts table, the business analyst can easily determine the total number of students and the percentage who have not yet attempted an exam, making A the verified answer.

Reveal Solution Next Question

QUESTION: 23

A business analyst from the APAC region is creating a single KPI object for that region.
The analyst must meet the following requirements:
· The KPI should show a total of sales
· The business wants to compare current year (CY) vs last year (LY) sales · The KPI should not change if the user makes selections Which measure(s) will allow the KPI object to fulfill this requirement? A)

B)

C)

D)

Option A
Option B
Option C
Option D

Answer(s): A

Explanation:

For the KPI object that meets the requirements of comparing Current Year (CY) sales against Last Year (LY) sales, while ensuring the KPI remains static regardless of selections, we need to leverage Set Analysis with the 1 identifier. This ensures the KPI ignores any selections made by the user. Option A uses the correct structure of Set Analysis that compares CY sales to LY sales within the APAC region, and the 1 set identifier ensures the KPI does not change based on selections. The logic is structured as follows:
Sum({1 <region={"apac"}, year={$(=max(year))}>} Sales) computes the sales for the APAC region for the current year (CY).
Sum({1 <region={"apac"}, year={$(=max(year)-1)}>} Sales) computes the sales for the APAC region for the previous year (LY).
This expression will ensure that the comparison of sales between CY and LY is made, without being affected by user selections.
Key Concepts:
Set Analysis with 1: The 1 set identifier ensures that selections made by users do not affect the result, making the KPI static.
Comparison of CY vs. LY: The use of $(=max(year)) and $(=max(year)-1) ensures that the current and previous years are dynamically compared.
Why the Other Options Are Less Suitable:
B, C, and D: While these options use a similar structure, they do not correctly handle the measure structure or have syntactical issues. Only Option A properly utilizes the 1 set identifier and dynamic year comparison for the APAC region.
References for Qlik Sense Business Analyst:
Set Analysis for Static KPIs: Using the 1 set identifier in Qlik Sense ensures that a KPI remains static and unaffected by user selections, which is essential for business requirements like this. Thus, A is the correct choice because it correctly computes the required static KPI for the APAC region, making it the verified answer.

Reveal Solution Next Question

QUESTION: 24

A clothing manufacturer has operations throughout Europe and needs to manage access to the data. There is data for the following countries under the field SACOUNTRY -> France, Spain, United

Kingdom and Germany. The application has been designed with Section Access to manage the data displayed.

What is the expected outcome of this Section Access table?

USER1 sees data for France and Spain, USER2 sees data for the UK. ADMIN sees data for France, Spain, Germany and United Kingdom
USER1 does not see data for France and Spain. USER2 does not see data for the United Kingdom.
ADMIN sees data for all countries.
USER1 does not see data for France and Spain, USER2 does not see data for United Kingdom.
ADMIN can not open the application
USER1 sees data for France and Spain, USER2 sees data for the UK. ADMIN sees data for France, Spain and United Kingdom

Answer(s): A

Explanation:

In this Section Access script, the roles and access to data for different users are defined based on the SACOUNTRY field. Here's how the data access will work:
ADMIN: The ADMIN user has access to all data because the * in the SACOUNTRY field allows full access to all countries in the dataset.
USER1: This user has access to Spain and France because the SACOUNTRY field specifies these countries for USER1.
USER2: This user has access to United Kingdom because the SACOUNTRY field specifies only the UK

for USER2.
Key Concepts:
Section Access: This feature in Qlik Sense controls which data users can see based on their login credentials. The access rights are controlled through fields like ACCESS, USERID, and SACOUNTRY in this case.
Why the Other Options Are Less Suitable:
B and C: These suggest that users won't see data they have access to, which contradicts the defined Section Access script.
D: This incorrectly assumes that ADMIN cannot see Germany, which is not defined in the script.
References for Qlik Sense Business Analyst:
Section Access Best Practices: In Qlik Sense, Section Access tables define the data that users can see, and the use of * for the ADMIN role ensures access to all data.

Thus, A is the correct answer because it matches the expected data access behavior based on the script, making it the verified answer.

Reveal Solution Next Question

Free QSBA2024 Exam Braindumps (page: 6)

QUESTION: 21

Explanation:

QUESTION: 22

Explanation:

QUESTION: 23

Explanation:

QUESTION: 24

Explanation: