Microsoft Certified: Power Platform App Maker Associate Power BI Integration and Data Visualization 2 — Questions and Answers
Question 1: What is the Power BI 'On-premises data gateway' used for?
- Connecting Power BI service to data sources that are behind a corporate firewall or on-premises servers (Correct answer)
- Caching Power BI reports locally on desktop machines
- Deploying Power BI reports to on-premises servers
- Encrypting data in transit between Power BI and Azure
Correct answer: Connecting Power BI service to data sources that are behind a corporate firewall or on-premises servers
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?
- Connecting to, transforming, and loading data from multiple sources into the data model before building visuals (Correct answer)
- Writing DAX measures and calculated columns
- Designing report layouts and themes
- Publishing reports to the Power BI service
Correct answer: Connecting to, transforming, and loading data from multiple sources into the data model before building visuals
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?
- To filter other visuals on the report page based on a selected value or range (Correct answer)
- To display data in a pie chart format
- To show a table of raw data
- To create drill-through pages in the report
Correct answer: To filter other visuals on the report page based on a selected value or range
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?
- Power BI queries the source database directly at report load time rather than importing data into the model (Correct answer)
- The dataset is updated every minute automatically
- Users query the dataset directly via SQL
- Power BI bypasses the gateway for faster performance
Correct answer: Power BI queries the source database directly at report load time rather than importing data into the model
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)?
- A packaged collection of dashboards and reports published from a workspace for broader distribution to end users (Correct answer)
- A standalone Power BI Desktop installation
- A mobile app for viewing Power BI on phones
- A custom visual downloaded from AppSource
Correct answer: A packaged collection of dashboards and reports published from a workspace for broader distribution to end users
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.
Question 6: In Power BI, what is 'drill-through'?
- A navigation technique allowing users to right-click a data point and jump to a detail page filtered by that value (Correct answer)
- Expanding a visual to see all data rows
- Zooming into a time-series chart for a smaller date range
- Clicking through a hierarchy in a matrix visual
Correct answer: A navigation technique allowing users to right-click a data point and jump to a detail page filtered by that value
Drill-through lets report designers create a target page that receives filter context from a selected value, allowing users to jump to a detailed view of a specific item.
Microsoft Certified: Power Platform App Maker Associate Power BI Integration and Data Visualization 2
What is the Power BI 'On-premises data gateway' used for?