QlikView QSBA2021 Online Practice Questions and Exam Preparation

QlikView QSBA2021 Online Questions & Answers

• Question 1:

  A business analyst ;s creating an app tor the team. A set of selections must be applied every time an app is opened. What should the business analyst do to meet this requirement?

  A. Use a sheet action and apply a bookmark named 'Default'
  B. Create a masnup and use the API to apply default selections
  C. Create a bookmark and select 'Set selections as app default"
  D. Use Section access to predefine tie default selections
  A. Use a sheet action and apply a bookmark named 'Default'

• Question 2:

  Refer to the exhibit.

  

  What is the selection slate of light gray values?

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

• Question 3:

  Refer to the exhibit

  

  A business analyst is modifying a box plot End users report unexpected blue dots in a box plot. What should the business analyst do?

  A. Under Box plot elements, select Whisker length and increase to two interquartile ranges
  B. Under Box plot elements deselect Include outliers
  C. Under the Dimensions menu, deselect Include null values
  D. Ask the data architect to modify the data model
  A. Under Box plot elements, select Whisker length and increase to two interquartile ranges

  ---

  explanation:

  Explanation/Reference:

• Question 4:

  A business analyst is creating an app for technicians. The app must meet several requirements

  1.

  Visualization labels must change according to the selected tame period

  2.

  A button to toggle between Month and Year to Date (YTD)

  3.

  Two fields combine to create one dimension that is used m several visualizations Which three options are needed to meet the requirements? (Select three.)

  A. Master items
  B. Variables
  C. Calculated fields
  D. Alternate states
  E. Set analysis
  A. Master items
  B. Variables
  C. Calculated fields

  ---

  explanation:

  Explanation/Reference:

• Question 5:

  Refer to the exhibit.

  

  The data architect toads these fields from a data source A business analyst is creating an app for the human resources team Several visualizations are required

  1.

  Line chart to show the number of new hires and terminations monthly

  2.

  Treemap to show the number of employees by department and job level

  3.

  Distribution plot of annual salaries or amount of benefits received by duration of employment or location

  4.

  KPI to show average cost per employee The cost per employee can be calculated by adding the employee salary to the amount of benefits received Which two additional fields does the business analyst need from the data architect lo meet these requirements? (Select two )

  A. Number of h res and termination
  B. Benefits received
  C. Average cost of employee
  D. Years employed
  E. Department
  B. Benefits received
  D. Years employed

  ---

  explanation:

  Explanation/Reference:

• Question 6:

  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:

  Explanation/Reference:

• Question 7:

  A business analyst is creating a story One visualization must be scaled only vertically. Which steps are needed to apply this in the storytelling view?

  A. Select the Effects library to rescale the visualization
  B. Select Edit in the Snapshot library and rescale the visualization
  C. Select Unlock the snapshot and rescale the visualization
  D. Select Edit on the visualization and enter the new height
  B. Select Edit in the Snapshot library and rescale the visualization

• Question 8:

  A business analyst is creating an app for the sales department

  Users of the app most be able to create sheets and analyze data The salesdepartment has several additionalrequirements:

  Reuse the global sales visualization Create new visualizations The app has over 100 visualizations

  Users will NOT have access to the full data model

  What should be added to the master items to meet the requirement?

  A. All fields as dimensions and measures All visualizations
  B. All fields as dimensions and measures Selected visualizations
  C. Seated fields as dimensions and measures Selected visualizations
  D. Selected fields as dimensions and measures All visualizations
  A. All fields as dimensions and measures All visualizations

  ---

  explanation:

  Explanation/Reference:

• Question 9:

  Refer to the exhibits

  

  After the latest data reload a business analyst notices the value tor CategoryID 'B321' seems different

  What is causing this discrepancy?

  A. The data type for CategorylD 332V does not match the others
  B. Null values are deluded in the source data
  C. Some categories do NOT exist in the Category table
  D. Hyphen character ('.') is included m the source data
  A. The data type for CategorylD 332V does not match the others

  ---

  explanation:

  Explanation/Reference:

• Question 10:

  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