Microsoft PL-300 Based on Real Exam Environment

Microsoft Power BI Data Analyst Questions and Answers

Question 17

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.

Options:

Column profile

Column distribution

Show whitespace

Column quality

Monospace

Question 18

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

Options:

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power Bi Desktop, use the Auto date/time option when creating the reports.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

Question 19

You have a Power Bl report that uses row-level security (RLS).

You need to transfer RLS membership maintenance to an Azure network security team. The solution must NOT provide the Azure network security team with the ability to manage reports, datasets. or dashboards.

What should you do?

Options:

Add the Azure network security team as members of the RLS role.

Instruct the Azure network security team to create security groups. Configure RLS to use the groups.

Configure custom instructions for the Request access feature that instructs users to contact the Azure network security team.

Grant the Read and Build permissions for the Power Bl datasets to the Azure network security team.

Question 20

You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.

You build a report analyzing the internal networks of employees based on whom they send emails to.

You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.

What should you do?

Options:

Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Remove the Subject and Body columns during the import.

From Model view, set the Subject and Body columns to Hidden.

Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Microsoft PL-300 Based on Real Exam Environment

Microsoft Power BI Data Analyst Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce