Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 351:

  HOTSPOT

  You have a semantic model that contains a table named Sales.

  The table contains the following columns:

  1. Order ID

  2. Product ID

  3. Sales Dote

  4. Sales Amount

  You need to create a DAX measure that will return the total sales amount for the same dates from the previous year. How should you complete the measure? To answer, select the appropriate options m the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 352:

  You have a Power BI report that contains one visual.

  You need to provide users with the ability to change the visual type without affecting the view for other users.

  What should you do?

  A. From the Bookmarks pane, select Focus mode, and then select Add.
  B. From Report settings, select Personalize visuals.
  C. From Visual options in Report settings, select Use the modern visual header with updated styling options.
  D. From Tabular Editor, create a new perspective.
  B. From Report settings, select Personalize visuals.

• Question 353:

  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 a percentile line by using the Salary measure and set the percentile to 50%.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

  https://dash-intel.com/powerbi/statistical_functions_percentile.php

• Question 354:

  DRAG DROP

  You receive annual sales data that must be included in Power BI reports.

  From Power Query Editor, you connect to the Microsoft Excel source shown in the following 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? 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:

  

  

• Question 355:

  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

  Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. 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. Append 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. Merge the Customer and Address tables.
  D. Merge the Customer and Address tables.

• Question 356:

  HOTSPOT

  You have a query named All Sales that imports sales data into a Power BI model.

  You plan to create a star schema by separating columns into separate queries and performing further transformations. The solution must meet the following requirements:

  Use All Sales as the source for three other queries named Sales Fact Product Dimension, and Customer Dimension.

  Minimize maintenance effort.

  What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 357:

  Note: This question is part of a series of questions that use 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 the same in each question in this series.

  You have a Microsoft SQL Server database that contains the following tables.

  

  The following columns contain date information:

  1. Date[Month] in the mmyyyy format

  2. Date[Date_ID] in the ddmmyyyy format

  3. Date[Date_name] in the mm/dd/yyyy format

  4. Monthly_returns[Month_ID] in the mmyyyy format

  The Order table contains more than one million rows.

  The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

  You plan to use Power BI Desktop to create an analytics solution for the data.

  You need to create a relationship between the Order table and the Store table on the Store_ID column.

  What should you do before you create the relationship?

  A. In the Order table query, use the Table.TrasformRows function.
  B. In the Store table query, use the Table.TrasformRows function.
  C. In the Store table query, use the Table.TrasformColumnTypes function.
  D. In the Order table query, use the Table.TrasformColumnTypes function.
  C. In the Store table query, use the Table.TrasformColumnTypes function.

• Question 358:

  You have a Power BI dashboard that displays different visualizations of company sales.

  You enable Q&A on the dashboard.

  You need to provide users with sample questions that they can ask when using Q&A.

  Which settings should you modify from the Power BI Settings?

  A. Subscriptions
  B. Dashboards
  C. Datasets
  D. Workbooks
  C. Datasets

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/service-q-and-a-create-featured-questions

• Question 359:

  HOTSPOT

  You plan to create a Power B1 semantic model named Model1 that will contain data from an Azure SQL database. Model! will have the following tables.

  

  You create DimDate and DimProduct by using import storage mode.

  You need to configure the storage mode for each remaining table. The solution must meet the following requirements:

  1. The data in FactSales must be available within five minutes of being available in the source data.

  2. The query response time for reports connected to the model must be minimized.

  Which storage mode should you configure for each table? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 360:

  You need to create a semantic model in Power 81 Desktop. The solution must meet the following requirements:

  1. The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order.

  2. The orders must be filtered to the selected CustomerlD value.

  3. Users must select the CustomerlD value from a list.

  4. The list of customers must come from an OData source. solution.

  Which three objects should you create in Power Query Editor? Each correct answer presents part of the

  NOTE: Each correct selection is worth one point.

  A. an Orders query that has a single column containing a list of customers
  B. a parameter for CustomerlD that uses a query to populate the suggested values
  C. an Orders query that has a filter on CustomerlD
  D. a Customers query that has a single column containing a list of customer IDs
  E. a Customers query that has a filter on CustomerlD
  F. a parameter for CustomerlD that uses manually entered values to populate the suggested values
  B. a parameter for CustomerlD that uses a query to populate the suggested values
  C. an Orders query that has a filter on CustomerlD
  D. a Customers query that has a single column containing a list of customer IDs