Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 11:

  Note: This question is a part of a series of questions that present 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

  exactly the same in each question in this series.

  Start of repeated scenario

  You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

  

  You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

  

  You plan to use Power BI to import data from 2013 to 2015.

  Product Subcategory [Subcategory] contains NULL values.

  End of repeated scenario.

  You implement the Power BI model.

  You need to add a new column to the Product Subcategory table that uses the following formula.

  =if [Subcategory] =null then "NA" else [Subcategory]

  Which command should you use in Query Editor?

  A. Column From Examples

  B. Custom Column

  C. Invoke Custom Function

  D. Conditional Column

  Correct Answer: D

  References: http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999

• Question 12:

  You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

  A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.

  You need to ensure that User sees App1 from the My organization AppSource.

  What should you do?

  A. From the app workspace, click Update app, configure the Content settings, and then click Update app.

  B. From the app workspace settings, add a member.

  C. From the app workspace, click Update app, configure the Access setting, and then click Update app.

  D. From the app workspace, share the dashboard.

  Correct Answer: C

  References: https://docs.microsoft.com/en-us/power-bi/service-organizational-content-pack-introduction#what-is-appsource

• Question 13:

  You create a dataset sourced from dozens of flat files in Azure Blob storage. The dataset uses incremental refresh.

  From powerbi.com, you deploy the dataset and several related reports to Microsoft Power BI Premium capacity.

  You discover that the dataset refresh fails after the refresh runs out of resources.

  What is a possible cause of the issue?

  A. Query folding is not occurring.

  B. You selected Only refresh complete periods.

  C. The data type of the column used to partition the data changed.

  D. A filter is missing on the report.

  Correct Answer: A

  The Power BI service partitions data based on date range. This is what enables only certain partitions to be refreshed incrementally. To make this work, the partition filter conditions are pushed down to the source system by including them in the queries. Using Power Query terminology, this is called "query folding". It is not recommended that incremental refresh is used when the required query folding cannot take place.

  Reference: https://powerbi.microsoft.com/en-us/blog/incremental-refresh-query-folding/

• Question 14:

  You are creating a visual to show the ranking of product categories by sales revenue.

  Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant

  Which approach provides the widest variety of visuals while adhering to the security policy?

  A. Use default visuals or custom visuals uploaded from a .pbiviz file.

  B. Use only default visuals.

  C. Use default or any custom visuals from the marketplace.

  D. Use default or certified custom visuals.

  Correct Answer: C

• Question 15:

  A manager can represent only a single country.

  You need to use row-level security (RLS) to meet the following requirements:

  The managers must only see the data of their respective country.

  The number of RLS roles must be minimized.

  Which two actions should you perform? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Create a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

  B. Create a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

  C. For the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

  D. Create one role for each country.

  E. For the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

  Correct Answer: AC

  In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service.

  See https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670 for more information.

• Question 16:

  You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

  You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

  What should you do?

  A. Change the data type of the Logged column to Date.

  B. Apply a transform to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

  C. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

  D. Apply a transform to extract the first 11 characters of the Logged column.

  Correct Answer: C

• Question 17:

  You have the following table named Location.

  

  The GeoCode column represents the country where each customer is located.

  You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

  

  You need to ensure that the map displays the country locations. What should you do?

  A. Replace the values in the GeoCode column with postal codes or zip codes.

  B. Change the name of the GeoCode column to Country.

  C. Change the name of the Location table to Country.

  D. Change the Default Summarization of the GeoCode column.

  E. Add a Geoportal column to the Location table.

  F. Change the Data Type of the GeoCode column.

  Correct Answer: B

  References: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

• Question 18:

  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 remove the loT GUID column and retain the loT ID column.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

• Question 19:

  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 an average line by using the Salary measure.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead create a percentile line by using the Salary measure and set the percentile to 50%.

  Note: 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 20:

  You have the dashboard shown in the following exhibit.

  

  You need to modify the dashboard to display as shown in the following exhibit.

  

  What should you do?

  A. Create and apply a custom dashboard theme.

  B. Change the colors of the visuals in the report.

  C. Apply the Dark dashboard theme.

  D. Upload a snapshot image of the dashboard.

  Correct Answer: A

  The visual colors can't be changed on the dashboard from a report after the visual has already been pinned. Applying a dashboard custom theme will do it.