Power BI Exam UPDATED ACTUAL Exam
Questions and CORRECT Answers
You plan to use Power BI Desktop to create a report with multiple visualizations.
You need to create a standalone chart that will be dedicated to filtering other visuals on the same
report page.
Which type of visualization should you use?
Select only one answer.
A. funnel
B. matrix
C. scatter
D. slicer - CORRECT ANSWER - D. slicer
You plan to create a Power BI workspace.
You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint
Online document library is available to workspace users once the workspace is created.
Which setting should you configure when creating the workspace?
Select only one answer.
A. Allow contributors to update the app
B. Develop a template app
D. Workspace OneDrive - CORRECT ANSWER - D. Workspace OneDrive
You are editing a Power BI Desktop report visual that displays gross sales data with the
hierarchy based on a year, quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the year.
What should you do first?
Select only one answer.
A. In the Visualization pane, remove all date hierarchy fields from the Axis well.
B. In the Visualization pane, modify the Format visual Range settings.
,C. In the Filters pane, add a filter based on the year.
D. In the Filters pane, add a filter based on the quarter, month, and day. - CORRECT
ANSWER - A. In the Visualization pane, remove all date hierarchy fields from the Axis
well.
You have designed a star schema to simplify your data.
You need to understand the relationship between the tables in the star schema.
What is the relationship between the fact tables and dimension tables?
Select only one answer.
A. one-to-many
B. many-to-one
C. one-to-one
D. many-to-many - CORRECT ANSWER - A. one-to-many
You plan to certify a Power BI dataset.
You need to identify at which level within your organization the permissions to certify a dataset
are assigned.
Which level should you identify?
Select only one answer.
A. Tenant
B. Workspace
C. Workbook
D. Dataset - CORRECT ANSWER - Select only one answer.
A. Tenant
You need to create a new hierarchy in Power BI Desktop.
What should you do first?
Select only one answer.
A. From the Report view, drag-and-drop one column onto another column in the Fields pane.
, B. From the Model view, drag-and-drop one column onto another column in the Fields pane.
C. From the Model view, right-click and select Create hierarchy.
D. From the Report view, right-click and select Create hierarchy. - CORRECT ANSWER -
C. From the Model view, right-click and select Create hierarchy.
You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety
of reports.
Which object from a report page can be pinned to the dashboard?
Select all answers that apply.
A. Slicer
B. Custom visual
C. Ribbon chart
D. Image
E. Filter - CORRECT ANSWER - B. Custom visual
C. Ribbon chart
D. Image
You need to create a histogram that will display ranges of integers in groups.
Which two resources do you need to create the histogram? Each correct answer presents part of
the solution.
Select all answers that apply.
A. a Numerical column
B. a DateTime column
C. a List group type
D. a Bin group type - CORRECT ANSWER - A. a Numerical column
C. a List group type
You have a bar chart and column chart visual on a report page. Selecting any column from the
bar chart visual filters the column chart data to less than 1% of its unfiltered value.
Questions and CORRECT Answers
You plan to use Power BI Desktop to create a report with multiple visualizations.
You need to create a standalone chart that will be dedicated to filtering other visuals on the same
report page.
Which type of visualization should you use?
Select only one answer.
A. funnel
B. matrix
C. scatter
D. slicer - CORRECT ANSWER - D. slicer
You plan to create a Power BI workspace.
You need to ensure that you will be able to configure a Microsoft 365 group whose SharePoint
Online document library is available to workspace users once the workspace is created.
Which setting should you configure when creating the workspace?
Select only one answer.
A. Allow contributors to update the app
B. Develop a template app
D. Workspace OneDrive - CORRECT ANSWER - D. Workspace OneDrive
You are editing a Power BI Desktop report visual that displays gross sales data with the
hierarchy based on a year, quarter, month, and day.
You need to prevent users from viewing the hierarchy based on the year.
What should you do first?
Select only one answer.
A. In the Visualization pane, remove all date hierarchy fields from the Axis well.
B. In the Visualization pane, modify the Format visual Range settings.
,C. In the Filters pane, add a filter based on the year.
D. In the Filters pane, add a filter based on the quarter, month, and day. - CORRECT
ANSWER - A. In the Visualization pane, remove all date hierarchy fields from the Axis
well.
You have designed a star schema to simplify your data.
You need to understand the relationship between the tables in the star schema.
What is the relationship between the fact tables and dimension tables?
Select only one answer.
A. one-to-many
B. many-to-one
C. one-to-one
D. many-to-many - CORRECT ANSWER - A. one-to-many
You plan to certify a Power BI dataset.
You need to identify at which level within your organization the permissions to certify a dataset
are assigned.
Which level should you identify?
Select only one answer.
A. Tenant
B. Workspace
C. Workbook
D. Dataset - CORRECT ANSWER - Select only one answer.
A. Tenant
You need to create a new hierarchy in Power BI Desktop.
What should you do first?
Select only one answer.
A. From the Report view, drag-and-drop one column onto another column in the Fields pane.
, B. From the Model view, drag-and-drop one column onto another column in the Fields pane.
C. From the Model view, right-click and select Create hierarchy.
D. From the Report view, right-click and select Create hierarchy. - CORRECT ANSWER -
C. From the Model view, right-click and select Create hierarchy.
You have a Power BI dashboard that is comprised of pinned visuals that are taken from a variety
of reports.
Which object from a report page can be pinned to the dashboard?
Select all answers that apply.
A. Slicer
B. Custom visual
C. Ribbon chart
D. Image
E. Filter - CORRECT ANSWER - B. Custom visual
C. Ribbon chart
D. Image
You need to create a histogram that will display ranges of integers in groups.
Which two resources do you need to create the histogram? Each correct answer presents part of
the solution.
Select all answers that apply.
A. a Numerical column
B. a DateTime column
C. a List group type
D. a Bin group type - CORRECT ANSWER - A. a Numerical column
C. a List group type
You have a bar chart and column chart visual on a report page. Selecting any column from the
bar chart visual filters the column chart data to less than 1% of its unfiltered value.
