DRAG DROP - (Topic 3)
You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future
Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

Solution:


Does this meet the goal?

Correct Answer:A

DRAG DROP - (Topic 3)
You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned
How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Solution:


Does this meet the goal?

Correct Answer:A

HOTSPOT - (Topic 3)
You have a data source that contains the following columns.

You have the following view that shows the percentage of total sales by category:

You want to change the calculation to show the percentage of total sales within the categories of every region annually. Which Compute Using option should you use? (Click the appropriate Option in the Answer Area.)

Solution:


Does this meet the goal?

Correct Answer:A

- (Topic 3)
When a Data Analyst needs to format workbook settings, which options are available in the Format Workbook panel?

Correct Answer:A

DRAG DROP - (Topic 3)
You have a data source that contains the following columns.

You want to filter regions based on the highest sales. Users must be able to specify the number of regions shown.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area.
Use Answer Area arrows to re-order the options.)

Solution:


Does this meet the goal?

Correct Answer:A

- (Topic 3)
A Data Analyst has the following dashboard.

Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?

Correct Answer:B