Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 31:

  You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.

  You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.

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

  NOTE: Each correct selection is worth one point.

  A. Use quick insights on the dashboard.

  B. Hide the report page.

  C. Ask a question by using QandA.

  D. Add the visual to the report.

  E. Pin the visual to the dashboard.

  Correct Answer: CE

• Question 32:

  You have a collection of reports for the HR department of your company.

  You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months.

  Which type of visualization should you use?

  A. scatter chart

  B. ribbon chart

  C. line chart

  D. key influences

  Correct Answer: C

  The best data for forecasting is time series data or uniformly increasing whole numbers. The line chart has to have only one line.

  Try forecasting: Try the new forecasting capabilities of Power View today on your own data or with the sample report available as part of the Power BI report samples. To view your own data, upload a workbook with a Power View time series line chart to Power BI for Office 365.

  Reference: https://powerbi.microsoft.com/en-us/blog/introducing-new-forecasting-capabilities-in-power-view-for-office-365

• Question 33:

  You have the Power Bl model shown in the following exhibit.

  

  There are four departments in the Departments table.

  You need to ensure that users can see the data of their respective department only.

  What should you do?

  A. Create a row-level security (RLS) role for each department, and then define the membership of the role.

  B. Create a DepartmentID parameter to filter the Departments table.

  C. To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.

  D. Create a slicer that filters Departments based on DepartmentID.

  Correct Answer: A

• Question 34:

  You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

  1.

  First name

  2.

  Last name

  3.

  Email address

  4.

  State/Region

  5.

  Phone number

  You import the list into Power Query Editor.

  You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

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

  NOTE: Each correct selection is worth one point.

  A. Open the Advanced Editor.

  B. Select Column quality.

  C. Enable Column profiling based on entire dataset.

  D. Select Column distribution.

  E. Select Column profile.

  Correct Answer: CE

  In Power query, the load preview by default is 1000 row. By default, the column quality also only looks at the first 1000 row. You can verify this by the status bar at the bottom of the Power query window. To change the profiling so it analyses

  the entire column of data, select the profiling status in the status bar. Then select Column profiling based on the entire data set.

  https://theexcelclub.com/data-profiling-views-in-power-query-excel-and-power-bi/

• Question 35:

  You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.

  You need to reduce the size of the data model.

  What should you do?

  A. Round the hour of the Date column to startOfHour.

  B. Change the data type of the Date column to Text.

  C. Trim the Date column.

  D. Split the Date column into two columns, one that contains only the time and another that contains only the date.

  Correct Answer: D

  We have to separate date and time tables. Also, we don't need to put the time into the date table, because the time is repeated every day. Split your DateTime column into a separate date and time columns in fact table, so that you can join the date to the date table and the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.

  Reference: https://intellipaat.com/community/6461/how-to-include-time-in-date-hierarchy-in-power-bi

• Question 36:

  You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.

  You need to modify the report so that when you select a column m the column chart, the donut chart redraws by using the data from the selected column.

  What should you do?

  A. Select the column chart and set the donut chart interaction to None.

  B. Select the column chart and set the donut chart interaction to Filter.

  C. Select the donut chart and set the column chart interaction to Filter.

  D. Select the donut chart and set the column chart interaction to None.

  Correct Answer: B

• Question 37:

  You build a Power Bl report that displays 10T temperature data streaming from a refrigerator.

  You publish the report to the Bl service.

  You need to be notified when the temperature rises above four degrees Celsius.

  What should you do?

  A. Pin a report page to a dashboard and set an alert on the page.

  B. Set an alert on a KPI visual in the report.

  C. Pin a card visual to a dashboard and set an alert on the tile.

  D. Pin a card visual to a dashboard and create a subscription.

  Correct Answer: A

• Question 38:

  You are creating a Power BI model that contains a table named Store. Store contains the following fields.

  You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?

  A. Set the data category of City. State/Province, and Country.

  B. Set Summarization for City. State/Province, and Country to Don't summarize

  C. Change the data type of City. State/Province, and Country.

  D. Create a calculated column that concatenates the values it City, State/Province, and Country.

  Correct Answer: A

• Question 39:

  You have a Microsoft Excel file in a Microsoft OneDrive folder.

  The file must be imported to a Power Bi dataset

  You need to ensure that the dataset can be refreshed in powefbi.com.

  Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Text/CSV

  B. Folder

  C. Excel Workbook

  D. SharePoint folder

  E. Web

  Correct Answer: DE

  -

  Copy and edit Path of the Excel file then use "Web" Connector: Option E

  -

  Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D Source: https://www.youtube.com/watch?v=GGHbbg6yi-A

• Question 40:

  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

  Correct Answer: C