Power BI 778 Power BI Service and Collaboration 2 — Questions and Answers
Question 1: What is a 'dataflow' in Power BI?
- A real-time data stream from IoT devices
- A reusable set of Power Query transformations stored in the Power BI Service (Correct answer)
- A data pipeline from Azure Data Factory
- A data export workflow to SharePoint
Correct answer: A reusable set of Power Query transformations stored in the Power BI Service
Dataflows store reusable Power Query ETL logic in the cloud, allowing multiple datasets and reports to share the same transformation logic.
Question 2: What is the purpose of 'Scheduled Refresh' in Power BI Service?
- Automatically re-renders visuals every hour
- Automatically updates an imported dataset by re-running the data load from the source on a schedule (Correct answer)
- Refreshes the browser page on a timer
- Re-publishes the report file daily
Correct answer: Automatically updates an imported dataset by re-running the data load from the source on a schedule
Scheduled Refresh keeps imported datasets up to date by automatically pulling fresh data from the source at specified intervals.
Question 3: What is required to enable Scheduled Refresh for an on-premises data source in Power BI?
- A Power BI Premium license
- An on-premises data gateway (Correct answer)
- A direct VPN connection to the server
- A service principal with admin rights
Correct answer: An on-premises data gateway
An on-premises data gateway acts as a secure bridge between Power BI Service in the cloud and on-premises data sources.
Question 4: Which Power BI Service feature allows users to subscribe to a report page and receive it via email on a schedule?
- Data alerts
- Email subscriptions (Correct answer)
- Scheduled export
- Push reports
Correct answer: Email subscriptions
Email subscriptions in Power BI Service send a snapshot of a report page or dashboard to subscribers on a defined schedule.
Question 5: What is a 'certified' dataset in Power BI?
- A dataset that has been encrypted by Microsoft
- A dataset that has been reviewed and endorsed by a designated authority as a trusted data source (Correct answer)
- A dataset with a valid SSL certificate
- A dataset connected to a government-certified source
Correct answer: A dataset that has been reviewed and endorsed by a designated authority as a trusted data source
Certified datasets have been vetted and promoted by a Power BI admin or authorized user as a reliable, authoritative data source.
Question 6: What is the Power BI REST API used for?
- Writing DAX queries from outside Power BI
- Programmatically managing Power BI resources like workspaces, datasets, and reports (Correct answer)
- Connecting Power BI to REST-based data sources only
- Exporting reports as REST-compliant formats
Correct answer: Programmatically managing Power BI resources like workspaces, datasets, and reports
The Power BI REST API allows developers to automate and manage Power BI assets including embedding, refreshing datasets, and managing workspaces.
Power BI 778 Power BI Service and Collaboration 2
What is a 'dataflow' in Power BI?