Microsoft PL-300 Exam Questions Instant Access

Question 1

You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:

* Date

* Fiscal year

* Fiscal Quartet

* Month Name

* Calendar Year

* Week Number

* Month Number

* Calendar Quarter

You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?

ADATATABLE

BADDCOLUMS

CSUMMARIZE

DCALCULATE

Answer : C

Question 2

In the Power BI service, you create an app workplace that contains several dashboards.

You need to provide a user named user1@contoso.com with the ability to edit and publish dashboards.

What should you do?

AModify the members of the app workspace.

BConfigure security for the dataset used by the app.

CShare the dashboard, and then modify the Access settings of the dashboard.

DFrom the app workspace, click Update app, and then configure the Access settings.

Answer : C

Question 3

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.

You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.

Which report setting should you configure?

ADon't allow end user to save filters on this report.

BChange default visual interaction from cross highlighting to cross filtering.

CEnable the updated filter pane, and show filters in the visual header for this report.

DAllow users to add comments to this report.

EChoose the type of data you allow your end users to export.

Answer : E

https://powerbi.microsoft.com/en-us/blog/announcing-persistent-filters-in-the-service/

Question 4

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 5

You use an R visual to produce a map of 500,000 customers. You include the values of CustomerID, Latitude, and Longitude in the fields sent to the visual. Each customer ID is unique.

In powerbi.com, when users load the visual, they only see some of the customers.

What is the cause of the issue?

AThe visual was built by using a different version of R.

BThe data comes from a Microsoft SQL Server source.

CThe data is deduplicated.

DToo many records were sent to the visual.

Answer : D

R visuals in the Power BI service have a few limitations including:

Data size limitations -- data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image. Additionally, the input data has a limit of 250 MB.

https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

Question 6

You have a Power Bl semantic model named Model! that contains two fields named Sales and Quarter. Model 1 contains a DAX measure that sums the Sales column.

You need to create a report that will contain the visual shown in the following exhibit.

The solution must NOT require additional DAX measures.

Which type of visual should you use?

Aribbon chart

Bline chart

C100% stacked area chart

Darea chart

Answer : D

Question 7

You are reviewing a query that produces 10,000 rows in the Power Query Editor.

You need to identify whether a column contains only unique values.

Which two Data Preview options can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

AColumn profile

BColumn distribution

CShow whitespace

DColumn quality

EMonospace

Answer : A, B

B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.

By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).

A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.

https://docs.microsoft.com/en-us/power-query/data-profiling-tools

Microsoft Power BI Data Analyst PL-300 Exam Questions