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

Drag and Drop Question
You are modeling data in table named SalesDetail by using Microsoft Power Bl.
You need to provide end users with access to the summary statistics about the SalesDetail data.
The users require insights on the completeness of the data and the value distributions.
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.

Drag and Drop Question
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.

Hotspot Question
You are using Performance analyzer to analyze the performance of a visual in a Power BI report.
You need to identify the following log information:
- The time spent to retrieve data from a source
- The time required to wait for other visuals to complete
Which task categories should you review? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

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?

You create a Power BI report named Summary1.
You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1.
Which two metrics display the execution duration in Performance analyzer? Each correct answer present part of the solution.
NOTE: Each correct answer is worth one point.

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

You have a Power BI 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 have the dataset shown in the following exhibit.

You need to ensure that the visual shows only the 10 cities that have the highest sales profit.
What should you do?

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.
You need to reduce the size of the data model.
What should you do?

You have a Power BI report that will be rendered on a vertical display.
You need to maximize the portion of the screen area used by the report.
What should you do?

You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.

You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?

You have a Power BI dataset that contains quarterly sales performance data.
You need to enable managers to review the data in a format that meets the following requirements:
- Is optimized for printing.
- Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.
What should you create?

Hotspot Question
You plan to use Power Query Editor to get data from an API.
The API returns a JSON response.
You have a username and password for the API.
Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Case Study 4 - Contoso Ltd 2
Overview
Contoso, Ltd. is a manufacturing company that produces sports equipment. Contoso holds quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including balance sheets and profit and loss statements for each of the company's four business units.
Existing Environment
Data and Sources
Data for the reports comes from the sources shown in the following table.

The balance sheet data is unrelated to the profit and loss results other than they both relate to dates.
Balance Sheet Data
The balance sheet data is imported and includes the final monthly balances of each account in the format shown in the following table.

The balance sheet data always includes a row for each account for each month.
Product Catalog Data
The product catalog shows how products roll up to product categories, which roll up to the business units. The product list is provided in the format shown in the following table.

Revenue data is provided at the date and product level. Expense data is provided at the date and department level.
Business Issues
Historically, it has taken two analysts a week to prepare the reports for the quarterly board meetings. Also, there is usually at least one issue each quarter where a value in a report is wrong because of a bad cell reference in an Excel formula. On occasion, there are conflicting results in the reports because the products and departments that roll up to each business unit are not defined consistently.
Requirements
Planned Changes
Contoso plans to automate and standardize the quarterly reporting process by using Power BI.
The company wants to reduce how long it takes to populate the reports to less than two days.
The company wants to create common logic for the business units, products, and departments.
The logic will be used across all reports, including but not limited to the quarterly reporting for the board.
Technical Requirements
Contoso wants the reports and datasets refreshed with minimum manual effort.
The company wants to provide the board with a single package of reports that will contain custom navigation and links to supplementary information.
Maintenance, including manually updating data and access, must be minimized as much as possible.
Security Requirements
The reports must be made available to the board from powerbi.com. An Azure Active Directory (Azure AD) group will be used to share information with the board.
Contoso identifies the following security requirements for analyst access:
- Analysts must be able to access all balance sheet and product catalog data.
- Analysts must be able to access only the profit and loss data of their respective business unit.
- Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board.
- Analysts must NOT be able to share the quarterly reports with anyone.
- Analysts must NOT be able to make new reports by using the balance sheet data.
Report Requirements
You plan to relate the balance sheet table to a date table in Power BI in a many-to-one relationship based on the last day of the month. At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
The date table will contain the columns shown in the following table.

The definitions and attributes for the products, departments, and business units must be consistent across all the reports.
The board must be able to get the following information from the quarterly reports:
- Revenue trends over time
- The ending balances of each account
- Changes in long-term liabilities from the previous quarter
- The percent of total revenue contributed by each product category
- A comparison of quarterly revenue versus the same quarter from the previous year
- The reports must be updated with the latest data by 5 AM each day.
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?