100% Free QlikView QSBA2022 Practice Test Questions

Question 1

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:

* Review specific areas and periods

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

* Define calendar periods and add calculations for specific data fields

Some examples are as follows:

Other-Image-72ab1f2a4-aa74-4e74-80c2-4fa267633198

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

Answer: D

Question 2

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 : 1. Sum({$< OrderYear = {$(=Year(Today()))} >} Sales)2. Sum({$< OrderYear = {$(=Year(Today())-1)} >} Sales)

B : 1. Sum({$< OrderYear = {CurrentYear} >} Sales)2. Sum({$< OrderYear = {CurrentYear-1} >} Sales)

C : 1. Sum({$< OrderYear = {Year(Today())} >} Sales)2. Sum({$< OrderYear = {Year(Today())-1} >} Sales)

D : 1. Sum({$< OrderYear = {$(=Year(Today(0)))} >} Sales)2. Sum({$< OrderYear = {$(=Year(Today(0))-1)} >} Sales)

Answer: A

Question 3

A company uses a Dashboard for its analysis. Users noticed some needs and created multiple bookmarks to optimize daily work. A developer had previously created some help markers based on interviews conducted with business users during the development stage. The company decided to take advantage of the bookmarks created by users and add to existing bookmarks.
What steps should the business analyst take to meet the requirements?

A : • Create a duplicate copy of the app• Delete the published app• Publish the duplicate app

B : • Prompt the developer and/or user to publish the bookmark to the community

C : • Duplicate the app in Work• Review previous bookmarks• Replace the existing published app

D : • Review previous bookmarks• Copy the app to a new stream• Publish the app in the new stream

Answer: B

Question 4

A business analyst is creating an app that requires several visualizations

* A scatter plot mat shows the margin percentage and total sales by product category

* A map with a the layer that visualizes lines between retail stores and lactones

* A KPI that shows total cost

Margin?n be calculated by dividing profit by revenue Profit is the difference between total cost and total sates

Which two sets of fields can the business analyst use to meet these requirements? (Select two.)

A : Line GeometryMargin%

B : Product CategoryLocation

C : SalesTotal Cost

D : Product CategoryRetail Store LocationFactory Location

E : Line Geometry

Answer: A,C

Question 5

A business analyst needs to analyze sales using an existing Sales Orders application:

• The sales order details table were added from a QVD file using Data Manager;

• The in-app and QVD sales order table does not have the pre-calculated "Sales" field

• Sales can be calculated by multiplying between "Qty" and "UnPrice"

How should the business analyst add the "Sales" field to the sales order table?

2021-10-22-14-30-44-24d6ee1c04d0d9442c628f3ab0500d6a

A : In the Data Viewer, add a calculated field named "Sales" with the expression: UnPrice * Qty

B : In Data Manager, add a calculated field named "Sales" with the expression: Sum(UnPrice * Qty)

C : In Data Manager, add a calculated field named "Sales" with the expression: UnPrice * Qty

D : In qvd file sales orders, add an additional field with the name "Sales" with the expression: UnPrice * Qty

Answer: C

Free Practice QlikView QSBA2022 Exam Questions 2025