Microsoft Power BI Power BI Service and Collaboration 2 — Questions and Answers
Question 1: What is a 'Dataflow' in Power BI Service?
- A real-time data streaming pipeline
- A cloud-based ETL feature that uses Power Query to prepare reusable datasets stored in Azure Data Lake (Correct answer)
- A scheduled refresh mechanism for reports
- A connector that links Power BI to Azure Data Factory
Correct answer: A cloud-based ETL feature that uses Power Query to prepare reusable datasets stored in Azure Data Lake
Dataflows are cloud-based Power Query transformations that create reusable, refreshable entity tables stored in Azure Data Lake Storage, shareable across multiple datasets.
Question 2: What is an 'On-premises data gateway' used for in Power BI?
- A firewall to protect Power BI dashboards
- A bridge that enables Power BI Service to connect to on-premises data sources for scheduled refresh or DirectQuery (Correct answer)
- A local server for hosting Power BI reports
- A VPN for Power BI mobile access
Correct answer: A bridge that enables Power BI Service to connect to on-premises data sources for scheduled refresh or DirectQuery
The On-premises data gateway acts as a secure bridge between Power BI Service in the cloud and data sources located in on-premises or private network environments.
Question 3: What is 'Scheduled Refresh' in Power BI Service?
- A feature that refreshes the browser tab automatically
- An automated data refresh of an imported dataset at configured times without manual intervention (Correct answer)
- A real-time streaming refresh for DirectQuery datasets
- A nightly backup of all .pbix files
Correct answer: An automated data refresh of an imported dataset at configured times without manual intervention
Scheduled Refresh automatically updates an imported dataset's data at configured times (up to 8 times/day on Pro, 48 times/day on Premium) by re-running the data load pipeline.
Question 4: What is the maximum number of times a Power BI Pro dataset can be scheduled to refresh per day?
- 4 times
- 8 times (Correct answer)
- 24 times
- 48 times
Correct answer: 8 times
Power BI Pro datasets support up to 8 scheduled refreshes per day; Power BI Premium supports up to 48 scheduled refreshes per day.
Question 5: What does 'Sensitivity Labels' in Power BI Service help with?
- Adding visual labels to chart axes
- Classifying and protecting Power BI content based on Microsoft Information Protection sensitivity labels (Correct answer)
- Labeling datasets with their data source type
- Adding watermarks to exported reports
Correct answer: Classifying and protecting Power BI content based on Microsoft Information Protection sensitivity labels
Sensitivity Labels in Power BI integrate with Microsoft Information Protection to classify content (e.g., Confidential, Public) and apply protection policies like encryption when exported.
Question 6: What is 'Incremental Refresh' in Power BI and what is its main benefit?
- A refresh that only updates changed rows, reducing refresh time and resource use for large datasets (Correct answer)
- A feature that refreshes one visual at a time
- A refresh limited to the last 7 days of data
- A manually triggered partial refresh of selected tables
Correct answer: A refresh that only updates changed rows, reducing refresh time and resource use for large datasets
Incremental Refresh divides a table into historical (frozen) and recent (refreshed) partitions, so only new or changed data is refreshed, dramatically reducing refresh times for large datasets.
Microsoft Power BI Power BI Service and Collaboration 2
What is a 'Dataflow' in Power BI Service?