Microsoft Power BI Data Analyst (PL-300)

You have a folder that contains 100 CSV files.

You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files.

Which three 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 order.

Select and Place:

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?

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales.

You need to create a measure that calculates the total sales from the equivalent month of the previous year.

How should you complete the calculation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

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?

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: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date.

Does this meet the goal?

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: 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.

Does this meet the goal?

You are creating a Power BI model and report.

You have a single table in a data model named Product. Product contains the following fields:

✑ ID

✑ Name

✑ Color

✑ Category

✑ Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

How should you complete the DAX expression? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Select and Place:

You are creating a sales report in Power BI for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:

✑ The count of orders and the sum of total sales by Order Date

✑ The count of customers who placed an order

✑ The average quantity per order

You need to reduce data refresh times and report query times.

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

NOTE: Each correct selection is worth one point.

You are creating a Power BI model that contains a table named Store. Store contains the following fields.

You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City.

What should you do to ensure that the locations are mapped properly?

You are building a data model for a Power BI report.

You have data formatted as shown in the following table.

You need to create a clustered bar chart as shown in the following exhibit.

What should you do?

You need create a date table in Power BI that must contain 10 full calendar years, including the current year.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Select and Place:

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: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table.

Does this meet the goal?

You have a Power BI report that contains a measure named Total Sales.

You need to create a new measure that will return the sum of Total Sales for a year up to a selected date.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You are modifying a Power BI model by using Power BI Desktop.

You have a table named Sales that contains the following fields.

You have a table named Transaction Size that contains the following data.

You need to create a calculated column to classify each transaction as small, medium, or large based on the value in Sales Amount.

How should you complete the code? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.

You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

You have a Power BI report for the procurement department. The report contains data from the following tables.

There is a one-to-many relationship from Suppliers to LineItems that uses the ID and Supplier ID columns.

The report contains the visuals shown in the following table.

You need to minimize the size of the dataset without affecting the visuals.

What should you do?

You have a Power BI report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns.

The report contains the visuals shown in the following table.

The dataset takes a long time to refresh.

You need to modify Posts and Traffic queries to reduce load times.

Which two actions will reduce the load times? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

You plan to build a data model for a Power BI report.

You need to prepare the data so that it is available to the model in the format shown in the following table.

Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

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.

You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA.

You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA.

Which three 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 order.

Select and Place:

You have a Power BI report. The report contains a visual that shows gross sales by date. The visual has anomaly detection enabled.

No anomalies are detected.

You need to increase the likelihood that anomaly detection will identify anomalies in the report.

What should you do?

You have a dataset that has the permissions shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

You have the Power Bl dashboard shown in the Dashboard exhibit (Click the Dashboard tab)

You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit (Click the Mobile tab.)

What should you do? To answer, select the appropriate options in the answer area.

NOTE. Each correct selection is worth one point.

Hot Area:

In Power Bl Desktop, you are creating visualizations in a report based on an imported dataset.

You need to allow Power Bl users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data.

What should you do?

You have a Power Bl workspace named Bl Data that contains a dataset named Bl Finance.

You have the Build permission for the Bl Finance dataset. but you do NOT have permissions for the workspace.

You need to connect to Bl Finance and create a report.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You have the Power Bl data model shown in the following exhibit.

The Country table contains the following data.

You create two row-level security (RLS) roles named Manager and CFO.

You plan to publish the dataset to the Power Bl service.

You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

Each manager must see only the data in the Sales and Human Resources tables for their own country.

The CFO must be prevented from seeing the data in the Human Resources table.

The CFO must see the sales data of all countries.

How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

You have a Power Bl dataset and a connected report.

You need to ensure that users can analyze data in Microsoft Excel only by connecting directly to the dataset.

You grant the users the Build permission for the dataset.

What should you do next?

You have a Power Bl report named Report1 and a dashboard named Dashboard1. Report1 contains a line chart named Sales by month.

You pin the Sales by month visual to Dashboard1.

In Report1, you change the Sales by month visual to a bar chart.

You need to ensure that the bar chart displays on Dashboard1.

What should you do?

You build a Power Bl report that displays IoT temperature data streaming from a refrigerator.

You publish the report to the Power Bl service.

You need to be notified when the temperature rises above four degrees Celsius.

What should you do?

You use Power Bl Desktop to create a Power Bl data model and a blank report.

