PL-300 Online Practice Questions and Answers

Correct Answer: A

Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter

Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.

The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.

Reference: https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi

Correct Answer: C

Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical

content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows.

Reference:

https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview

Correct Answer: B

Instead create a percentile line by using the Salary measure and set the percentile to 50%.

Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

Reference:

https://dash-intel.com/powerbi/statistical_functions_percentile.php

Correct Answer:

https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabase The following table lists all of the advanced options you can set in Power Query Desktop and Power Query Online. Advanced option Description Command timeout in minutes If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop. SQL statement For information, go to Import data from a database using native database query. Include relationship columns If checked, includes columns that might have relationships to other tables. If this box is cleared, you won't see those columns. Navigate using full hierarchy If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. Enable SQL Server Failover support If checked, when a node in the Azure SQL failover group isn't available, Power Query moves from that node to another when failover occurs. If cleared, no failover occurs.

Correct Answer:

Box 1: No

It will show the total number of accounts that were live at the last day of the year only.

Note:

DISTINCTCOUNT counts the number of distinct values in a column.

LASTDATE returns the last date in the current context for the specified column of dates.

Box 2: No

It will show the total number of accounts that were live at the last day of the month only.

Box 3: Yes

Reference:

https://docs.microsoft.com/en-us/dax/distinctcount-function-dax https://docs.microsoft.com/en-us/dax/lastdate-function-dax

Correct Answer:

Box 1: are 20 values that occur There are 20 unique values.

Box 2: Elm, American Elm, American is below Peer, flowering species in the graphic.

Correct Answer:

Correct Answer:

Correct Answer:

Step 1: Select Use Header as First Row.

Step 2: Select Department and Product and Unpivot Other Columns

Unpivot Other Columns: This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted.

Step 3: Rename the Attribute column to Year and the Value column to Revenue.

You might want to unpivot data, sometimes called flattening the data, to put it in a matrix format so that all similar values are in one column. This is necessary, for example, to create a chart or a report.

When you unpivot, you unpack the attribute-value pairs that represent an intersection point of the new columns and re-orient them into flattened columns:

Values (in blue on the left) are unpivoted into a new column (in blue on the right).

Attributes (in green on the left) are unpivoted into a new column (in green on the right) and duplicates are correspondingly mapped to the new Values column.

Correct Answer:

1- Convert list to table 2- Expand Column 3- Set Date type

Here is an example: https://youtu.be/B4kzyxnhQfI

The definition of the function which expand columns: https://docs.microsoft.com/en- us/powerquery-m/table-expandrecordcolumn