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

You have a Power BI tenant.

You have reports that use financial datasets and are exported as PDF files.

You need to ensure that the reports are encrypted.

What should you implement?

Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI. You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets. What should you recommend?

You create a report by using Microsoft Power BI Desktop.

The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network. You plan to publish the report to the Power BI Service.

What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary.

Solution: You create a median line by using the Salary measure.

Does this meet the goal?

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?

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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You enable included in app for all assets.

Does this meet the goal?

You are reviewing a query that produces 10,000 rows in the Power Query Editor.

You need to identify whether a column contains only unique values.

Which two Data Preview options can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

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