Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 461:

  You need to design the data model to meet the report requirements.

  What should you do m Power Bl Desktop?

  A. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
  B. From Power Bi Desktop, use the Auto date/time option when creating the reports.
  C. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.
  D. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column
  C. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

• Question 462:

  DRAG DROP

  You a-e using Power Bl Desktop 10 profile data in Power Query Editor.

  You need to review the percentage of errors and the maximum value of each column.

  Which options should you use in Power Query Editor?

  To answer, drag the appropriate options to the correct requirements. Each option 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 463:

  You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

  You add the following fields to the Explain By field:

  1. Customer Country

  2. Product Category

  3. Supplier Country

  4. Sales Employee

  5. Supplier Name

  6. Product Name

  7. Customer City

  The key influencers visual returns the results shown in the following exhibit.

  

  What can you identify from the visual?

  A. Customers in Austria order 18.8 more units than the average order quantity.
  B. Customers in Boise order 20.37 percent more than the average order quantity.
  C. Product Category positively influences the quantity per order.
  D. Customers in Cork order lower quantities than average.
  A. Customers in Austria order 18.8 more units than the average order quantity.

  ---

  Explanation

  Average quantity of units is displayed.

  Incorrect:

  Not B: Average quantity of units is displayed, not percentage.

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

• Question 464:

  You need to minimize me size of the dataset. The solution must meet the report requirements.

  What should you do?

  A. Change lite OrderlD column in the Orders table to the text data type.
  B. Filter out discontinued products while importing the Product table.
  C. Remove the QuantityPerUnit column from the Products table
  D. Group the Categories table by the CategorylD column.
  C. Remove the QuantityPerUnit column from the Products table

• Question 465:

  HOTSPOT

  You need to create a KPI visualization to meet the reporting requirements of the sales managers.

  How should you create the visualization? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Scenario: The sales managers require a visual to analyze sales performance versus sales targets.

  Box 1: Sales[sales_amount]

  Box 2: Date[month]

  Time > FiscalMonth. This value will represent the trend.

  Box 3: Targets[sales_target]

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

• Question 466:

  Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.

  You need to recommend an application lifecycle strategy. The solution must minimize access to production assets 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. Create one workspace for development. From the new workspace, publish an app for production.
  C. Create a workspace for development and a workspace for production. From the production workspace, publish an app.
  D. In one 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 a workspace for development and a workspace for production. From the production workspace, publish an app.

  ---

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

  You have a query in Power Query Editor that contains the following data.

  

  You need to transform the data to appear as shown in the following table.

  

  What should you do?

  A. Convert the Classes column into a list.
  B. Unpivot the Classes column.
  C. Extract the text between delimiters in the Classes column.
  D. Split the Classes column into rows by using a delimiter.
  D. Split the Classes column into rows by using a delimiter.

• Question 468:

  HOTSPOT

  You use Power Query Editor to review the query shown in the following exhibit.

  

  Each Region value appears only on the row where it first occurred. Each subsequent occurrence of the Region value is blank.

  You need to ensure that every row contains the correct non-blank value. The solution must minimize development effort.

  Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 469:

  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 in 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. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
  B. Change the data type of the Logged column to Date.
  C. Split the Logged column by using at as the delimiter.
  D. Apply a transformation to extract the first 11 characters of the Logged column.
  C. Split the Logged column by using at as the delimiter.

  ---

  Explanation

  Simply create a custom table in Power Query, enter the date shown in the question into a column called Date, and then Split it by a delimiter. No need for spaces on either side of "at" Power BI takes care of the rest:

  = Table.SplitColumn(#"Changed Type", "Date", Splitter.SplitTextByDelimiter("at", QuoteStyle.Csv), {"Date.1", "Date.2"})

  It will even automatically change the type to Date:

  = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Date.1", type date}, {"Date.2", type time}})

• Question 470:

  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: