QlikView QlikView Certification QSBA2018 Questions & Answers

• Question 11:

  A business analyst needs to make a complex pie chart easier to understand. The pie chart shows the total number of customers by customer type. There are 12 customer types. Some customers do NOT have a type assigned.

  The business analyst needs to: Show all customers including those without a customer type See the total number of customers in each customer type

  Which two visualizations could the business analyst use to meet these requirements? (Choose two.)

  A. Donut

  B. Treemap

  C. KPI

  D. Scatter plot

  E. Bar chart

  Correct Answer: CE

• Question 12:

  

  Refer to the exhibit.

  A range of colors between red (using code RGB(229,20,0)) and green (using code RGB(164,196,23)) needs to be used as a gradient in a scatter plot that displays sales and cost by store. The gradient needs to produce visualization shown in the exhibit.

  What is the most efficient method a business analyst should use to meet this requirement?

  A. Modify the visualization to set a color for the data points with an expression based on a Colormix 1 function

  B. Create a new calculation in the data model with the Colormix1 function that can be used as a gradient in the visualization

  C. Modify the default CSS file to produce the required color gradient

  D. Create a new measure in the master items with the Colormix2 function so that the gradient can be used in any visualization

  Correct Answer: A

• Question 13:

  A marketing team needs to analyze current sales by age groups in a bar chart. The following age groups

  are created in the data manager, and the field is named AgeGroup:

  Children: 16 years old and younger

  YoungAdult: 17 to 30 years old

  Adult: 31 years old and older

  The business analyst will use an expression to set the colors for the bars:

  If ([AgeGroup] = `Children', Red(), If ([AgeGroup] = `YoungAdult', Blue(), Green()))

  Which steps must be completed to apply the correct colors in the visualization?

  A. Select Data in the properties panel and create a calculated dimension using the expression editor.

  B. Create a master item dimension using the expression, in the visualization, select Color by dimension and use the newly created master item.

  C. Under Appearance in the properties panel, select Color, then select Color by expression, and make sure that The expression is a color code is checked.

  D. Create a master item measure using the expression. In the visualization, select Color by measure and use the newly created master item.

  Correct Answer: B

  Reference: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Colors/ examples-visualization-colors.htm#anchor-4

• Question 14:

  

  Refer to the exhibit.

  A business analyst must provide a visualization to show the trends of the number of orders generated per

  employee. The Customer must be searchable.

  EmployeeID, EmployeeName, OrderID, and CustomerID will be included in the load.

  Which additional fields must be loaded to meet this requirement?

  A. OrderDate, Customer, ProductID

  B. Customer, ProductID

  C. OrderDate, Customer

  D. OrderDate, UnitPrice

  Correct Answer: D

• Question 15:

  A business analyst must create an interactive table to analyze sales performance for the selected year and the previous year.

  Which are the correct expressions to meet this requirement?

  

  A. B. C.

  

  D.

  Correct Answer: B

• Question 16:

  Which three actions can a business analyst complete in the Qlik Sense Enterprise hub? (Choose three.)

  A. Grant users access to a stream

  B. Load data from multiple sources

  C. Publish an app into a stream

  D. Publish a sheet into the Community section

  E. Schedule a reload of an app

  Correct Answer: ACD

• Question 17:

  The sales department requests a new Qlik Sense app to show the amount of sales in each territory. The app must:

  Allow analysis of aggregate views of big data stores Include objects that allow the user to jump to a specific sheet Provide a way to send a report through email

  Which three products or features should the business analyst use to meet these requirements? (Choose three.)

  A. On Demand App Generation

  B. Bookmarks

  C. Qlick Sense Enterprise for Elastic

  D. Qlick NPrinting

  E. Qlick DataMarket

  Correct Answer: ADE

• Question 18:

  

  Refer to the exhibit.

  A business analyst needs to add a reference line to a bar chart.

  Which action should the business analyst take to meet this requirement?

  A. Select the Max trend line in the properties panel of the bar chart

  B. Create a calculated field in the data manager and use it as a chart expression

  C. Create a reference line using Max(Aggr(Sum(Sales),CompanyName))

  D. Create a reference line using Aggr(Max(Sum(Sales),CompanyName))

  Correct Answer: C

• Question 19:

  A hospital has a large number of users who create their own visualizations in Qlik Sense Enterprise. The hospital has several requirements: Users must be able to create their own visualizations Users can duplicate and modify existing sheets New visualizations can be shared among the work groups in a governed and controlled way User created objects and sheets can be included in the base sheets

  Which three privileges will meet these requirements? (Choose three.)

  A. Users can publish sheets to the Community section

  B. The app owner can promote community sheets to base sheets

  C. Users can promote community sheets to base sheets

  D. Users can replace base sheets with community sheets

  E. Users can copy and modify base sheets

  Correct Answer: ABE

• Question 20:

  A wholesaler needs to show sales and products in a PowerPoint presentation.

  The dimensions and measures are: Product Name Sum of Sales Number of Orders

  Which two chart types could the business analyst use to meet these requirements? (Choose two.)

  A. Stacked bar chart

  B. Combo chart

  C. Scatter plot

  D. Distribution plot

  E. Treemap

  Correct Answer: AD