Microsoft Certified: Power Platform App Maker Associate Power BI Integration and Data Visualization 2

Question 1

What is the Power BI 'On-premises data gateway' used for?

Accepted Answer

Connecting Power BI service to data sources that are behind a corporate firewall or on-premises servers

Answer

The on-premises data gateway acts as a secure bridge that allows Power BI service (cloud) to query on-premises data sources like SQL Server or Oracle databases.

Question 2

In Power BI Desktop, what is 'Power Query' used for?

Accepted Answer

Connecting to, transforming, and loading data from multiple sources into the data model before building visuals

Answer

Power Query (the Get Data / Transform Data experience) provides an M-language-based ETL environment for shaping and combining data before it enters the report's data model.

Question 3

What is the purpose of a 'slicer' visual in Power BI?

Accepted Answer

To filter other visuals on the report page based on a selected value or range

Answer

Slicers are interactive filter controls placed on the report canvas that let users select values to filter all connected visuals on the page or across pages.

Question 4

In Power BI, what does 'DirectQuery' mode mean for a dataset?

Accepted Answer

Power BI queries the source database directly at report load time rather than importing data into the model

Answer

In DirectQuery mode, Power BI sends queries to the underlying data source each time a visual is rendered, ensuring up-to-date data but relying on source performance.

Question 5

What is a Power BI 'app' (App workspace app)?

Accepted Answer

A packaged collection of dashboards and reports published from a workspace for broader distribution to end users

Answer

Power BI apps bundle selected reports and dashboards from a workspace into a polished, version-controlled package that can be distributed to large audiences without giving access to the workspace itself.

Microsoft Certified: Power Platform App Maker Associate Practice Test

Microsoft Certified: Power Platform App Maker Associate Practice Test

Microsoft Certified: Power Platform App Maker Associate Power BI Integration and Data Visualization 2