PL-300 Practice Test 22 — 15 Questions

Question 1

Which TWO actions improve the accessibility of a Power BI report for users with visual impairments?

Accepted Answer

Use a high-contrast color theme.. Option A is correct because applying a high-contrast color theme in Power BI (via View > Themes or a custom JSON theme) increases the luminance difference between foreground text/visuals and background, which helps users with low vision or color-vision deficiencies distinguish content. Option B is correct because adding alt text to every visual in the Visualizations pane's Format > General > Alt Text field lets screen readers such as Narrator, JAWS, or NVDA announce a meaningful description of each chart, making the report navigable for blind users. Option C is wrong because small font sizes reduce legibility rather than improve it, working against accessibility best practices. Option D is wrong because high color saturation alone does not guarantee sufficient contrast and can actually worsen readability for users with color-vision deficiencies. Option E is wrong because complex drillthrough interactions add navigation complexity and are not an accessibility improvement; simpler, predictable navigation is preferred.

Answer

Use small font sizes to fit more content.

Answer

Use high color saturation for all elements.

Answer

Include complex drillthrough interactions.

Question 2

Your organization uses Microsoft Purview to catalog Power BI assets. You need to ensure that all published reports and dashboards are automatically scanned and added to the catalog. What should you do?

Accepted Answer

Register the Power BI tenant as a data source in Microsoft Purview.. The correct option is A: register the Power BI tenant as a data source in Microsoft Purview. Microsoft Purview scans and catalogs Power BI assets (reports, dashboards, datasets, dataflows) only after the Power BI tenant is registered as a data source and a scan is configured, which uses the Power BI Admin API and requires tenant-level read-only admin permissions. Option B is unrelated: enabling Microsoft Entra ID authentication in the Power BI admin portal does not trigger Purview scanning or cataloging. Option C, applying sensitivity labels, governs data protection and classification but does not populate the Purview catalog with Power BI assets. Option D is incorrect because creating a workspace and assigning a catalog admin role does not register the tenant or initiate scanning of published reports and dashboards.

Answer

Enable 'Allow Azure Active Directory authentication' in the Power BI admin portal.

Answer

Apply sensitivity labels to all assets.

Answer

Create a new workspace in Power BI and assign the catalog admin role.

Question 3

Which THREE of the following are valid considerations when using Power BI's AI visuals? (Choose three.)

Accepted Answer

Some AI visuals have a limit on the number of data points they can analyze.. Option B is correct because AI visuals such as Key Influencers and Decomposition Tree have practical limits on the volume of data points they can process effectively, so large datasets may need filtering or aggregation before use. Option D is correct because several AI-powered features (for example, some Cognitive Services integrations and certain AI insights) require Power BI Premium or Premium Per User capacity rather than being fully available on shared/Pro capacity. Option E is correct because AI visuals depend on the semantic type of fields: for instance, Key Influencers needs a categorical field to analyze and a numeric or categorical target, while Q&A and Smart Narrative rely on properly typed numeric, categorical, or date fields to generate meaningful results. Option A is not a valid consideration because AI visuals are part of Power BI Pro/Premium licensing and do not require a separate 'AI workload' license. Option C is not correct because AI visuals are not deprecated in favor of Copilot; Copilot is an additional generative feature, and the AI visuals remain supported.

Answer

AI visuals are only available with an AI workload license.

Answer

AI visuals are deprecated in favor of Copilot.

Question 4

You are importing data from a folder containing multiple CSV files with the same structure. You want to combine all files into a single table, but only include files that have been modified in the last 7 days. What Power Query transformation should you use?

Accepted Answer

Filter the folder contents by 'Date Modified' before combining. Option B is correct because Power Query's Folder data source exposes file metadata columns such as Date modified, and applying a filter on that column before invoking the Combine Files transformation restricts the combined table to only files modified within the last 7 days. This keeps the import efficient and ensures the resulting single table contains only the desired recent files. Option A is wrong because 'Sample File' merely defines the file structure and does not filter by modification date. Option C is wrong because 'Merge Queries' joins two existing queries on matching keys, not folder file metadata. Option D is wrong because filtering after combining would still load all files first, and the Date modified column is not retained in the combined result.

Answer

Use 'Sample File' and manually filter

Answer

Use 'Merge Queries' with the folder

Answer

Combine files using 'Combine & Load', then filter by date modified

Question 5

You create a Power BI report that uses a live connection to an Azure Analysis Services (AAS) model. You want to enforce row-level security defined in the AAS model. What should you do?

Accepted Answer

No additional configuration needed; RLS from AAS is automatically applied.. Option B is correct because when a Power BI report uses a live connection to an Azure Analysis Services (AAS) model, the report does not contain its own dataset or RLS definitions; instead, it queries the AAS model directly, so the row-level security roles and memberships defined in the AAS model are automatically enforced for the connecting user. This is the standard behavior for live connections to Analysis Services, where security is managed at the source model rather than in Power BI. Option A is wrong because object-level security (OLS) restricts columns/tables, not rows, and is not a substitute for RLS. Option C is wrong because you cannot create RLS roles on the dataset in the Power BI service when the report uses a live connection, since there is no imported dataset in Power BI to configure. Option D is wrong because defining RLS roles in Power BI Desktop and publishing applies only to imported or DirectQuery datasets hosted in Power BI, not to live-connected AAS models.

Answer

Use object-level security (OLS) instead.

Answer

Use Power BI service to create RLS roles on the dataset.

Answer

Define the same RLS roles in Power BI Desktop and publish.

Question 6

You have a report with a map visual showing store locations by city. However, some cities are not displaying on the map. You verified that the city names are correct. What should you check first?

Accepted Answer

Add latitude and longitude fields to the map visual.. The correct option is B: add latitude and longitude fields to the map visual. Power BI's built-in map relies on geocoding city names, and ambiguous or duplicate city names across regions often fail to plot, so supplying explicit latitude and longitude values gives the visual unambiguous coordinates to render each store location. Option A is unnecessary because switching to the ArcGIS Map visual does not resolve missing geocoding data. Option C is irrelevant since a filled map still depends on the same geocoding and would not fix missing points. Option D is not the issue because the scenario already confirms the city names are correct, and a text data type is expected for city fields anyway.

Answer

Use ArcGIS Map visual instead of the built-in map.

Answer

Change the map visual to a filled map.

Answer

Ensure the city column is set to the Text data type.

Question 7

A Power BI administrator wants to allow users to create dashboards and reports, but prevent them from sharing content outside the organization. Which two settings should be configured in the Power BI admin portal? (Choose two.)

Accepted Answer

Disable 'Share content with external users' in the tenant settings.. Option D is correct because disabling 'Share content with external users' in the Power BI admin portal tenant settings blocks users from sharing dashboards and reports with recipients outside the organization, directly satisfying the requirement to prevent external sharing. Option E is correct because disabling 'Publish to web' prevents users from publishing reports to public websites, which is another channel for exposing content outside the organization. Option A is incorrect because disabling 'Create workspaces' would prevent users from creating workspaces, conflicting with the goal of allowing them to create dashboards and reports. Option B is incorrect because disabling 'Export data' restricts exporting underlying data rather than sharing dashboards and reports externally. Option C is incorrect because 'Featured tables' relates to promoting tables in Excel's data types gallery and has no bearing on external sharing.

Answer

Disable 'Create workspaces' in the tenant settings.

Answer

Disable 'Export data' in the tenant settings.

Answer

Disable 'Featured tables' in the tenant settings.

Question 8

Which TWO approaches can you use to implement row-level security (RLS) in Power BI?

Accepted Answer

Create roles with static filters.. Option D is correct because creating roles with static filters is a core RLS implementation method in Power BI: in Power BI Desktop you define roles in Manage Roles and add DAX filter expressions on tables (for example, [Region] = "West"), then assign users or groups to those roles in the Power BI service, so each user sees only the rows matching the filter. Option E is correct because dynamic filters based on USERNAME() (or USERPRINCIPALNAME()) implement RLS by evaluating the signed-in user at query time, typically via a relationship to a security/identity table, so row visibility adapts automatically without creating a separate static role per user. Option A is not a valid RLS approach because assigning users to security groups in the dataset is a membership/administration step, not a row-filtering mechanism by itself. Option B is wrong because column-level security restricts which columns are visible, not which rows. Option C is wrong because object-level security restricts access to tables and columns (metadata), not rows.

Answer

Assign users to security groups in the dataset.

Answer

Use column-level security to restrict row visibility.

Answer

Use object-level security to restrict rows.

Question 9

You have a Power BI dataset that connects to an Azure SQL Database. You need to use single sign-on (SSO) so that users' identities are passed to the database. What authentication method should you configure?

Accepted Answer

OAuth2 with Microsoft Entra ID. OAuth2 with Microsoft Entra ID (option C) is correct because Power BI's SSO to Azure SQL Database relies on Microsoft Entra ID token-based authentication, where the user's Entra ID identity is passed through to the database via OAuth2, enabling row-level security and auditing per user. Azure SQL Database natively supports Entra ID authentication, and Power BI can forward the user's token when the data source is configured with DirectQuery and SSO enabled. Windows authentication (A) is not applicable since Azure SQL Database does not accept on-premises Windows/Kerberos credentials directly without a gateway and Entra ID setup. Key authentication (B) uses a shared key rather than a user identity, so it cannot provide SSO. Basic authentication with a service account (D) uses a single shared credential, not the individual user's identity, so it also fails to meet the SSO requirement.

Answer

Windows authentication

Answer

Key authentication

Answer

Basic authentication with a service account

Question 10

You are creating a Power BI report and want to allow users to ask questions about the data using natural language. Which feature should you enable?

Accepted Answer

Q&A visual.. The Q&A visual (option C) is the correct choice because it lets report consumers type natural-language questions and automatically returns answers as visuals, which is exactly the requirement for asking questions about the data in natural language. Quick Insights (A) instead runs automated analytics to surface patterns and anomalies without accepting user questions. The Key Influencers visual (B) is a predefined AI visual that explains which factors drive a metric, not a natural-language query interface. Copilot for Power BI (D) can generate report content and summaries, but the dedicated in-report natural-language question feature is the Q&A visual.

