PL-300: Microsoft Power BI Data Analyst

Question #: 9
Topic #: 15
You need to create the dataset.
Which dataset mode should you use?

A. Import
B. DirectQuery
C. Composite
D. live connection

Selected Answer: A

Question #: 10
Topic #: 2
You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?

A. In the report, add a DAX calculated column that calculates the length of col1
B. In the report, add a DAX function that calculates the average length of col1
C. From Power Query Editor, add a column that calculates the length of col1
D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

Selected Answer: D

Question #: 11
Topic #: 7
You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.
What should you set as the relationship cardinality?

A. One to one
B. Many to many
C. Many to one
D. One to many

Selected Answer: D

Question #: 12
Topic #: 8
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?

A. a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id] B. a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id] C. an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id] D. an additional date table named ShipDate, a one-to-many relationship from Date[date_id] to Sales[sales_date_id], and a one-to-many relationship from ShipDate[date_id] to Sales[sales_skip_date_id]

Selected Answer: D

Question #: 13
Topic #: 6
You need to create the required relationship for the executive’s visual.
What should you do before you can create the relationship?

A. Change the data type of Sales[region_id] to Whole Number.
B. Change the data type of Sales[region_id] to Decimal Number.
C. In the Sales table, add a measure for Sum(sales_amount).
D. Change the data type of Sales[sales_id] to Text.

Selected Answer: A

Question #: 14
Topic #: 10
You need to update the Power BI model to ensure that the analysts can quickly build drill-downs from business unit to product in a visual.
What should you create?

A. a group
B. a calculated table
C. a hierarchy
D. a calculated column

Selected Answer: C

Question #: 18
Topic #: 1
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?

A. Microsoft Teams Personal Analytics
B. SQL Server database
C. Dataverse
D. Dataflows

Selected Answer: C

Question #: 19
Topic #: 3
You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.
You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.
How should the visual interactions be set on the column chart when the bar chart is selected?

A. highlight
B. filter
C. no impact

Selected Answer: A

Question #: 20
Topic #: 6
You need to get data from the Microsoft SQL Server tables.
What should you use to configure the connection?

A. Import that uses a Microsoft account
B. Import that uses a database credential
C. DirectQuery that uses a database credential
D. DirectQuery that uses the end-user’s credentials

Selected Answer: D

Question #: 21
Topic #: 11
You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.
Which type of visualization should you create?

A. pie chart
B. scatterplot
C. bar chart

Selected Answer: C

Question #: 22
Topic #: 2
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.

Selected Answer: A

Question #: 23
Topic #: 13
What should you create to meet the reporting requirements of the sales department?

