QlikView QSBA2024 - Qlik Sense Business Analyst Exam
Page: 2 / 10
Total 50 questions
Question #6 (Topic: Exam A)
Two customers in an organization want to use an app that contains a finance data set. With different analysis objectives, each customer will only use a subset of that data.
Which procedure should the business analyst follow?
Which procedure should the business analyst follow?
A. Apply Section Access to manage the data for each customer
B. Create multiple visualizations using set analysis
C. Duplicate and rename the apps for each customer
D. Unpivot, then re-associate the data tables for each customer
Answer: A
Question #7 (Topic: Exam A)
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?
A. Total distinct values and Subset ratio for the StudentID field in the Attempts table
B. Non-null values and Subset ratio for the StudentID field in the Students table
C. Subset ratio and Present distinct values for the ExamID field in the Attempts table
D. Present distinct values and Density% for the ExamID field in the Exams table
Answer: A
Question #8 (Topic: Exam A)
Refer to the exhibit.
An app that will track experiments for rodents (e.g., rats and mice) that navigate mazes (labyrinths) is being developed. Individual rodents are catalogued in the Rodent table, while the Mazes table has metadata for the mazes. The MazeEscapes table holds a record of each attempt at a maze by a rodent. A business analyst needs to build a KPI that will allow users to see how many rodents have made at least one attempt at any maze.
How should the analyst construct the KPI?
A. Create RodentID AS Rodent ID_counter in the MazeEscapes table.
Use Count (Distinct RodentID_Counter) as the KPI expression. B. Create l AS RodentID_Counter in the Rodent table.
Use Sum (RodentID_Counter) as the KPI expression. C. Create 1 AS RodentID_Counter in the MazeEscapes table.
Use Sum (RodentID_Counter) as the KPI expression. D. Create Rodent ID AS RodentID_Counter in the Rodent table.
Use Count (Distinct RodentID_Counter) as the KPI expression.
Use Count (Distinct RodentID_Counter) as the KPI expression. B. Create l AS RodentID_Counter in the Rodent table.
Use Sum (RodentID_Counter) as the KPI expression. C. Create 1 AS RodentID_Counter in the MazeEscapes table.
Use Sum (RodentID_Counter) as the KPI expression. D. Create Rodent ID AS RodentID_Counter in the Rodent table.
Use Count (Distinct RodentID_Counter) as the KPI expression.
Answer: C
Question #9 (Topic: Exam A)
Refer to the exhibit.
The users of a Qlik Sense app report slow performance. The app contains approximately 10 million rows of data. The business analyst notices the following KPI master measure definition:
Left( Trim( TransactionName), 1 ) * Right ( TransactionName, 5)
Which steps should the business analyst complete to improve app performance?
A. Ask the developer of the underlying database to change the structure of the field TransactionName.
B. - In the Data manager, use the Split function to split the field values with the underscore character as the separator.
- In the Data manager, use the Add calculated field function to multiply the 1st and the 3rd column of the split field.
- Reload the data. C. Change the master measure definition as follows:
subfield( TransactionName, '_', 1) * subfield( TransactionName, '_', 3)
In the Data manager, use the Replace function to remove the middle part of the field TransactionName
- In the Data manager, use the Add calculated field function to multiply the 1st and the 3rd column of the split field.
- Reload the data. C. Change the master measure definition as follows:
subfield( TransactionName, '_', 1) * subfield( TransactionName, '_', 3)
In the Data manager, use the Replace function to remove the middle part of the field TransactionName
Answer: B
Question #10 (Topic: Exam A)
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?
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?
A. USER1 sees data for France and Spain, USER2 sees data for the UK. ADMIN sees data for France, Spain, Germany and United Kingdom
B. USER1 does not see data for France and Spain. USER2 does not see data for the United Kingdom. ADMIN sees data for all countries.
C. USER1 does not see data for France and Spain, USER2 does not see data for United Kingdom. ADMIN can not open the application
D. USER1 sees data for France and Spain, USER2 sees data for the UK. ADMIN sees data for France, Spain and United Kingdom
Answer: A