You need to add the Word Cloud visual shown in the following exhibit to the report.

The solution must minimize development effort.

Which three 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 order.

Select and Place:

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 GUID and IoT ID columns are unique to each row in the query.

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

Solution: You remove the IoT GUID column and retain the IoT ID column.

Does this meet the goal?

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 GUID and IoT ID columns are unique to each row in the query.

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

Solution: You create a custom column that concatenates the IoT GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.

Does this meet the goal?

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 GUID and IoT ID columns are unique to each row in the query.

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

Solution: You split the IoT DateTime column into a column named Date and a column named Time.

Does this meet the goal?

You receive annual sales data that must be included in Power Bl reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

You need to create a report that meets the following requirements:

• Visualizes the Sales value over a period of years and months
• Adds a slicer for the month
• Adds a slicer for the year

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

You have a Power Bl report that contains four pages.

All the pages contain a slicer for a field named Country.

You need to ensure that when a user selects a country on page 1, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages.

What should you do?

You have the Power Bl data model shown in the following exhibit.

You need to create a measure to count the number of product categories that had products sold during a selected period.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have a Power Bl report that contains one page. The page contains two lines charts and one bar chart.

You need to ensure that users can perform the following tasks for all three visuals:

• Switch measures used in the visuals.
• Change the visualization type.
• Add a legend.

The solution must minimize development effort.

What should you do?

You have the dashboard shown in the following exhibit.

You need to modify the dashboard to display as shown in the following exhibit.

What should you do?

You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate for font size color. and bar chart formatting.

What should you do?

-

You have a Power BI visual that uses indicators to show values that are out of range as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

You maintain a Power BI workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.

The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

You need to modify the dashboard mobile layout to meet the following requirements:

✑ Only show single-value visuals.

✑ Minimize scrolling.

What should you do?

You attempt to connect Power Bl 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?

You are creating a Power Bl report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend.

You need to include a visual that identifies which fields have the greatest impact on Spend.

Which type of visual should you use?

You have a Power Bl data model that analyzes product sales over 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 is 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? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

You need to create a measure that will return the percentage of late orders.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have the Power Bl data model shown in the following exhibit.

The Sales table has the following columns.

The data model must support the following analysis:

Total sales by product by month in which the order was placed

Quantities sold by product by day on which the order was placed

Number of sales transactions by quarter in which the order was placed

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area:

You have a Power Bl report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to 5.

You need to format the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.

Which three actions should you perform in sequence in Power Bl Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Select and Place:

You have a Power Bl model that contains a table named Date.

The table has the following columns.

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

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You have a Power Bl report that contains five pages.

Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

You have a Power Bl model that contains a table named Employee. The table contains the following data.

Each employee has one manager as shown in the ParentEmployeelD column.

All reporting paths lead to the CEO at the top of the organizational hierarchy.

You need to create a calculated column that returns the count of levels from each employee to the CEO.

Which DAX expression should you use?

You have a Power Bl data model that contains two tables named Products and Sales.

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

You have a report that contains a report-level filter for Products.

You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total.

How should you complete the DAX measure? To answer, drag the appropriate DAX functions to the correct targets. Each function may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Select and Place:

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?

You r powerbi.com.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Hot Area:

You need to get data from the Microsoft SQL Server tables.

What should you use to configure the connection?

You have a column named UnitsInStock as shown in the following exhibit.

UnitsInStock has 75 non-null values, of which 51 are unique.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

You have two Power Bl workspaces named WorkspaceA and WorkspaceB. 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.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

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 GUID and IoT ID columns are unique to each row in the query.

You need to analyze IoT 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?

You have a Power BI report.

You have a table named Data1 that contains 10 million rows.

Data1 is used in the following visuals:

✑ A card that shows the number of records

✑ A bar chart that shows total transaction amount by territory

✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory.

You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.

What should you do?

You are creating a line chart in a Power BI report as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

You are using Power Bl Desktop to connect to an Azure SQL database.

The connection is configured as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct solution is worth one point.

Hot Area:

From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR.

You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.

What should you do?

You have a Power Bl data model that contains a table named Stores. The table has the following columns:

Store Name

Open Date

Status

State

City

You need to create a calculated column named Active Store Name that meets the following requirements:

When the value of the Status column is the value in the Store Name column must be returned.

When the value of the Status column is NOT “A", the value in the Store Name column that is prefixed with "Inactive - " must be returned.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.