ExamGecko
Login
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
Open VPLUS File
Convert VPLUS to PDF

Related questions

You have the tables shown in the following table. The Impressions table contains approximately 30 million records per month. You need to create an ad analytics system to meet the following requirements: Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required. Minimize the data model size. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure. Does this meet the goal?
You have a Power BI model that contains a table named Sales. The Sales table contains the following columns: * Order Line ID * Product ID * Unit Price * Order ID * Quantity Orders are uniquely identified by using the order ID and can have multiple order lines Each order line within an order contains a different product ID. You need to write a DAX measure that counts the number of orders. Which formula should you use?
HOTSPOT You have the Power Bl data model shown in the following exhibit. You need to create a measure to count the number of product categories that had products sold during a selected period. How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
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. From Power Query Editor, you profile the data shown in the following exhibit. The IoT GUID and IoT ID columns are unique to each row in query. You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance. Solution: You split the loT DateTime column into a column named Date and a column named Time. Does this meet the goal?
You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?
You have a query that returns the data shown in the following exhibit. You need to configure the query to display the data as shown in the following exhibit. Which step should you use in the query?
You are profiling data by using Power Query Editor. You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is shown in the following exhibit. 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.
DRAG DROP You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. 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.
DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent. How should you complete the calculation? 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 drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.