- (Topic 3)
You have the following dashboard that contains two sheets.

You want to minimize the whitespace between the sheets.
What should you configure?

1. A. The background
2. B. The position
3. C. The padding
4. D. The size
5. E. The border

Correct Answer: C

- (Topic 3)
A Data Analyst has a data source that contains the following columns:

he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?

1. A. Drag the LOD expression to the Filters shelf.
2. B. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
3. C. Right-click the State dimension filter, and then click Attribute.
4. D. Right-click the State dimension filter, and then click Add to Context.

Correct Answer: D

- (Topic 3)
Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?

1. A. RUNNING_AVG
2. B. INCLUDE
3. C. AVG
4. D. EXCLUDE

Correct Answer: D

- (Topic 3)
A Data Analyst at a coffee company has the following visualization already built.

The analyst wants to make this more visually appealing by coloring the bars based on whether they are above or below the Average Sales within each Product Type.
Which calculation should the analyst use to calculate the Average Sales for each Product Type?

1. A. ( FIXED [Product] : AVG( (FIXED [Product Type] : AVG( [Sales] ) ) )
2. B. { EXCLUDE [Product] : SUM( [Sales] ) }
3. C. { FIXED [Product Type] : AVG( [Sales] ) }
4. D. : FIXED ([Product Type]) : AVG( [ FIXED [Product] : SUM( [Sales] ) ] )

Correct Answer: D

- (Topic 3)
You have the following table.

You need each record to alternate between grey and white. What should you change in the Format Shading pane?

1. A. the row banding size to 1
2. B. the column banding size to 1
3. C. the row banding size to 3
4. D. the column banding size to 3

Correct Answer: A