A. a measure column that uses the following formula: SUMX(FILTER(‘Sales’, ‘Sales'[sales_amount] > 0)),[sales_amount])
B. a calculated column that uses the following formula: ABS(Sales[sales_amount])
C. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
D. a measure that uses the following formula: SUM(Sales[sales_amount])

Selected Answer: A

Question #: 24
Topic #: 15
You need to configure access for the sales department users. The solution must the meet the security requirements.
What should you do?

A. Share each report to the Azure Active Directory group of the sales department.
B. Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.
C. Distribute an app to the users in the Azure Active Directory group of the sales department.
D. Add the sales department as a member of the reports workspace.

Selected Answer: D

Question #: 25
Topic #: 8
You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?

A. Create a security role that has a table filter on the Sales Manager table where username = UserName().
B. Create a security role that has a table filter on the Sales Manager table where username = sales_manager_id.
C. Create a security role that has a table filter on the Region Manager table where sales_manager_id = UserPrincipalName().
D. Create a security role that has a table filter on the Sales_Manager table where name = UserName().

Selected Answer: A

Question #: 26
Topic #: 4
You have a Power BI tenant.
You have reports that use financial datasets and are exported as PDF files.
You need to ensure that the reports are encrypted.
What should you implement?

A. Microsoft Intune policies
B. row-level security (RLS)
C. sensitivity labels
D. dataset certifications

Selected Answer: C

Question #: 29
Topic #: 1
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.
The data model contains several measures.
You need to create a Power BI report from the existing data. The solution must minimize development effort.
Which type of data source should you use?

A. Power BI dataset
B. a SharePoint folder
C. Power BI dataflows
D. an Excel workbook

Selected Answer: A

Question #: 30
Topic #: 14
You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.
What should you do?

A. From each report in powerbi.com, select Refresh visuals.
B. From Power BI Desktop, download the PBIX file and refresh the data.
C. Configure a scheduled refresh without using an on-premises data gateway.
D. Configure a scheduled refresh by using an on-premises data gateway.

Selected Answer: C

Question #: 31
Topic #: 3
A user creates a Power BI report named ReportA that uses a custom theme.
You create a dashboard named DashboardA.
You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Publish ReportA to Power BI.
B. From ReportA save the current theme.
C. Publish ReportA to the Microsoft Power BI Community theme gallery.
D. From DashboardA, create a custom theme.
E. From DashboardA, upload a JSON theme.

Selected Answer: BE

Question #: 32
Topic #: 2
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

Selected Answer: D

Question #: 33
Topic #: 9
You need to minimize the size of the dataset. The solution must meet the report requirements.
What should you do?

A. Group the Categories table by the CategoryID column.
B. Remove the QuantityPerUnit column from the Products table.
C. Filter out discontinued products while importing the Products table.
D. Change the OrderID column in the Orders table to the Text data type.

Selected Answer: B

Question #: 34
Topic #: 4
You have a Microsoft Excel file on a file server.
You create a Power BI report and import a table from the Excel file.
You publish the report.
You need to ensure that the data refreshes every four hours.
What should you do first?

A. Upload the Excel file to a Power BI workspace.
B. Create a subscription to the report.
C. Deploy an on-premises data gateway.
D. Edit the data source credentials.

Selected Answer: C

Question #: 35
Topic #: 8
You merge data from Sales_Region, Region_Manager, Sales_Manager, and Manager into a single table named Region.
What should you do next to meet the reporting requirements of the executives?

A. Create a DAX calculated column that retrieves the region manager from the Weekly_Returns table based on the sales_region_id column.
B. Apply row-level security (RLS) to the Region table based on the sales manager username.
C. Configure a bi-directional relationship between Region and Sales_Region.
D. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Selected Answer: D

Question #: 36
Topic #: 1
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
✑ Customer ID
✑ Customer Name
✑ Phone
✑ Email Address
✑ Address ID
Address contains the following columns:
✑ Address ID
✑ Address Line 1
✑ Address Line 2
✑ City
✑ State/Region
✑ Country
✑ Postal Code
Each Customer ID represents a unique customer in the Customer table. Each Address ID represents a unique address in the Address table.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

A. Merge the Customer and Address tables.
B. Group the Customer and Address tables by the Address ID column.
C. Transpose the Customer and Address tables.
D. Append the Customer and Address tables.

Selected Answer: A

Question #: 37
Topic #: 14
What is the minimum number of Power BI datasets needed to support the reports?

A. a single imported dataset
B. two imported datasets
C. two DirectQuery datasets
D. a single DirectQuery dataset

Selected Answer: B

Question #: 38
Topic #: 3
You need to create a visualization that compares revenue and cost over time.
Which type of visualization should you use?

A. waterfall chart
B. stacked area chart
C. line chart
D. donut chart

Selected Answer: B

Question #: 39
Topic #: 9
You need to design the data model to meet the report requirements.
What should you do in Power BI Desktop?

A. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.
B. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
C. From Power BI Desktop, use the Auto date/time option when creating the reports.
D. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

Selected Answer: A

Question #: 40
Topic #: 7
Which DAX expression should you use to get the ending balances in the balance sheet reports?

A. CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), LASTDATE ( ‘Date'[Date] ) )
B. CALCULATE ( SUM( BalanceSheet[BalanceAmount] ), DATESQTD(‘Date'[Date]) )
C. FIRSTNONBLANK (‘Date'[Date] SUM( BalanceSheet[BalanceAmount] ) )
D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE (‘Date'[Date] ))

Selected Answer: B

Question #: 41
Topic #: 2
You have a Power BI query named Sales that imports the columns shown in the following table.

Users only use the date part of the Sales_Date field. Only rows with a Status of Finished are used in analysis.
You need to reduce the load times of the query without affecting the analysis.
Which two actions achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Remove the rows in which Sales[Status] has a value of Canceled.
B. Remove Sales[Sales_Date].
C. Change the data type of Sale[Delivery_Time] to Integer.
D. Split Sales[Sale_Date] into separate date and time columns.
E. Remove Sales[Canceled Date].

Selected Answer: AE

Question #: 42
Topic #: 4
You have a dataset that is used infrequently and refreshes every hour.
You receive a notification that the refresh was disabled due to inactivity.
Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Enable query caching for the dataset.
B. Import the dataset to Microsoft Excel.
C. From the Power BI service, open a dashboard that uses the dataset.
D. From the Power BI service, open a report that uses the dataset.
E. From PowerShell, run the get-powerbireport cmdlet.

Selected Answer: CD

Question #: 43
Topic #: 8
What should you create to meet the reporting requirements of the sales department?

A. a measure that uses a formula of COUNTROWS(Sales)
B. a calculated column that use a formula of COUNTA(Sales[sales_id])
C. a calculated column that uses a formula of SUM(Sales[sales_id])
D. a measure that uses a formula of SUM(Sales[sales_id])

Selected Answer: A

Question #: 47
Topic #: 2
You build a report to analyze customer transactions from a database that contains the tables shown in the following table.

You import the tables.
Which relationship should you use to link the tables?

A. one-to-many from Transaction to Customer
B. one-to-one between Customer and Transaction
C. many-to-many between Customer and Transaction
D. one-to-many from Customer to Transaction

Selected Answer: D

Question #: 48
Topic #: 4
You have a Power BI workspace that contains a dataset, a report, and a dashboard. The following groups have access:
✑ External users can access the dashboard.
✑ Managers can access the dashboard and a manager-specific report.
✑ Employees can access the dashboard and a row-level security (RLS) constrained report.
You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.
What should you use?

A. comments
B. chat in Microsoft Teams
C. alerts
D. subscriptions

Selected Answer: A

Question #: 49
Topic #: 8
What should you do to address the existing environment data concerns?

A. a calculated column that uses the following formula: ABS(Sales[sales_amount])
B. a measure that uses the following formula: SUMX(FILTER(‘Sales’, ‘Sales'[sales_amount] > 0)),[sales_amount])
C. a measure that uses the following formula: SUM(Sales[sales_amount])
D. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

Selected Answer: B

Question #: 51
Topic #: 3
You build a report to help the sales team understand its performance and the drivers of sales.
The team needs to have a single visualization to identify which factors affect success.
Which type of visualization should you use?

A. Key influencers
B. Line and clustered column chart
C. Q&A
D. Funnel chart

Selected Answer: A

Question #: 52
Topic #: 2
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

A. From Model view, set the Subject and Body columns to Hidden.
B. Remove the Subject and Body columns during the import.
C. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Selected Answer: B

Question #: 53
Topic #: 8
You need to create a calculated column to display the month based on the reporting requirements.
Which DAX expression should you use?

A. FORMAT(‘Date'[date],”MMM YYYY”)
B. FORMAT(‘Date'[date_id],”MMM”) & ” ” & FORMAT(‘Date'[year], “#”)
C. FORMAT(‘Date'[date_id],”MMM YYYY”)
D. FORMAT(‘Date'[date],”M YY”)

Selected Answer: A

Question #: 54
Topic #: 4
You have a PBIX file that imports several tables from an Azure SQL database.
The data will be migrated to another Azure SQL database.
You need to change the connections in the PBIX file. The solution must minimize administrative effort.
What should you do?

A. From Power Query Editor, create new queries.
B. From Power Query Editor, modify the source of each query.
C. Create a PBIT file, open the file, and change the data sources when prompted.
D. Modify the Data source settings.

Selected Answer: D

Question #: 57
Topic #: 1
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.

Selected Answer: D

Question #: 58
Topic #: 4
You have a Power BI workspace that contains several reports.
You need to provide a user with the ability to create a dashboard that will use the visuals from the reports.
What should you do?

A. Create a row-level security (RLS) role and add the user to the role.
B. Share the reports with the user.
C. Grant the Read permission for the datasets to the user.
D. Add the user as a member of the workspace.
E. Add the user as a Viewer of the workspace.

Selected Answer: D

uestion #: 60
Topic #: 2
You have the Power BI model shown in the following exhibit.

A manager can represent only a single country.
You need to use row-level security (RLS) to meet the following requirements:
✑ The managers must only see the data of their respective country.
✑ The number of RLS roles must be minimized.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.
B. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.
C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.
D. Create one role for each country.
E. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Selected Answer: AC

Question #: 61
Topic #: 3
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?

A. Customers in Austria order 18.8 more units than the average order quantity.
B. Customers in Boise order 20.37 percent more than the average order quantity.
C. Product Category positively influences the quantity per order.
D. Customers in Cork order lower quantities than average.

Selected Answer: A

Question #: 62
Topic #: 1
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.

Selected Answer: A