Microsoft Power Platform Fundamentals Power BI 1 — Questions and Answers
Question 1: What is the primary purpose of Power BI Desktop?
- To host and share reports online
- To create and publish reports and dashboards (Correct answer)
- To manage user permissions for datasets
- To write DAX scripts for Azure
Correct answer: To create and publish reports and dashboards
Power BI Desktop is used to create reports and data models that can then be published to the Power BI service.
Question 2: Which Power BI component allows users to view and interact with reports in a browser?
- Power BI Desktop
- Power BI Mobile
- Power BI Service (Correct answer)
- Power BI Gateway
Correct answer: Power BI Service
The Power BI Service (app.powerbi.com) is the cloud-based platform where reports and dashboards are shared and consumed in a browser.
Question 3: What does DAX stand for in the context of Power BI?
- Data Analysis Expressions (Correct answer)
- Dynamic Aggregation Extensions
- Dashboard Analytics XML
- Data Access eXchange
Correct answer: Data Analysis Expressions
DAX (Data Analysis Expressions) is the formula language used in Power BI to create calculated columns, measures, and tables.
Question 4: Which of the following is a valid use case for Power BI Dataflows?
- Building chatbot conversation flows
- Reusing ETL logic across multiple Power BI datasets (Correct answer)
- Managing row-level security policies
- Scheduling email alerts for KPI thresholds
Correct answer: Reusing ETL logic across multiple Power BI datasets
Power BI Dataflows allow organizations to define reusable data preparation logic (ETL) that multiple datasets can consume.
Question 5: What is a Power BI dataset?
- A collection of visuals arranged on a single page
- A curated connection to one or more data sources with a defined data model (Correct answer)
- A scheduled export of report data to Excel
- A shared folder containing .pbix files
Correct answer: A curated connection to one or more data sources with a defined data model
A Power BI dataset is a data model containing connections, relationships, and measures that reports can be built on top of.
Question 6: Which Power BI feature enables a report consumer to ask questions about data using plain English?
- Power Query Editor
- Q&A visual (Correct answer)
- Decomposition tree
- Smart narrative
Correct answer: Q&A visual
The Q&A visual lets users type natural language questions (e.g., 'total sales by region') and automatically generates a matching visualization.
Microsoft Power Platform Fundamentals Power BI 1
What is the primary purpose of Power BI Desktop?