Microsoft PL-300 Exam Practice Test Instant Access

Question 1

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

AGet data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.

BGet data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

CGet data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to the
manufacturing reports library.

DGet data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Answer : B

We have to import Excel files from SharePoint, so we need the connector SharePoint folder which is used to get access to the files stored in the library. SharePoint list is a collection of content that has rows and columns (like a table) and is used for task lists, calendars, etc. Since we have to filter only on manufacturing reports, we have to select Transform and then filter by the corresponding folder path.

https://docs.microsoft.com/en-us/power-query/connectors/sharepointlist

Question 2

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

Aa measure that uses a formula of SUM (Sales [sales_id])

Ba calculated column that use a formula of COUNTA(sales [sales_id])

Ca measure that uses a formula of COUNTROWS (Sales)

Da calculated column that uses a formula of SUM (Sales [sales_id])

Answer : C

The sale department requires reports that contain the number of sales transactions.

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

https://docs.microsoft.com/en-us/dax/countrows-function-dax

Question 3

A manager can represent only a single country.

You need to use row-level security (RLS) to meet the following requirements:

The managers must only see the data of their respective country.

The number of RLS roles must be minimized.

Which two actions should you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

ACreate a single role that filters Country[Manager_Email] by using the USERNAME DAX function.

BCreate a single role that filters Country[Manager_Email] by using the USEROBJECTID DAX function.

CFor the relationship between Purchase Detail and Purchase, select Apply security filter in both directions.

DCreate one role for each country.

EFor the relationship between Purchase and Purchase Detail, change the Cross filter direction to Single.

Answer : A, C

In Power BI Service the username and userprincipalname both return the email address, it's only in Power BI Desktop that username is domain/username rather than the email address. So I agree that userprincipalname is better generally as you always get the same value, the answer is correct and you can use username as your RLS since the role will be applied in the Service. See https://community.powerbi.com/t5/Community-Blog/USERNAME-v-s-USERPRINCIPALNAME-in-RLS-for-Power-BI-Embedded/ba-p/1867670 for more information.

Question 4

You need to create a Power Bl theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.

What should you do?

ACreate a theme as a PBIVIZ file and import the theme into Power Bl Desktop.

BCreate a theme as a JSON file and import the theme into Power Bl Desktop.

CFrom Power Bl Desktop, use a built-in report theme.

DFrom Power Bl Desktop, customize the current theme.

Answer : D

Question 5

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 an on-premises data gateway.

You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

Solution: You configure incremental refresh.

Does this meet the goal?

AYes

BNo

Answer : B

Question 6

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

AOption A

BOption B

COption C

DOption D

Answer : A, D

Question 7

SIMULATION

You need to create a relationship in the dataset for RLS.

What should you do? To answer select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

ASee the answer as below in explanation

Answer : A

Explanation.

Answer as below

Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test