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

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

List of questions

Question 171

Report
Export
Collapse

DRAG DROP

You are preparing a financial report in Power BI.

You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

Microsoft PL-300 image Question 138 106395 10052024010716000000

You need to prepare the data to support the following:

Visualizations that include all measures in the data over time

Year-over-year calculations for all the measures

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 171 106395 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 171 106395 10052024010716000

Explanation:

https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

asked 05/10/2024
Enayat Meer
28 questions

Question 172

Report
Export
Collapse

HOTSPOT

You have the Power BI data model shown in the following exhibit.

Microsoft PL-300 image Question 139 106396 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 selection is worth one point.


Microsoft PL-300 image Question 172 106396 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 172 106396 10052024010716000
asked 05/10/2024
Manuel Jong
43 questions

Question 173

Report
Export
Collapse

HOTSPOT

You are enhancing a Power BI model that has DAX calculations.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year. Which DAX functions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 173 106397 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 173 106397 10052024010716000

Explanation:

Reference:

https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/

asked 05/10/2024
Peter Kiraly
34 questions

Question 174

Report
Export
Collapse

HOTSPOT

You have the data lineage shown in the following exhibit.

Microsoft PL-300 image Question 141 106398 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 selection is worth one point.


Microsoft PL-300 image Question 174 106398 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 174 106398 10052024010716000

Explanation:

Box 1: CONTOSO BIKES report

Box 2: three datasets

Images, tweets and the Contoso datasets

asked 05/10/2024
Lawrence Bargers
32 questions

Question 175

Report
Export
Collapse

HOTSPOT

You are building a financial report by using Power BI.

You have a table named financials that contains a column named Date and a column named Sales.

You need to create a measure that calculates the relative change in sales as compared to the previous quarter. How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 175 106399 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 175 106399 10052024010716000

Explanation:

Box 1: CALCULATE

Box 2: DATEADD

Box 3: DIVIDE

Example:

NET_SALES QoQ% =

IF(

ISFILTERED('Calendar'[Date]),

ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."), VAR __PREV_QUARTER = CALCULATE( SUM('research ra_qtr_template'[NET_SALES]), DATEADD('Calendar'[Date].[Date], -1, QUARTER) ) RETURN DIVIDE( SUM('research ra_qtr_template'[NET_SALES]) - __PREV_QUARTER, __PREV_QUARTER ))

Reference:

https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/mp/547054

asked 05/10/2024
Derek Steven Schulte
41 questions

Question 176

Report
Export
Collapse

HOTSPOT

You have a power BI tenant that hosts the datasets shown in the following table.

Microsoft PL-300 image Question 143 106400 10052024010716000000

You have the following requirements:

• The export of reports that contain Personally Identifiable Information (Pll) must be prevented.

• Data used for financial decisions must be reviewed and approved before use.

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 176 106400 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 176 106400 10052024010716000
asked 05/10/2024
Umaish Nair
35 questions

Question 177

Report
Export
Collapse

HOTSPOT

You are profiling data by using Power Query Editor.

The AddressLine2 column in a table named Address is shown in the following exhibit.

Microsoft PL-300 image Question 144 106401 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 selection is worth one point.


Microsoft PL-300 image Question 177 106401 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 177 106401 10052024010716000
asked 05/10/2024
- Paulo Fonseca
38 questions

Question 178

Report
Export
Collapse

DRAG DROP

Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.

Start of repeated scenario

You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

Microsoft PL-300 image Question 145 106402 10052024010716000000

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

Microsoft PL-300 image Question 145 106402 10052024010716000000

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You need to edit the Product Category table query to match the desired Power BI model.

How should you complete the advanced query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to frag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 178 106402 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 178 106402 10052024010716000

Explanation:

Reference:

https://msdn.microsoft.com/en-us/library/mt260776.aspx

https://msdn.microsoft.com/en-us/library/mt260808.aspx

asked 05/10/2024
Allam Sunandhareddy
34 questions

Question 179

Report
Export
Collapse

DRAG DROP

You have a Microsoft Excel workbook that contains two tables.

From Power BI, you create a dashboard that displays data from the tables.

You update the tables each day.

You need to ensure that the virtualizations in the dashboard are updated daily.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.


Microsoft PL-300 image Question 179 106403 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 179 106403 10052024010716000

Explanation:

Reference: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

asked 05/10/2024
Felipe Santos Cardoso
40 questions

Question 180

Report
Export
Collapse

HOTSPOT

Your company plans to use Power BI for 20 users in the sales department. The users will perform the following tasks:

Access a published Power BI app

Modify reports in an app workspace

Share dashboards created in My Workspace

You need to identify which Power BI licenses are required for the tasks. The solution must use the Power BI (free) licenses, whenever possible. Which license should you identify for each task? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 180 106404 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 180 106404 10052024010716000

Explanation:

https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps

https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace

asked 05/10/2024
Borja Arranz Palenzuela
38 questions
Total 370 questions
Go to page: of 37
Search

Related questions