PL-300 Microsoft Power BI Data Analyst Questions and Answers

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 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 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 dataset. Which dataset mode should you use?

You have a Power BI semantic model.

You discover that he semantic model contains values that display as errors.

You need to use data profiling feature in Power Query to preview the date and identify the issues.

What should you select to gain into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

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 address the data concerns before creating the data model. What should you do in Power Query Editor?

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

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

What should you create?

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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?

You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.

From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium

capacity.

You discover that the dataset refresh fails after the refresh runs out of resources.

What is a possible cause of the issue?

Vou have a Microsoft Power Bl Desktop report named Report! that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1.

You need to simplify the connection to the data source for User1.

Which type of file should you create?

You have a Microsoft Power Bl 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 custom 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?

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

What should you do?

You are using Microsoft Power Bl Desktop to profile data in Power Query Editor. Table data is displayed 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.

You are designing the data model for a Power Bl semantic model. You have the following tables in the star schema.

Which table is the fact table of the star schema, and which column in the Patient table is the surrogate key of the star schema? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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 have a semantic model named Model1.

You need to ensure that users can verify that the data in Model1 meets corporate standards. What should you do?

You a-e using Power Bl Desktop 10 profile data in Power Query Editor.

You need to review the percentage of errors and the maximum value of each column.

Which options should you use in Power Query Editor? To answer, drag the appropriate options to the correct requirements. Each option 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 open powerbi.com 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.

You have a Microsoft Power Bl workspace.

You need to grant the user capabilities shown in the following table.

The solution must use the principle of least privilege.

Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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 have a semantic model that contains a table named Employees. The table contains the following columns:

• Employee ID

• First Name

• Last Name

• Department

• Salary

Each employee is uniquely identified by using Employee ID.

You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.

Which DAX expression should you use?

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?

You have a Power B1 semantic model that contains a table named Item. The Item table contains a column named Quantity. You need to create a DAX query that meets the following requirements:

• The rank of items must be calculated according to the values in Quantity.

• Ranking must NOT be skipped if two or more items have the same value in Quantity.

• If an item is unfiltered, the total of Quantity must display a blank value.

How should you complete the DAX formula? 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 model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

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 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 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 have a Power B1 report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader. What should you configure on the bar chart?

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?

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.

Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:

Access a published Power BI app

Modify reports in an app workspace

Share dashboards created in My Workspace

You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible.

Which license should you identify for each task? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.

What should you do?

You manage a Power BI model has a table named Sales and product.

You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.

What should you do from Power BI Desktop?

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.

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?

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

You create a Power Bl report1 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 need to create a semantic model in Power 81 Desktop. The solution must meet the following requirements:

• The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order.

• The orders must be filtered to the selected CustomerlD value.

• Users must select the CustomerlD value from a list.

• The list of customers must come from an OData source.

Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

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?

You have a Power B1 model that contains a table named Date. The table has the following columns.

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 have multiple dashboards.

You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

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

You need to create a new measure that will return the sum of Total Sates 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.