Free QlikView QSBA2022 Exam 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 : 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 : eate 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 : date 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 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 : ne Geometry

Answer: A,C

Question 3

A business analyst has access to all of a company's data tor the past 10 years The source table consists of the following fields Transactions Transaction Time Transaction Date Transaction Year Cardholder Cardholder address Cardissuer and Amount Users request to create an app based on this source

Users only review me data for the past 2 years Data must be updated daily Users do not view cardholder into

What should the business analyst do to reprove the app performance?

A : 1. Deselect Cardholder and time field in data manager2. Use a pant based on auto-calendar fields3. Perform a daily reload via the data manager

B : 1. Delete Cardholder and time fields in data manager2. Use set analysis to show data based on transaction year3. Use an API to perform a daily reload task

C : 1. Deselect Cardholder and time fields in data manager2. Apply a filter to extract data based on transaction year3. Request a daily reload task from the System Admin

D : 1. Delete Cardholder and time fields in data manager2. Use a bookmark based on auto-calendar fields3. Use the reload function in the sheet Editor asset panel

Answer: D

Question 4

A developer has created an application with native objects in a way that is well organized by sheets so that users can gain their insights independently. Users have notebooks, mobile phones and tablets. When the application was created, the developer did not imagine that the application would be accessed by mobile devices, but the good news is that the application adapts very well to any format and screen size.

What's the name of this feature?

A : ociative selection model

B : ponsive design

C : er-friendly analytics

D :

Answer: B

Question 5

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