Power BI Service 03 - Connect to Data

Which of the following data connection options is not available from the Get Data menu?

• MySQL

• My organization

• Template apps

• Files

When importing Excel data into Power BI, your file must include at least one:

• Range

• Column

• Table

• Pivot Table

Which of the following is true about the standard mode data gateway?

• Can be used by Power BI, PowerApps, and Flow

• Can be used with both Windows and Mac operating systems

• Can only be used by you

• None of the above

Which of the following can dataflows be used for?

• Store data

• Integrate data

• Transform data

• All of the above

Which of the following dataflow tools are available to Power BI Pro license types?

• Incremental Refresh

• Add New Entities

• Add Linked Entities

• ML Models

Which of the following must happen in order to build reports from a dataflow?

• Create named entities

• Apply query editor transformations

• Connect to dataflow as a dataset

• Refresh the dataflow

Which of the following sources accepts setting and configuring scheduled refresh?

• Datasets

• Dataflows

• Both types of sources accept configuring scheduled refresh

• Neither type of source accepts configuring scheduled refresh

In order to setup scheduled refresh of a dataset, the dataset must contain a:

• Column

• Data array

• Table

• Data model

After a dataflow is created, which of the following must happen before you can connect to a dataflow in Power BI Desktop?

• Dataflow must be added to a report

• Dataflow must be mapped to the Common Data Model

• Dataflow must be refreshed

• None of the above

Which of the following is commonly described as "Power Query in the cloud"?

• Gateways

• Entities

• Data Models

• Dataflows