Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 1:

  Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

  

  You need to shape the query to display the following three columns:

  1.

  Month

  2.

  Sales

  3.

  Year

  What should you select in Power Query Editor?

  A. Pivot column

  B. Merge columns

  C. Unpivot columns

  D. Transpose

  Correct Answer: C

  This will convert your column headers (Jan-20, Feb-20,

• Question 2:

  You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

  

  A one-to-many relationship exists between the tables.

  The auto date/time option for the data model is enabled.

  You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

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

  NOTE: Each correct answer is worth one point.

  A. Create a relationship between the Date table and the Sales table.

  B. Disable the auto date/time option.

  C. Create a Date table and select Mark as Date Table.

  D. Disable the load on the Date table.

  E. Remove the relationship between the Product table and the Sales table.

  Correct Answer: AC

  https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables Marking table as date table will remove built-in connected date tables. As we need only month and quarter, we can reduce Date information in newly created Date table - comparing to built-in date tables our created Date table will be lighter so model size is decreases

• Question 3:

  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 create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 4:

  You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.

  You pin the Sales by month visual to Dashboard1.

  In Report1, you change the Sales by month visual to a bar chart.

  You need to ensure that bar chart displays on Dashboard1.

  What should you do?

  A. Edit the details for the dashboard tile of Dashboard1.

  B. Select Refresh visuals for Dashboard1.

  C. the Sales by month bar chart to Dashboard1

  D. Refresh the dataset used by Report1 and Dashboard1.

  Correct Answer: D

• Question 5:

  You have a Microsoft Excel file on a file server.

  You create a Power BI report and import a table from the Excel file.

  You publish the report.

  You need to ensure that the data refreshes every four hours.

  What should you do first?

  A. Upload the Excel file to a Power BI workspace.

  B. Create a subscription to the report.

  C. Deploy an on-premises data gateway.

  D. Edit the data source credentials.

  Correct Answer: C

• Question 6:

  You are creating a dashboard by using the Power Bl service.

  You have an existing report page that contains three charts.

  You need to add the charts to the dashboard while maintaining the interactivity between the charts.

  What should you do?

  A. Pin each chart as a tile.

  B. Edit interactions in the report and set all interactions to Filter

  C. Edit the dashboard theme and pin each chart as a file.

  D. Pin the report page as a live tile.

  Correct Answer: D

• Question 7:

  You have a dataset that is used infrequently and refreshes every hour. You receive a notification that the refresh was disabled due to inactivity.

  Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Enable query caching for the dataset.

  B. Import the dataset to Microsoft Excel.

  C. From the Power BI service, open a dashboard that uses the dataset.

  D. From the Power BI service, open a report that uses the dataset.

  E. From PowerShell, run the get-powerbireport cmdlet.

  Correct Answer: CD

  After two months of inactivity, scheduled refresh on your dataset is paused. A dataset is considered inactive when no user has visited any dashboard or report built on the dataset. At that time, the dataset owner is sent an email indicating the scheduled refresh is paused. The refresh schedule for the dataset is then displayed as disabled. To resume scheduled refresh, simply revisit any dashboard or report built on the dataset. https://learn.microsoft.com/en-us/power-bi/connectdata/refresh-scheduled- refresh#scheduled-refresh

• Question 8:

  You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.

  You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.

  You need to ensure that the data is updated every morning. The solution must minimize configuration effort.

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

  NOTE: Each correct selection is worth one point.

  A. Configure the dataset to use the existing On-premises data gateway.

  B. Deploy an On-premises data gateway in personal mode.

  C. Set the refresh frequency to Daily.

  D. Configure the dataset to use the personal gateway.

  Correct Answer: AC

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

• Question 9:

  You have a Power Bl query named Sates that imports the columns shown in the following table.

  

  Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.

  You need to reduce the load times of the query without affecting the analysis.

  Which two actions achieve this goal? Each correct answer presents a complete solution.

  NOTL Each correct selection is worth one pant.

  A. Remove the rows in which sales [status] has a value of Canceled.

  B. Change the data type of sale [Delivery_Time] to Integer

  C. Removes (Canceled Date).

  D. Split Sales [Sale_Date] into separate date and time columns.

  E. Remove sales [Sales_Date].

  Correct Answer: AE

  It says: You need to reduce the LOAD times of the query without affecting the analysis. Only answers A and E can reduce the load times. D may reduce only the time needed to process the data. Someone said that E is not the answer because: "All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value". You must read again the decription cause it says " Each answer presents a COMPLETE solutiuon" not part of a solution.

• Question 10:

  You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization.

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

  NOTE: Each correct selection is worth one point.

  A. Add the same slicer to each page and configure Sync slicers.

  B. Edit the interactions of the KPI visualization.

  C. Configure a page-level filter.

  D. Edit the interactions of the slicer that is on the same page as the KPI visualization.

  E. Configure a report-level filter.

  Correct Answer: AD

  Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.

  By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.

  Reference:

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