Power BI Exam - Module 3 -
Model data with Power BI
questions 2025-
2026(updated & already
graded A+)
In a Power BI Desktop model design, which type of object
do you create to connect multiple tables?\
a. Relationship
b. Column
c. Measure - answer a
Which of the following statements is correct regarding a
star schema design?
a. Fact tables store accumulations of business events.
b. Fact tables store accumulations of business entities.
c. Fact tables must have a unique column. - answer a
In what order does an analytic query implement its
phases?
a. Filter, Group, Summarize
, b. Group, Filter, Summarize
c. Summarize, Filter, Group - answer a
Geoffrey is a data modeler at Adventure Works who
developed a DirectQuery model that connects to the data
warehouse. To improve the query performance of higher-
grain sales queries, Geoffrey added an import aggregation
table. What else should Geoffrey do to improve query
performance of the higher-grain queries?
a. Set related dimension tables as aggregation tables.
b. Set related dimension tables to dual storage mode.
c. Set related dimension tables to import storage mode. -
answer b
Breana is a data modeler at Adventure Works who
developed a manufacturing model, which is an import
model. Breana needs to ensure that manufacturing
reports deliver real-time results. Which type of table
should Breana create?
a. Aggregation table.
b. Hybrid table.
c. Partitioned table. - answer b
Mousef is a business analyst at Adventure Works who
wants to create a new model by extending the sales
dataset, which is delivered by IT. Mousef wants to add a
new table of census population data sourced from a web
page. Which model framework should Mousef use?
Model data with Power BI
questions 2025-
2026(updated & already
graded A+)
In a Power BI Desktop model design, which type of object
do you create to connect multiple tables?\
a. Relationship
b. Column
c. Measure - answer a
Which of the following statements is correct regarding a
star schema design?
a. Fact tables store accumulations of business events.
b. Fact tables store accumulations of business entities.
c. Fact tables must have a unique column. - answer a
In what order does an analytic query implement its
phases?
a. Filter, Group, Summarize
, b. Group, Filter, Summarize
c. Summarize, Filter, Group - answer a
Geoffrey is a data modeler at Adventure Works who
developed a DirectQuery model that connects to the data
warehouse. To improve the query performance of higher-
grain sales queries, Geoffrey added an import aggregation
table. What else should Geoffrey do to improve query
performance of the higher-grain queries?
a. Set related dimension tables as aggregation tables.
b. Set related dimension tables to dual storage mode.
c. Set related dimension tables to import storage mode. -
answer b
Breana is a data modeler at Adventure Works who
developed a manufacturing model, which is an import
model. Breana needs to ensure that manufacturing
reports deliver real-time results. Which type of table
should Breana create?
a. Aggregation table.
b. Hybrid table.
c. Partitioned table. - answer b
Mousef is a business analyst at Adventure Works who
wants to create a new model by extending the sales
dataset, which is delivered by IT. Mousef wants to add a
new table of census population data sourced from a web
page. Which model framework should Mousef use?
