QlikView QlikView Certification QSBA2018 Questions & Answers

• Question 21:

  A business analyst must create a horizontal bar chart to identify the top Sales Reps, Customer Segment Description, and Customer City.

  Users must be able to analyze the data for one field at a time The chart should show the unique number of customers for each dimension being analyzed The dimensions and measures created must be re-used on other charts

  Which steps should the business analyst perform to configure the chart correctly?

  A. Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions Create a master item measure using Count(Distinct[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the measure

  B. Create a cyclic dimension as a master item using all three dimensions and add it to the chart Create a master item measure using Count(Total[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the measure

  C. Create all three dimensions as master items and add one as the chart dimension and the other two as alternative dimensions Create a master item measure using Count(Total[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the measure

  D. Create all three dimensions as master items and add to the bar chart Create a master item measure using Count(Distinct[Customer Number]) and add it to the chart Change the chart presentation to Horizontal and sort it by the first dimension

  Correct Answer: C

• Question 22:

  A printing company has several requirements for a new Qlik Sense app: Report of daily work orders Total number of print jobs Print jobs based on region Total number of print jobs by month

  The app will be used by executives, sales managers, sales representatives, and press workers.

  Which sheets should a business analyst build to meet these requirements?

  A. Sheet 1: Details page that shows the daily print jobs in a table Sheet 2: Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region Sheet 3: Visualizations that show the count of print jobs by month and press worker

  B. Sheet 1: Details page that shows the daily print jobs in a table Sheet 2: Dashboard with a KPI visualization of total print jobs by month, customer, sales representative, and region Sheet 3: Report page that shows the daily print jobs

  C. Sheet 1: Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region Sheet 2: Visualizations that show the count of print jobs by month, customer, sales representative, and region Sheet 3: Details page that shows the daily print jobs in a table

  D. Sheet 1: Dashboard with a KPI visualization of total print jobs, and a bar chart with print jobs by region Sheet 2: Details page that shows the daily print jobs in a table Sheet 3: Details page that shows the daily print jobs

  Correct Answer: B

• Question 23:

  A business analyst creates a scatter plot and wants to save it for reuse by colleagues. The business analyst must remain the owner of this scatter plot, and should be the only person allowed to make changes. These changes should be applied automatically to all instances of this visualization.

  Which two actions should the business analyst take to meet these requirements? (Choose two.)

  A. Copy the scatter plot on every sheet of the app

  B. Add the finished scatter plot to the master items

  C. Copy the scatter plot to the custom objects

  D. Publish the app to the Everyone stream

  E. Publish the finished scatter plot to the hub

  Correct Answer: AB

  Reference: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/ Visualizations/visualizations.htm

• Question 24:

  

  Refer to the exhibit.

  A company is starting to use a new customer account system. The business analyst must include this data in an existing app.

  Data from the legacy customer account system is already available in the app.

  Both tables have similar data, but the columns have different names.

  Which actions should the business analyst take to merge data from both systems?

  A. 1. Select Legacy Accounts

  2.

  Click Concatenate tables

  3.

  Select New Customer Accounts

  4.

  Map the tables

  5.

  Click Apply

  B. 1. Select New Customer Accounts

  2.

  Drag it over Invoices

  3.

  Define the association

  4.

  Click Apply

  C. 1. Select Legacy Accounts

  2.

  Click Concatenate tables

  3.

  Select New Customer Accounts

  4.

  Click Sample data

  5.

  Click Apply

  D. 1. Select New Customer Accounts

  2.

  Drag it over Legacy Accounts

  3.

  Rename the association

  4.

  Click Apply

  Correct Answer: A

• Question 25:

  

  Refer to the exhibits.

  After the latest data reload, a business analyst notices the value for CategoryID `B321 appears to be

  different from the other values.

  What is causing this difference?

  A. Null values are included in the source data

  B. Pre-aggregated data is being used

  C. Hyphen characters (`-') are included in the source data

  D. Some categories do NOT exist in the Category table

  Correct Answer: B

• Question 26:

  What does the color light gray indicate in the selections tool?

  A. The field value is an alternative selection

  B. The field value is locked and can NOT be selected

  C. The field value is associated with the selection

  D. The field value is NOT associated with the selection

  Correct Answer: A

  Reference: https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Selections/associativeselection-model.htm?_ga=2.117296261.2062347430.1553174917-2064436038.1553174917

• Question 27:

  A manufacturer has several requirements for its new sales dashboard: Deliver analytics to mobile devices Share data with retail partners via a custom portal Prevent sensitive data from being shared with competitors Provide governed reusable assets

  Which capabilities should a business analyst use to meet these requirements?

  A. Cloud deployment Master items Mashups Configurable security rules

  B. Export to Word Storytelling Mashups Configurable security rules

  C. Mashups Master items Responsive design Configurable security rules

  D. Cloud deployment Master items Alerting Central management

  Correct Answer: C

• Question 28:

  

  

  Refer to the exhibits.

  A business analyst must improve the first chart shown to make it look like the second chart.

  Which two actions should the business analyst take to meet this requirements? (Choose two.)

  A. Replace the three measures with one measure that calculated Total Sales

  B. Change the stacked chart property in the properties panel

  C. Add Year as an additional dimension

  D. Change the continuous chart property in the properties panel

  E. Change the Area property in the chart properties

  Correct Answer: BD

• Question 29:

  A hospital billing department is concerned with the performance of the cardiology and orthopedic departments. The billing department wants to add a visualization to an existing app to analyze billing for these two departments.

  The business analyst must consider the hierarchy of: The department The physicians in each department The procedure performed by the physicians

  What should the business analyst create to meet the requirements?

  A. A scatter plot using alternate dimensions A bookmark for the physician

  B. A bar chart with a cyclic group A bookmark for the physician

  C. A bar chart using master items drill-down A bookmark for the departments

  D. A scatter plot using set analysis A bookmark for the departments

  Correct Answer: D

• Question 30:

  A sales department has a pie chart that displays the total amount of sales by city.

  Users have requested several changes to the pie chart:

  Display the labels in `Red'

  Increase the font size of the title

  Change the color of the values to `Blue'

  Which technique should a business analyst use to meet these requirements?

  A. Create a custom theme

  B. Develop a widget

  C. Change chart properties

  D. Use single configurator

  Correct Answer: C

  Reference: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/ Visualizations/PieChart/pie-chart-properties-panel.htm