Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 91:

  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 Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

  You need to recreate the Power View sheets as reports in the Power Bl service.

  Solution: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power Bl, and then click Upload

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

• Question 92:

  You have a Power BI report. The report contains visualizations that have interactions. You need to identify which visualizations take the longest to complete. What should you use?

  A. SQL Server Profiler

  B. Performance Analyzer in Power BI Desktop

  C. Query Diagnostics in Power BI

  D. Microsoft Edge DevTools

  Correct Answer: B

  Use Power BI Desktop Performance Analyzer to optimize reports. In Power BI Desktop you can find out how each of your report elements, such as visuals and DAX formulas, are performing. Using the Performance Analyzer, you can see and record logs that measure how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive.

  Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

• Question 93:

  You manage a Power BI model has a table named Sales and product.

  You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.

  What should you do from Power BI Desktop?

  A. From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= "United States" andand [ProductCategory]= "Clothing"

  B. Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing

  C. From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= "United States"

  D. Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

  Correct Answer: D

  References: https://docs.microsoft.com/en-us/power-bi/power-bi-how-to-report-filter

• Question 94:

  You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.

  You are creating a Power Bl dashboard that will include two visuals from each report

  You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.

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

  NOTE: Each correct selection is worth one point.

  A. Upload a snapshot.

  B. Select the dark dashboard theme.

  C. Turn on tile flow.

  D. When pinning visuals to the dashboard, select Use destination theme.

  E. For the browser, set the color preference to dark mode.

  Correct Answer: DE

• Question 95:

  You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

  You need to ensure that the users will see the current data when they view the dashboard.

  How should you configure the connection to the data source?

  A. Deploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

  B. Deploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

  C. Deploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

  D. Deploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

  Correct Answer: D

  References: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#power-bi-connectivity-modes

• Question 96:

  You have five sales regions. Each region is assigned a single salesperson.

  You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.

  Salespeople must see only the data from their region.

  You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.

  A salesperson reports that she believes she should see more data.

  You need to verify what data the salesperson currently sees.

  What should you do?

  A. Use the Test as role option to view data as the salesperson's user account.

  B. Use the Test as role option to view data as the Sales role.

  C. Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

  D. Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

  Correct Answer: B

  Validate the roles within Power BI Desktop

  After you've created your roles, test the results of the roles within Power BI Desktop.From the Modeling tab, select View as.

  

  A picture containing application

  Description automatically generatedThe View as roles window appears, where you see the roles you've created.

  

  Select a role you created, and then select OK to apply that role.The report renders the data relevant for that role.

  You can also select Other user and supply a given user.Graphical user interface, application Select OK.The report renders based on what that user can see.

  Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

• Question 97:

  Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.

  You have a Microsoft SQL Server database that contains the following tables.

  

  The following columns contain date information:

  1.

  Date[Month] in the mmyyyy format

  2.

  Date[Date_ID] in the ddmmyyyy format

  3.

  Date[Date_name] in the mm/dd/yyyy format

  4.

  Monthly_returns[Month_ID] in the mmyyyy format

  The Order table contains more than one million rows.

  The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.

  You plan to use Power BI Desktop to create an analytics solution for the data.

  You need to create a relationship between the Order table and the Store table on the Store_ID column.

  What should you do before you create the relationship?

  A. In the Order table query, use the Table.TrasformRows function.

  B. In the Store table query, use the Table.TrasformRows function.

  C. In the Store table query, use the Table.TrasformColumnTypes function.

  D. In the Order table query, use the Table.TrasformColumnTypes function.

  Correct Answer: C

• Question 98:

  You are using the key influencers visual to identify which factors affect the quantity of items sold in an order.

  You add the following fields to the Explain By field:

  Customer Country Product Category Supplier Country Sales Employee Supplier Name Product Name Customer City

  The key influencers visual returns the results shown in the following exhibit.

  

  What can you identify from the visual?

  A. Customers in Austria order 18.8 more units than the average order quantity.

  B. Customers in Boise order 20.37 percent more than the average order quantity.

  C. Product Category positively influences the quantity per order.

  D. Customers in Cork order lower quantities than average.

  Correct Answer: A

  Average quantity of units is displayed.

  Incorrect:

  Not B: Average quantity of units is displayed, not percentage.

  Reference:

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

• Question 99:

  You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports.

  How should you provision access to the reports for the HR managers?

  A. Create a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

  B. Publish the reports to a different workspace other than the one hosting the datasets.

  C. Publish the reports in an app and grant the HR managers access permission.

  D. Add the HR managers as members of the existing workspace that hosts the reports and the datasets.

  Correct Answer: C

  Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have

  access to datasets in the workspace.

  RLS doesn't restrict this data access.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

• Question 100:

  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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

  You need to create a reference line to show which employees are above the median salary.

  Solution: You create a constant line and set the value to .5.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  Instead create a percentile line by using the Salary measure and set the percentile to 50%.

  Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

  Reference:

  https://dash-intel.com/powerbi/statistical_functions_percentile.php