Microsoft PL-300 - Microsoft Power BI Data Analyst

You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

• Create reports that use the HR dataset.

• Publish the reports to WorkspaceB.

• Prevent the ability to modify the HR dataset.

• Prevent the ability to add users to WorkspaceB.

You have a Power 81 semantic model that contains a table named Table1. Table1 runs in Import storage mode. You need to update the model to change the storage mode of Table1 to DirectQuery. What should you do?

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?

You hove a folder that contains 50 JSON files.

You need to use Power 81 Desktop to make the metadata ol the files available as a single semantic model. The solution must NOT store the data of the JSON files.

Which type of data source should you use. and which transformation should you perform? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are enhancing a Power BI model that has DAX calculations.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

Which DAX functions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You create a report by using Microsoft Power BI Desktop.

The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network.

You plan to publish the report to the Power BI Service.

What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

You need to create a calculated table that v/ill contain the following:

You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:

• Customer_Name

• Customer ID

• Website

The Contacts table contains the following columns:

• Contact ID

• Contact Email

• Contact Name

• Customer Name

A web-based contact form is used to fill the Contacts table. The data is not sanitized.

You need to create a merge for the Customer and Contacts tables.

What should you do?

You have a Rawer Bl report That imports a dace 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: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?