Deal of the Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft PL-300 Exam

Certification Provider: Microsoft
Exam Name: Microsoft Power BI Data Analyst
Number of questions in our database: 295
Exam Version: Mar. 14, 2023
PL-300 Exam Official Topics:
  • Topic 1: Create reference lines by using the Analytics pane/ Identify and create appropriate keys for joins
  • Topic 2: Resolve inconsistencies, unexpected or null values, and data quality issues/ Select a shared dataset or create a local dataset
  • Topic 3: Apply user-friendly naming conventions to columns and queries/ Design and implement role-playing dimensions
  • Topic 4: Define a relationship's cardinality and cross-filter direction/ Publish, import, or update assets in a workspace
  • Topic 5: Evaluate and transform column data types/ Identify and connect to a data source
  • Topic 6: Apply sensitivity labels to workspace content/ Design a data model that uses a star schema
  • Topic 7: Identify poorly performing measures, relationships, and visuals/ Replace implicit measures with explicit measures
  • Topic 8: Reduce cardinality levels to improve performance/ Create model calculations by using DAX
  • Topic 9: Configure row-level security group membership/ Choose an appropriate visualization type
  • Topic 10: choose an appropriate visualization type/ Get data from different data sources
  • Topic 11: Group and layer visuals by using the selection pane/ Implement row-level security roles
  • Topic 12: Choose when to use a paginated report/ Configure table and column properties
  • Topic 13: Edit and configure interactions between visuals/ Drilldown into data using interactive visuals
  • Topic 14: Choose between continuous and categorical axes/ Format and configure visualizations
  • Topic 15: Add a Quick Insights result to a dashboard/ Configure subscriptions and data alerts

Free Microsoft PL-300 Exam Actual Questions

The questions for PL-300 were last updated On Mar. 14, 2023

Question #1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

From Power Query Editor, you profile the data shown in the following exhibit.

The IOT ID columns are unique to each row in query.

You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.

Solution: You change the IOT DateTime column to the Date data type.

Does this meet the goal?

Reveal Solution Hide Solution
Correct Answer: A

Question #2

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

You add the following fields to the Explain By field:

* Customer Country

* Product Category

* Supplier Country

* Sales Employee

* Supplier Name

* Product Name

* Customer City

The key influencers visual returns the results shown in the following exhibit.

What can you identify from the visual?

Reveal Solution Hide Solution
Correct Answer: A

Question #3

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

Due Date

Order Date

Delivery Date

You need to support the analysis of sales over time based on all the date foreign keys.

Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.

Does this meet the goal?

Reveal Solution Hide Solution
Correct Answer: B

You can reference an inactive relationship whit DAX function USERELATIONSHIP(), but using DAX is not mentioned here.

So follow this refactory methodology:

Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query.

Source: https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive


Question #4

You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

You add the following fields to the Explain By field:

* Customer Country

* Product Category

* Supplier Country

* Sales Employee

* Supplier Name

* Product Name

* Customer City

The key influencers visual returns the results shown in the following exhibit.

What can you identify from the visual?

Reveal Solution Hide Solution
Correct Answer: A

Question #5

The table has the following columns.

You need to add a column that will be used to sort the Year Month column chronologically.

Reveal Solution Hide Solution
Correct Answer: A, D

Answer as.

You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.

The dataset must be refreshed daily.

You need to ensure that the Power BI service can connect to the database and refresh the dataset.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?



Unlock all PL-300 Exam Questions with Advanced Practice Test Features:
  • Select Question Types you want
  • Set your Desired Pass Percentage
  • Allocate Time (Hours : Minutes)
  • Create Multiple Practice tests with Limited Questions
  • Customer Support
Get Full Access Now
Disscuss Microsoft PL-300 Topics, Questions or Ask Anything Related

Save Cancel