PL-300 Free Practice Test

- (Exam Topic 4)
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?

1. A. Viewer
2. B. Contributor
3. C. Member
4. D. Admin

Correct Answer: C
A Member can add members or others with lower permissions. Note:

- (Exam Topic 4)
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?

1. A. Create production reports in a separate workspace that uses a shared dataset from the development workspac
2. B. Grant the end users access to the production workspace.
3. C. Create one workspace for developmen
4. D. From the new workspace, publish an app for production.
5. E. Create a workspace for development and a workspace for productio
6. F. From the production workspace, publish an app.
7. G. In one workspace, create separate copies of the assets and append DEV to the names of the copied asset
8. H. 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/

- (Exam Topic 4)
Your company has employees in 10 states.
The company recently decided to associate each state to one of the following three regions: East, West, and North.
You have a data model that contains employee information by state. The model does NOT include region
information.
You have a report that shows the employees by state.
You need to view the employees by region as quickly as possible. What should you do?

1. A. Create a new aggregation that summarizes by employee.
2. B. Create a new group on the state column and set the Group type to List.
3. C. Create a new group on the state column and set the Group type to Bin.
4. D. Create a new aggregation that summarizes by state.

Correct Answer: B
https://www.mssqltips.com/sqlservertip/4720/binning-and-grouping-data-with-power-bi/

- (Exam Topic 4)
You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

1. A. decomposition tree
2. B. Q&A
3. C. smart narrative
4. D. key influences

Correct Answer: D

- (Exam Topic 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?

1. A. Yes
2. B. No

Correct Answer: B
The filter is applied after the data is imported. Instead add a WHERE clause to the SQL statement.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial