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

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

List of questions

Question 251

Report
Export
Collapse

You have a Power BI report that contains four pages.

All the pages contain a slicer for a field named Country,

You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3. The solution must prevent page 4 from being affected by selections on the other pages, What should you do?

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.

Sync the Country slicer on page 1, page 2, and page 3.

Sync the Country slicer on page 1, page 2, and page 3.

Move the Country slicer from page 2 and page 3 to page 1.

Move the Country slicer from page 2 and page 3 to page 1.

Suggested answer: B
asked 05/10/2024
Srinivasan Krishnamoorthy
39 questions

Question 252

Report
Export
Collapse

You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR. You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

• Create reports that use the HR dataset.

• Publish the reports to WorkspaceB.

• Prevent the ability to modify the HR dataset.

• Prevent the ability to add users to WorkspaceB.


Microsoft PL-300 image Question 219 Answer 1 106476 10052024010716000000


Microsoft PL-300 image Question 219 Answer 1 106476 10052024010716000000

Suggested answer: A
asked 05/10/2024
Mark Anthony Simon
38 questions

Question 253

Report
Export
Collapse

The Sales table contains records of sales by day from the last five years up until today's date.

You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

Which DAX expression should you use?

Microsoft PL-300 image Question 220 106477 10052024010716000000

Option A

Option A

Option B

Option B

option C

option C

Option D

Option D

Suggested answer: B
asked 05/10/2024
luis lozano
35 questions

Question 254

Report
Export
Collapse

You have a Power BI data model that contains a table named Stores. The table has the following columns:

* Store Name

* Open Date

* Status

* State

* City

You need to create a calculated column named Active Store Name that meets the following requirements:


Microsoft PL-300 image Question 221 Answer 1 106478 10052024010716000000


Microsoft PL-300 image Question 221 Answer 1 106478 10052024010716000000

Suggested answer: A
asked 05/10/2024
takasuka masahide
39 questions

Question 255

Report
Export
Collapse

You need to create a Power BI 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?

From Power Bl Desktop, customize the current theme,

From Power Bl Desktop, customize the current theme,

From power Bl Desktop, use a built in report theme.

From power Bl Desktop, use a built in report theme.

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

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

Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

Suggested answer: B
asked 05/10/2024
Nadja Burkart
32 questions

Question 256

Report
Export
Collapse

DRAG DROP

You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.

Microsoft PL-300 image Question 223 106480 10052024010716000000

The solution must minimize development effort

Which three 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 256 106480 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 256 106480 10052024010716000
asked 05/10/2024
Victor Ogbonna
34 questions

Question 257

Report
Export
Collapse

HOTSPOT

You are using Power Bi Desktop to connect to an Azure SQL database The connection is configured as shown in the following exhibit.

Microsoft PL-300 image Question 224 106481 10052024010716000000

Microsoft PL-300 image Question 224 106481 10052024010716000000

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 solution is worth one point


Microsoft PL-300 image Question 257 106481 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 257 106481 10052024010716000

Explanation:

https://docs.microsoft.com/en-us/power-query/connectors/azuresqldatabaseThe following table lists all of the advanced options you can set in Power Query Desktop and PowerQuery Online. Advanced option

Description

Command timeout in minutes

If your connection lasts longer than 10 minutes (the default timeout), you can enter another the connection open longer. This option is only available in Power Query Desktop. SQL statement

For information, go to Import data from a database using native database query.

Include relationship columns

If checked, includes columns that might have relationships to other tables. If this box is cleared, columns. Navigate using full hierarchy

If checked, the navigator displays the complete hierarchy of tables in the database you're connecting navigator displays only the tables whose columns and rows contain data. Enable SQL Server Failover support

If checked, when a node in the Azure SQL failover group isn't available, Power Query moves when failover occurs. If cleared, no failover occurs.

asked 05/10/2024
cristian vargas
42 questions

Question 258

Report
Export
Collapse

DRAG DROP

You have a Power BI data model that contains two tables named Products and Sales.

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

You have a report that contains a report-level filter for Products.

You need to create a measure that will return the percent of total sales for each product. The measure must respect the report-level filter when calculating the total. How should you complete the DAX measure? To answer drag the appropriate DAX functions to the correct targets- Each function may be used once, more than once, or not at all the spirt bar between panes or scroll to view content NOTE:

Each correct selection is worth one point


Microsoft PL-300 image Question 258 106482 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 258 106482 10052024010716000
asked 05/10/2024
Darren Sloan
41 questions

Question 259

Report
Export
Collapse

DRAG DROP

Exhibit:

Microsoft PL-300 image Question 226 106483 10052024010716000000

You need to create a report that meets the requirements:

• Visualizes the Sales value over a period of years and months

• Adds a Slicer for the month

• Adds a Slicer for the year

Which three actions Should you perform in sequence?


Microsoft PL-300 image Question 259 106483 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 259 106483 10052024010716000
asked 05/10/2024
Kevin Harley
29 questions

Question 260

Report
Export
Collapse

HOTSPOT

The data model must support the following analysis:

Microsoft PL-300 image Question 227 106484 10052024010716000000

Total sales by product by month in which the order was placed

Quantities sold by product by day on which the order was placed

Number Of sales transactions by quarter in Which the order was placed For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.


Microsoft PL-300 image Question 260 106484 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 260 106484 10052024010716000
asked 05/10/2024
Sivakumar Duraimanickam
36 questions
Total 370 questions
Go to page: of 37
Search

Related questions