Power BI & Data Visualization

Which Microsoft Windows application lets an analyst import data from a wide range of sources, build a data model, and create reports with interactive visualizations?

• APower BI service
• BPower BI phone app
• CPower BI Desktop✓
• DFabric Data Factory

Answer: Power BI Desktop is the Windows application where a typical workflow starts, letting analysts import data, build an analytics data model, and create interactive reports. The Power BI service is instead the cloud service where finished reports are published, scheduled, and shared. The Power BI phone app is for consuming reports on mobile devices, and Fabric Data Factory builds ingestion pipelines rather than reports.

In a Power BI semantic model, what does a measure represent?

• AA level within an attribute hierarchy used to drill down
• BAn entity used to aggregate or group data, such as product or customer
• CA live connection to Delta tables stored in OneLake
• DA numeric value being analyzed or reported, such as revenue or quantity✓

Answer: A measure is a numeric value you want to analyze or report on, such as sales revenue or quantity, and is defined within a semantic model. An entity used to aggregate or group by, such as product or customer, describes a dimension instead. A level used to drill down through aggregated values describes part of an attribute hierarchy, and a live connection to Delta tables in OneLake describes Direct Lake mode, not a measure.

Which Power BI engine stores semantic model data in an efficient in-memory columnar store and computes aggregations at query time?

• ADirect Lake mode
• BThe Power Query engine
• CThe DAX formula engine
• DThe VertiPaq engine✓

Answer: The VertiPaq engine stores semantic model data in an efficient in-memory columnar store, computing aggregations at query time rather than pre-calculating them. Direct Lake is a storage mode for reading OneLake files directly, not the in-memory engine itself. The DAX formula engine evaluates the calculations defined by DAX expressions, and Power Query is the tool used to import and transform data, not the storage engine.

Which type of chart is described as a good way to visually compare numeric values for discrete categories?

• AScatter plots
• BPie charts
• CLine charts
• DBar and column charts✓

Answer: Bar and column charts are described as a good way to visually compare numeric values across discrete categories. Line charts instead suit examining trends, often over time, rather than comparing discrete categories directly. Scatter plots are used to compare two numeric measures and identify a relationship between them, and pie charts compare categorized values as proportions of a total rather than as discrete comparisons.

A report author wants an AI-powered visual that identifies which factors most strongly drive a selected metric, displaying the results as an interactive visual. Which Power BI feature should they use?

• ADecomposition tree
• BSmart narrative
• CQ&A visual
• DKey influencers✓

Answer: Key influencers is the AI-powered feature that identifies which factors most strongly drive a selected metric, presenting the results as an interactive visual. A smart narrative instead automatically generates a written summary describing what a visualization shows. The Q&A visual lets users ask plain-English questions and receive chart answers, and a decomposition tree enables interactive drill-down across dimensions rather than ranking driving factors.

Which Power BI capability requires Fabric capacity of F2 or higher, or Power BI Premium P1 or higher, to generate DAX measures from a natural-language description?

• ACopilot in Power BI✓
• BThe VertiPaq engine
• CSmart narrative visual
• DThe Q&A feature

Answer: Copilot in Power BI requires Fabric capacity of F2 or higher, or Power BI Premium P1 or higher, and can generate DAX measure expressions from a natural-language description. The Q&A feature instead lets users type plain English questions and receive chart responses without that capacity requirement being specified. The smart narrative visual automatically generates a text summary of report data, and the VertiPaq engine is the in-memory storage engine, not an AI feature.