PL-300 Practice Test 1 — 10 Questions

Question 1

You want to create a custom visual that is not available in the default Power BI visuals pane. What should you do?

Accepted Answer

Download the visual from AppSource and import it.. Custom visuals can be imported from AppSource or a file. The option to get from AppSource is standard.

Answer

Write the visual in Python and add it to the report.

Answer

Use the R script visual to create the visual.

Answer

Create a custom visual using Power BI Desktop's built-in editor.

Question 2

You are a Power BI administrator. You need to prevent users from exporting underlying data from reports. Which tenant setting should you disable?

Accepted Answer

'Export data'. 'Export data' controls the ability to export underlying data. Option B is wrong because 'Export reports as PowerPoint' is for exporting the report itself. Option C is wrong because 'Export reports as PDF' is for static exports. Option D is wrong because 'Export reports as MHTML' is also for report export.

Answer

'Export reports as PowerPoint presentations'

Answer

'Export reports as PDF files'

Answer

'Export reports as MHTML files'

Question 3

You are a data analyst for a utility company. You import a table named MeterReadings from an OData feed. The table contains a column named ReadingTimestamp that includes date and time. You need to create two new columns: one that contains only the date and one that contains only the hour of the day as a number (0–23). You want to use built-in Power Query transformations from the Add Column tab without writing custom formulas. Which two transformations should you use? (Choose two.)

Accepted Answer

Select ReadingTimestamp, then on the Add Column tab choose Time and select Hour.. To create a date-only column and an hour column from a timestamp, you use the Date Only transformation and the Hour transformation, both available on the Add Column tab. These are built-in, code-free operations that add new columns while keeping the original timestamp. Other date or time transformations extract different components and do not meet the stated requirements.

Answer

Select ReadingTimestamp, then on the Add Column tab choose Date and select Year.

Answer

Select ReadingTimestamp, then on the Add Column tab choose Time and select Duration.

Answer

Select ReadingTimestamp, then on the Add Column tab choose Date and select Month.

Question 4

You want to allow users to highlight different product categories in a line chart by selecting from a list. Which feature should you add?

Accepted Answer

Slicer. A slicer filters or highlights data based on selection, making it ideal for category selection. Bookmarks save a state, drillthrough navigates to another page, and tooltips show details on hover.

Answer

Tooltip

Answer

Bookmarks

Answer

Drillthrough

Question 5

You need to create a visual that shows the relationship between advertising spend and website traffic. Which type of visual is most appropriate?

Accepted Answer

Scatter chart. Scatter charts are ideal for showing relationships between two numeric variables. A line chart shows trends over time, a bar chart compares categories, and a pie chart shows proportions.

Answer

Stacked bar chart

Answer

Pie chart

Answer

Line chart

Question 6

Refer to the exhibit. You have a Power BI dataset with the JSON policy shown. You add a user to the USOnly role. What happens when that user views a report based on this dataset?

Accepted Answer

The user sees only rows where Region is 'US' in the Sales table.. Row-level security (RLS) restricts data: only rows where Region is 'US' are visible. Option A is wrong because RLS does not hide the entire table. Option C is wrong because RLS does not affect columns. Option D is wrong because RLS does not affect other tables unless defined.

Answer

The user sees all rows in the Sales table.

Answer

The user sees all rows but the SalesAmount column is hidden.

Answer

The user sees all rows in all tables of the dataset.

Question 7

Your Power BI report includes a map visual showing store locations. However, some locations are not appearing correctly because of ambiguous place names. What should you do to ensure accurate geocoding?

Accepted Answer

Use latitude and longitude fields instead of location names. Using latitude and longitude fields bypasses Bing's geocoding, ensuring accuracy. Changing the map style does not fix geocoding, using a filled map is for regions, and a bubble chart is not geographic.

Answer

Aggregate the data by country

Answer

Switch to a bubble chart

Answer

Change the map visual to a filled map

Question 8

A data analyst needs to combine two queries in Power Query: 'Sales2023' and 'Sales2024', both with identical column structures. Which operation should the analyst use to append the rows from 'Sales2024' to 'Sales2023'?

Accepted Answer

Append Queries. The Append Queries operation in Power Query is designed to combine rows from two or more tables with identical column structures, stacking the rows of 'Sales2024' beneath those of 'Sales2023'. This is the correct method because it preserves all columns and adds data vertically, which matches the requirement to append rows.

Answer

Merge Queries

Answer

Group By

Answer

Pivot Column

Question 9

Which TWO are valid reasons to use a dataflow in Power BI when preparing data?

Accepted Answer

To handle large data volumes that exceed dataset limits. Option A is correct because dataflows store transformed data in Common Data Model (CDM) entities in Azure Data Lake Storage Gen2, so they can process and persist large data volumes that would otherwise exceed a single dataset's size or memory limits. Option B is correct because a dataflow's CDM entities can be consumed by multiple Power BI datasets, letting you define the transformation logic once and reuse the same cleansed data across many datasets instead of duplicating ETL work. Option C is not a valid reason, since dataflows that connect to on-premises sources still require an on-premises data gateway; dataflows do not eliminate that need. Option D is not correct because dataflows are refreshed on a scheduled (batch) basis and are not a mechanism for real-time streaming, which is handled by streaming datasets or push datasets. Option E is not correct because data lineage is a metadata/governance feature surfaced automatically in the workspace, not something a dataflow is used to enforce.

Answer

To avoid using an on-premises data gateway

Answer

To achieve real-time data refresh

Answer

To automatically enforce data lineage

Question 10

You have a report with a line chart showing monthly sales. Users need to see the exact sales value when they hover over a data point. What should you configure?

Accepted Answer

Configure the visual's tooltip to display the value.. Tooltips in Power BI are designed to show detailed information about a data point when the user hovers over it. By default, the visual's tooltip already includes the value, but if it has been customized or removed, you need to ensure the tooltip is configured to display the sales value. This provides an interactive way to see exact numbers without cluttering the chart with permanent labels.

Answer

Enable data labels on the chart.

Answer

Add a report page tooltip.

Answer

Set the category label to show the value.