Question 1

A business analyst has data for these fields • Year • Sales Amount • Product Number • Country • Order Number Which three KPIs may be calculated? (Select three.)

Options :

A : Average Sales Per Year

B : Total Sales by Country

C : Total Sales by Customer

D : Average Order Sales Amount

E : Total Customer Count by Country

Answer: A,D,E

Question 2

Refer to the exhibit.

A business analyst creates a water fall chart to understand how an initial value is affected by a series of intermediate positive and negative values. Which two actions must a business analyst perform to create the water fall chart shown? (Select two )

Options :

A : Add five dimensions*

B : Add five measures

C : Check "Show as water fall" on the Style tab of the bar chart properties

D : On the dimension limit properties sheet set limit to only show the first five values

E : Use the Bar Offset property with the correct expression

Answer: C,E

Question 3

A business analyst needs to calculate the average order value by country. Which two objects meet this requirement? (Select two.)

Options :

A : List box

B : Multi box

C : Table box

D : Statistics box

E : Straight table

Answer: B,C

Question 4

A business analyst needs to analyze average sales by product number and country by year. Which measure(s) should the business analyst use?

Options :

A : Year

B : Average Sales

C : Average Sales and Year

D : Product Number and Average Sales

Answer: D

Question 5

Refer to the exhibit.

The Sales table shown represents the entire data set A business analyst adds an expression in a document:

Next, the analyst selects Year = '2010' and RegionID = '2\. What is the result of the expression with these selections?

Options :

A : 250

B : 750

C : 850

D : 650

Answer: C

Free QV12BA Mock Exam – Practice Online Confidently

Buying Options: