Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 211:

  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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

  During the development process, you need to import a sample of the data from the Order table.

  Solution: You write a DAX expression that uses the FILTER function.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  The filter is applied after the data is imported.

  Instead add a WHERE clause to the SQL statement.

  https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

• Question 212:

  DRAG DROP

  You use Microsoft Power BI Desktop to preview a query in Power Query Editor. The query contains a column named Location Name.

  You need to identify the maximum length of each value in the Location Name column without changing the data.

  Which actions should you perform in sequence? To answer, drag the appropriate actions to the correct order. 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 to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  

• Question 213:

  You have a Power BI model that contains a table named Sales. The Sales table contains the following columns:

  1. Order Line ID

  2. Product ID

  3. Unit Price

  4. Order ID

  5. Quantity

  Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID.

  You need to write a DAX measure that counts the number of orders.

  Which formula should you use?

  A. CountRows('Sales')
  B. Count ('Sales'(Order ID])
  C. CountA (Sale** (Order ID])
  D. DistinctCount (sales'[Order ID])
  D. DistinctCount (sales'[Order ID])

• Question 214:

  You have the dataset shown in the following exhibit.

  

  You need to ensure that the visual shows only the 10 cities that have the highest sales profit.

  What should you do?

  A. Add a Top N filter to the visual.
  B. Configure the Sales Profit measure to use the RANKX function.
  C. Add a calculated column to the table that uses the TOPN function. In the visual, replace Sales Profit with the calculated column.
  D. Add a calculated column to the table that returns the city name if the city is in the top 10, otherwise the calculated column will return "Not in Top 10". In the visual, replace Sales Profit with the calculated column.
  A. Add a Top N filter to the visual.

  ---

  Explanation

  Power BI Top N Filters are useful to display the top performing records, and Bottom N filters are helpful to display the least performing records. For example, we can display top or bottom 10 products by orders or sales.

  Note:

  Select the Column you want to display the Top Sales Profit Then change the Filter Type of that Column to Top N Fill in Top / Bottom number field And lastly drag to the By Value filed your Sales Profit

  https://www.tutorialgateway.org/power-bi-top-10-filters/

• Question 215:

  HOTSPOT

  You have a dataset that contains revenue data from the past year.

  You need to use anomaly detection in Power Bl to show anomalies in the dataset.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Line

  Populate the axis with a date field

• Question 216:

  You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region.

  What should you do next to meet the reporting requirements of the executives?

  A. Apply row-level security (RLS) to the Region table based on the sales manager username.
  B. Configure a bi-directional relationship between Region and Sales.Region.
  C. Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.
  D. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.
  D. In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

• Question 217:

  From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The dataset has a row-level security (RLS) role named HR.

  You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.

  What should you do?

  A. From Power Bl Desktop, change the Row-Level Security settings.
  B. From Power Bl Desktop, import a table that contains the HR team members
  C. From powerbi.com, add users to the HR role for the dataset.
  D. From powerbi.com, share the dataset to the HR team members.
  C. From powerbi.com, add users to the HR role for the dataset.

• Question 218:

  HOTSPOT

  You need to create the Top Customers report.

  Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: Top N

  Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

  Once you drag to SKU to Visual level filter you should get Top N option

  Note: The two most common filter types: automatic and manual.

  Then there are more advanced filters.

  Box 2: Visual

  Once you drag to SKU to Visual level filter you should get Top N option.

  https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/

• Question 219:

  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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

  During the development process, you need to import a sample of the data from the Order table.

  Solution: From Power Query Editor, you import the table and then add a filter step to the query.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 220:

  You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.

  You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

  What should you do?

  A. Create a column by example that starts with 2018-12-31.
  B. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
  C. Apply the parse function from the Date transformations options to the Logged column.
  D. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
  D. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.