Question 1

A business analyst s creating an app for the sales team. The app must meet several requirements

* Compare 10 top -performing sales representatives and the amount of sales for each

* Investigate margin percentage and total sales by each product category

* View distribution of sales amount

Which visualizations should be used for this app?

Options :

A : A treemap box plot, and histogram

B : A bar chart, line chart, and scatter plot

C : A treemap container and distribution plot

D : A bar chart scatter plot and histogram

Answer: A

Question 2

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 3

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?

Options :

A : Associative selection model

B : Responsive design

C : User-friendly analytics

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

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 5

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?

Options :

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

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

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

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

Answer: C

Higher Test Marks with Free Online QSBA2022 Exam Practice

Buying Options: