- (Topic 3)
You have the following visualization.

The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

1. A. 2
2. B. 4
3. C. 3

Correct Answer: A

- (Topic 3)
You have the following dataset that contain null values in the Profits field.

You want the data to appear as shown in the following table.

Which two formulas achieve the goal? Choose two.

1. A. ZN ([Profits])
2. B. ISNULL ([Profits])
3. C. IFNULL [(profits] ,0)
4. D. IF [Profits] != null then [Profits] END

Correct Answer: AC

HOTSPOT - (Topic 3)
You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Topic 3)
You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

1. A. Image
2. B. Sheet
3. C. Web page
4. D. Horizontal

Correct Answer: A

- (Topic 3)
You want to create the following dashboard that will contain two sheets.

What should you do?

1. A. Drag both sheets to the dashboard and add a border to each sheet.
2. B. Drag both sheets to the dashboard and add a background lo each sheet.
3. C. Add both sheets lo a horizontal container and add a border to the container.
4. D. Add a border to both sheets and add both sheets to a horizontal object.

Correct Answer: C