Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 371:

  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 have a Power BI report that imports a date table and a sales table from an Azure SQL Database data source. The sales table has the following date foreign keys:

  Due Date

  Order Date

  Delivery Date

  You need to support the analysis of sales over time based on all three dates at the same time.

  Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationships between the sales table and the date table.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 372:

  In Power Query Editor, you have a query named Sales Data that contains the following columns.

  

  You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the size of the dataset.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Reference the Sales Data query to create the new queries.
  B. Disable the load for the Sales Fact query.
  C. Duplicate the Sales Data query to create the new queries.
  D. Clear Include in report refresh for the Sales Data query.
  E. Disable the load for the Sales Data query.
  A. Reference the Sales Data query to create the new queries.
  E. Disable the load for the Sales Data query.

• Question 373:

  HOTSPOT

  You hove a folder that contains 50 JSON files.

  You need to use Power 81 Desktop to make the metadata ol the files available as a single semantic model. The solution must NOT store the data of the JSON files.

  Which type of data source should you use. and which transformation should you perform? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 374:

  You have a Power BI semantic model named Model1 that runs in Import storage mode.

  You need to reduce the size of Model1. The solution must NOT increase report query response times.

  What should you do?

  A. Remove unnecessary columns.
  B. Unpivot unnecessary columns.
  C. Rename unnecessary columns.
  D. Change Model1 to DirectQuery storage mode.
  A. Remove unnecessary columns.

• Question 375:

  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:

  

  

• Question 376:

  You have the CSV file shown in the following table.

  

  You use Power Query Editor to preview the data in the file.

  You need to transform the data to meet the following requirements:

  1. The first column must contain the month.

  2. The second column must contain the year.

  3. The third column must contain the order amount for the month and year.

  Which transformation should you use first?

  A. unpivot
  B. pivot
  C. transpose
  D. remove
  A. unpivot

• Question 377:

  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.

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IOT ID columns are unique to each row in query.

  You need to analyze 10T events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You change the IOT DateTime column to the Date data type.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  B is correct because changing the IoT DateTime column to the Date data type alone will not meet the goal of analyzing IoT events by the hour and day of the year in power query.

• Question 378:

  HOTSPOT

  You have Power BI report that contains the fields shown in the following exhibit.

  

  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.

  

  

• Question 379:

  Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
  B. a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
  C. a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.
  D. a pie chart that shows balances by account category without filters.
  E. a ribbon chart that shows balances by quarter and accounts in the legend.
  A. a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
  E. a ribbon chart that shows balances by quarter and accounts in the legend.

  ---

  Explanation

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualizationtypes-for-reports-and-q-and-a

• Question 380:

  You have a Power BI query named Expenses that imports the following data.

  

  Users only use the date portion of the TransactionDate value when performing data analysis.

  You need to minimize the model size without affecting the analysis.

  Which two actions should you perform? (Choose two) Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Change the data type of the TransactionDate column to Date.
  B. Change the data type of the PostDate column to Date.
  C. Remove the PostDate column.
  D. Remove the TransactionID column.
  A. Change the data type of the TransactionDate column to Date.
  C. Remove the PostDate column.

  ---