PL-300: Microsoft Power BI Data Analyst

Question #: 144
Topic #: 3
You have a line chart that shows the number of employees in a department over time.
You need to see the total salary costs of the employees when you hover over a data point.
What should you do?

A. Add salary to the drillthrough fields.
B. Add salary to the visual filters.
C. Add salary to the tooltips.

Selected Answer: C

Question #: 145
Topic #: 1
You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

A. Merge queries
B. Combine files
C. Append queries

Selected Answer: A

Question #: 146
Topic #: 4
You have a Power BI 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?

A. Certify the dataset used by the report.
B. Change the default visual interaction for the report.
C. For the report, change the Export data setting to None.
D. For the report, change the Export data setting to Summarized data, data with current layout and underlying data.

Selected Answer: C

Question #: 148
Topic #: 1
You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
B. Change the data type of the Logged column to Date.
C. Split the Logged column by using at as the delimiter.
D. Apply the Parse function from the Date transformations options to the Logged column.

Selected Answer: C

Question #: 149
Topic #: 3
You have the visual shown in the Original exhibit. (Click the Original tab.)

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

What should you add to the visual?

A. a measure
B. an Average line
C. a trendline
D. a forecast

Selected Answer: D

Question #: 150
Topic #: 2
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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.
During the development process, you need to import a sample of the data from the Order table.
Solution: You add a report-level filter that filters based on the order date.
Does this meet the goal?

A. Yes
B. No

Selected Answer: B

Question #: 151
Topic #: 1
You have a PBIX file that imports data from a Microsoft Excel data source stored in a file share on a local network.

You are notified that the Excel data source was moved to a new location.

You need to update the PBIX file to use the new location.

What are three ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. From the Datasets settings of the Power BI service, configure the data source credentials.
B. From the Data source settings in Power BI Desktop, configure the file path.
C. From Current File in Power BI Desktop, configure the Data Load settings.
D. From Power Query Editor, use the formula bar to configure the file path for the applied step.
E. From Advanced Editor in Power Query Editor, configure the file path in the M code.

Selected Answer: BDE

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

A. Yes
B. No

Selected Answer: B

Question #: 154
Topic #: 4
You have a Power BI workspace named BI Data that contains a dataset named BI Finance.

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

You need to connect to BI 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.

A. From the Power BI service, create a dataflow to the dataset by using DirectQuery.
B. From Power BI Desktop, connect to a Dataverse data source.
C. From the Power BI service, create a new report and select a published dataset.
D. From Power BI Desktop, connect to a shared dataset.

Selected Answer: CD

Question #: 155
Topic #: 3
You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

Which type of visual should you use?

A. smart narrative
B. decomposition tree
C. Q&A
D. key influencers

Selected Answer: B

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

A. Yes
B. No

Selected Answer: A

Question #: 157
Topic #: 3
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible.
What should you do?

A. Create a new aggregation that summarizes by state.
B. Create a new aggregation that summarizes by employee.
C. Create a new group on the state column and set the Group type to List.
D. Create a new group on the state column and set the Group type to Bin.

Selected Answer: C

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

A. Yes
B. No

Selected Answer: A

Question #: 159
Topic #: 3
You have a collection of reports for the HR department of your company.
You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.
Which type of visualization should you use?

A. ribbon chart
B. scatter chart
C. line chart
D. key influencers

Selected Answer: C

Question #: 161
Topic #: 3
You have a Microsoft Power BI dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source.
The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

A. A new transaction was added to the data source.
B. The dashboard tile cache refreshed.
C. A user added a comment to a tile.
D. A user pressed F5.

Selected Answer: B

Question #: 168
Topic #: 3
You are building a Power BI report to analyze customer segments.
You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.
Which type of visualization should you use?

A. decomposition tree
B. funnel chart
C. Q&A
D. key influencers

Selected Answer: A

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

A. Set the data type for SalesOrderNumber to Decimal Number.
B. Remove the CustomerKey and ProductKey columns.
C. Remove the TaxAmt and Freight columns.
D. Filter the data to only the NorthWest region sales territory.

Selected Answer: CD

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

A. Change the data type of City, State/Province, and Country.
B. Set Summarization for City, State/Province, and Country to Don’t summarize.
C. Set the data category of City, State/Province, and Country.
D. Create a calculated column that concatenates the values in City, State/Province, and Country.

Selected Answer: C

Question #: 171
Topic #: 3
You have a table that contains sales data and approximately 1,000 rows.
You need to identify outliers in the table.
Which type of visualization should you use?

A. area chart
B. scatter plot
C. pie chart
D. donut chart

Selected Answer: B

Question #: 172
Topic #: 3
You have a report that contains three pages. One of the pages contains a KPI visualization.
You need to filter all the visualizations in the report except for the KPI visualization.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Edit the interactions of the KPI visualization.
B. Add the same slicer to each page and configure Sync slicers.
C. Edit the interactions of the slicer that is on the same page as the KPI visualization.
D. Configure a page-level filter.
E. Configure a report-level filter.

Selected Answer: BC

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

A. From Power Query Editor, split the Machine-User column by using a delimiter.
B. From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
C. In a DAX function, create two calculated columns named Machine and User by using the SUBSTITUTE function.
D. In a DAX function, create two measures named Machine and User by using the SUBSTITUTE function.

Selected Answer: A

Question #: 176
Topic #: 3
You are creating a Power BI 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?

A. Q&A
B. smart narrative
C. decomposition tree
D. key influencers

Selected Answer: D

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

A. Yes
B. No

Selected Answer: B

Question #: 181
Topic #: 3
You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

What should you do?

A. Change the report theme.
B. Change the dashboard theme.
C. Edit the details of each tile.
D. Create a custom CSS file.

Selected Answer: B

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

A. Increase the Expected range transparency setting.
B. Add a data field to the Legend field well.
C. Increase the Sensitivity setting.
D. Add a data field to the Secondary values field well.

Selected Answer: C

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

A. Merge Suppliers and LineItems.
B. Remove the LineItems[Description] column.
C. Remove the rows from LineItems where LineItems[Invoice Date] is before the beginning of last month.
D. Group LineItems by LineItems[Invoice ID] and LineItems[Invoice Date] with a sum of LineItems[Price].

Selected Answer: B

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

A. Decrease the size of the card visuals. Remove the map and bar chart visuals.
B. Decrease the size of the map and bar chart visuals. Move all the card visuals to the top of the layout.
C. Remove the card visuals. Increase the size of the map and bar chart visuals.
D. Move the bar chart visuals to the top of the layout. Remove the map visuals. Decrease the size of the card visuals.

Selected Answer: A

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

A. Remove the rows in Posts in which Posts[Publish Date] is in the last seven days.
B. Remove the rows in Traffic in which Traffic[URL Visited] does not contain ג€blogג€.
C. Remove Traffic[IP Address], Traffic[Browser Agent], and Traffic[Referring URL].
D. Remove Posts[Full Text] and Posts[Summary].
E. Remove the rows in Traffic in which Traffic[Referring URL] does not start with ג€/ג€.

Selected Answer: BD

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

A. Add a count field of the transaction amount to the size bucket of the scatter plot.
B. Add a trend line to the scatter plot.
C. Enable high-density sampling on the scatter plot.
D. Apply a row filter to the Data1 query in Power Query Editor.

Selected Answer: C

Question #: 188
Topic #: 3
You have a Power BI workspace named Inventory that contains a dataset, a report, and a dashboard.
You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

A. Ask a question by using Q&A.
B. Hide the report page.
C. Pin the visual to the dashboard.
D. Use quick insights on the dashboard.
E. Add the visual to the report.

Selected Answer: AC

Question #: 189
Topic #: 2
You have the Power BI data model shown in the following exhibit.

The Sales table contains records of sales by day from the last five years up until today’s date.

You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.

Which DAX expression should you use?

A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
D. SUM(Sales[Sales])

Selected Answer: C

Question #: 191
Topic #: 2
You use Power BI Desktop to load data from a Microsoft SQL Server database.

While waiting for the data to load, you receive the following error.

You need to resolve the error.

What are two ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A. Reduce the number of rows and columns returned by each query.
B. Split log running queries into subsets of columns and use Power Query to merge the queries.
C. Use Power Query to combine log running queries into one query.
D. Disable query folding on long running queries.

Selected Answer: AB

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

A. Yes
B. No

Selected Answer: A

Question #: 193
Topic #: 3
You have a Power BI report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers.
You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only.
What should you do?

A. On each page, modify the interactions of the slicer.
B. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.
C. Sync the slicers on Page1 and Page3.

Selected Answer: C

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

A. Yes
B. No

Selected Answer: A

Question #: 195
Topic #: 3
You have a Power BI 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?

A. Add a blank button to page 1.
B. Add a page navigation button to page 1.
C. Create a bookmark for each page.
D. Add a bookmark navigation button to page 1.

Selected Answer: B

Question #: 196
Topic #: 3
You build a Power BI report that displays IoT temperature data streaming from a refrigerator.

You publish the report to the Power BI service.

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

What should you do?

A. Set an alert on a KPI visual in the report.
B. Pin a card visual to a dashboard and create a subscription.
C. Pin a card visual to a dashboard and set an alert on the tile.
D. Pin a report page to a dashboard and set an alert on the page.

Selected Answer: C

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

A. Yes
B. No

Selected Answer: B

Question #: 198
Topic #: 2
You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report.

You need to recommend a solution to improve the performance of the report.

What should you recommend?

A. Change any DAX measures to use iterator functions.
B. Remove unused columns from tables in the data model.
C. Replace the default visuals with AppSource visuals.
D. Increase the number of times that the dataset is refreshed.

Selected Answer: B

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

A. Create and apply a custom dashboard theme.
B. Change the colors of the visuals in the report.
C. Apply the Dark dashboard theme.
D. Upload a snapshot image of the dashboard.

Selected Answer: A