QUESTION: 17

DRAG DROP (Drag and Drop is not supported)
You publish a dataset that contains data from an on-premises Microsoft SQL Server database.
The dataset must be refreshed daily.
You need to ensure that the Power BI service can connect to the database and refresh the dataset.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 18

You attempt to connect Power BI Desktop to a Cassandra database.
From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.
You need to select an alternate data connector that will connect to the database.
Which type of connector should you choose?

Microsoft SQL Server database
ODBC
OLE DB
OData

Answer(s): B

Reveal Solution Next Question

QUESTION: 19

DRAG DROP (Drag and Drop is not supported)
You receive annual sales data that must be included in Power BI reports.
From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.
You need to create a report that meets the following requirements:
• Visualizes the Sales value over a period of years and months
• Adds a slicer for the month
• Adds a slicer for the year
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

See Explanation section for answer.

Answer(s): A

Explanation:

Reveal Solution Next Question

QUESTION: 20

HOTSPOT (Drag and Drop is not supported)
You are using Power BI Desktop to connect to an Azure SQL database.
The connection is configured as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct solution is worth one point.