Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 71:

  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?

  A. Add a data field to the Secondary values field weft

  B. Increase the Sensitivity setting.

  C. Increase the Expected range transparency setting,

  D. Add a data field to the Legend field well

  Correct Answer: C

  If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you decrease the sensitivity, the algorithm is more selective on what it considers an anomaly.

  Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection

• Question 72:

  In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

  You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

  What should you do?

  A. Create an active relationship between the tables and select Assume referential integrity.

  B. Create an inactive relationship between the tables and select Assume referential integrity.

  C. Create an inactive relationship between the tables and select Apply security filter in both directions.

  D. Create an active relationship between the tables and select Apply security filter in both directions.

  Correct Answer: D

  By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi- directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID.

  

  Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

• Question 73:

  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?

  A. Yes

  B. No

  Correct Answer: B

• Question 74:

  You have a BI dataset and a connected report.

  You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.

  You grant the users the Build permission for dataset

  What Should do next?

  A. Change default visual interaction for the report

  B. For the report change the Export data setting to Summarized data, data with current layout and underlying data

  C. For the report, change the Export data setting to None

  D. Certify the dataset used by the report.

  Correct Answer: B

• Question 75:

  You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

  A. Key influences

  B. Funnel chart

  C. QandA

  D. Line and clustered column chart

  Correct Answer: A

  The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers.

  The key influencers visual is a great choice if you want to:

  See which factors affect the metric being analyzed. Contrast the relative importance of these factors. For example, do short-term contracts have more impact on churn than long-term contracts?

  Reference:

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

• Question 76:

  In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the users from exporting the underlying data What should you do?

  A. From Power BI Desktop, configure the Data Load settings for the current file.

  B. From the Power BI service, configure the dataset permissions.

  C. From Power BI Desktop, configure the Report settings for the current file.

  D. From Power BI Desktop, modify the data source permissions.

  Correct Answer: C

  The export functionality can be disabled on several levels. First, Power BI Service admins can disable this functionality on tenant level. With that, nobody will be able to export the data. More about that later. Second, as a dataset owner you can decide if you allow your users to export the data. This is managed in dataset settings, but only changeable in Power BI desktop.

  No matter what settings are applied in Power BI desktop, the tenant settings will overrule this. In the end the Power BI Service admin decides what options are possible to use.

  https://data-marc.com/2020/04/13/power-bi-governance-why-you-should-consider-to- disable-export-to-excel/ https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization- export-data?tabs=powerbi-desktop

• Question 77:

  You import a large dataset to 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

  A. Show whitespace

  B. Column distribution

  C. Column profile

  D. Column quality

  E. Monospaced

  Correct Answer: AD

• Question 78:

  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?

  A. key influencers

  B. decomposition tree

  C. QandA

  D. smart narrative

  Correct Answer: A

• Question 79:

  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.

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IoT GUID and IoT ID columns are unique to each row in query.

  You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You split the loT DateTime column into a column named Date and a column named Time.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  The correct answer is A. Splitting datetime column will improve the perfomance even if it generates one more column, having less unique values in separated date and time columns will achieve better compression.

• Question 80:

  You have a report that includes a card visualization.

  You need to apply the following conditional formatting to the card while minimizing design effort.

  For values that are greater than or equal to 100, the font of the data label must be dark red.

  For values that are less than 100, the font of the data label must be dark gray.

  Which type of format should you use?

  A. Color scale

  B. Rules

  C. Field value

  Correct Answer: B