Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online 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 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: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  Creating two additional tables in Power Query can be a possible solution:

  Remove any inactive relationships.

  Consider renaming the role-playing dimension-type table to better describe its role. In the example, the Airport table is related to the ArrivalAirport column of the Flight table, so it's renamed as Arrival Airport. 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.

  In the example, the Departure Airport table was created by using the following calculated table definition.

• Question 122:

  You are creating a report in Power BI Desktop.

  You load a data extract that includes a free text field named coll.

  You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.

  What should you do?

  A. In the report, add a DAX calculated column that calculates the length of col1
  B. In the report, add a DAX function that calculates the average length of col1
  C. From Power Query Editor, add a column that calculates the length of col1
  D. From Power Query Editor, change the distribution for the Column profile to group by length for col1
  D. From Power Query Editor, change the distribution for the Column profile to group by length for col1

  ---

  Explanation

  From Power Query.. highlight the column.. from the tab view select Column Profile Option.. in the Value distribution section that appears below, from the 3dots.. you can change to group by text length distribution

• Question 123:

  HOTSPOT

  You have a Power BI workspace that contains a semantic model and a report named Sales report.

  All users in the sales department are assigned the Viewer role for the workspace.

  The Sales report is configured as shown in the Sales report exhibit. (Click the Sales report tab.)

  

  From Power BI Desktop, you configure the Report settings as shown in the Report settings exhibit. (Click the Report settings tab.)

  

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

• Question 124:

  You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.

  Which role should you assign to the user?

  A. Viewer
  B. Contributor
  C. Member
  D. Admin
  C. Member

  ---

  Explanation

  Member role allows adding members or other with lower permissions to the workspace.

  

  https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces

• Question 125:

  DRAG DROP

  You have the Power Bl data model shown in the following exhibit.

  You create two row-level security (RlS) roles named Manager and CFO.

  You plan to publish the dataset to the Power Bl service.

  You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

  1. Each manager must see only the data in the Sales and Human Resources tables for their own country.

  2. The CFO must be prevented from seeing the data in the Human Resources table.

  3. The CFO must see the sales data of all countries.

  How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.

  

  The Country table contains the following data.

  

  You plan to publish the dataset to the Power Bl service.

  You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:

  1. Each manager must see only the data in the Sales and Human Resources tables for their own country.

  2. The CFO must be prevented from seeing the data in the Human Resources table.

  3. The CFO must see the sales data of all countries.

  How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression 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.

  Select and Place:

  

  

• Question 126:

  You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.

  In powerbi.com, when users load the visual, they only see some of the customers.

  What is the cause of the issue?

  A. The visual was built by using a different version of R.
  B. The data comes from a Microsoft SQL Server source.
  C. The data is deduplicated.
  D. Too many records were sent to the visual.
  D. Too many records were sent to the visual.

  ---

  Explanation

  R visuals in the Power BI service have a few limitations including: Data size limitations ?data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.

  https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

• Question 127:

  You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.

  You build a report analyzing the internal networks of employees based on whom they send emails to.

  You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.

  What should you do?

  A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.
  B. Remove the Subject and Body columns during the import.
  C. From Model view, set the Subject and Body columns to Hidden.
  B. Remove the Subject and Body columns during the import.

• Question 128:

  HOTSPOT

  You have a Power BI semantic model.

  You need to create a column that will contain year over year (YOY) revenue. The column must contain a ratio of change factor compared to the previous year's monthly revenue.

  How should you complete the OAX formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 129:

  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. Q&A
  D. smart narrative
  D. smart narrative

  ---

  Explanation

  The smart narrative visualization helps you quickly summarize visuals and reports. It provides relevant innovative insights that you can customize. Use smart narrative summaries in your reports to address key takeaways, to point out trends, and to edit the language and format for a specific audience. In PowerPoint, instead of pasting a screenshot of your report's key takeaways, you can add narratives that are updated with every refresh. Your audience can use the summaries to understand the data, get to key points faster, and explain the data to others.

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

• Question 130:

  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 measure to rank total sales by product. The results must appear as shown in the following table.

  

  Which DAX formula should you use?

  A. Product Ranking= RANKX (Product, [SalesAmount], , DESC, Skip)
  B. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense)
  C. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Skip)
  D. Product Ranking= RANKX (ALL (`Product'), [SalesAmount], , Asc, Dense
  B. Product Ranking= RANKX (ALL, (`Product'), [SalesAmount], , DESC, Dense)

  ---

  Explanation

  References:

  https://msdn.microsoft.com/en-us/library/gg492185.aspx