Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 121:

  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: You add a Power Apps custom visual to the report.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 122:

  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 percentile line by using the Salary measure and set the percentile to 50%.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

  Reference: https://dash-intel.com/powerbi/statistical_functions_percentile.php

• Question 123:

  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?

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

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

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

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

  Correct Answer: C

• Question 124:

  Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

  You have a Microsoft SQL Server database that contains the following tables.

  

  The following columns contain date information:

  -Date[Month] in the mmyyyy format

  -Date[Date_ID] in the ddmmyyyy format

  -Date[Date_name] in the mm/dd/yyyy format

  -Monthly_returns[Month_ID] in the mmyyyy format

  The Order table contains more than one million rows.

  The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

  You plan to use Power BI Desktop to create an analytics solution for the data.

  You need to create a relationship between the Monthly_returns table and Date[Date_ID].

  What should you do before you create the relationship?

  A. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.

  B. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.

  C. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.

  D. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.

  Correct Answer: B

  References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

• Question 125:

  You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection.

  You need to ensure that users can use QandA from the Power BI service for the dataset.

  What should you do?

  A. From the Power BI service, add an enterprise gateway to the dataset.

  B. From Power BI Desktop, add synonyms and suggested questions.

  C. From Power BI Desktop, add a QandA visual to the report.

  D. From the Power Bi service, select Turn on Qand A for this dataset.

  Correct Answer: D

• Question 126:

  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:

  1.

  Due Date

  2.

  Order Date

  3.

  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?

  A. Yes

  B. No

  Correct Answer: B

  You can reference an inactive relationship whit DAX function USERELATIONSHIP(), but using DAX is not mentioned here.

  So follow this refactory methodology:

  Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query.

  Source: https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

• Question 127:

  ion have a Power BI dataset that contains a table named Temperature Readings. Temperature Readings contains the columns shown in the following table.

  

  The table has 12 million rows. All the columns are needed for analysis.

  You need to optimize the dataset to decrease the model size. The solution must not affect the precision of the data.

  What should you do?

  A. Split the DateTime column into separate date and time columns.

  B. Disable the Power Query load.

  C. Round the Longitude column two decimal places.

  D. Change the data type of the TempCelsius column to Integer

  Correct Answer: B

  Disable Power Query load.

  Power Query queries that are intended support data integration with other queries should not be loaded to the model. To avoid loading the query to the model, take care to ensure that you disable query load in these instances.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction#disable-power-query-query-load

• Question 128:

  You are building a Power Bl report that uses data from an Azure SQL database named erp1. You Import the following tables.

  

  You need to perform the following analyses:

  1.

  Orders sold over time that include a measure of the total order value

  2.

  Orders by attributes of products sold

  The solution must minimize update times when interacting with visuals in the report. What should you do first?

  A. From Power Query, merge the Orders query and the Order Line Hems query.

  B. Calculate the count of orders per product by using a DAX function.

  C. Create a calculated column that adds a list of product categories to the Orders table by using a DAX function.

  D. From Power Query, merge the Order Line Items query and the Products query.

  Correct Answer: D

  https://www.sqlbi.com/articles/header-detail-vs-star-schema-models-in-tabular-and-power-bi/

• Question 129:

  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 query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number.

  You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.

  You need to ensure that nonnumeric values in the CustomerlD column are set to 0.

  Solution: From Query Editor, select the CustomerlD column and click Remove Errors.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 130:

  You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.

  You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.

  Which report setting should you configure?

  A. Don't allow end user to save filters on this report.

  B. Change default visual interaction from cross highlighting to cross filtering.

  C. Enable the updated filter pane, and show filters in the visual header for this report.

  D. Allow users to add comments to this report.

  E. Choose the type of data you allow your end users to export.

  Correct Answer: E

  https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/