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

Caching Power BI reports locally on desktop machines

Answer

Deploying Power BI reports to on-premises servers

Answer

Encrypting data in transit between Power BI and Azure

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

Writing DAX measures and calculated columns

Answer

Designing report layouts and themes

Answer

Publishing reports to the Power BI service

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

To display data in a pie chart format

Answer

To show a table of raw data

Answer

To create drill-through pages in the report

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

The dataset is updated every minute automatically

Answer

Users query the dataset directly via SQL

Answer

Power BI bypasses the gateway for faster 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

A standalone Power BI Desktop installation

Answer

A mobile app for viewing Power BI on phones

Answer

A custom visual downloaded from AppSource

Question 6

In Power BI, what is 'drill-through'?

Accepted Answer

A navigation technique allowing users to right-click a data point and jump to a detail page filtered by that value

Answer

Expanding a visual to see all data rows

Answer

Zooming into a time-series chart for a smaller date range

Answer

Clicking through a hierarchy in a matrix visual