Publishing, Automation & Governance

In the Power BI deployment architecture, what is the “Workspace Layer”?

The PBIX file containing the data model and report visuals.

Correct Incorrect Correct answer

The cloud environment (e.g., "Sales Intelligence Workspace") where datasets and reports are hosted.

Correct Incorrect Correct answer

The curated collection of reports presented to end-users (e.g., "Sales Analytics App").

Correct Incorrect Correct answer

The underlying source data files (e.g., Excel, SQL Database).

Correct Incorrect Correct answer

You need to grant a colleague the ability to view reports in your workspace but not edit or share them. Which workspace role should you assign?

Viewer

Correct Incorrect Correct answer

Member

Correct Incorrect Correct answer

Contributor

Correct Incorrect Correct answer

Admin

Correct Incorrect Correct answer

You have finalized your report in Power BI Desktop (CDIP-BP_Module5_YourName.pbix). What is the standard procedure to upload it to your CDIP-BP Workspace in the Power BI Service?

In Power BI Service, click Upload > Browse and select the PBIX file.

Correct Incorrect Correct answer

In Power BI Desktop, go to Home > Publish, sign in, and select the target Workspace.

Correct Incorrect Correct answer

In Power BI Desktop, go to File > Export > Power BI template.

Correct Incorrect Correct answer

In Power BI Desktop, click File > Save As and choose a cloud location.

Correct Incorrect Correct answer

Immediately after publishing your report to the Power BI Service, what is a crucial first validation step?

Check that the PBIX file size is below 1GB.

Correct Incorrect Correct answer

Open the report in the Power BI Service and verify that all visuals render correctly and slicers are interactive.

Correct Incorrect Correct answer

Ensure the data gateway is installed on your local machine.

Correct Incorrect Correct answer

Confirm that the DAX measures are correctly formatted in Power BI Desktop.

Correct Incorrect Correct answer

You need to configure your published dataset to automatically refresh every morning at 6:00 AM. Where in the Power BI Service do you configure this “Scheduled Refresh”?

In Power BI Desktop, under File > Options > Data Load.

Correct Incorrect Correct answer

In the Power Query Editor settings.

Correct Incorrect Correct answer

In the Power BI Service, navigate to the Dataset settings page.

Correct Incorrect Correct answer

In the Workspace settings page.

Correct Incorrect Correct answer

Your Power BI report sources data directly from an Excel file stored on your company’s internal network drive (not OneDrive/SharePoint). To enable scheduled refresh in the Power BI Service, what additional component is typically required?

To compress the PBIX file before publishing.

Correct Incorrect Correct answer

To allow the Power BI Service (cloud) to securely connect to data sources located on-premises (e.g., a local SQL Server or file share).

Correct Incorrect Correct answer

To manage user licenses and permissions within the Power BI tenant.

Correct Incorrect Correct answer

To create custom visuals for Power BI reports.

Correct Incorrect Correct answer

How can you ensure that you (or your IT team) are automatically notified via email if a scheduled dataset refresh fails?

Configure Data Alerts on dashboard tiles.

Correct Incorrect Correct answer

In the Scheduled Refresh settings for the dataset, add email addresses to the notification list.

Correct Incorrect Correct answer

Set up a Power Automate flow to monitor the refresh status.

Correct Incorrect Correct answer

Check the Power BI Audit Log in the M365 Compliance Center.

Correct Incorrect Correct answer

Which of the following tasks is a typical use case for integrating Power BI with Power Automate (Flow)?

Creating complex DAX measures.

Correct Incorrect Correct answer

Designing the visual layout of the Power BI report.

Correct Incorrect Correct answer

Automatically exporting a Power BI report page as a PDF and emailing it on a schedule.

Correct Incorrect Correct answer

Managing relationships between tables in the data model.

Correct Incorrect Correct answer

For the example flow “Automated Report Distribution” (emailing a PDF summary every Monday morning), what is the initiating Trigger in Power Automate?

When a new row is added to the FactSales table.

Correct Incorrect Correct answer

On a defined schedule (e.g., Recurrence trigger set to every Monday at 8:00 AM).

Correct Incorrect Correct answer

When a user clicks a button within the Power BI report.

Correct Incorrect Correct answer

When a specific DAX measure crosses a threshold.

Correct Incorrect Correct answer

Within the Power Automate flow that distributes the report, which specific Power BI Action is used to generate the PDF export?

"Get data from Power BI dataset"

Correct Incorrect Correct answer

"Export To File for Power BI Reports"

Correct Incorrect Correct answer

"Refresh a dataset"

Correct Incorrect Correct answer

"Send email (Outlook)"

Correct Incorrect Correct answer

You are tasked with creating the Governance Register for your published reports. What key information should this register contain for each report?

The DAX formulas for all measures.

Correct Incorrect Correct answer

Report Name, Owner, Dataset Source, Refresh Frequency, Access Level, Compliance Status.

Correct Incorrect Correct answer

A list of all visuals used in the report.

Correct Incorrect Correct answer

