ExamGecko
Home / Microsoft / PL-300 / List of questions
Ask Question

Microsoft PL-300 Practice Test - Questions Answers, Page 24

List of questions

Question 231

Report
Export
Collapse

HOTSPOT

You have a Power Bl report.

You have the following tables.

Microsoft PL-300 image Question 198 106455 10052024010716000000

You have the following DAX measure.

Microsoft PL-300 image Question 198 106455 10052024010716000000


Microsoft PL-300 image Question 231 106455 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 231 106455 10052024010716000
asked 05/10/2024
Veronica Puddu
54 questions

Question 232

Report
Export
Collapse

HOTSPOT

You have a Power Bl report named Orders that supports the following analysis:

• Total sales over time

• The count of orders over time

• New and repeat customer counts

The data model size is nearing the limit for a dataset in shared capacity. The model view for the dataset is shown in the following exhibit.

Microsoft PL-300 image Question 199 106456 10052024010716000000


Microsoft PL-300 image Question 232 106456 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 232 106456 10052024010716000
asked 05/10/2024
Matthew Farrington
35 questions

Question 233

Report
Export
Collapse

HOTSPOT

You have a column named UnitslnStock as shown in the following exhibit

Microsoft PL-300 image Question 200 106457 10052024010716000000

UnitsInStock has 75 non-null values, of which 51 are unique.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 233 106457 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 233 106457 10052024010716000
asked 05/10/2024
FELIPE VILLAGOMEZ CARDENAS VILLAGOMEZ
42 questions

Question 234

Report
Export
Collapse

DRAG DROP

You plan to create a report that will display sales data from the last year for multiple regions You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.


Microsoft PL-300 image Question 234 106458 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 234 106458 10052024010716000
asked 05/10/2024
DAVID STAATZ
40 questions

Question 235

Report
Export
Collapse

HOTSPOT

You plan to create a Power Bl dataset to analyze attendance at a school. Data will come from two separate views named View1 and View? in an Azure SQL database. View1 contains the columns shown in the following table.

Microsoft PL-300 image Question 202 106459 10052024010716000000

View2 contains the columns shown in the following table.

Microsoft PL-300 image Question 202 106459 10052024010716000000

The views can be related based on the Class ID column.

Class ID is the unique identifier for the specified class, period, teacher, and school year. For example, the same class can be taught by the same teacher during two different periods, but the class will have a different class ID. You need to design a star schema data model by using the data in both views. The solution must facilitate the following analysis:

The count of classes that occur by period

The count of students in attendance by period by day

The average number of students attending a class each month

In which table should you include the Teacher First Name and Period Number fields? To answer,

select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 235 106459 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 235 106459 10052024010716000
asked 05/10/2024
Markus Hechtl
35 questions

Question 236

Report
Export
Collapse

You have the Power Bl model shown in the following exhibit.

Microsoft PL-300 image Question 203 106460 10052024010716000000

There are four departments in the Departments table.

You need to ensure that users can see the data of their respective department only.

What should you do?

Create a row-level security (RLS) role for each department, and then define the membership of the role.

Create a row-level security (RLS) role for each department, and then define the membership of the role.

Create a DepartmentID parameter to filter the Departments table.

Create a DepartmentID parameter to filter the Departments table.

To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.

To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.

Create a slicer that filters Departments based on DepartmentID.

Create a slicer that filters Departments based on DepartmentID.

Suggested answer: A
asked 05/10/2024
Rakesh Prasad
25 questions

Question 237

Report
Export
Collapse

You import a Power Bl dataset that contains the following tables:

• Date

• Product

• Product Inventory

The Product inventory table contains 25 million rows. A sample of the data is shown in the following table.

Microsoft PL-300 image Question 204 106461 10052024010716000000

The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. What should you do?

Change Summarization for DateKey to Don't Summarize.

Change Summarization for DateKey to Don't Summarize.

Change the data type of UnitCost to Integer.

Change the data type of UnitCost to Integer.

Remove the relationship between Date and Product Inventory.

Remove the relationship between Date and Product Inventory.

Remove MovementDate.

Remove MovementDate.

Suggested answer: D
asked 05/10/2024
Karen Vivanco
29 questions

Question 238

Report
Export
Collapse

You have more than 100 published datasets.

Ten of the datasets were verified to meet your corporate quality standards.

You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets. What should you do?

Publish the datasets in an app.

Publish the datasets in an app.

Promote the datasets.

Promote the datasets.

Feature the dataset on the home page.

Feature the dataset on the home page.

Certify the datasets.

Certify the datasets.

Suggested answer: D
asked 05/10/2024
Chakravarthy Sankaranarayanan
34 questions

Question 239

Report
Export
Collapse

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1. A user wants to create a report by using the data In DS1 and publish the report to another workspace. You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user. What should you do?

Share RPT1 with the user.

Share RPT1 with the user.

Add the user as a Viewer of Workspace1.

Add the user as a Viewer of Workspace1.

Add the user as a member of Workspace1.

Add the user as a member of Workspace1.

Grant the Build permission for DS1 to the user.

Grant the Build permission for DS1 to the user.

Suggested answer: D

Explanation:


asked 05/10/2024
João Faria
36 questions

Question 240

Report
Export
Collapse

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?

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

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.

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.

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.

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

Suggested answer: B

Explanation:

It is common practice that the PBI developer creates RLS groups and instructs the network team to create the corresponding AD roles. Then the developer assigns the AD groups to the RLS groups.

asked 05/10/2024
Wendie Canez
39 questions
Total 370 questions
Go to page: of 37
Search

Related questions