Answer

Quick Insights.

Answer

Key Influencers visual.

Answer

Copilot for Power BI.

Question 11

Your organization uses Power BI with a shared capacity (no Premium capacity). You need to implement row-level security (RLS) on a dataset that is used by multiple reports. Which of the following is a limitation you must consider?

Accepted Answer

RLS cannot be applied when the dataset uses DirectQuery to a data source that requires single sign-on (SSO) because the user's identity is passed through, and the source must enforce RLS.. The correct option is C: RLS cannot be applied when the dataset uses DirectQuery to a data source that requires single sign-on (SSO) because the user's identity is passed through, and the source must enforce RLS. In a shared capacity, Power BI does not perform RLS for DirectQuery sources that use SSO; instead, it passes the user's credentials to the source, so the source system must enforce its own row-level security. Options A, B, and D are incorrect: RLS is supported in shared capacity, roles can be created in Power BI Desktop, and RLS can be applied to DirectQuery tables (with the SSO caveat noted in C).

Answer

RLS is not supported in shared capacity; you need a Premium license.

Answer

RLS roles must be created in the Power BI service after publishing; they cannot be created in Power BI Desktop.

Answer

RLS can only be applied to tables that are imported, not to tables using DirectQuery.

Question 12

You have a Power BI dataset that contains a table with sales data and a separate date table. You need to create a measure that calculates the total sales for the previous month relative to the selected date. Which DAX function should you use?

Accepted Answer

PREVIOUSMONTH. PREVIOUSMONTH (option C) is correct because it is a time-intelligence function that returns a single-column table of dates for the entire month immediately preceding the dates in the current filter context, so wrapping it in CALCULATE with SUM of sales yields the previous month's total sales. It works directly against a marked date table and shifts the context back exactly one month, which matches the requirement. SAMEPERIODLASTYEAR shifts the context back one year, not one month, so it would return the same period last year. DATEADD shifts dates by a specified number of intervals but requires an explicit interval argument and is more general, not purpose-built for the immediately preceding month. PARALLELPERIOD shifts by a specified number of intervals and returns a full period, but it also requires an interval argument and is not the specific previous-month function.

Answer

SAMEPERIODLASTYEAR

Answer

DATEADD

Answer

PARALLELPERIOD

Question 13

You need to create a hierarchy in Power BI that allows drilling down from Year to Quarter to Month. What is the correct approach?

Accepted Answer

Create a hierarchy in the Date table using Year, Quarter, Month columns. The correct option is D: create a hierarchy in the Date table using the Year, Quarter, and Month columns. In Power BI, a hierarchy is built by dragging fields onto each other in the Fields pane, so placing Year above Quarter above Month in a date table produces exactly the Year → Quarter → Month drill-down path required. The other options do not fit: A (separate measures) produces independent calculations, not a drillable hierarchy; B (Drillthrough) navigates to a separate report page filtered by a selected value, not down levels within a visual; and C (DATESYTD) is a time-intelligence function that returns year-to-date totals, not a hierarchy.

Answer

Create separate measures for each level

Answer

Use the Drillthrough feature

Answer

Use the DATESYTD function

Question 14

You are cleaning a column that contains numbers stored as text, with occasional leading/trailing spaces and currency symbols. You apply the function above to the column. However, some rows return null even though the original text appears to be a valid number, such as '$ 1,234.56'. What is the most likely cause?

Accepted Answer

The function does not remove commas and currency symbols before conversion.. Conversion functions like Number.FromText do not automatically strip currency symbols, commas, or spaces. The input '$ 1,234.56' must be cleaned (e.g., remove $, spaces, and commas) before conversion, or the conversion fails and returns null. The error handling (if any) only catches the error; it does not sanitize the input.

Answer

The try...otherwise block is not catching parsing errors.

Answer

Text.Clean removes necessary decimal separators.

Answer

The function is applied to the wrong data type column.

Question 15

You are using Power Query to transform a column 'FullName' containing values like 'Smith, John'. You need to split this into 'LastName' and 'FirstName' columns. Which THREE steps are required?

Accepted Answer

Use 'Split Column' by delimiter. Option B is correct because the 'FullName' values like 'Smith, John' must first be separated at the comma, which is exactly what Power Query's 'Split Column' by delimiter (comma) does, producing two new columns. Option C is correct because the delimiter is followed by a space, so the resulting 'John' value will have a leading space that must be removed with Trim to get clean FirstName values. Option E is correct because the split produces generically named columns (e.g., 'FullName.1' and 'FullName.2'), so they must be renamed to 'LastName' and 'FirstName' to match the required output. Option A does not belong because Unpivot transforms columns into rows and is unrelated to splitting a single text column. Option D does not belong because merging the columns back would undo the split and recreate a single combined value, contradicting the goal of separate LastName and FirstName columns.

Answer

Unpivot columns

Answer

Merge the split columns back