The Power Query M code for the ETL process.

Correct Incorrect Correct answer

What is the primary benefit of using the “Lineage View” in the Power BI Service for governance?

To track user access and report views over time.

Correct Incorrect Correct answer

To visually trace the flow of data from the source, through datasets and dataflows, to reports and dashboards.

Correct Incorrect Correct answer

To compare different versions of the same Power BI report.

Correct Incorrect Correct answer

To manage workspace roles and permissions.

Correct Incorrect Correct answer

How should you manage “Version Control” for your Power BI reports according to the recommended strategy?

Rely on Power BI Service's automatic version history.

Correct Incorrect Correct answer

Save copies of the PBIX file with clear version numbers (e.g., Report_v1.0.pbix, Report_v1.1.pbix) and maintain a separate Version Log sheet.

Correct Incorrect Correct answer

Only keep the latest version of the PBIX file.

Correct Incorrect Correct answer

Use GitHub or a similar code repository to store the PBIX files.

Correct Incorrect Correct answer

You need to implement Row-Level Security (RLS) to restrict data visibility based on user roles (e.g., by Region). Where do you initially define these roles and their associated DAX filter rules?

In Power BI Service, under Workspace Settings.

Correct Incorrect Correct answer

In Power BI Desktop, on the Modeling tab, using Manage roles and View as.

Correct Incorrect Correct answer

In Power Query Editor, using Filter Rows.

Correct Incorrect Correct answer

In Power Automate, using a conditional action.

Correct Incorrect Correct answer

You are defining an RLS role for regional managers. You have a DimTerritory table with a Region column. You want the filter to dynamically match the logged-in user’s email address (assuming their email IS their region name for simplicity). Which DAX expression would achieve this dynamic filtering?

DimTerritory[Region] = "West"

Correct Incorrect Correct answer

DimTerritory[Region] = USERPRINCIPALNAME()

Correct Incorrect Correct answer

CONTAINS(AllowedRegionsTable, [Region], USERNAME())

Correct Incorrect Correct answer

LOOKUPVALUE(UserRegionTable[Region], UserRegionTable[Email], USERPRINCIPALNAME())

Correct Incorrect Correct answer

After defining your RLS roles in Power BI Desktop, how can you test them before publishing to ensure they filter the data correctly?

Publish the report and ask managers if they see the correct data.

Correct Incorrect Correct answer

In Power BI Service, assign users to roles and check the report.

Correct Incorrect Correct answer

In Power BI Desktop, use the View as feature on the Modeling tab to test each role.

Correct Incorrect Correct answer

Check the dataset refresh history for errors.

Correct Incorrect Correct answer

You have created several related reports (Sales Overview, Product Details, Customer Analysis) within your workspace. You want to share these with the wider sales team as a polished, easy-to-navigate collection. What Power BI Service feature is best for this?

To allow multiple developers to co-author a report.

Correct Incorrect Correct answer

To bundle related reports and dashboards into a curated package for distribution to a broad audience.

Correct Incorrect Correct answer

To connect Power BI to external applications like Salesforce.

Correct Incorrect Correct answer

To write and execute DAX queries against the dataset.

Correct Incorrect Correct answer

Which of the following is a key governance documentation deliverable required by the CDIP-BP program, used for tracking and auditing your reporting assets?

The final PBIX file containing the report and model.

Correct Incorrect Correct answer

The Governance Register spreadsheet documenting report owners, refresh schedules, etc.

Correct Incorrect Correct answer

A screenshot of the main dashboard page.

Correct Incorrect Correct answer

The M code from the Power Query transformations.

Correct Incorrect Correct answer

You want to find out how many users viewed your published “Sales Performance Dashboard” yesterday and which pages they looked at most. Which built-in Power BI Service feature provides this information?

The Power BI Admin Portal

Correct Incorrect Correct answer

The Lineage View in the workspace

Correct Incorrect Correct answer

The Usage Metrics Report for a specific report or dashboard

Correct Incorrect Correct answer

The On-Premises Data Gateway logs

Correct Incorrect Correct answer

What is the main objective of the Module 5 Mini Project?

To optimize the DAX calculations for maximum performance.

Correct Incorrect Correct answer

To create the visual dashboard and charts.

Correct Incorrect Correct answer

To publish the existing dashboard, set up refresh, implement security (RLS), and create governance documentation.

Correct Incorrect Correct answer

To perform the initial ETL process using Power Query.

Correct Incorrect Correct answer

Publishing, Automation & Governance

Publishing, Automation & Governance

DataPro 23 October 2025

Exam Summary

Information

Results

Results

Categories

1. Question

Hint

2. Question

Hint

3. Question

Hint

4. Question

Hint

5. Question

Hint

6. Question

Hint

7. Question

Hint

8. Question

Hint

9. Question

Hint

10. Question

Hint

11. Question

Hint

12. Question

Hint

13. Question

Hint

14. Question

Hint

15. Question

Hint

16. Question

Hint

17. Question

Hint

18. Question

Hint

19. Question

Hint

20. Question

Hint