Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 111:

  Note: This question is a part of a series of questions that present 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

  exactly the same in each question in this series.

  Start of repeated scenario

  You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

  

  You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

  

  You plan to use Power BI to import data from 2013 to 2015. Product Subcategory [Subcategory] contains NULL values.

  End of repeated scenario.

  You implement the Power BI model.

  You add another table named Territory to the model. A sample of the data is shown in the following table.

  

  You need to create a relationship between the Territory table and the Sales table.

  Which function should you use in the query for Territory before you create the relationship?

  A. Table.RemoveMatchingRows

  B. Table.Distinct

  C. Table.InDistinct

  D. Table.ReplaceMatchingRows

  Correct Answer: B

  References: https://msdn.microsoft.com/en-us/library/mt260775.aspx

• Question 112:

  You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals:

  1.

  Switch the measures used in the visuals.

  2.

  Change the visualization type.

  3.

  Add a legend.

  4.

  The solution must minimize development effort. What should you do?

  A. Enable personalization for each Visual.

  B. Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart

  C. Edit the interactions between the three visuals.

  D. Enable personalization for the report

  Correct Answer: C

• Question 113:

  Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power BI.

  You need to recommend an application lifecycle strategy. The solution must minimize access to production assets and prevent end users from viewing the development assets.

  What should you recommend?

  A. Create production reports in a separate workspace that uses a shared dataset from the development workspace. Grant the end users access to the production workspace.

  B. Create one workspace for development. From the new workspace, publish an app for production.

  C. Create a workspace for development and a workspace for production. From the production workspace, publish an app.

  D. In one workspace, create separate copies of the assets and append DEV to the names of the copied assets. Grant the end users access to the workspace.

  Correct Answer: C

  Use different work stages (Development, Test, and Production).

  Deploy from the Development workspace.

  Reference:

  https://visualbi.com/blogs/microsoft/powerbi/application-lifecycle-management-power-bi/

• Question 114:

  You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.

  The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.

  The report is a single page that contains 15 custom visuals and 10 default visuals.

  Users say that the report is slow to load the visuals when they access and interact with the report

  You need to recommend a solution to improve the performance of the report.

  What should you recommend?

  A. Split the visuals onto multiple pages.

  B. Implement row-level security (RLS).

  C. Replace the default visuals with custom visuals.

  D. Increase the number of times that the dataset is refreshed.

  Correct Answer: A

• Question 115:

  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 several reports and dashboards in a workspace.

  You need to grant all organizational users read access to a dashboard and several reports.

  Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  Statements and questions are tricky and confusing. When the access is granted for the group (all users) for ALL (each) dashboards and ALL (each) reports in the workspace, then the will have read access to the specific (A, one) Dashboard and several reports, because they are part of all dashboards and reports. There is no statement, that for the other dashboards (except the one) and the other reports (except the several) that access must be prevented. They are also accessible (maybe it is not desired but not stated here).

• Question 116:

  You have an Azure SQL database that contains sales transactions. The database is updated frequently.

  You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.

  How should you configure the data connection?

  A. Add a SQL statement.

  B. Set Data Connectivity mode to DirectQuery.

  C. Set the Command timeout in minutes setting.

  D. Set Data Connectivity mode to Import.

  Correct Answer: B

  With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.

  DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

• Question 117:

  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 several reports and dashboards in a workspace.

  You need to grant all organizational users read access to a dashboard and several reports.

  Solution: You publish an app to the entire organization.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: A

  https://docs.microsoft.com/es-es/power-bi/collaborate-share/service-create-distribute-apps

• Question 118:

  What should you do to address the existing environment data concerns?

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

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

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

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

  Correct Answer: B

• Question 119:

  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 median line by using the Salary measure. Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  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_median.php

• Question 120:

  You have a Power Bl report that contains five pages.

  Pages 1 to 4 are visible and page 5 is hidden.

  You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages.

  The solution must minimize development and maintenance effort as pages are added to the report.

  What should you do first?

  A. Add a blank button to page 1.

  B. Add a bookmark navigation button to page 1.

  C. Create a bookmark for each page.

  D. Add a page navigation button to page 1.

  Correct Answer: C