QlikView QSBA2021 Online Practice Questions and Exam Preparation

QlikView QSBA2021 Online Questions & Answers

• Question 21:

  A business analyst needs to develop a visualization that compares performances of every product the company sells and each product category. The CEO wants to highlight the worst-and best-performing products and categories in a meeting that beg/is in one hour Using a bar chart which two approaches should the business analyst use? (Select two.)

  A. Alternative dimensions using fixed number limitations
  B. Stacked bar chart using ColorMix function
  C. Stack dimensions and color by measure
  D. Alternative dimensions and diverging color scheme
  E. Stack dimensions and color by dimension
  B. Stacked bar chart using ColorMix function
  D. Alternative dimensions and diverging color scheme

  ---

  Explanation/Reference:

• Question 22:

  After a campaign a marketing group has data that snows distinct increases of product sales over a 12-month period. The group needs to highlight the products that show the highest revenue.

  What should be developed to meet this requirement?

  A. Grid chart with diverging color by measure
  B. Line chart with area gradient color by measure
  C. Waterfall chart with custom positive value color
  D. Mekko chart with diverging color by dimension
  D. Mekko chart with diverging color by dimension

• Question 23:

  Refer to the exhibit.

  

  What is the selection slate of light gray values?

  A. Possible
  B. Excluded
  C. Selected
  D. Alternative
  B. Excluded

• Question 24:

  A business analyst inherits an app full of sheets The business analyst needs to redesign the app using the DAR principle

  How should the business analyst orderthe visualizations?

  A. KPIs Table PivotTable Bar Chart Pie Chart Line Chart
  B. Bar Chart Pie Chart Line Chart KPIs Table Pivol Table
  C. KPIS Ba' Chart Pie Chart Line Chart Table Pivot. Table
  D. Bar Chart Pie Chart Line Chart Table Pivot Table KPIs
  D. Bar Chart Pie Chart Line Chart Table Pivot Table KPIs

  ---

  Explanation/Reference:

• Question 25:

  How does the Qlik Associative Engine analyze data from one or more data sources?

  A. Creates a set of pre aggregated queries for Qlik Sense to run
  B. Associates data into cubes to enable multidimensional analysis
  C. Inner joins multiple data sources together to remove unrequired information
  D. Combines multiple data sources without pre-aggregation
  A. Creates a set of pre aggregated queries for Qlik Sense to run

• Question 26:

  A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.

  The team wants to use insight Advisor to query events and opportunities to:

  1.

  Review specific areas and periods

  2.

  Use marketing terms not currently present in the app when classifying opportunities

  3.

  Define calendar periods and add calculations for specific data fields Some examples are as follows:

  

  Which process should the business analyst follow?

  A. Add tags into the data fields to improve how the Insight Advisor identifies the fields when using the natural language queries Use the Selection tool to remove any tads not needed for the search results
  B. Define me business logic and vocabulary to define values using the fields m me data set Create groups and set properties in fields Use Calendar groups to define custom periods
  C. Create master dimensions and measures, including calendar measures to define fiscal periods Use tags to improve the insight Advisor search features and include vocabulary terms
  D. Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field
  D. Update the data set using data manager or data load editor to include these terms as flags or values in the data set Also define the variable to determine which calculation should be used for each field

  ---

  Explanation/Reference:

• Question 27:

  A customer wants to perform a regional sates analysis to learn how products setover time m different areas The business analyst needs to design a sheet in the app tor business users to perform several tasks

  1.

  Select two different groups of countries to study ?Compare sales over time between these two groups using a bar chart

  2.

  Change the group items by selecting different countries at any time

  3.

  Select a time range in the bar chart and drill-down to daily transactional sales

  Which steps should the business anaryst follow to meet these requirements?

  A. Create one Alternate State Set1 Create two Filter Panels one associated to this Set1and one Default State(S) Create a Bar chart with the drill-down dimension and two measuressum({Set1'$} Sales)and sum({'Set1"S) Sales)
  B. Create two Alternate States Set1and Set2 Create two Filter Panels each associated with an Alternate State Create a Bar chart with a drill-down dimension and two measures sum({Set1'$} Sales) and sum{fSet2"S} Sales)
  C. Create one Alternate State Set1 Create two Filter Panels one associated lo this Set1 and one Default State1($) Create a Bar chart with the drill-down dimension and two measures sum({Set1-$) Sales) and sum('Set1-S) Sales)
  D. Create two Alternate States Sell and Set2 Create two Finer Panels each associated with an Alternate Stale Create a Bar chart with drill-down dimension and two measures sum({Set1'S} Sates) and sum({,Set2'*S} Sales)
  D. Create two Alternate States Sell and Set2 Create two Finer Panels each associated with an Alternate Stale Create a Bar chart with drill-down dimension and two measures sum({Set1'S} Sates) and sum({,Set2'*S} Sales)

  ---

  Explanation/Reference:

• Question 28:

  An organization recently acquired a competitor A business analyst needs to merge me custom databases with 20 years of customer and order transactions. The data must be integrated into the existing app to show the past two years of data Performance degradation must be minimized

  What should the business analyst do to meet this requirement?

  A. Add the new Customers and Orders tables and associate the new tables to me existing data model Filter the data from the Customers and Orders table to bring only data created within the past two years
  B. Add the new Customers and Orders tables and concatenate the new tables to the existing data model Filter the data from the Orders table to bring only data created within the past two years
  C. Add the new Customers and Orders tables and associate the new tables to the existing data model Filter the data from the Orders table to bring only data created within the past two years
  D. Add the new Customers and Orders tables and concatenate the new tables to the existing data model Filter the data from the Customers and Orders table to bring only data created within the past two years
  C. Add the new Customers and Orders tables and associate the new tables to the existing data model Filter the data from the Orders table to bring only data created within the past two years

  ---

  Explanation/Reference:

• Question 29:

  The business analyst needs to see now me same data wil appear m other chart types

  

  Which steps should the business analyst take to meet these requirements?

  A. 1. Create a new chart 2. Enable Insights 3. Select a recommended chart
  B. 1. Duplicate the chart 2. Drag and drop a new chart object over the old chart 3. Select Replace
  C. 1. Create a new chart 2. Enable Chart suggestions 3. Select a recommended chart
  D. 1. Duplicate the chart 2. Enable Chart suggestions 3. Select a recommended chart
  C. 1. Create a new chart 2. Enable Chart suggestions 3. Select a recommended chart

  ---

  Explanation/Reference:

• Question 30:

  Refer to the exhibits.

  

  These tables have the same structure. The Customers information is as shown in the Data Model Viewer In a sheet called "Customer Analysis" there is a filter pane with Customers.

  A business analyst s developing an app for the Sales department and loads the data about Customers from two files.

  The business analyst wants the values to appear as they were loaded How should this issue be resolved?

  A. Disable Sorting Auto and uncheck all options.
  B. Disable Sorting Auto and uncheck Sort Numerically.
  C. Enable Sort by Expression ReloadTime().
  D. Enable Sort by State and select Descending.
  C. Enable Sort by Expression ReloadTime().

  ---

  Explanation/Reference: