PL-300 Exam Questions Tutorials

In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.

What should you do?

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the data, which would likely prevent the errors you encountered in the Power BI semantic model.

You have a Power BI data model 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 three dates at the same time.

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

Does this meet the goal?

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

Which data modeling design should you use?

You have a Power Bl semantic model that contains two queries.

You discover that a report based on the model has performance issues.

You plan to use Power Query to reduce the data loaded to the model.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.