Home / Microsoft / PL-300

Microsoft PL-300 Practice Test - Questions Answers, Page 23

Question list

List of questions

Question 221

(0)

You are creating a Power Bl report by using Power Bi Desktop. You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections i

Question 222

(0)

You have a Power Bl workspace that contains several reports. You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

Question 223

(0)

You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access: • External users can access the dashboard. • Managers can access the dashboard a

Question 224

(0)

You have a report in Power Bl named report1 that is based on a shared dataset. You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being aff

Question 225

(0)

HOTSPOT 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 e

Question 226

(0)

DRAG DROP You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1. Sheet2 contains the following table named Table2

Question 227

(0)

HOTSPOT You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The data has the following refresh requirements: • Customer must be refreshed daily. • Date must be r

Question 228

(0)

HOTSPOT You need to create a Power Bl report. The first page or the report must contain the following two views: * Sales By Postal Code * Sales by Month Both views must display a slicer to selec

Question 229

(0)

HOTSPOT You have a dataset that contains revenue data from the past year. You need to use anomaly detection in Power Bl to show anomalies in the dataset. What should you configure? To answer, sel

Question 230

(0)

DRAG DROP You have a Power Bl workspace that contains a single-page report named Sales. You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals

Related questions

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 have a Power BI data model that contains a table named Employees. The table has the following columns: * Employee Name * Email Address * Start Date * Job Title You are implementing dynamic row-level security (RLS). You need to create a table filter to meet the following requirements: * Users must see only their own employee data * The DAX expression must work in both Power 81 Desktop and the Power BI service. Which expression should you use?

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?

You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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 query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?

DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent. How should you complete the calculation? 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.

HOTSPOT 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.

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

DRAG DROP You have a Microsoft Excel spreadsheet that contains the data shown in the following table. You plan to build a data model for a Power Bl report. You need to prepare the data so that it is available to the model in the format shown in the following table. Which three actions should you perform in sequence in Power Query Editor? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

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 three dates at the same time. Solution; You create measures that use the uSEREIATIOHSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table. Does this meet the goal?

Question 221

You are creating a Power Bl report by using Power Bi Desktop.

You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals. Which type of visual should you use?

key influencers

decomposition tree

Q&A

smart narrative

Show Answer Comment (0)

Question 222

You have a Power Bl workspace that contains several reports.

You need to provide a user with the ability to create a dashboard that will use the visuals from the reports. What should you do?

Grant the Read permission for the datasets to the user.

Add the user as a Viewer of the workspace.

Share the reports with the user.

Create a row-level security (RLS) role and add the user to the role.

Add the user as a member of the workspace.

Show Answer Comment (0)

Question 223

You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access:

• External users can access the dashboard.

• Managers can access the dashboard and a manager-specific report.

• Employees can access the dashboard and a row-level security (RLS) constrained report.

You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised. What should you use?

subscriptions

comments

alerts

chat in Microsoft Teams

Show Answer Comment (0)

Question 224

You have a report in Power Bl named report1 that is based on a shared dataset.

You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected. What should you do?

Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.

Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.

Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.

Apply row-level security (RLS) to the shared dataset.

Show Answer Comment (0)

Question 225

HOTSPOT

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.

Show Answer Comment (0)

Question 226

DRAG DROP

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Sheet2 contains the following table named Table2.

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

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.

Show Answer Comment (0)

Question 227

HOTSPOT

You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.)

The data has the following refresh requirements:

• Customer must be refreshed daily.

• Date must be refreshed once every three years.

• Sales must be refreshed in near real time.

• SalesAggregate must be refreshed once per week.

You need to select the storage modes for the tables. The solution must meet the following requirements:

Show Answer Comment (0)

Question 228

HOTSPOT

You need to create a Power Bl report. The first page or 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.

Show Answer Comment (0)

Question 229

HOTSPOT

You have a dataset that contains revenue data from the past year.

You need to use anomaly detection in Power Bl to show anomalies in the dataset.

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

NOTE: Each correct selection is worth one point.

Show Answer Comment (0)

Question 230

DRAG DROP

You have a Power Bl workspace that contains a single-page report named Sales.

You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard. 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.

Show Answer Comment (0)

Total 370 questions

21 22 23 24 25

Go to page: of 37