Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 361:

  You have a Power BI semantic model that contains a table named Table1. Table1 runs in Import storage mode.

  You need to update the model to change the storage mode of Table1 to DirectQuery.

  What should you do?

  A. Delete Table1, and then add the table to the model again in DirectQuery storage mode.
  B. From Power Query Editor, duplicate the query for Table1.
  C. From Model view, change the storage mode of Table1 to DirectQuery.
  D. Add an aggregation table to the model.
  A. Delete Table1, and then add the table to the model again in DirectQuery storage mode.

• Question 362:

  HOTSPOT

  You have a Power BI semantic model named ModelA that contains the following columns:

  

  All of the columns use the Text data type.

  Based on the model, you create a report named ReportA that contains the following columns:

  1. OrderID

  2. OrderDate

  3. CustomerID

  4. ShippingAddress

  ReportA is the only report connected to ModelA.

  You discover that ReportA has performance issues caused by the size of ModelA.

  What should you do to optimize and reduce the size of ModelA? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 363:

  You have a Power Bl report that contains five pages.

  Pages 1 to 4 are visible and page 5 is hidden.

  You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages.

  The solution must minimize development and maintenance effort as pages are added to the report.

  What should you do first?

  A. Add a blank button to page 1.
  B. Add a bookmark navigation button to page 1.
  C. Create a bookmark for each page.
  D. Add a page navigation button to page 1.
  D. Add a page navigation button to page 1.

• Question 364:

  You have a Microsoft SharePoint Online site that contains several document libraries.

  One of the document libraries contains manufactunng reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

  You need to use Power Bl Desktop to load only the manufacturing reports to a table for analysis.

  What should you do?

  A. Get data from a SharePoint folder, enter the site URL and then select Combine & Load
  B. Get data from a SharePoint list and enter the site URL Select Combine & Transform, then filter by the folder path to the manufacturing reports library.
  C. Get data from a SharePoint list enter the site URL and then select Combine & Load
  D. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.
  D. Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.

• Question 365:

  DRAG DROP

  You have the line chart shown in the exhibit. (Click the Exhibit tab.)

  

  You need to modify the chart to meet the following requirements:

  1. Identify months that have order counts above the mean.

  2. Display the mean monthly order count.

  Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

  Select and Place:

  

  

  ---

  1. Select the line chart

  2. Add the average line

  3. Turn on Data Label

  https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041

• Question 366:

  You have four sales regions. Each region has multiple sales managers.

  You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.

  You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.

  A sales manager changes to a different region.

  You need to ensure that the sales manager can see the correct sales data.

  What should you do?

  A. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.
  B. Change the Microsoft Power Bl license type of the sales manager.
  C. Manage the permissions of the underlying dataset
  D. Request that the sales manager be added to the correct Azure Active Directory group.
  D. Request that the sales manager be added to the correct Azure Active Directory group.

  ---

  Explanation

  Using AD Security Groups, you no longer need to maintain a long list of users.

  All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.

  Note: Configure role mappings

  Once published to Power BI, you must map members to dataset roles. Members can be user accounts or security groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security group memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.

  https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/

  https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

• Question 367:

  HOTSPOT

  You view a query named Transactions as shown in the following exhibit.

  

  The query gets CSV files from a folder.

  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: 9

  9 distinct CSV files.

  Box 2: 10

  10 distinct dates.

• Question 368:

  You have a semantic model named Model1.

  You have a Power BI report named RPT1 that is connected to Model1. RPT1 contains a table visual named Table1 that shows the results of multiple measures.

  You discover that the DAX query for Table1 runs slowly.

  You need to identify which measure is slowing query performance.

  What should you use?

  A. DAX query view
  B. Power Query Editor
  C. Model view
  D. Performance analyzer
  D. Performance analyzer

• Question 369:

  You plan to generate a line chart to visualize and compare the last six months of sales data for two departments.

  You need to increase the accessibility of the visual.

  What should you do?

  A. Configure a unique marker for each series.
  B. Configure a distinct color for each series.
  C. Replace long text with abbreviations and acronyms.
  D. Move important information to a tooltip.
  A. Configure a unique marker for each series.

• Question 370:

  HOTSPOT

  You have two tables named Customers and Invoice in a Power BI model. The Customers table contains the following fields:

  1. CustomerID

  2. Customer City

  3. Customer State

  4. Customer Name

  5. Customer Address 1

  6. Customer Address 2

  7. Customer Postal Code

  The Invoice table contains the following fields:

  1. Order ID

  2. Invoice ID

  3. Invoice Date

  4. Customer ID

  5. Total Amount

  6. Total Item Count

  The Customers table is related to the Invoice table through the Customer ID columns. A customer can have many invoices within one month.

  The Power BI model must provide the following information:

  The number of customers invoiced in each state last month

  The average invoice amount per customer in each postal code

  You need to define the relationship from the Customers table to the Invoice table. The solution must optimize query performance.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: One-to-many

  A customer can have many invoices within one month.

  Box 2: Single

  For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional).

  Single cross filter direction means "single direction", and Both means "both directions". A relationship that filters in both directions is commonly described as bi-directional.