Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test

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 need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

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

NOTE: Each correct selection is worth one point.

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?

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

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?

What is the minimum number of datasets and storage modes required to support the reports?

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.

How should you complete the measure? 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.

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to grant access to the business unit analysts.

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

NOTE: Each correct selection is worth one point.

Which DAX expression should you use to get the ending balances in the balance sheet reports?

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

You publish the dataset to 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.

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

What should you create to meet the reporting requirements of the sales department?

You publish the semantic model to 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.

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

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 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, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.

NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

You have a Power Bl report.

You have the following tables.

You have the following DAX measure.

You have a Power Bl semantic model that contains the data sources shown in the following table.

You need to configure the privacy levels of the data sources.

What should you configure (01 each data source? To answer, select (he appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:

* WebsiteName

* URL

You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements.

* Display the website name

* Enable users to navigate to the website’s URL by selecting the website name.

What should you use?

Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

You need to shape the query to display the following three columns:

* Month

* Sales

* Year

‘What should you select in Power Query Editor?

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?

You have a semantic model that connects to a streaming data source. The data source is updated frequently. You need to create a Power B1 report that meets the following requirements:

• Supports real-time analytics

• Minimizes performance impact on the data source

• Displays the most recent data without performing a data refresh

Which connectivity mode should you use for the dataset?

You are using Power Bi 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

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

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.

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 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?

You plan to create a report that will display sales data from the last year for multiple regions

You need to restrict access to individual rows of the data on a per region-basis by using roles.

Which four 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.

You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

A line chart that shows the number of defective products manufactured by day.

A KPI visual that shows the current daily percentage of defective products manufactured.

You need to be notified when the daily percentage of defective products manufactured exceeds 3%.

What should you create?

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 dataset named Pens that contains the following columns:

Item

Unit Price

Quantity Ordered

You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are creating a Power Bi report that will contain multiple visuals. Vou need to ensure that the report Is accessible to users who use a screen reader. Which two configurations should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You create a Power Bl dataset that contains the table shown in the following exhibit.

You need to make the table available as an organizational data type In Microsoft Excel.

How should you configure the properties of the table? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

The related dimension tables are imported into the model.

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

NOTE: Each correct selection is worth one point.

You need to create a Power BI report. The first page of the report must contain the following two views:

*Sales By Postal Code

*Sales by Month

Both views must display a slicer to select a value for a field named Chain.

The Sales By Postal Code view must display a map visual as shown in the following exhibit.

The Sales By Month view must display a column chart visual as shown in the following exhibit.

Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views.

What is the minimum number of bookmarks required, and which property should you apply to each bookmark? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You use Power Query Editor to review the query shown in the following exhibit.

You have a Power Bl app that contains a report named Report1.

You add a new page to Report1.

You need to ensure that users can view the new page. The solution must minimize administrative effort.

What should you do?

You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.

You are creating a Power Bl dashboard that will include two visuals from each report

You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.

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

NOTE: Each correct selection is worth one point.

You plan to use Power Bl Desktop to create a bog tracking dashboard that will pull data from Analytics in Azure DevOps.

From Power Bl Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:

• Use Analytics views.

• Filter data from the cloud.

Which connector should you use?

You need to create a visual as shown in the following exhibit.

The indicator color for Total Sales will be based on % Growth to Last Year.

The solution must use the existing calculations only.

How should you configure the visual? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You use Power 81 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.

You view a query named Transactions as shown in the following exhibit.

The query gets CSV files from a folder.

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.

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

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?

You attempt to connect Purer 81 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 of connector should you choose?

You have a Power 81 report. The report contains a single report page that uses the detault theme.

You need to configure the report page to match the formatting shown in the following exhibit.

What should you change on the report page?

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

• If the discount column returns an error, a discount of 0.05 must be used.

• All the rows of data must be maintained.

• Administrative effort must be minimized.

What should you do in Power Query Editor?

You have the tables shown in the following table.

The Impressions table contains approximately 30 million records per month.

You need to create an ad analytics system to meet the following requirements:

Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.

Minimize the data model size.

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 collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each 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?

You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column.

You need to create a report that will contain the visual shown in the following exhibit.

The solution must NOT require additional DAX measures.

Which type of visual should you use?