Designing and Implementing Enterprise-Scale Analytics Using Microsoft Azure and Power BI — Question 152

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?

Answer options

• A. Table1 was removed from the scheduled refresh.
• B. Dimension tables that relate to Table1 were changed to dual storage mode.
• C. A related aggregation table was created.
• D. A DirectQuery partition was added to Table1.

Correct answer: D

Explanation

When Table1 is changed to a hybrid table, a DirectQuery partition is automatically created for it, allowing for real-time data access. Options A and B are incorrect because changing to hybrid does not remove scheduled refresh or alter dimension tables. Option C is also incorrect as no aggregation table is created just from this change.