Question 1

A sales department has a pie chart that displays the total amount os sales by city.
Users have requested several changes to the pie chart:
• Display the labels in 'Red';
• Increase the font size of the title;
• Change the color of the values to 'Blue'.
Which technique should a business analyst use to meet these requirements?

Options :

A : Use single configurator

B : Change chart properties

C : Develop a widget

D : Create a custom theme

Answer: D

Question 2

A business analyst is creating an app for the sales department

Users of the app most be able to create sheets and analyze data The sales department has several additional requirements

* Reuse the global sales visualization

* Create new visualizations

* The app has over 100 visualizations

Users will NOT have access to the full data model

What should be added to the master items to meet the requirement?

Options :

A :

* All fields as dimensions and measures

* All visualizations

B :

* All fields as dimensions and measures

* Selected visualizations

C :

* Seated fields as dimensions and measures

* Selected visualizations

D :

* Selected fields as dimensions and measures

* All visualizations

Answer: A

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?

Options :

A :

1. Deselect Cardholder and time field in data manager

2. Use a pant based on auto-calendar fields

3. Perform a daily reload via the data manager

B :

1. Delete Cardholder and time fields in data manager

2. Use set analysis to show data based on transaction year

3. Use an API to perform a daily reload task

C :

1. Deselect Cardholder and time fields in data manager

2. Apply a filter to extract data based on transaction year

3. Request a daily reload task from the System Admin

D :

1. Delete Cardholder and time fields in data manager

2. Use a bookmark based on auto-calendar fields

3. Use the reload function in the sheet Editor asset panel

Answer: C

Question 4

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?

Options :

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

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

C : In 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 : Create 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 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

Options :

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 QSBA2022 Mock Exam – Practice Online Confidently

Buying Options: