Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 161:

  What should you create to meet the reporting requirements of the sales department?

  A. a measure column that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

  B. a calculated column that uses the following formula: ABS(Sales[sales_amount])

  C. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))

  D. a measure that uses the following formula: SUM(Sales[sales_amount])

  Correct Answer: A

• Question 162:

  You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

  A. Sync the slicers on Page1 and Page3

  B. On each page, modify the interactions of the slicer.

  C. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.

  Correct Answer: A

• Question 163:

  For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel

  We located in a Microsoft SharePoint folder The data model contains several measures

  You need to create a Power Bl report from the existing data.

  The solution must minimize development effort. Which type ol data source should you use?

  A. a SharePoint folder

  B. Power Bl dataflows

  C. an Excel workbook

  D. Power Bl dataset

  Correct Answer: D

  case states there is already a report published and the datamodel contains measures. therefore and to be able to use the measures in the datamodel you should connect to the existing dataset (which was created when you plublished the report) instead of starting from scratch with the files in the SharePoint folder.

• Question 164:

  You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

  

  You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

  

  What should you do?

  A. Edit the details of each tile.

  B. Change the report theme.

  C. Change the dashboard theme.

  D. Create a custom CSS file.

  Correct Answer: C

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes#how-dashboard-themes-work

• Question 165:

  Your company has training videos that are published to Microsoft Stream. You need to surface the videos directly in a Microsoft Power BI dashboard. Which type of tile should you add?

  A. video

  B. custom streaming data

  C. text box

  D. web content

  Correct Answer: D

  https://docs.microsoft.com/en-us/stream/portal-embed-video https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-add-widget#add-web-content

• Question 166:

  You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.

  You build a report analyzing the internal networks of employees based on whom they send emails to.

  You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.

  What should you do?

  A. Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

  B. Remove the Subject and Body columns during the import.

  C. From Model view, set the Subject and Body columns to Hidden.

  Correct Answer: B

• Question 167:

  You have a Power BI report named Report' and a dashboard named Dashboard'. 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 the bar chart displays on Dashboard',

  What should you do?

  A. Refresh the dataset used by Report1 and Dashboard1.

  B. Select Refresh visuals for Dashboard1.

  C. Edit the details for the dashboard tile Of Dashboar1.

  D. Pin the Sales by month bar chart to Dashboard1.

  Correct Answer: A

• Question 168:

  You have a Power BI model that contains a table named Employee. The table contains the following data.

  Each employee has one manager as shown in the ParentEmployeelD column

  

  All reporting paths lead to the CEO at the top of the organizational hierarchy.

  You need to create a calculated column that returns the count of levels from each employee to the CEO.

  Which DAX expression should you use?

  A. PATHLENGTH(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]))

  B. PATHITEM(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1,INTEGER)

  C. PATHCONTAINS(PATH(Employee[EmployeeID],Employee[ParentEmployeeID]),1)

  D. PATH(Employee[EmployeeID],Employee[ParentEmployeeID])

  Correct Answer: A

  Although for CEO it returns 1 - so I personally would substract 1 from this PATHLENGTH when creating the report, as I think numbers of levels from CEO to CEO is 0, formanagaers directly under CEO it is 1 etc

• Question 169:

  You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

  A. stacked area chart

  B. donut chart

  C. line chart

  D. waterfall chart

  Correct Answer: C

  A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time ?a time series ?thus the line is often drawn chronologically.

  Example:

  

  Reference: https://www.data-to-viz.com/graph/line.html

• Question 170:

  You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order. What should you configure in Microsoft Power Bl Desktop?

  A. the bookmark order

  B. the layer order

  C. the tab order

  D. the X position

  Correct Answer: C

  If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.

  Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools