PL-300 exam preparation

You are building a Power BI report that uses data from an Azure SQL database named erp1. You import the following tables.

You need to perform the following analyses:

Orders sold over time that include a measure of the total order value;

Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report.
What should you do first?

• • A. From Power Query, merge the Order Line Items query and the Products query.

• • B. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.

• • C. Calculate the count of orders per product by using a DAX function.

• • D. From Power Query, merge the Orders query and the Order Line Items query.

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.
What should you do?

• A. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.

• B. Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

• C. Get data from a SharePoint folder, enter the site URL, and then select Combine & Load.

• D. Get data from a SharePoint list, enter the site URL, and then select Combine & Load.

You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in the State is shown in the following exhibit.
How many different values including nulls are in the State column?

• 4

• 65

• 69

• 73

Answer explanation

Note: Column Distribution allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values (total number of values that only appear once in a given column).

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

• • A. Add a SQL statement.

• • B. Set the Command timeout in minutes setting.

• • C. Set Data Connectivity mode to Import.

• D. Set Data Connectivity mode to DirectQuery.

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The
Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements:
✑ Minimize online processing operations.
✑ Minimize calculation times and render times for visuals.
✑ Include data from the current year, up to and including the previous day.
What should you do?

• • A. Create a dataflows connection that has DirectQuery mode selected.

• • B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.

• C. Create a dataflows connection that has Import mode selected and schedule a daily refresh. 

• • D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

You attempt to connect Power BI Desktop to a Cassandra database.
From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.You need to select an alternate data connector that will connect to the database.
Which type of connector should you choose?

• • A. Microsoft SQL Server database

• B. ODBC 

• • C. OLE DB

• • D. OData

From Power Query Editor, you attempt to execute a query and receive the following error message ->Datasource.Error: Could not find file.
What are two possible causes of the error? Each correct answer presents a complete solution.

• A. You do not have permissions to the file

• • B. An incorrect privacy level was used for the data source

• • C. The file is locked

• D. The referenced file was moved to a new location

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions.
Each sales region has an HR manager.
You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.
How should you provision access to the reports for the HR managers?

• A. Publish the reports in an app and grant the HR managers access permission

• • B. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace

• • C. Publish the reports to a different workspace other than the one hosting the datasets

• • D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?

• • A. Viewer

• • B. Admin

• • C. Contributor

• D. Member

Answer explanation

You have the Power BI model shown in the following exhibit. There are four departments in the Departments table. You need to ensure that users can see the data of their respective department only.
What should you do?

• • A. Create a slicer that filters Departments based on DepartmentID.

• B. Create a row-level security (RLS) role for each department, and then define the membership of the role. 

• C. Create a DepartmentID parameter to filter the Departments table

• • D. To the ConfidentialData table, add a calculated measure that uses the CURRENTGROUP DAX function.