Microsoft Power BI Microsoft Power BI 2 — Questions and Answers
Question 1: Which Power BI component is used to author reports and connect to data on the desktop?
- Power BI Desktop (Correct answer)
- Power BI Mobile
- Power BI Gateway
- Power BI Report Server admin
Correct answer: Power BI Desktop
Power BI Desktop is the free Windows application for building data models and authoring reports.
Question 2: What language is used to create calculated columns and measures in Power BI?
- DAX (Correct answer)
- MDX
- T-SQL
- Python
Correct answer: DAX
DAX (Data Analysis Expressions) is used for calculated columns, measures, and tables.
Question 3: Which engine is used in Power Query to transform and shape data?
- M (Power Query Formula Language) (Correct answer)
- DAX
- VBA
- R script only
Correct answer: M (Power Query Formula Language)
Power Query uses the M formula language to perform data transformation steps.
Question 4: What is the default storage mode that imports data into Power BI's in-memory model?
- Import (Correct answer)
- DirectQuery
- Live Connection
- Composite only
Correct answer: Import
Import mode loads data into the VertiPaq in-memory engine for fast performance.
Question 5: Which feature lets users ask questions in natural language to generate visuals?
- Q&A (Correct answer)
- Quick Insights
- Bookmarks
- Sync slicers
Correct answer: Q&A
The Q&A feature interprets natural-language questions and produces visuals automatically.
Question 6: Where do you publish a finished Power BI Desktop report for sharing?
- Power BI Service (app.powerbi.com) (Correct answer)
- OneNote
- SharePoint list
- Power Automate
Correct answer: Power BI Service (app.powerbi.com)
Reports are published to the Power BI Service cloud workspace for sharing and collaboration.
Question 7: What visual is best for showing a part-to-whole relationship of a single category?
- Pie or donut chart (Correct answer)
- Line chart
- Scatter chart
- Funnel for trends
Correct answer: Pie or donut chart
Pie and donut charts display how categories contribute to a whole.
Microsoft Power BI Microsoft Power BI 2
Which Power BI component is used to author reports and connect to data on the desktop?