Microsoft Power BI Microsoft Power BI 2

Question 1

Which Power BI component is used to author reports and connect to data on the desktop?

Accepted Answer

Power BI Desktop

Answer

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?

Accepted Answer

DAX

Answer

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?

Accepted Answer

M (Power Query Formula Language)

Answer

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?

Accepted Answer

Import

Answer

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?

Accepted Answer

Q&A

Answer

The Q&A feature interprets natural-language questions and produces visuals automatically.

Microsoft Power BI Practice Test