PL-300 Free Practice Test

- (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 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: From the Power Bl service, get the data from SharePoint Online, and then click
Connect
Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: B
We need to click "Import", not "Connect".
References:
https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

- (Topic 1)
You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?

1. A. Create a security role that has a table filter on the Sales_Manager table where username = UserName()
2. B. Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
3. C. Create a security role that has a table filter on the Sales_Manager table where name = UserName().
4. D. Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Correct Answer: A
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row- level-security/

- (Topic 4)
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:
- Date[Month] in the mmyyyy format
- Date[Date_ID] in the ddmmyyyy format
- Date[Date_name] in the mm/dd/yyyy format
- 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?

1. A. In the Order table query, use the Table.TrasformRows function.
2. B. In the Store table query, use the Table.TrasformRows function.
3. C. In the Store table query, use the Table.TrasformColumnTypes function.
4. D. In the Order table query, use the Table.TrasformColumnTypes function.

Correct Answer: C

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

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. In the same workspace, create separate copies of the assets and append DEV to the names of the copied asset
4. D. Grant the end users access to the workspace.
5. E. Create separate workspaces for development and productio
6. F. Grant the end users access to the production workspace.
7. G. Create one workspace for developmen
8. H. From the workspace, publish an app for production.

Correct Answer: C