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

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

List of questions

Question 141

Report
Export
Collapse

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 a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets. You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?

Yes

Yes

No

No

Suggested answer: B

Explanation:

We need to click "Import", not "Connect".

Reference:

https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

asked 05/10/2024
DAVID LOPEZ MORGADO
41 questions

Question 142

Report
Export
Collapse

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 a query for a table named Sales. Sales has a column named CustomerlD. The Data Type of CustomerlD is Whole Number. You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values. You need to ensure that nonnumeric values in the CustomerlD column are set to 0.

Solution: From Query Editor, select the CustomerlD column and click Remove Errors.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: B
asked 05/10/2024
Yosra Chabchoub
38 questions

Question 143

Report
Export
Collapse

You have the following table named Location.

Microsoft PL-300 image Question 110 106367 10052024010716000000

The GeoCode column represents the country where each customer is located.

You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

Microsoft PL-300 image Question 110 106367 10052024010716000000

You need to ensure that the map displays the country locations.

What should you do?

Replace the values in the GeoCode column with postal codes or zip codes.

Replace the values in the GeoCode column with postal codes or zip codes.

Change the name of the GeoCode column to Country.

Change the name of the GeoCode column to Country.

Change the name of the Location table to Country.

Change the name of the Location table to Country.

Change the Default Summarization of the GeoCode column.

Change the Default Summarization of the GeoCode column.

Add a Geoportal column to the Location table.

Add a Geoportal column to the Location table.

Change the Data Type of the GeoCode column.

Change the Data Type of the GeoCode column.

Suggested answer: B

Explanation:

Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

asked 05/10/2024
Alireza Noura
35 questions

Question 144

Report
Export
Collapse

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 a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date. The tables have the following relationships:

Sales[DueDate] and Date[Date]

Sales[ShipDate] and Date[Date]

Sales[OrderDate] and Date[Date]

The active relationship is on Sales[DueDate].

You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data. Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A

Explanation:

Reference:

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

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

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

asked 05/10/2024
Maureen Lande
44 questions

Question 145

Report
Export
Collapse

HOTSPOT

You are creating a column chart visualization.

You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

Microsoft PL-300 image Question 112 106369 10052024010716000000

The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

Microsoft PL-300 image Question 112 106369 10052024010716000000

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 145 106369 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 145 106369 10052024010716000
asked 05/10/2024
G C
48 questions

Question 146

Report
Export
Collapse

HOTSPOT

You need to create a visual as shown in the following exhibit.

Microsoft PL-300 image Question 113 106370 10052024010716000000

The indicator color for Total Sales will be based on % Growth to Last Year.

The solution must use the existing calculations only.

How should you configure the visual? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 146 106370 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 146 106370 10052024010716000

Explanation:

Box 1: Background color

To format the Color column based on its field values, select Conditional formatting for the Color field, and then select Background color or Font color. In the Background color or Font color dialog box, select Field value from the Format by drop-down field. Box 2: Field value

With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field values.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

asked 05/10/2024
Tim Klein
37 questions

Question 147

Report
Export
Collapse

HOTSPOT

You are creating a quick measure as shown in the following exhibit.

Microsoft PL-300 image Question 114 106371 10052024010716000000

You need to create a monthly rolling average measure for Sales over time-How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 147 106371 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 147 106371 10052024010716000

Explanation:

Box 1: Total Sales

We select the field Total Sales

Box 2: Date

Select a date field.

Box 3: Month

Monthly periods.

Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quick-measures

asked 05/10/2024
Thijs van Ham
36 questions

Question 148

Report
Export
Collapse

HOTSPOT

You are creating an analytics report that will consume data from the tables shown in the following table.

Microsoft PL-300 image Question 115 106372 10052024010716000000

There is a relationship between the tables.

There are no reporting requirements on employeejd and employee_photo.

You need to optimize the data model

What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.


Microsoft PL-300 image Question 148 106372 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 148 106372 10052024010716000

Explanation:

Box 1: Hide

Optimize data by hiding fields and sorting visualization data

Box 2: Delete

The fastest way to optimize your Power BI report is to limit the number of columns to only the ones you need in your data model. Go through your tables in Power Query and determine what fields are being used. Delete these columns if they are not being used in any of your reports or calculations.

Reference:

https://tessellationtech.io/optimizing-power-bi-reports/

asked 05/10/2024
SAM E REYES
34 questions

Question 149

Report
Export
Collapse

HOTSPOT

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Microsoft PL-300 image Question 116 106373 10052024010716000000

Sales contains only the data shown in the following table.

Microsoft PL-300 image Question 116 106373 10052024010716000000

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 149 106373 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 149 106373 10052024010716000

Explanation:

Box 1: Yes

The Related function returns a related value from another table.

The RELATED function requires that a relationship exists between the current table and the table with related information. You specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch the value from the specified column in the related table. If a relationship does not exist, you must create a relationship. Box 2: Yes

Box 3: No

TX only occurs in the Sales table, but not in the CityData table.

Reference:

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

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

asked 05/10/2024
Laura Archilla
36 questions

Question 150

Report
Export
Collapse

DRAG DROP

You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide. You have a table named Products that contains the columns shown in the following table.

Microsoft PL-300 image Question 117 106374 10052024010716000000

Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value. You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size. 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 150 106374 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 150 106374 10052024010716000
asked 05/10/2024
Camille Rudio
35 questions
Total 370 questions
Go to page: of 37
Search

Related questions