Question 1

A business analyst is working with retail data for consumer products. The customer is interested in the

following:

• Ability to look for outliers on sales volume and margin %

• Ability to understand the clustering of products visually

• Ability to see products that are above the median sales volume

Which action should the business analyst take to implement these requirements?

Options :

A :

Create a pivot table and color the sales volume cell using K-Means function and median sales volume as an additional column

B :

Create a treemap visualization showing sales volume and margin% by product with the median sales volume in the title

C :

Create a combo chart with K-Means colors for the bar and a line measure representing median sales volume

D : Create a scatter plot using K-Means to color the products and add a median sales volume reference line

Answer: D

Question 2

A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of data. The requirements include: • Users need to drill down to various details within the available data set.• Several final measures will be repeatedly used. These final measures require combining several fields in asingle table.• User experience and load time is a high priority.Which action should the business analyst take to meet these requirements?

Options :

A : Aggregate the data to the source period

B : Develop a master item using the required source fields

C : Combine the various source fields in a calculated item in the Data manager

D : Combine the source fields and create additional fields in Excel

Answer: B

Question 3

A business analyst must add a list of temporary employees (interns) to the current sales app. The app contains

an existing employees table. When the business analyst profiles the data, the association view displays

possible associations as shown.

Which action should the business analyst take in Data manager to meet the requirements?

Options :

A : Create a concatenated key to associate the Employees and InternEmp tables

B : Concatenate the InternEmp table to the Employees tables within Data manager

C : Force an association between the InternEmp and the Orders tables

D : Create an association between the EmpID and EmployeelD fields

Answer: D

Question 4

The sales manager is investigating the relationship between Sales and Margin to determine if this relationship

is linear when choosing the dimension Customer or Product Category.

The sales manager wants to have the potential percentage Sales for each Stage (Initial to Won) of the sales

process.

Which visualizations will meet these requirements?

Options :

A :

Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

B :

Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales

C :

Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales

D :

Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

Answer: B

Question 5

The sales manager is investigating the relationship between Sales and Margin to determine if this relationshipis linear when choosing the dimension Customer or Product Category.The sales manager wants to have the potential percentage Sales for each Stage (Initial to Won) of the salesprocess.Which visualizations will meet these requirements?

Options :

A : Scatter plot: Measures X-axis Sales and Y-axis Margin, Dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

B : Scatter plot: Measures X-axis Sales and Y-axis Margin, Alternative dimensions Customer or Product category Funnel chart: Segments Stage, Width Sales

C : Combo chart: Measures Sales and Margin, Dimensions Customer or Product category Pie chart: Dimension Stage, Measure Sales

D : Distribution plot: Alternative measures Sales and Margin, Alternatives dimensions Customer or Product category Bar chart: Dimension Stage, Measure Sales

Answer: B

Free QSBA2024 Mock Exam – Practice Online Confidently

Buying Options: