QlikView QSBA2024 Online Practice Questions and Exam Preparation

QlikView QSBA2024 Online Questions & Answers

• Question 11:

  A business analyst needs to build a chart that enables users to analyze the correlation between the following measures for all products:

  1. Product Sales ($)

  2. Order Volume

  3. Margin%

  Which visualization should the business analyst use?

  A. Multi KPI
  B. Combo chart
  C. Scatter plot
  D. Pivot table
  C. Scatter plot

  ---

  Explanation

  A scatter plot is the most appropriate visualization for analyzing the correlation between Product Sales ($) , Order Volume , and Margin % . Scatter plots are ideal for showing relationships between two or more continuous variables, which is

  crucial for identifying trends or correlations among these measures.

  Key Concepts:

  Scatter Plot: This chart type is specifically designed to display correlations between measures, making it the ideal choice for visualizing relationships between Product Sales, Order Volume, and Margin %.

  Multiple Measures: Scatter plots in Qlik Sense can plot two measures on the X and Y axes and can use colors or bubbles to represent additional measures (such as Margin %).

  Why the Other Options Are Less Suitable:

  A. Multi KPI: A Multi KPI displays multiple metrics but doesn't show correlations between them.

  B. Combo chart: A combo chart combines bar and line charts but is not suited for analyzing correlations between multiple continuous measures.

  D. Pivot table: While useful for data aggregation, a pivot table does not provide a clear visualization of correlations between measures.

  References for Qlik Sense Business Analyst:

  Scatter Plot for Correlation Analysis: Scatter plots are recommended in Qlik Sense when exploring relationships between multiple continuous variables.

  Thus, the scatter plot is the most effective visualization for analyzing the correlation between Product Sales, Order Volume, and Margin %, making the correct answer. C

• Question 12:

  A business analyst is developing an app that requires a complex visualization. The visualization is very similar in style and configuration to another visualization in a different app, but the data models are completely different.

  Which action should the business analyst take to most efficiently create the new visualization?

  A. Add the base visualization to the master items and use it as a template for the new visualization.
  B. Note the properties of the base visualization and create the new visualization from scratch.
  C. Copy and paste the visualization between the apps, and update the data properties in the new app.
  D. Open both apps at the same time. Drag the base visualization between apps, then update the data properties.
  C. Copy and paste the visualization between the apps, and update the data properties in the new app.

  ---

  Explanation

  When working with Qlik Sense apps, a business analyst often encounters situations where visualizations may be highly similar between different apps, even if the underlying data models differ. In such cases, efficiency is crucial, and Qlik Sense provides several methods to reuse visualizations across apps. Let's break down the options:

  A. Add the base visualization to the master items and use it as a template for the new visualization.This option suggests adding the base visualization to the master items. While master items are useful for reusing dimensions, measures, and visualizations within the same app , they do not easily transfer across apps. In this case, since the visualization is required in a different app, this approach would not be the most efficient or feasible.

  B. Note the properties of the base visualization and create the new visualization from scratch.This option involves manually noting the properties and then replicating them in the new app. While this would work, it is labor-intensive and increases the likelihood of human error, especially in complex visualizations. It is not an efficient solution for business analysts looking to save time.

  C. Copy and paste the visualization between the apps, and update the data properties in the new app.This is the most efficient solution. Qlik Sense allows for thecopying and pasting of visualizations between different apps , and you can then adjust the properties to fit the new data model. This option enables the business analyst to leverage existing visual work without having to recreate it from scratch. Updating the data properties, such as dimensions and measures, ensures that the visualization functions correctly with the new data model.

  D. Open both apps at the same time. Drag the base visualization between apps, then update the data properties.While this seems like a practical option, Qlik Sense does not allow users to drag and drop visualizations directly between different apps. As a result, this method is not possible.

  Key Qlik Sense Business Analyst

  References:

  Copying and pasting visualizationsis a common practice in Qlik Sense when working between different apps. The ability to quickly replicate and adapt visualizations across apps helps streamline the development process.

  Adjusting data properties such as dimensions and measures ensures that visualizations adapt to different data models without the need for full recreation.

  Efficiency and error reduction are critical in app development, and copy-paste functionalities are specifically designed to reduce manual work in such scenarios.

  In conclusion, the correct and most efficient action for the business analyst to take is , copy and paste the C visualization, and then update the relevant data properties.

• Question 13:

  A business analyst has access to all of a company's data for the past 10 years. The source table consists of the following fields: TransactionID, TransactionTime, Transaction Date, Transaction Year, Cardholder, Cardholder address, Cardissuer, and Amount.

  Users request to create an app based on this source with the following requirements:

  1. Users only review the data for the past 2 years

  2. Data must be updated daily

  3. Users should not view cardholder info

  Which steps should the business analyst complete to improve the app performance?

  A. 1. Delete Cardholder and time fields in Data manager 2. Use a bookmark based on auto-calendar fields 3. Use the reload function in the sheet Editor asset panel
  B. 1. Delete Cardholder and time fields in Data manager 2. Use set analysis to show data based on transaction year 3. Use an API to perform a daily reload task
  C. 1. Deselect Cardholder and time fields in Data manager 2. Use a filter pane based on auto-calendar fields 3. Perform a daily reload via the Data manager
  D. 1. Deselect Cardholder and time fields in Data manager 2. Apply a filter to extract data based on transaction year 3. Request a daily reload task from the system admin
  D. 1. Deselect Cardholder and time fields in Data manager 2. Apply a filter to extract data based on transaction year 3. Request a daily reload task from the system admin

  ---

  Explanation

  The business analyst needs to optimize the app for performance and ensure that users only see data from the past two years, without cardholder information, and that the data is updated daily. Bydeselecting the Cardholder and time fields in

  the Data Manager, the analyst ensures that sensitive information is not loaded. Applying a filter to extract data based on transaction year ensures that only relevant data (the last two years) is included in the app, improving performance.

  Lastly, requesting a daily reload task from the system administrator ensures that the app stays up to date.

  Key Concepts:

  Deselecting Fields: This removes unnecessary fields, such as Cardholder information, from the data model, which improves performance and ensures privacy.

  Filtering Data: Applying a filter to limit data to the last two years reduces the dataset size and improves app responsiveness.

  Daily Reload Task: Requesting a daily reload ensures that the app's data stays current, meeting the requirement for daily updates.

  Why the Other Options Are Less Suitable:

  A. Delete Cardholder and time fields, use bookmark: A bookmark is not an efficient solution for filtering by transaction year.

  B. Set analysis and API reload: Set analysis works within the app but does not optimize the data load itself. Using an API for reload tasks is unnecessarily complex.

  C. Use filter pane and auto-calendar: While auto-calendar fields can be useful, they don't optimize the data loading process for performance.

  References for Qlik Sense Business Analyst:

  Efficient Data Loading: Qlik Sense recommends filtering data at the load stage to improve performance, especially when dealing with large datasets.

  Thus, is the correct solution, making it the verified answer. D

• Question 14:

  A company CFO has requested an app that contains visualizations applicable to analyzing the finance data. Each regional finance team will analyze their data and should only have access to the data in their region. The app must contain a high-level sheet that navigates to relevant detail sheets.

  Which features support a logical design structure?

  A. A dashboard of KPIs and section access
  B. A pivot table that filters by region
  C. A Multi KPI with set analysis
  D. A dashboard with regional bookmarks
  A. A dashboard of KPIs and section access

  ---

  Explanation

  To fulfill the CFO's request for an app that allows each regional finance team to access only their data while navigating from a high-level sheet to detail sheets, the combination of a dashboard of KPIs and Section Access is ideal. A dashboard

  of KPIs provides high-level insights, and Section Access ensures that users from different regions can only see the data relevant to their region. Section Access allows for controlled access to data, ensuring data security and segregation.

  Key Concepts:

  Dashboard of KPIs: A dashboard displaying key performance indicators (KPIs) gives a high-level overview of financial data, allowing users to quickly assess critical metrics.

  Section Access: This Qlik Sense feature controls data access based on user roles, ensuring that users only have access to the data relevant to their region.

  Why the Other Options Are Less Suitable:

  B. Pivot table: A pivot table is useful for detailed analysis but not suitable for designing a navigation structure or controlling access to data by region.

  C. Multi KPI with set analysis: While set analysis can filter data, it doesn't control access at the regional level as effectively as Section Access.

  D. Dashboard with regional bookmarks: Bookmarks are user-specific and do not offer security or access control, which is required in this scenario.

  References for Qlik Sense Business Analyst:

  Section Access for Regional Data Control: Qlik Sense recommends Section Access for managing data access when different users need to see only specific subsets of data.

  Thus, is the best solution because it combines high-level KPIs with robust data access controls using Section A Access, making it the correct answer.

• Question 15:

  The human resources department needs to see a distribution of salaries broken down by department with standard deviation indicators.

  Which visualization should the developer use?

  A. Distribution plot
  B. Box plot
  C. Histogram
  D. Scatter plot
  B. Box plot

  ---

  Explanation

  A box plot is the best visualization for displaying the distribution of salaries broken down by department with standard deviation indicators. Box plots show the spread of data, including key measures like quartiles, median, and outliers, which

  are useful for analyzing salary distributions. They also naturally incorporate standard deviation indicators through the spread of data.

  Key Concepts:

  Box Plot: This type of chart is designed for analyzing the distribution of data across different categories (in this case, departments). It shows the spread and variability of data, which can include standard deviations.

  Why the Other Options Are Less Suitable:

  A. Distribution plot: While a distribution plot can show spread, it's not as effective for showing standard deviation and is less suited for categorical breakdowns.

  C. Histogram: A histogram shows the distribution of a single variable, but it doesn't provide the same detailed breakdown as a box plot.

  D. Scatter plot: Scatter plots are used for showing relationships between two variables and are not suitable for showing standard deviation across departments.

  References for Qlik Sense Business Analyst:

  Box Plot for Distribution Analysis: Box plots are ideal for visualizing data distribution and variability across categories, making them the preferred choice for analyzing salary distribution by department.

  Thus, the box plot is the best choice for visualizing salary distribution with standard deviation indicators, making the verified answer. B

• Question 16:

  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 RodentlD AS RodentID_Counter in the MazeEscapes table. Use Count (Distinct RodentlD Counter) as the KPI expression.
  B. Create 1 AS RodentID_Counter in the Rodent table. Use Sum (RodentlD Counter) as the KPI expression.
  C. Create 1 AS RodentID_Counter in the MazeEscapes table. Use Sum (RodentlD Counter) as the KPI expression.
  D. Create RodentlD AS RodentlD Counter in the Rodent table. Use Count (Distinct RodentID Counter) as the KPI expression.
  A. Create RodentlD AS RodentID_Counter in the MazeEscapes table. Use Count (Distinct RodentlD Counter) as the KPI expression.

  ---

  Explanation

  In this case, we need to count how many unique rodents have made at least one attempt at any maze. Since the relationship between the Rodent table and the MazeEscapes table is a one-to-many relationship (each rodent may attempt

  several mazes), the best approach is to base the calculation on the MazeEscapes table, as it holds the actual records of rodent attempts.

  By creating a new field RodentID_Counter in the MazeEscapes table, the analyst ensures that each rodent's attempt is captured. Using the Count (Distinct RodentID_Counter) as the KPI expression then accurately counts each unique rodent

  that has made at least one attempt, without counting multiple attempts by the same rodent.

  Key Concepts:

  Distinct Count: The distinct count ensures that rodents who have made multiple maze attempts are only counted once.

  MazeEscapes Table: This table holds the records of each attempt, making it the correct source for this KPI.

  Why the Other Options Are Less Suitable:

  B. Sum (RodentID_Counter) in the Rodent table: This would incorrectly sum the number of rodents rather than counting unique attempts, leading to inaccurate results.

  C. Sum (RodentID_Counter) in the MazeEscapes table: Summing the counter would not account for the distinct rodents, leading to incorrect counting.

  D. RodentID_Counter in the Rodent table: This would not correctly reflect the rodents that have made an attempt, as not every rodent in the Rodent table may have attempted a maze.

  References for Qlik Sense Business Analyst:

  Distinct Count in KPI: It is best practice to use Count(Distinct ...) when working with KPIs that require unique counts, such as counting distinct rodents in this scenario.

  Thus, is the verified answer because it ensures that each rodent is counted once, based on their attempts in A the MazeEscapes table.

• Question 17:

  A customer is developing over 100 apps, each with several sheets that contain multiple visualizations and text objects. The customer wants to standardize all colors used every object across every app. The customer also needs to be able to change these colors quickly, as required.

  Which steps should the business analyst take to make sure the color palette is easily maintained in every app?

  A. 1. Design all base objects as master visualizations 2. Link each object in each app to the relevant master visualization 3. Adjust the data properties as required
  B. 1. Develop the first app with every variation of object and visualization that will be required 2. Duplicate this app to create every other app 3. Remove the variations that are not required and adjust the ones needed
  C. 1. Create all color expressions as variables in a text file 2. Load it in each app with an include statement 3. Use these variables in the color property of all objects
  D. 1. Store color definitions within a .qvd file 2. Have each app load this file as a data island in the model 3. Have every object select its required color property from the rows within the data island
  C. 1. Create all color expressions as variables in a text file 2. Load it in each app with an include statement 3. Use these variables in the color property of all objects

  ---

  Explanation

  In scenarios where a customer needs to standardize colors across multiple apps and be able to update them quickly, using variables in combination with an include statement is the most flexible and maintainable approach.

  A. Design all base objects as master visualizations and link each object in each app to the relevant master visualization.While master visualizations help with consistency within a single app, they don't offer an easy way to update all apps globally. You would need to manually update the colors in every master visualization in each app, which is not efficient for large-scale management.

  B. Develop the first app with every variation of object and visualization and duplicate this app. Duplicating apps will create maintenance challenges. Each app would need to be updated individually if colors or other settings change, which is not scalable for over 100 apps.

  C. Create all color expressions as variables in a text file, load it in each app with an include statement, and use these variables in the color property of all objects.This is the most efficient solution. By storing color definitions in a text file and loading them with an include statement , the business analyst can update the colors in one place, and these updates will be reflected across all apps that use the file. This method ensures easy maintenance and flexibility.

  D. Store color definitions within a .qvd file and load it as a data island.While using a .qvd file is possible, it's not as straightforward as using variables and an include statement. Data islands are typically used for selection purposes, and this method would introduce unnecessary complexity in managing colors.

  Key Qlik Sense Business Analyst

  References:

  Variablesare widely used in Qlik Sense for managing repeated expressions or values like colors. They can be defined once and reused throughout the app.

  Include statementsallow external files (like text files containing variables) to be loaded into apps, ensuring that updates made to the text file are automatically reflected in all apps that use it. This creates a flexible and scalable solution for

  managing standardization across multiple apps.

  Thus, the best way to maintain a standardized color palette across all apps is tocreate all color expressions as variables in a text file and load them into each app using an include statement .

• Question 18:

  Refer to the exhibits.

  

  A business analyst must add a list of temporary employees (interns) to the current sales app. The app contains an existing employees table. When the business analyst profiles the data, the association view displays possible associations as shown.

  Which action should the business analyst take in Data manager to meet the requirements?

  A. Create a concatenated key to associate the Employees and InternEmp tables
  B. Concatenate the InternEmp table to the Employees tables within Data manager
  C. Force an association between the InternEmp and the Orders tables
  D. Create an association between the EmpID and EmployeelD fields
  D. Create an association between the EmpID and EmployeelD fields

  ---

  Explanation

  The InternEmp table contains information about temporary employees (interns), and the Employees table contains regular employee data. To properly link these two tables, the business analyst needs to create an association between the

  EmpID in the InternEmp table and the EmployeeID in the Employees table. This will ensure that the two tables are correctly associated based on the employee identifiers, allowing the system to relate both tables in the data model.

  Key Concepts:

  Association: Qlik Sense automatically suggests associations between tables based on field names. By linking EmpID from InternEmp with EmployeeID from Employees, the tables can be properly related in the data model.

  Association View: The association view in Data Manager helps visualize how tables are connected and suggests appropriate links between tables based on common fields.

  Why the Other Options Are Less Suitable:

  A. Create a concatenated key: Concatenation is unnecessary for this scenario since the data model relies on direct associations between keys.

  B. Concatenate the tables: Concatenating the InternEmp table into the Employees table would combine the records, but it's not appropriate since the two tables should remain separate entities.

  C. Force an association between InternEmp and Orders: There's no need to associate InternEmp with Orders directly since the focus is on employees and interns.

  References for Qlik Sense Business Analyst:

  Field Associations in Qlik Sense: Properly associating fields between tables is crucial for building a clean and efficient data model in Qlik Sense.

  Thus, creating an association between EmpID and EmployeeID is the best approach, making the correct D answer.

• Question 19:

  A company director who spends very little time in applications needs to be informed when a threshold is breached. Which feature should the business analyst use?

  A. Weekly PDF report
  B. Storytelling
  C. Alerting
  D. Bookmark
  C. Alerting

  ---

  Explanation

  To inform a company director when a threshold is breached, Alerting is the most appropriate feature. Qlik Sense allows users to set up automated alerts based on specific conditions or thresholds. Thesealerts can be configured to notify users

  when certain criteria are met, making it ideal for keeping the director informed without requiring them to constantly check the application.

  Key Concepts:

  Alerting: This feature allows users to set conditions (such as when a sales or performance threshold is breached) and automatically send notifications to the relevant individuals.

  Automated Notifications: Alerting ensures that the director is notified promptly and automatically when a critical threshold is reached.

  Why the Other Options Are Less Suitable:

  A. Weekly PDF report: A weekly report would not provide real-time notifications, which are necessary when thresholds are breached.

  B. Storytelling: Storytelling is used for presentations, not for monitoring thresholds.

  D. Bookmark: A bookmark only saves a particular selection or view, and cannot send notifications when a condition is met.

  References for Qlik Sense Business Analyst:

  Alerting in Qlik Sense: Qlik Sense's alerting functionality is designed to notify users when specific conditions are triggered, making it ideal for scenarios where timely notifications are critical.

  Thus, using Alerting is the best solution to notify the director when a threshold is breached, making the C verified answer.

• Question 20:

  A company CEO requests an app that contains global sales information. The CEO needs to present this information to an audience of international investors during an upcoming meeting.

  The presentation must meet several requirements:

  1. Contain visualizations that present clearly to a large audience

  2. Answer audience questions dynamically

  3. Be made available as shared content

  4. Emphasize important sales revenue

  Which Qlik Sense features should the business analyst prepare?

  A. Embed a video player in the shared app with a recording to describe the charts
  B. Create a sheet that features colorful and layered visualizations and export as a PDF
  C. Set up NPrinting to connect to the app and design a si ides how-style report
  D. Create a storytelling narration in a published app that contains embedded sheets
  D. Create a storytelling narration in a published app that contains embedded sheets

  ---

  Explanation

  To meet the CEO's requirements for a dynamic, interactive, and visually impactful presentation that can also be shared, the Storytelling feature in Qlik Sense is the best option. The Storytelling feature allows the business analyst to create a

  narrative combining static snapshots and live Qlik Sense sheets. This is perfect for large presentations as it lets the CEO present critical information and answer audience questions dynamically by embedding live sheets into the story, making

  the presentation interactive.

  Key Concepts:

  Storytelling: This feature allows the creation of a sequence of slides that include embedded live Qlik Sense visualizations, enabling dynamic responses to audience questions.

  Shared Content: Once the app is published, it can be shared with a broader audience, allowing stakeholders to interact with the embedded sheets.

  Why the Other Options Are Less Suitable:

  A. Embed a video player: While videos can be useful, they do not allow for dynamic interaction, which is a requirement.

  B. Colorful and layered visualizations exported as PDF: PDFs are static, and exporting as a PDF would not allow for dynamic interaction during the presentation.

  C. NPrinting slideshow-style report: NPrinting is useful for generating reports, but it does not meet the need for live, dynamic presentations.

  References for Qlik Sense Business Analyst:

  Qlik Sense Storytelling for Presentations: Storytelling allows users to blend narrative and interactive elements, making it ideal for presenting to large audiences.

  Thus, is the best choice because it meets all the requirements for interactive and dynamic presentations, D making it the verified answer.