Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 201:

  DRAG DROP

  You have a Power Bi report that contains five bookmarks.

  You need to add an object to the report from which users can navigate between three specific bookmarks.

  How should you complete the task? To answer, drag the appropriate actions to the correct steps, each action may be used once more than once, or not at all. You may need to drag the split bar between panes or scroll lo view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 202:

  DRAG DROP You plan to use Power BI to create a quarterly profit report that meets the following requirements: Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage

  Compares profit margins across sales regions

  Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual 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:

  

  Correct Answer:

  

• Question 203:

  DRAG DROP

  You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

  

  You plan to build a data model for a Power Bl report.

  You need to prepare the data so that it is available to the model in the format shown in the following table.

  

  Which three actions should you perform in sequence in Power Query Editor? 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:

  

  Correct Answer:

  

• Question 204:

  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:

  

  Correct Answer:

  

• Question 205:

  DRAG DROP

  You use Power Query Editor to preview customer feedback data.

  You need to use Al Insights to add a column of enhanced data based on the customer feedback. The solution must identify the following:

  1.

  What the customers most often provide feedback about

  2.

  Whether the customers like your company's product

  3.

  The language of the feedback

  Which Al Insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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:

  

  Correct Answer:

  

• Question 206:

  DRAG DROP - (Topic 4)

  Exhibit:

  

  You need to create a report that meets the requirements:

  1.

  Visualizes the Sales value over a period of years and months

  2.

  Adds a Slicer for the month

  3.

  Adds a Slicer for the year

  Which three actions Should you perform in sequence?

  Select and Place:

  

  Correct Answer:

  

• Question 207:

  DRAG DROP

  You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.

  You add a sheer named Country to each page of the report.

  You need to configure the report to meet the following requirements:

  1.

  When a user selects a country on the first page, the report must filter the other pages.

  2.

  The second and third pages must display only the filtered results.

  Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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:

  

  Correct Answer:

  

• Question 208:

  DRAG DROP

  You create a data model in Power BI.

  Report developers and users provide feedback that the data model is too complex.

  The model contains the following tables.

  

  The model has the following relationships:

  *There is a one-to-one relationship between Sales_Region and Region_Manager.

  *There are more records in Manager than in Region_Manager, but every record in Region_Manager has a corresponding record in Manager.

  *There are more records in Sales_Manager than in Sales_Region, but every record in Sales_Region has a corresponding record in Sales_Manager.

  You need to denormalize the model into a single table. Only managers who are associated to a sales region must be included in the reports.

  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.

  NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  Select and Place:

  

  Correct Answer:

  

  1.Merge [Region_Manager] and [Manager] by using an inner join. 3.Merge [Sales_Region] and [Sales_Manager] by using an inner join. 6.Merge [Sales_Region] and [Region_Manager] by using an inner join.

• Question 209:

  DRAG DROP

  In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

  Every Product has a ProductSubCategory.

  Not every ProductsubCategory has a parent ProductCategory.

  You need to merge the three queries into a single query. The solution must ensure the best performance in Power Query.

  How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge type 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:

  

  Correct Answer:

  

• Question 210:

  DRAG DROP

  You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.

  The dataset must be refreshed daily.

  You need to ensure that the Power BI service can connect to the database and refresh the dataset.

  Which four 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

  Select and Place:

  

  Correct Answer: