Question 1

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

Question 2

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 3

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.)

Options :

A :

Line Geometry

Margin%

B :

Product Category

Location

C :

Sales

Total Cost

D :

Product Category

Retail Store Location

Factory Location

E : Line Geometry

Answer: A,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 share a link to a specific visualization with colleagues

Which steps should the business analyst use?

Options :

A :

1. Go to the OMC and select App Object

2. Right-click the correct visualization to get the URL

3. Share the URL with colleagues

B :

1. Go to the Dev Hub and select Single Configurator

2. Select Add data

3. Copy the URL from the browser and share with colleagues

C :

1. Right-click the visualization and select Share

2. Select </> Embed

3. Copy the URL and share with colleagues

D :

1. Right-click the visualization and select View data

2. Select Export data

3. Share the provided link with colleagues

Answer: A

Free QSBA2022 Mock Exam – Practice Online Confidently

Buying Options: