Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 531:

  You have a Power BI model that contains a table named Employee. The table contains the following data.

  Each employee has one manager as shown in the ParentEmployeelD column

  

  All reporting paths lead to the CEO at the top of the organizational hierarchy.

  You need to create a calculated column that returns the count of levels from each employee to the CEO.

  Which DAX expression should you use?

  A. PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))
  B. PATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER)
  C. PATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1)
  D. PATH(Employee[EmployeeID],Employee[ParentEmployeeID])
  A. PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))

  ---

  Explanation

  Although for CEO it returns 1 - so I personally would substract 1 from this PATHLENGTH when creating the report, as I think numbers of levels from CEO to CEO is 0, formanagaers directly under CEO it is 1 etc

• Question 532:

  You import two Microsoft Excel tables named Customer and Address into Power Query.

  Customer contains the following columns:

  1. Customer ID

  2. Customer Name

  3. Phone

  4. Email Address

  5. Address ID

  Address contains the following columns:

  1. Address ID

  2. Address Line 1

  3. Address Line 2

  4. City

  5. State/Region

  6. Country

  7. Postal Code

  The Customer ID and Address ID columns represent unique rows.

  You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.

  What should you do?

  A. Merge the Customer and Address tables.
  B. Transpose the Customer and Address tables.
  C. Group the Customer and Address tables by the Address ID column.
  D. Append the Customer and Address tables.
  A. Merge the Customer and Address tables.

  ---

  Explanation

  There are two primary ways of combining queries: merging and appending. When you have one or more columns that you'd like to add to another query, you merge the queries.

  When you have additional rows of data that you'd like to add to an existing query, you append the query.

  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

• Question 533:

  HOTSPOT

  You have a column named UnitsInStock as shown in the following exhibit.

  

  UnitsInStock has 75 non-null values, of which 51 are unique.

  Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: 75

  Box 2: reduce

  They reduce from the number of values (75), to the number of unique values (51).

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data

• Question 534:

  Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard.

  Which type of tile should you add?

  A. video
  B. custom streaming data
  C. text box
  D. web content
  D. web content

  ---

  Explanation

  https://docs.microsoft.com/en-us/stream/portal-embed-video

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content

• Question 535:

  You need to review the data for which there are concerns before creating the data model.

  What should you do in Power Query Editor?

  A. Select Column distribution.
  B. Select the sales_amount column and apply a number filter.
  C. Select Column profile, and then select the sales_amount column.
  D. Transform the sales_amount column to replace negative values with 0.
  C. Select Column profile, and then select the sales_amount column.

  ---

  Explanation

  Because it has a min and a max info so you can see if there are negative values.

  https://www.xspdf.com/resolution/50510644.html

• Question 536:

  HOTSPOT

  You have a Power BI model that has the following tables:

  Product (Product_id, Product_Name)

  Sales (Order_id, Order_Date, Product_id, Salesperson_id, Sales_Amount) Salesperson (Salesperson_id, Salesperson_name, address)

  You plan to create the following measure.

  Measure1 = DISTINCTCOUNT(Sales[ProductID])

  You need to create the following relationships:

  1. Sales to Product

  2. Sales to Salesperson

  The solution must ensure that you can use Measure1 to display the count of products sold by each salesperson.

  How should you configure the relationships? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 537:

  You have a Power BI app that contains a report named Report1. You add a new page to Report1.

  You need to ensure that users can view the new page. The solution must minimize administrative effort.

  What should you do?

  A. Update the audience in the app.
  B. Update the app.
  C. Update the contact information in the app.
  D. Unpublish and create a new app.
  B. Update the app.

• Question 538:

  HOTSPOT

  You have a Fabric workspace that contains the items shown in the following table.

  

  You need to make content available to the management department and the accounting department at your company. The solution must meet the following requirements:

  1. The management department must have view access to the Headcount and Department Expenses reports.

  2. The management department must NOT be able to view any other current or future reports.

  3. The management department must NOT be able to build new reports by using the semantic models.

  4. The accounting department must only be able to view the Company Expenses report.

  5. The accounting department must be able to build new reports by using the Expenses semantic model.

  The solution must follow the principle of least privilege and minimize administrative effort.

  How should you make the content available to the users in each department? To answer, select the appropriate options in the answer area.

  NOTE: Each collect selection is worth one point.

  

  

• Question 539:

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

  What should you recommend?

  A. Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.
  B. In the same workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.
  C. Create separate workspaces for development and production. Grant the end users access to the production workspace.
  D. Create one workspace for development. From the workspace, publish an app for production.
  C. Create separate workspaces for development and production. Grant the end users access to the production workspace.

  ---

  Explanation

  Use different work stages (Development, Test, and Production).

  Deploy from the Development workspace.

  https://visualbi.com/blogs/microsoft/powerbi/application-lifecycle-management-power-bi/

• Question 540:

  You embed a Power BI report in a Microsoft SharePoint Online page.

  A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following error message: "This content isn't available".

  User1 is unable to view the report.

  You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

  You need to ensure that User1 can view the report form SharePoint Online.

  What should you do?

  A. Publish the app workspace.
  B. Edit the settings of the Power BI web part.
  C. Modify the members of the app workplace.
  D. Share the dashboards in the app workspace.
  C. Modify the members of the app workplace.

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo