Microsoft PL-300 Practice Test 1

Question 1

An analyst needs subsecond slicing over a stable monthly ledger and is allowed to cache the source rows in the model. What should the report or semantic-model owner do?

Use Direct Lake over the supported Fabric tables.
Connect to the approved shared Power BI semantic model.
Import the ledger into a Power BI semantic model.
Connect to the relational source using DirectQuery.

Explanation

Correct Answer

Import materializes compressed data in the model and queries it without contacting the operational source on each interaction, supporting low-latency cached historical analytics.

Incorrect Answers

Direct Lake reads underlying Delta data using the tabular engine and avoids a conventional full import duplicate. It is useful for querying lakehouse Delta tables directly, not for low-latency cached historical analytics.

Reusing the shared semantic model centralizes metric definitions and existing managed relationships. Its scope is reporting on governed enterprise measures, not low-latency cached historical analytics.

DirectQuery sends supported visual queries to the source instead of storing imported fact rows. It would address live operational data without model caching, not low-latency cached historical analytics.

Question 2

A team maintains employee roster records as a list on a SharePoint site and needs its typed columns. Which Power BI approach BEST satisfies the stated requirement?

Use the Folder connector and Combine Files workflow.
Use the OData Feed connector with the service URL.
Use the SQL Server database connector with approved authentication.
Use the SharePoint Online List connector.

Explanation

Correct Answer

The list connector retrieves list item fields and metadata instead of pretending the list is a file, supporting loading structured SharePoint list items.

Incorrect Answers

Folder enumeration and sample-file transformation combine consistently shaped files. It would address combining recurring local extract files, not loading structured SharePoint list items.

The OData connector consumes the endpoint's metadata and entity navigation surface. That targets acquiring OData service entities, not loading structured SharePoint list items.

The database connector supports relational schema browsing and model loading or DirectQuery. It may suit accessing a managed SQL operational database, not loading structured SharePoint list items.

Question 3

A protected SaaS analytics API requires an interactive organizational identity authorized by Microsoft Entra. What should the report or semantic-model owner do?

Configure organizational-account OAuth authentication for the supported connector.
Use the connector's supported Web API credential mode and protected key storage.
Choose the supported Windows authentication mode and gateway identity.
Use Anonymous authentication only for the approved public endpoint.

Explanation

Correct Answer

Organizational OAuth uses user or service identity tokens instead of pasting anonymous keys, supporting delegated enterprise identity authentication.

Incorrect Answers

The Web API credential mechanism supplies an authorized API key without embedding it in query text. Its scope is protected API-key authentication, not delegated enterprise identity authentication.

Windows authentication uses an approved directory context for the internal database. That is meant for integrated corporate database access, not delegated enterprise identity authentication.

Anonymous mode avoids sending unnecessary secrets to a source designed for public reads. It would address permitted unauthenticated catalog reads, not delegated enterprise identity authentication.

Question 4

Payroll records must not flow into a public web request when a query combines sources. Which Power BI approach BEST satisfies the stated requirement?

Reenable privacy-level enforcement and correct source-specific classifications.
Mark the payroll source Private in Power Query source privacy settings.
Assign Organizational privacy level to the approved internal source.
Assign Public privacy level to that public source.

Explanation

Correct Answer

Private isolation limits folding and combining that could expose protected source values to another endpoint, supporting isolate confidential payroll during data combination.

Incorrect Answers

Ignoring privacy restrictions can allow query behavior that transmits restricted values to another source. It would address restore privacy isolation after unsafe bypass, not isolate confidential payroll during data combination.

Organizational privacy permits compatible combinations within the trusted organization boundary. It may suit controlled internal source combination, not isolate confidential payroll during data combination.

Public sources are permitted to contribute data to higher-trust mashups without treating their values as secrets. It is useful for appropriately classify open-source information, not for isolate confidential payroll during data combination.

Question 5

A report queries an API using a year that business users change during development without editing every query step. What should the report or semantic-model owner do?

Configure the parameter's data type and allowed values appropriately.
Update the published semantic model's parameter values and applicable credentials.
Create a Power Query year parameter and reference it in the source transformation.
Parameterize server and database names and set environment-appropriate values.

Explanation

Correct Answer

A parameter provides a typed reusable input to multiple query expressions, supporting reusable year input in Power Query.

Incorrect Answers

Typed and constrained parameters reduce invalid query argument combinations. It is useful for safe parameter value validation, not for reusable year input in Power Query.

Published parameters and credential configuration are managed in the service independently of the local file. Its scope is correct service-side production parameter values, not reusable year input in Power Query.

Source parameters separate environment configuration from the transformation logic. It would address changing SQL endpoints safely across environments, not reusable year input in Power Query.

Question 6

A cloud-hosted SQL database is directly reachable by the Power BI service with supported cloud credentials. Which Power BI approach BEST satisfies the stated requirement?

Install and configure an on-premises data gateway with approved data source mappings.
Deploy a supported gateway cluster with redundant members.
Migrate to an on-premises data gateway in standard mode with delegated administration.
Configure the supported cloud connection without an unnecessary on-premises gateway.

Explanation

Correct Answer

A public cloud source supported by native service connectivity can refresh without on-premises tunneling, supporting direct managed cloud refresh.

Incorrect Answers

The gateway brokers service refresh traffic to internal network sources. It would address refresh from isolated corporate SQL, not direct managed cloud refresh.

A gateway cluster can distribute requests and provide availability when a member fails. That targets resilient enterprise gateway access, not direct managed cloud refresh.

Standard gateway supports shared enterprise data source administration beyond one user's personal gateway. It may suit centrally administered gateway reuse, not direct managed cloud refresh.

Question 7

A report refreshes a huge order table daily but only the most recent month's orders change. What should the report or semantic-model owner do?

Configure incremental refresh with RangeStart and RangeEnd filter parameters.
Introduce supported query-reduction or Apply controls for high-interaction filters.
Configure automatic page refresh within capacity and source limits.
Increase semantic model scheduled refresh frequency within its license and source limits.

Explanation

Correct Answer

Incremental refresh partitions historical and changing rows to avoid full reprocessing, supporting partition refresh by changing date window.

Incorrect Answers

Query reduction delays or consolidates source requests rather than firing on every intermediate selection. Its scope is limit DirectQuery filter-query bursts, not partition refresh by changing date window.

Automatic page refresh updates eligible DirectQuery pages on a defined interval. That is meant for recurring real-time page updates, not partition refresh by changing date window.

Refresh schedules determine when import data is reloaded from sources. It would address align Import freshness with business cadence, not partition refresh by changing date window.

Question 8

A data model's SQL source was moved to a new approved host and all transformations should remain. Which Power BI approach BEST satisfies the stated requirement?

Map the semantic model to the correct gateway connection and data source.
Change the source endpoint in Power Query data source settings.
Update the source credentials in the relevant Power BI connection settings.
Clear permissions for the old data source and reauthenticate only when authorized.

Explanation

Correct Answer

Connection settings can be updated without rebuilding later transform steps; this helps retain transformations after server relocation.

Incorrect Answers

Service refresh requires matching connection paths and authentication mappings. It would address fix published model gateway binding, not retain transformations after server relocation.

Refresh authentication is separate from the source address and cached data. It may suit repair expired cloud credentials, not retain transformations after server relocation.

Clearing source permissions removes stored credential bindings for that endpoint. It is useful for removing obsolete stored source credentials, not for retain transformations after server relocation.

Question 9

A supplier CSV contains semicolons within quoted text, and the import separates fields at every semicolon incorrectly. What should the report or semantic-model owner do?

Parse JSON and expand the list and nested records in Power Query.
Use the Web connector's detected table or supported HTML table selection.
Use the CSV connector with the correct delimiter and quoting rules.
Set the source text encoding to the file's actual character set.

Explanation

Correct Answer

Delimiter and quotation parsing prevents embedded separators from splitting one logical field; this helps preserve quoted CSV field boundaries.

Incorrect Answers

JSON navigation and expansion converts hierarchical payloads to tabular columns. It is useful for flatten structured JSON records, not for preserving quoted CSV field boundaries.

Table extraction selects semantic rows and columns from supported web content. Its scope is retrieve tabular website data, not preserve quoted CSV field boundaries.

Correct code-page decoding preserves Unicode and legacy encoded characters. It would address decode supplier text correctly, not preserve quoted CSV field boundaries.

Question 10

A SQL view has hundreds of millions of rows but only current-quarter purchases are required for this report. Which Power BI approach BEST satisfies the stated requirement?

Move supported foldable filters before the nonfolding custom transformation.
Inspect View Native Query and query-folding indicators for the selected step.
Stage an approved shared reference result and control query evaluation rather than duplicate repeated API calls.
Filter rows near the source step while preserving query folding.

Explanation

Correct Answer

Folded filtering delegates predicates to the database and reduces transferred rows, supporting push restricted date filters to SQL.

Incorrect Answers

Filter order can preserve upstream database pushdown before an operation prevents further folding. It would address avoid breaking query folding too early, not push restricted date filters to SQL.

Query folding indicators and native statements expose pushdown behavior where supported. That targets verify relational query folding, not push restricted date filters to SQL.

Reusing a controlled source evaluation may reduce repeated requests when supported by the refresh plan. It may suit manage rate-limited API request duplication, not push restricted date filters to SQL.