Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 131:

  You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.

  You need to ensure that all the visualization in the report can be consumed by users.

  Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Funnel charts

  B. Custom visuals

  C. Bubble maps

  D. Breadcrumbs

  E. R visuals

  Correct Answer: DE

  References: https://powerbi.microsoft.com/en-us/guided-learning/reportserver-quickstart-powerbi-report/

• Question 132:

  You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers.

  The report contains a line chart that shows expenses by month.

  You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort.

  What should you do?

  A. Add a column chart, a bookmark, and a button for users to choose a visual.

  B. Create a mobile report that contains a column chart.

  C. Create a separate report page for users to view the column chart.

  D. Enable report readers to personalize visuals.

  Correct Answer: C

• Question 133:

  You have the visual shown in the Original exhibit. {Click the Original tab.)

  

  You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

  

  What should you add to the visual?

  A. a measure

  B. a trendline

  C. a forecast

  D. an Average line

  Correct Answer: C

  Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.

  

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

• Question 134:

  You import two Microsoft Excel tables named Customer and Address into Power Query Customer contains the following columns:

  Customer ID Customer Name Phone Email Address Address ID

  Address contains the following columns: Address ID Address Line 1 Address Line 2 City State/Region Country Postal Code

  Each Customer ID represents a unique customer m the Customer table. Each Address ID represents a unique address m the Address table. You need to create a query that has one row per customer. Each row must contain City. State/ Region, and Country for each customer.

  What should you do?

  A. Append the Customer and Address tables.

  B. Transpose the Customer and Address tables.

  C. Group the Customer and Address tables by the Address ID column.

  D. Merge the Customer and Address tables.

  Correct Answer: D

• Question 135:

  You have an on-premises Power BI Report Server.

  You plan to create a report in Power BI Desktop and publish the report to the report server.

  Which data source should the report use?

  A. Microsoft Azure SQL Database

  B. a Microsoft SQL Server database

  C. a Microsoft SQL Server Analysis Services (SSAS) database

  D. Microsoft Excel

  Correct Answer: C

  References: https://docs.microsoft.com/en-us/power-bi/report-server/quickstart-create-powerbi-report https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-sources

• Question 136:

  You have a PBiX file that imports several tables from an Azure SQL database.

  The data will be migrated to another Azure SQL database.

  You need to change the connections in the PBIX file. The solution must minimize administrative effort.

  What should you do?

  A. From Power Query Editor, modify the source of each query.

  B. Create a PBiT file, open the file, and change the data sources when prompted

  C. From Power Query Editor, create new queries.

  D. Modify the Data source settings.

  Correct Answer: D

• Question 137:

  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 assign all the users the Viewer role to the workspace.

  Does this meet the goal?

  A. Yes

  B. No

  Correct Answer: B

  "You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports"

• Question 138:

  Your company plans to completely separate development and production assets such as datasets, reports, and dashboards in Microsoft Power Bl. You need to recommend an application lifecycle strategy. The solution must minimize maintenance to update access 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. In the same 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.

  C. Create separate workspaces for development and production. Grant the end users access to the production workspace.

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

  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 139:

  You have a Power Bl report for the marketing department. The report reports on web traffic to a blog and contains data from the following tables.

  

  There is a one-to-many relationship from Posts to Traffic that uses the URL and URL Visited columns. The report contains the visuals shown in the following table.

  

  The dataset takes a long time to refresh.

  You need to modify Posts and Traffic queries to reduce toad times.

  Which two actions will reduce the toad times? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Remove the rows m Traffic in which Traffic [Referring URL] does not start with "/"

  B. Remove the rows in Posts in which Post [Publish Date] is in the last seven days.

  C. Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).

  D. Remove Posts [Full Text] and Posts [Summary].

  E. Remove the rows in Traffic in which Traffic [URL visited] does not contain "blog''

  Correct Answer: DE

  D.These two columns are not used in the visuals and can be removed.

  E.Only blog posts rows are useful for the visuals.

  Incorrect:

  Three visuals need historical data.

  Traffic[Referring URL] is used in one of the visuals and therefore cannot be removed.

  These rows are used in 3 visuals.

• Question 140:

  You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values on a slicer on one page, the visuals are not updated on all the pages. You need to recommend a

  solution to ensure that users can select a value once to filter the results on all the pages.

  What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Sync the slicers across the pages.

  B. Replace the slicers with page-level filters.

  C. Replace the slicers with visual-level filters.

  D. Create a bookmark for each slicer value.

  E. Replace the slicers with report-level filters.

  Correct Answer: AE

  Add a report-level filter to filter an entire report. The visuals on the active page, and on all pages in the report, change to reflect the new filter. You can sync a slicer and use it on any or all pages in a report.

  1. On the Power BI Desktop View menu, select Sync slicers.

  

  The Sync slicers pane appears between the Filters and Visualizations panes.

  

  Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-report-add-filter https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers