PL-300 Practice Test 6 — 10 Questions

Question 1

Refer to the exhibit. The Power Query M code imports a CSV file. The import succeeds, but the 'OrderDate' column shows some dates as null even though they appear valid in the CSV. What is the most likely cause?

Accepted Answer

The date format in the CSV is not recognized by the locale used in the transformation.. Option A is correct because the '#Changed Type' step converts the column to type date, which will fail for any value that is not a valid date, resulting in null. If the CSV contains dates in a non-standard format (e.g., 'MM/dd/yyyy' vs 'dd/MM/yyyy'), the conversion may produce null. Option B is wrong because promoted headers only affect the first row. Option C is wrong because replacing 'null' with null would not affect dates. Option D is wrong because filtering rows does not affect data types.

Answer

The 'Filtered Rows' step removes rows where Amount > 0, which may include valid dates.

Answer

The 'Promoted Headers' step incorrectly changes the data type of the OrderDate column.

Answer

The 'Replaced Value' step replaces 'null' with null, causing the date to become null.

Question 2

You are reviewing a Power BI data source configuration in the data source settings. The exhibit shows the JSON representation of a data source. Which issue might arise from this configuration?

Accepted Answer

The authentication kind 'Key' is not supported for Azure SQL Database, causing connection failure.. Option D is correct because Azure SQL Database does not support the 'Key' authentication kind in Power BI data source settings. Azure SQL Database requires either Windows authentication, database credentials (Username/Password), or Azure AD-based authentication (such as OAuth2 or Service Principal). The 'Key' authentication kind is typically used for Azure Storage or Cosmos DB, not for Azure SQL Database, so this configuration will cause a connection failure.

Answer

The server name contains a hyphen, which is invalid in SQL Server connection strings.

Answer

The CommandTimeout value is too low and may cause queries to time out.

Answer

The option 'CreateNavigationProperties' is set to false, which may prevent relationships from being created.

Question 3

You are importing data from a CSV file that contains a column 'Date' with values in different formats (e.g., '01/15/2024', '2024-01-15'). You need to ensure all dates are recognized correctly. What should you do in Power Query?

Accepted Answer

In Power Query, set the data type to 'Date' and use 'Using Locale' to specify the correct locale for each file.. Option A is correct because Power Query's 'Using Locale' feature allows you to specify the cultural context (e.g., 'en-US' for MM/DD/YYYY or 'de-DE' for DD.MM.YYYY) when setting a column's data type to 'Date'. This ensures that dates in various formats, such as '01/15/2024' (US) and '2024-01-15' (ISO 8601), are interpreted correctly during import, as the locale dictates the expected date order and separator.

Answer

Change the data source to a SQL database.

Answer

Split the column into multiple columns and merge them back.

Answer

Use 'Replace Values' to standardize the date formats.

Question 4

You are reviewing a Power BI dataset configuration in the service. The JSON shows a data source for an Azure SQL Database. Which statement about the configuration is correct?

Accepted Answer

The dataset uses key-based authentication and does not use single sign-on.. Option A is correct because the JSON configuration for an Azure SQL Database data source in Power BI typically includes a credential setting that specifies authentication type. When the JSON shows a data source with a credential type of 'Basic' or 'Key' (and no 'SingleSignOn' property set to true), it indicates key-based authentication (e.g., using a username and password or service principal key) and explicitly disables single sign-on (SSO). This means the dataset does not leverage the user's Azure AD identity for data access.

Answer

The dataset uses single sign-on with Azure AD.

Answer

The dataset is configured to use a cloud gateway for direct query.

Answer

The dataset uses cloud-only data sources and does not require a gateway.

Question 5

You are preparing data in Power BI Desktop. You have a table with a column 'CustomerID' that contains duplicate values. You need to create a relationship to another table that also has 'CustomerID'. However, the relationship requires unique values in at least one of the tables. What should you do?

Accepted Answer

Remove duplicate rows from the 'CustomerID' column in the dimension table.. Option D is correct because to create a relationship in Power BI, at least one table must have unique values in the column used for the relationship. By removing duplicate rows from the 'CustomerID' column in the dimension table (which should contain unique identifiers), you ensure that the dimension table has unique values, allowing a one-to-many relationship to be established with the fact table. This is a standard data modeling practice in Power BI to enforce referential integrity.

