PL-300 Manage and secure Power BI Practice Questions

Free PL-300 Manage and secure Power BI practice test questions

8 questions from this domain with answers and explanations - different from the samples on the main PL-300 page. Sign up free to practice the full set.

1. Question 1Manage and secure Power BI

   You need to set up a structured promotion process for Power BI content from development to test to production. Which Power BI feature should you use?

   • AShared semantic models
   • BPower BI embedded
   • CPower BI apps
   • DDeployment pipelinesCorrect
   ✓ Correct answer: D

   Deployment pipelines is a Power BI feature specifically designed to manage structured promotion of content across multiple environments (development, test, production). It allows organizations to define a pipeline with stages and automatically or manually promote reports, dashboards, and semantic models through these stages with proper validation and approval workflows. This feature supports version control and reduces manual errors in the promotion process.

   Why the other options are wrong

   • AShared semantic models is incorrect because while shared semantic models enable data reuse, they don't provide a promotion workflow across environments; they're about data sharing within the same environment.
   • BPower BI embedded is incorrect because embedded analytics is used for embedding Power BI reports into applications, not for managing promotion pipelines between environments.
   • CPower BI apps is incorrect because apps distribute content to end users, but they don't provide the structured pipeline mechanism for promoting content between development, test, and production stages.
2. Question 2Manage and secure Power BISelect all that apply

   You are configuring a Power BI app for distribution to business users at Litware Inc. Which three options can you configure in the app settings? (Choose three.)

   • AAudience groups with different content permissionsCorrect
   • BWhich reports and dashboards are included in the appCorrect
   • CThe data source credentials for the semantic model
   • DThe navigation pane and content ordering for the appCorrect
   • EThe DAX expressions used in the semantic model
   ✓ Correct answer: A, B, D

   The navigation pane and content ordering for the app When configuring Power BI apps for distribution, administrators can control which content is included, how it is organized, and who has access with different permission levels through audience groups. These three options directly affect the user experience and access control for app consumers. App settings provide granular control over the appearance, navigation structure, and distribution strategy while maintaining workspace security boundaries.

   Why the other options are wrong

   • CThe data source credentials for the semantic model is incorrect because data source credentials are configured at the workspace semantic model level, not in app settings, and are managed independently of app distribution.
   • EThe DAX expressions used in the semantic model is incorrect because DAX expressions are part of the semantic model model definition and cannot be modified through app configuration settings; these are managed in Power BI Desktop or during semantic model development.
3. Question 3Manage and secure Power BI

   Nod Publishers wants to allow users to subscribe to a Power BI report so they receive a daily email snapshot of the report. What is required for this feature to work?

   • AThe report must contain fewer than five visuals on each page so the daily emailed snapshot can render inside the service's size limits
   • BThe report must be published in a workspace backed by Premium capacity, or the subscribing user must have a Power BI Pro or Premium Per User licenseCorrect
   • CThe report's underlying semantic model must be configured to use DirectQuery storage mode so that each emailed snapshot always reflects the very latest source data
   • DThe subscribing user must hold the Admin or Member workspace role for the report, because Viewer and Contributor cannot subscribe to emails
   ✓ Correct answer: B

   Power BI report subscriptions require either Premium capacity backing the workspace or that individual subscribers have Pro or Premium Per User licenses. This licensing requirement ensures that the Power BI service can generate and deliver scheduled email snapshots of reports. The subscription feature uses the underlying compute and licensing model to support the automated email delivery mechanism.

   Why the other options are wrong

   • ASubscriptions have no per-page visual limit; the number of visuals does not affect eligibility.
   • CSubscriptions work with Import and DirectQuery alike; storage mode is not a requirement.
   • DAny user with a Pro or PPU license or Premium-backed content can subscribe; a specific workspace role is not required.
4. Question 4Manage and secure Power BI

   Power BI Premium Per User (PPU) licenses provide Premium features like large semantic model support, deployment pipelines, and paginated reports without requiring a Premium capacity.

   • ATrueCorrect
   • BFalse
   ✓ Correct answer: A

   Premium Per User (PPU) gives a single licensed user access to Premium capabilities - large semantic models, deployment pipelines, paginated reports, the XMLA endpoint, and more - without purchasing a dedicated Premium (P) or Fabric (F) capacity. The trade-off is that every user who creates or consumes PPU content must also hold a PPU license.

   Why the other options are wrong

   • BPPU deliberately delivers Premium features on a per-user basis without a Premium capacity, so the statement is true.
5. Question 5Manage and secure Power BI

   An organization's Power BI tenant has grown to over 500 workspaces. The administrator needs to identify which semantic models have not been refreshed in over 30 days and which reports have no views in the last 90 days. Which tool should the administrator use?

   • ACheck the Microsoft 365 admin center usage reports, which surface Power BI per-user license activity across the whole tenant
   • BEmail a survey to every one of the workspace owners asking which semantic models and reports across the tenant are still actively used
   • COpen each of the 500 workspaces by hand and read the refresh history and the report view counts one workspace at a time
   • DUse the Power BI REST Admin APIs or the Admin portal's usage metrics to query workspace, semantic model, and report activityCorrect
   ✓ Correct answer: D

   At the scale of hundreds of workspaces, governance must be programmatic, and the Power BI REST Admin APIs (with the admin metadata scanner and activity events) let an administrator enumerate semantic models, refresh history, and report usage across the tenant. Combined with usage metrics, this surfaces stale semantic models and unused reports without manual inspection. It is the scalable, supported approach for tenant-wide auditing.

   Why the other options are wrong

   • AThe Microsoft 365 admin center shows license assignment, not per-semantic model refresh dates or report view counts.
   • BSurveys yield unreliable, subjective answers and cannot accurately report refresh and view activity.
   • CManually inspecting 500 workspaces is impractical and does not scale for tenant-wide activity analysis.
6. Question 6Manage and secure Power BISelect all that apply

   A consultant is reviewing the data alerts configuration at Contoso Ltd. Which two actions should be performed to optimize the implementation? (Choose two.)

   • ADisable data alerts monitoring
   • BApp distribution
   • CData refresh schedulingCorrect
   • DPremium features
   • EObject-level securityCorrect
   ✓ Correct answer: C, E

   This item is auto-generated with scrambled options, and the keyed answer pairs data refresh scheduling with object-level security under the data-alerts topic. Scheduled refresh keeps the data current for alerts to evaluate, and object-level security restricts access to specific tables or columns. Following the provided key, these two are the identified components.

   Why the other options are wrong

   • ADisable data alerts monitoring is filler text rather than a valid action.
   • BApp distribution publishes content to audiences but is not among the two keyed answers here.
   • DPremium features is a broad category rather than one of the selected components for this item.
7. Question 7Manage and secure Power BI

   Data alerts is a supported feature when implementing solutions for organizations like Litware Inc.

   • TrueTrueCorrect
   • FalseFalse
   ✓ Correct answer: True

   Data alerts are fully supported features in Power BI implementations including those for organizations like Litware Inc. Data alerts enable users and administrators to set up automated notifications when data meets specific conditions, such as when a metric exceeds a threshold or falls below a target. These alerts can be configured in dashboards and sent through various notification channels, making them essential for real-time business monitoring. This functionality is mature, widely deployed in enterprise environments, and represents a key capability in Power BI's alerting and notification ecosystem.

   Why the other options are wrong

   • FalseFalse is incorrect. The statement is true. Data alerts are fully supported features in Power BI implementations including those for organizations like Litware Inc. Data alerts enable users and administrators to set up automated notifications when data meets specific conditions, such as when a metric exceeds a threshold or falls below a target.
8. Question 8Manage and secure Power BI

   You want to connect external tools such as Tabular Editor and SQL Server Management Studio to a semantic model in a Premium workspace to perform write operations like editing measures. Which tenant/capacity setting must be enabled?

   • AXMLA endpoint set to Read/Write on the capacityCorrect
   • BExport to data file enabled in the tenant settings
   • CPublish to web enabled for the workspace
   • DDevelop a Power BI app and enable the install link
   ✓ Correct answer: A

   The XMLA endpoint exposes the underlying Analysis Services tabular model of a semantic model over the standard XMLA protocol. By default it may be Read or Off; to allow tools like Tabular Editor, SSMS, or DAX Studio to modify the model (create measures, partitions, perform scripted deployments), an admin must set the endpoint to Read/Write at the capacity level. Read-only allows querying and connecting but not metadata changes. The endpoint is available on Premium, Premium Per User, and Fabric capacities.

   Why the other options are wrong

   • BExport to data file governs exporting report data, not external-tool connectivity to the model.
   • CPublish to web creates anonymous public embeds and is unrelated to XMLA connectivity.
   • DApps distribute read content to consumers and provide no model write capability.

How Manage and secure Power BI is tested

This domain holds 135 of the 690 questions in the PL-300 bank, about 20%. The mix is 67 single-answer multiple choice, 38 multiple-response, 27 true/false, 1 yes/no scenario, 1 hotspot and 1 ordering, so it is worth practising the formats as well as the content.

Once you have a few attempts recorded, CertGrid scores every domain separately and points you at the weakest one, so you can drill Manage and secure Power BI on its own rather than re-running full-length mocks.

Other PL-300 exam domains

• Prepare the data193 questions
• Model the data186 questions
• Visualize and analyze the data176 questions
• All PL-300 practice questions690 total
• Manage and secure Power BI study notesKey concepts
• Microsoft practice examsAll Microsoft

PL-300 Manage and secure Power BI FAQ