PL-300 Microsoft Power BI Data Analyst Questions and Answers

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 need to get data from the Microsoft SQL Server tables. What should you use to configure the connection'

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 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 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 have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?

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 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 use Power B1 Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share.

File1 Is moved to a different folder.

When you open RPT1 in Power B1 Desktop, you discover that the report displays outdated data.

You need to ensure that the data in File1 refreshes properly.

What should you do?

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 have an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You decrease the dashboard cache update frequency.

Does this meet the goat?

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.

You have the Performance analyzer results shown in the following exhibit.

You have a Power BI imported dataset that contains the data model 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 semantic model.

You need to configure row level security (RLS) to restrict data access for users that have the Viewer permissions.

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

You have a semantic model named Model1 that contains sales data.

You need to ensure that Modell is refreshed on the first day of each month to include last month's sales data. What should you configure?

You have a semantic mortal 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

NOTE: Each selection is worth one point.

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the data, which would likely prevent the errors you encountered in the Power BI semantic model.

You have a Power BI data model 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 three dates at the same time.

Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationships between sales table and the date table.

Does this meet the goal?

You need to create a relationship in the dataset for RLS.

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

NOTE: Each correct selection is worth one point.

You are profiling data by using Power Query Editor.

You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

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

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.

Does this meet the goal?

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.

Vou have a Power B1 semantic model that contains the following table named Employees.

An employee is considered active if the TermDate column for that employee contains no value.

You need to create a DAX measure that will count the number of active employees.

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 an app workspace named Retail Analysis in the Power BI service.

You need manage the members that have access to the app workspace.

What should you do?

You have a Power Bl report named Orders that supports the following analysis:

• Total sales over time

• The count of orders over time

• New and repeat customer counts

The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.

You plan to generate a line chart to visualize and compare the last six You need to Increase the accessibility of the visual. What should you do? O A- A. Configure a unique marker for each series

B. Configure a distinct color for each series.

C. Replace long text with abbreviation and acronyms.

D. Move important Information to a tooltip.

You have the Power BI data model 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 sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

Which data modeling design should you use?

You have an on-premises Power BI Report Server.

You plan to create a report in Power BI Desktop and publish the report to the report server.

Which data source should the report use?

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 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 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 is possible way to achieve this goal?

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product.

The Sales table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.

Which data modeling design should you use?

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

No anomalies ate detected

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

What should you do?

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 have a Power B1 report that contains the fields 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.

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

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?

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

What should you do?

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?

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

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?

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

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 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 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 need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

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 create a solution to meet the notification requirements of the warehouse shipping department.

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

NOTE: Each correct select 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.