nerdexam
Microsoft

DP-500 · Question #113

You deploy a tabular model named DM1 to a Power BI Premium capacity. DM1 was created as an import model. You change a fact table named Table1 into a hybrid table. What else occurred on DM1…

The correct answer is D. A DirectQuery partition was added to Table1. Changing an imported fact table to a hybrid table in Power BI Premium capacity automatically adds a DirectQuery partition to that table, combining real-time and cached data access.

Implement and manage data models

Question

You deploy a tabular model named DM1 to a Power BI Premium capacity. DM1 was created as an import model. You change a fact table named Table1 into a hybrid table. What else occurred on DM1 automatically after the change?

Options

  • ATable1 was removed from the scheduled refresh.
  • BDimension tables that relate to Table1 were changed to dual storage mode.
  • CA related aggregation table was created.
  • DA DirectQuery partition was added to Table1.

How the community answered

(41 responses)
  • A
    12% (5)
  • B
    2% (1)
  • C
    7% (3)
  • D
    78% (32)

Why each option

Changing an imported fact table to a hybrid table in Power BI Premium capacity automatically adds a DirectQuery partition to that table, combining real-time and cached data access.

ATable1 was removed from the scheduled refresh.

Hybrid tables still contain import partitions that require scheduled refresh to keep the cached data up to date, so the table is not removed from scheduled refresh.

BDimension tables that relate to Table1 were changed to dual storage mode.

While dual storage mode is often used for dimension tables in composite models with hybrid tables to optimize performance, it is not an automatic change when a fact table is converted to hybrid.

CA related aggregation table was created.

Aggregation tables are manually created and configured to summarize data and improve query performance; they are not automatically generated when a table becomes hybrid.

DA DirectQuery partition was added to Table1.Correct

A hybrid table in Power BI combines both import and DirectQuery partitions, allowing for fresh data directly from the source while serving historical data from the in-memory cache; thus, when a table is configured as a hybrid, a DirectQuery partition is automatically added.

Concept tested: Power BI hybrid tables partitions

Source: https://learn.microsoft.com/en-us/power-bi/enterprise/hybrid-tables-overview

Topics

#Hybrid Tables#Power BI Premium#Data Model Optimization#DirectQuery Partitions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-500 Practice