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. A free account includes a fixed set of 20 questions for this exam; paid access unlocks the full bank.

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 BI

   You notice that a scheduled data refresh is failing every morning. The error message indicates gateway connectivity issues. Which tool should you use first to diagnose the problem?

   • AThe on-premises data gateway app diagnostics and logsCorrect
   • BSQL Server Profiler traces on the source database
   • CThe Performance Analyzer pane in Power BI Desktop
   • DDAX Studio connected to the published semantic model
   ✓ Correct answer: A

   When a scheduled refresh fails with gateway connectivity issues, the first diagnostic tool should be the on-premises data gateway app itself, which provides detailed logs and diagnostics about connection attempts, authentication errors, and network issues. These logs are the most direct source of information about gateway-level problems and are specifically designed to troubleshoot connectivity and communication failures between the gateway and data sources.

   Why the other options are wrong

   • BSQL Server Profiler captures events occurring inside a SQL Server instance once a connection has been established; if the gateway cannot reach the server, nothing arrives for Profiler to trace, so it cannot show why the connection failed.
   • CPerformance Analyzer records how long each visual's DAX query and rendering take in a report open in Power BI Desktop; it never touches the gateway or the service's scheduled refresh.
   • DDAX Studio connects to a loaded model to run and time DAX queries and inspect VertiPaq storage; it analyses query performance and reports nothing about gateway connectivity or refresh failures.
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 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 Premium features configuration at Wide World Importers. Which two actions should be performed to optimize the implementation? (Choose two.)

   • ALineage view
   • BDisable Premium features monitoring
   • COn-premises data gatewayCorrect
   • DGateway management
   • ECapacity managementCorrect
   ✓ Correct answer: C, E

   This item is auto-generated with scrambled options, and the keyed answer pairs the on-premises data gateway with capacity management under the Premium-features topic. The gateway connects Premium workloads to on-premises data, and capacity management governs Premium resource allocation and performance. Following the provided key, these two are the identified Premium-related components.

   Why the other options are wrong

   • ALineage view shows item dependencies but is not among the two keyed answers here.
   • BDisable Premium features monitoring is filler text rather than a valid action.
   • DGateway management overlaps conceptually with the gateway but is not the keyed item; the selected pair names the on-premises data gateway itself and capacity management.
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

   The classic data alert is created from a dashboard tile that shows a single number, so a card, KPI or gauge; it cannot be set on a tile carrying more than one value. You choose a threshold, above or below, a maximum notification frequency, and whether an email accompanies the entry in the notification centre. Evaluation happens after the semantic model behind the tile refreshes, which is what ties alert timing to the refresh schedule rather than to a clock. Alerts of this kind are per user and private: yours are invisible to everyone else even on a shared dashboard. Power Automate can take the alert as a trigger, which is how one becomes a Teams message, a ticket or an approval.

   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 706 questions in the PL-300 bank, about 19%. 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 data197 questions
• Model the data188 questions
• Visualize and analyze the data186 questions
• All PL-300 practice questions706 total
• Manage and secure Power BI study notesKey concepts
• Microsoft practice examsAll Microsoft

PL-300 Manage and secure Power BI FAQ