Courseiva
Manage and secure Power BIhardMultiple ChoiceObjective-mapped

Automatic Sensitivity Labels on Exports

Your organization uses Microsoft Purview Information Protection to label sensitive data in Power BI datasets. You need to ensure that when a report is exported to Excel, the sensitivity label is automatically applied. What should you configure?

Quick Answer

Ensuring the dataset carries a sensitivity label so exports inherit it automatically is the answer because Microsoft Purview Information Protection labels are designed to travel with the data rather than being reapplied at every step downstream. Once a label is set on the dataset itself, any export generated from that dataset -- including an Excel export -- carries the same label without requiring separate configuration on the report or the export action, which is what makes the protection consistent and low-maintenance. The other options fail because they target the wrong layer of the process. The admin portal setting that applies sensitivity labels to exported data is a fallback mechanism meant to cover situations where the underlying data source has no label of its own; it doesn't override or duplicate inheritance that's already happening from a properly labeled dataset. Data loss prevention policies operate differently again -- they monitor and can flag or block sensitive data movement, but they don't assign sensitivity labels themselves. And there is no separate mechanism for setting a default label at the individual report level, since labels flow from the dataset down to everything built on it. When a scenario asks how protection should persist through an export or downstream artifact, look for where the label originates and trust that it propagates automatically rather than assuming each new artifact needs its own explicit configuration.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Ensure the dataset has a sensitivity label and that the export inherits the label.

When a Power BI dataset has a sensitivity label applied via Microsoft Purview Information Protection, any downstream exports (such as reports exported to Excel) automatically inherit that label. This inheritance ensures consistent protection across all outputs. Option D is incorrect because the Power BI admin portal setting 'Apply sensitivity labels to exported data' is used to apply labels when the data source does not have a label, but it does not override automatic inheritance from a labeled dataset. Option B is incorrect because DLP policies in Microsoft Purview monitor and protect data, but they do not automatically apply sensitivity labels to exports. Option C is incorrect because setting a default sensitivity label on a report is not a feature; sensitivity labels are inherited from the dataset, not configured per report.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Ensure the dataset has a sensitivity label and that the export inherits the label.

    Why this is correct

    Correct. When a dataset has a sensitivity label, exports inherit it automatically, ensuring consistent protection without manual intervention.

  • Use data loss prevention (DLP) policies in Microsoft Purview.

    Why it's wrong here

    Incorrect. Data loss prevention (DLP) policies in Microsoft Purview help prevent data leaks but do not automatically apply sensitivity labels to exported data.

  • Set a default sensitivity label on the report.

    Why it's wrong here

    Incorrect. There is no concept of a default sensitivity label on a report; labels are applied at the dataset level and inherited by downstream items.

  • Enable 'Apply sensitivity labels to exported data' in the Power BI admin portal.

    Why it's wrong here

    Incorrect. The 'Apply sensitivity labels to exported data' admin setting is used when the data source lacks a label, but automatic inheritance from a labeled dataset takes precedence and does not require this setting to be enabled.

About these practice questions

This PL-300 question is part of Courseiva's 217-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

1 more way this is tested on PL-300

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. An organization uses Power BI with Microsoft Purview Information Protection. A report contains sensitive customer data. The administrator wants to ensure that when the report is exported to Excel, the sensitivity label is automatically applied. What must be configured?

medium
  • A.Configure the Excel workbook to inherit the label from Power BI
  • B.Enable auto-labeling in the Power BI admin settings and configure the sensitivity label policy
  • C.Use row-level security to restrict access to sensitive data
  • D.Require users to manually apply a sensitivity label before exporting

Why B: Power BI supports automatic sensitivity labeling based on data classification, which can propagate to exports. Option A is wrong because manual labeling is not automatic. Option C is wrong because RLS does not affect labeling. Option D is wrong because the label is applied by Power BI, not Excel.

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.