Answer

Create a composite key using multiple columns.

Answer

Use the 'Merge Queries' feature to combine the tables into one.

Answer

Change the data type of 'CustomerID' to text.

Question 6

You are importing data from a web page that contains an HTML table. Power Query detects the table, but you notice that some columns contain HTML tags. Which TWO methods can you use to remove the HTML tags from the column values?

Accepted Answer

Use 'Replace Values' to remove specific tags like
and

.. Option B is correct because 'Replace Values' allows you to manually remove specific HTML tags (e.g.,
,

) by replacing them with an empty string, which is a straightforward method for cleaning known tags. Option E is correct because the 'Html.Table' function in Power Query can parse HTML content and extract the text from a table, effectively stripping tags and returning clean text values.

Answer

Split the column by delimiter '<' and then extract the first part.

Answer

Remove the columns containing HTML tags.

Answer

Use the 'Clean' function to remove all HTML tags.

Question 7

You are connecting to a data source that contains Personally Identifiable Information (PII). You need to ensure that only authorized users can view the data in Power BI reports. Which TWO actions should you take?

Accepted Answer

Define row-level security (RLS) roles in Power BI Desktop.. Options A and D are correct. Row-level security (RLS) restricts data access at the row level based on user roles. Object-level security (OLS) can hide entire tables or columns. Option B is wrong because data masking in Power Query is not a native feature; it must be done manually. Option C is wrong because sensitivity labels protect the report content but do not restrict data access. Option E is wrong because encryption at rest is a general security measure but does not control user access.

Answer

Enable encryption at rest for the dataset.

Answer

Use Power Query to mask PII columns by replacing values with '***'.

Answer

Apply sensitivity labels to the dataset.

Question 8

You have a Power BI dataset that uses a SQL Server view as the data source. The view returns data for all customers, but you only need data for customers in the 'West' region. The view does not accept parameters. How should you filter the data?

Accepted Answer

In Power Query, apply a filter on the Region column after loading the view.. Option B is correct because applying a filter in Power Query after loading the view is the standard approach when the source view does not accept parameters. This method leverages Power Query's query folding capabilities, which push the filter down to the SQL Server, reducing data transfer and improving performance. It avoids loading unnecessary data into the model while maintaining the ability to refresh efficiently.

Answer

Use a native SQL query in Power Query with a WHERE clause to ensure query folding.

Answer

Ask the database administrator to modify the view to include a WHERE clause.

Answer

Load the entire view into the model and use a report-level filter.

Question 9

You are reviewing a Power Query M expression that transforms column types. The 'SalesAmount' column contains values like '1,234.56' (with a comma as thousands separator). After applying this transformation, what is the likely result?

Accepted Answer

The transformation will result in errors for rows containing commas.. Option A is correct because Power Query's default type conversion for numeric columns expects a period as the decimal separator and no thousands separator. When the 'SalesAmount' column contains values like '1,234.56' with a comma as a thousands separator, attempting to convert the column directly to a number type (e.g., using 'Change Type' or 'Table.TransformColumnTypes') will cause errors for rows containing commas, as Power Query cannot parse the comma as part of a valid number. The comma is not a recognized numeric character in the default locale, so the conversion fails.

Answer

The column will be converted to text automatically.

Answer

The column will be successfully converted to numbers.

Answer

The transformation will ignore the comma and convert the number correctly.

Question 10

Which THREE actions in Power Query Editor can improve the performance of data refresh? (Select three.)

Accepted Answer

Remove columns that are not used in the report.. Option C is correct because removing unused columns reduces the amount of data loaded into the Power Query engine and the data model, directly decreasing memory usage and refresh time. Power Query processes all columns in a query step, so eliminating unnecessary columns early minimizes the data footprint for subsequent transformations and the final load.

Answer

Sort data in ascending order to improve compression.

Answer

Merge queries before filtering.

PL-300 Practice Test 6 — 10 Questions

Exhibit

PL-300 Practice Test 6 — 10 Questions

Exhibit