Microsoft Power BI Data Analyst — Question 70

You have a Power BI semantic model that contains a table named Table1. Table1 runs in Import storage mode.

You need to update the model to change the storage mode of Table1 to DirectQuery.

What should you do?

Answer options

• A. Delete Table1, and then add the table to the model again in DirectQuery storage mode.
• B. From Power Query Editor, duplicate the query for Table1.
• C. From Model view, change the storage mode of Table1 to DirectQuery.
• D. Add an aggregation table to the model.

Correct answer: A

Explanation

The correct answer is A because changing the storage mode of an existing table directly is not possible; you must delete and re-add it in the desired storage mode. Option B does not achieve the goal as duplicating the query does not change the storage mode. Option C is incorrect because the storage mode cannot be modified in that manner. Option D is unrelated to changing the storage mode of Table1.