Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 171:

  You have four sales regions. Each region has multiple sales managers.

  You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.

  You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.

  A sales manager changes to a different region.

  You need to ensure that the sales manager can see the correct sales data.

  What should you do?

  A. From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.

  B. Change the Microsoft Power Bl license type of the sales manager.

  C. Manage the permissions of the underlying dataset

  D. Request that the sales manager be added to the correct Azure Active Directory group.

  Correct Answer: D

  Using AD Security Groups, you no longer need to maintain a long list of users.

  All that you will need to do is to put in the AD Security group with the required permissions and Power BI will do the REST! This means a small and simple security file with the permissions and AD Security group.

  Note: Configure role mappings Once published to Power BI, you must map members to dataset roles. Members can be user accounts or security groups. Whenever possible, we recommend you map security groups to dataset roles. It involves managing security group memberships in Azure Active Directory. Possibly, it delegates the task to your network administrators.

  Reference: https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security-groups/ https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

• Question 172:

  You have multiple dashboards.

  You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally Identifiable Information (PII). The solution must minimize configuration effort and impact on the dashboard design.

  What should you use?

  A. comments

  B. tiles

  C. Microsoft Information Protection sensitivity labels

  D. Active Directory groups

  Correct Answer: C

  Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical

  content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied to datasets, reports, dashboards, and dataflows.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/admin/service-security-sensitivity-label-overview

• Question 173:

  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.

  Correct Answer: D

• Question 174:

  You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

  A. Add the sales department as a member of the reports workspace

  B. Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

  C. Distribute an app to the users in the Azure Active Directory group of the sales department.

  D. Share each report to the Azure Active Directory group of the sales department.

  Correct Answer: B

• Question 175:

  In the Power BI service, you create an app workplace that contains several dashboards.

  You need to provide a user named [email protected] with the ability to edit and publish dashboards.

  What should you do?

  A. Modify the members of the app workspace.

  B. Configure security for the dataset used by the app.

  C. Share the dashboard, and then modify the Access settings of the dashboard.

  D. From the app workspace, click Update app, and then configure the Access settings.

  Correct Answer: C

• Question 176:

  You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications.

  What should you do?

  A. Share the dashboard to the user.

  B. Create a subscription.

  C. Create a data alert.

  D. Tag the user in a comment.

  Correct Answer: C

  You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:

  Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.

  Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly.

  Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that have been certified.

  Email subscriptions don't support R-powered custom visuals at this time.

  Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

• Question 177:

  You need to create the dataset. Which dataset mode should you use?

  A. DirectQuery

  B. Import

  C. Live connection

  D. Composite

  Correct Answer: D

• Question 178:

  You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders. Which type of visualization should you create?

  A. bar chart

  B. scatterplot

  C. pie chart

  Correct Answer: A

  Scenario: The On-Time Shipping report will show the following metrics for a selected shipping month or quarter: The percentage of orders that were shipped late by country and shipping region Customers that had multiple late shipments during the last quarter

  Note: Bar and column charts are some of the most widely used visualization charts in Power BI. They can be used for one or multiple categories. Both these chart types represent data with rectangular bars, where the size of the bar is proportional to the magnitude of data values.

  The difference between the two is that if the rectangles are stacked horizontally, it is called a bar chart. If the rectangles are vertically aligned, it is called a column chart.

  Reference: https://www.pluralsight.com/guides/bar-and-column-charts-in-power-bi

• Question 179:

  Which DAX expression should you use to get the ending balances in the balance sheet reports?

  A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )

  B. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )

  C. FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )

  D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( 'Date' [Date] ) )

  Correct Answer: A

  Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter. DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.

  Reference: https://docs.microsoft.com/en-us/dax/datesqtd-function-dax

• Question 180:

  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.

  Correct Answer: AE

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