Free QlikView QSBA2022 Exam Questions

Become QlikView Certified with updated QSBA2022 exam questions and correct answers

Page: 1 / 24

Total 120 Questions | Updated On: Jun 17, 2026

Add To Cart

Question 1

A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name

What should the business analyst do to load the Excel data?

A : en the Excel file, remove all columns that do not have the suffix '_c' and save t>e Me to be loaded

B : elect the fields that do NOT have the '_c' suffix in the data manager table preview

C : ilize drier functionality in the data manager to select only columns with the suffix _C with a fitter condition

D : ad all columns because the recommended associations will use only columns with the suffix '_c*

Answer: C

Question 2

The board asked the team to review current sales by age group on a bar chart. These groups were created in Data Manager and named AgeGroup, as follows:
• Children: up to 16 years;
• YoungAdult: between 17 and 30 years old;
• Adult: 31+
The analyst then defines the colors of the bars with an expression:
If( AgeGroup = 'Children', Red(), If( AgeGroup = 'YoungAdult', Blue(), Green() ))
What's left to complete the jobs and apply the result to the visualization?

A : object properties, in data, create a calculated dimension using the informed expression

B : eate a master item for the dimension. In object properties, in color, select Color by Dimension and use the master item created

C : the object properties, in appearance, select Colors and then select the Color by Expression type. Be sure to keep selected the option "the expression is a color code"

D : eate a metric as a master item with this expression. In the view select Color by Metric and point to the master item created

Answer: C

Question 3

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 : the Data Viewer, add a calculated field named "Sales" with the expression: UnPrice * Qty

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

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

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

Answer: C

Question 4

A cinema company is analyzing the age group of customers who watch movies at least once a month and where they live. The following requirements should be considered:

• Age of customers

• Customer address

• Frequency of visits

What objects should the business analyst use to meet the requirements?

A : distribution chart and a pie chart

B : map and scatter plot

C : map and histogram

D : distribution chart and a treemap

Answer: C

Question 5

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

Page: 1 / 24

Total 120 Questions | Updated On: Jun 17, 2026

Add To Cart