Power BI 778 Performance Optimization and Troubleshooting

Question 1

Which Power BI storage mode loads all data into the in-memory VertiPaq engine for the fastest query performance?

Accepted Answer

Import

Answer

DirectQuery

Answer

Live Connection

Answer

Composite

Question 2

Which built-in Power BI Desktop tool records and displays the rendering time for each visual on a report page?

Accepted Answer

Performance Analyzer

Answer

Query Diagnostics

Answer

DAX Studio

Answer

Data Profiler

Question 3

What Power BI feature partitions historical data and refreshes only the most recent portion, reducing refresh duration for large datasets?

Accepted Answer

Incremental refresh

Answer

Scheduled refresh

Answer

Dataflows

Answer

Composite model

Question 4

What is 'query folding' in Power Query?

Accepted Answer

Pushing transformation steps back to the data source to execute natively

Answer

Combining multiple queries into a single query step

Answer

Folding a Power Query expression into a DAX measure

Answer

Merging results from two different data sources

Question 5

What is a common performance drawback of excessive bidirectional cross-filtering in a Power BI data model?

Accepted Answer

It can create ambiguous filter paths, leading to slower queries and unexpected results

Answer

It reduces the number of available DAX functions

Answer

It prevents the use of calculated columns

Answer

It forces all tables into DirectQuery mode

Question 6

Which column characteristic allows the VertiPaq engine to achieve the highest compression ratio?

Accepted Answer

Low-cardinality integer columns

Answer

High-cardinality text columns

Answer

DateTime columns with millisecond precision

Answer

Decimal columns with many unique values

Question 7

Which Power BI storage mode allows some tables to use Import while others use DirectQuery within the same dataset?

Accepted Answer

Composite model

Answer

Dual mode

Answer

Live Connection

Answer

Push dataset