Question 1

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 BI. 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: From Power Query Editor, you import the table and then add a filter step to the query. Does this meet the goal?

Options :

A : Yes

B : No

Answer: B

Question 2

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders. The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter. City[State Province] = "Kentucky" Role2 contains the following filter. Date[Calendar Year] = 2020 If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

Options :

A : The user will see data for which the State Province value is Kentucky and the Calendar Year is 2020.

B : The user will see data for which the State Province value is Kentucky or the Calendar Year is 2020.

C : The user will see only data for which the State Province value is Kentucky.

D : The user will receive an error and will not be able to see the data in the report.

Answer: B

Question 3

What should you create to meet the reporting requirements of the sales department?

Options :

A :

B :

C :

D :

Answer: C

Question 4

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

Options :

A : Create a row-level security (RLS) role and add the finance team to the role as members

B : Provide an Excel workbook that is connected to the Finance dataset.

C : Grant the finance team write permissions to the Finance dataset.

D : Grant the finance team build permissions to the Finance dataset.

Answer: D

Question 5

You embed a Power BI report in a Microsoft SharePoint Online page.

A user name User1 can access the SharePoint Online page, but the Power BI web part displays the following

error message: “This content isn’t available”.

User1 is unable to view the report.

You verify that you can access the SharePoint Online page and that the Power BI report displays as expected.

You need to ensure that User1 can view the report form SharePoint Online.

What should you do?

Options :

A : Publish the app workspace.

B : Edit the settings of the Power BI web part.

C : Modify the members of the app workplace.

D : Share the dashboards in the app workspace.

Answer: C

Confidently Practice Online with Free PL-300 Exam Cram

Buying Options: