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

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

List of questions

Question 31

Report
Export
Collapse

HOTSPOT

You need to create the Top Customers report.

Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Microsoft PL-300 image Question 31 106255 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 31 106255 10052024010716000

Explanation:

Box 1: Top N

Scenario: The Top Customers report will show the top 20 customers based on the highest sales amounts in a selected order month or quarter, product category, and sales region. Once you drag to SKU to Visual level filter you should get Top N option Note: The two most common filter types: automatic and manual. Then there are more advanced filters.

Box 2: Visual

Once you drag to SKU to Visual level filter you should get Top N option.

Reference:

https://powerbidocs.com/2020/01/21/power-bi-top-n-filters/

asked 05/10/2024
jaimie lloyd
44 questions

Question 32

Report
Export
Collapse

HOTSPOT

You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements. For each of the following statement, select Yes if the statement is true, Otherwise, select No.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 32 106256 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 32 106256 10052024010716000
asked 05/10/2024
SAI CHARAN TANGELLA
35 questions

Question 33

Report
Export
Collapse

HOTSPOT

You need to create a solution to meet the notification requirements of the warehouse shipping department. What should you do? To answer, select the appropriate options in the answer area.


Microsoft PL-300 image Question 33 106257 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 33 106257 10052024010716000

Explanation:

asked 05/10/2024
trobbies Real
26 questions

Question 34

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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

Solution: You add a WHERE clause to the SQL statement.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A
asked 05/10/2024
Kevin Suckiel
48 questions

Question 35

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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

Solution: You write a DAX expression that uses the FILTER function.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: B

Explanation:

The filter is applied after the data is imported.

Instead add a WHERE clause to the SQL statement.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

asked 05/10/2024
Wellington Rodrigues da Costa
34 questions

Question 36

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 are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

Solution: You add a report-level filter that filters based on the order date.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: B

Explanation:

The filter is applied after the data is imported.

Instead add a WHERE clause to the SQL statement.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

asked 05/10/2024
Piotr Jakubowski
41 questions

Question 37

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You add a Power Apps custom visual to the report.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A
asked 05/10/2024
alain giansily
40 questions

Question 38

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: In the Power Query M code, you replace references to the Excel file with DataSourceExcel.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: A

Explanation:

Instead modify the source step of the queries to use DataSourceExcel as the file path.

Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

asked 05/10/2024
Luis Alfonso Rodriguez Castro
35 questions

Question 39

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source. You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition. Solution: You create a new query that references DataSourceExcel.

Does this meet the goal?

Yes

Yes

No

No

Suggested answer: B

Explanation:

Instead modify the source step of the queries to use DataSourceExcel as the file path.

Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.

Reference:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

asked 05/10/2024
Victor Chacon
34 questions

Question 40

Report
Export
Collapse

You have the visual shown in the Original exhibit. {Click the Original tab.)

Microsoft PL-300 image Question 7 106264 10052024010716000000

You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

Microsoft PL-300 image Question 7 106264 10052024010716000000

What should you add to the visual?

a measure

a measure

a trendline

a trendline

a forecast

a forecast

an Average line

an Average line

Suggested answer: C

Explanation:

Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results.

Microsoft PL-300 image Question 7 explanation 106264 10052024010716000000

Reference:

https://powerbi.microsoft.com/fr-fr/blog/introducing-new-forecasting-capabilities-in-power-viewfor-office-365/

asked 05/10/2024
Henrik Persson
34 questions
Total 370 questions
Go to page: of 37
Search

Related questions