QSBA2018 Exam - Free QlikView Questions and Answers

Question #11 (Topic: Single Topic)

A business analyst must display current year sales versus previous year sales by region, sub-region, and city.
The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales.
Which calculated expressions should the business analyst create to meet these requirements?
A.

B.

C.

D.

Answer: B

Question #12 (Topic: Single Topic)

A business analyst needs to create an app showing sales data. The app requirements are as follows:
✑ Compare sales for the current year (CY Sales) versus last year (LY Sales)
✑ CY Sales must always be displayed in blue
✑ LY Sales must always be displayed in yellow
Which steps should the business analyst take to meet these requirements?

A. 1. Create a KPI with two measures, CY Sales and LY Sales 2. Write an IF expression to set the appropriate colors for each measure B. 1. Create CY Sales and LY Sales measures as master items 2. Write an IF expression to set the appropriate colors for the master items C. 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure 2. Create one KPI from the two master item measures D. 1. Create CY Sales and LY Sales measures as master items and set the required color for each measure using Value colors 2. Create two gauges, one for each measure and set the color for each appropriately

Answer: C

Question #13 (Topic: Single Topic)

A business analyst is creating a dashboard to analyze supply chains. The app must contain several elements:
✑ A bar chart that shows a number of products and product groups handled by shipper
✑ A map that shows the number of shipments sent from factory locations
A bar chart that shows average delivery costs by shipper

Which dimensions should the business analyst use for this app?

A. Product, Shipper, FactoryLocation B. Shipper, FactoryLocation C. Shipper, Product D. Product, ProductGroup, Shipper

Answer: B

Question #14 (Topic: Single Topic)

A business analyst uses the data manager to load customer data from a QVD file. The data manager automatically profiles the data, and recognizes City and
Country values as Geo data.
The app must meet the following requirements:
✑ Country field should be in Geo data format
✑ City should NOT be allowed as a mapping option for the users
✑ There must be an association between the Country and City fields
Which actions should the business analyst take to meet these requirements?

A. 1. In the Associations view, select the City field 2. Delete $geoname-tag from field properties B. 1. In the Associations view, select the City field 2. Change the format from ג€˜Geo dataג€™ to ג€˜No data profilingג€™ C. 1. In the Associations view, select the City field 2. Delete the City field D. 1. In the Associations view, select the City field 2. Change the format from ג€˜Geo dataג€™ to ג€˜Generalג€™

Answer: D

Question #15 (Topic: Single Topic)

Refer to the exhibit.
A business analyst must analyze sales using an existing sales order app.
✑ The Orders table in the app was added from a QVD file using the data manager
✑ The Orders table in the app and the QVD do NOT contain a SalesAmount field
✑ SalesAmount can be calculated by multiplying the Quantity and UnitPrice
How should the business analyst add a SalesAmount field into the Orders table?

A. In the data manager, create a new calculated field, SalesAmount, and set the expression value to Sum(UnitPrice * Quantity) B. In the data mode viewer, add a calculated field named SalesAmount with the expression UnitPrice * Quantity C. In the data manager, add a calculated field named SalesAmount with the expression UnitPrice * Quantity D. In the Orders QVD file, add an additional field named SalesAmount with the expression UnitPrice * Quantity

Answer: C

QlikView QSBA2018 - Qlik Sense Business Analyst Certification Exam Exam