Microsoft PL-300 Exam Questions Instant Access

Question 1

You have an app workspace named Retail Analysis in the Power BI service.

You need manage the members that have access to the app workspace.

What should you do?

AFrom the Power BI Admin portal, click Usage metrics.

BFrom the Office 365 Admin center, click Users.

CFrom the Office 365 Admin center, click Groups.

DFrom the Power BI Admin portal, click Tenant settings.

Answer : C

Question 2

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?

AReplace the default visuals with AppSource visuals.

BChange any DAX measures to use iterator functions.

CRemove unused columns from tables in the data model.

DIncrease the number of times that the dataset is refreshed

Answer : C

Remove unused columns from tables in the data model. This will reduce the size of your PBIX file and make your data model more efficient. You can use Power Query Editor to remove any columns that are not used in your report or calculations.

Question 3

You have a Power Bl semantic model that contains two queries.

You discover that a report based on the model has performance issues.

You plan to use Power Query to reduce the data loaded to the model.

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

NOTE: Each correct answer is worth one point.

AApply group by and summarize techniques.

BCombine the queries by using Append.

CRemove unnecessary columns and rows.

DCombine the queries by using Merge.

ECreate a new query group.

Answer : A, C

Question 4

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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: You add a report-level filter that filters based on the order date.

Does this meet the goal?

AYes

BNo

Answer : B

The filter is applied after the data is imported.

Instead add a WHERE clause to the SQL statement.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

Question 5

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?

AMicrosoft Azure SQL Database

Ba Microsoft SQL Server database

Ca Microsoft SQL Server Analysis Services (SSAS) database

DMicrosoft Excel

Answer : C

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 6

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

AFrom Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

BFrom Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

CFrom Power Bl Desktop, use the Auto date/time option when creating the reports.

DFrom Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Answer : B

Use Power Query to calculate calendar quarter and calendar month.

Scenario:

A single dataset must support all three reports:

- The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region.

- The Top Products report will show the top 20 products based on the highest sales amounts sold in a selected order month or quarter, sales region, and product category.

The data model must minimize the size of the dataset as much as possible, while meeting the report requirements and the technical requirements.

Question 7

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.

Microsoft Power BI Data Analyst PL-300 Exam Questions