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

Microsoft PL-300 Practice Test - Questions Answers

List of questions

Question 1

Report
Export
Collapse

You need to address the data concerns before creating the data model. What should you do in Power Query Editor?

Select Column distribution.

Select Column distribution.

Select the sales_amount column and apply a number filter.

Select the sales_amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.

Transform the sales_amount column to replace negative values with 0.
Suggested answer: C
asked 05/10/2024
Gofaone Ncube
42 questions

Question 2

Report
Export
Collapse

You need to create a calculated column to display the month based on the reporting requirements.

Which DAX expression should you use?

FORMAT('Date'[date], "MMM YYYY")

FORMAT('Date'[date], "MMM YYYY")

FORMAT('Date' [date], "M YY")

FORMAT('Date' [date], "M YY")

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")

FORMAT('Date' [date_id], "MMM YYYY")

FORMAT('Date' [date_id], "MMM YYYY")
Suggested answer: A
asked 05/10/2024
Justin Bake
43 questions

Question 3

Report
Export
Collapse

You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?

Change the data type of Sales[region_id] to Whole Number.

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number.

Change the data type of sales [region_id] to Decimal Number.
Suggested answer: A

Explanation:

Scenario: Executives require a visual that shows sales by region.

Need to change the sales_id column from Varchar to Whole Number (Integer).

asked 05/10/2024
Igor Vasiliev
44 questions

Question 4

Report
Export
Collapse

What should you create to meet the reporting requirements of the sales department?

a measure that uses a formula of SUM (Sales [sales_id])

a measure that uses a formula of SUM (Sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a calculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

a measure that uses a formula of COUNTROWS (Sales)

a calculated column that uses a formula of SUM (Sales [sales_id])

a calculated column that uses a formula of SUM (Sales [sales_id])
Suggested answer: C

Explanation:

The sale department requires reports that contain the number of sales transactions.

The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

Reference:

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

asked 05/10/2024
Anu V
34 questions

Question 5

Report
Export
Collapse

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

In the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.

Create a new table based on the Date table where date-id is unique, and then create a many-tomany relationship to Weekly_Return.
Suggested answer: A

Explanation:

Scenario: Region managers require a visual to analyze weekly sales and returns.

To relate the two tables we need a common column.

asked 05/10/2024
Pieter Louw
44 questions

Question 6

Report
Export
Collapse

You need to provide a solution to provide the sales managers with the required access.

What should you include in the solution?

Create a security role that has a table filter on the Sales_Manager table where username = UserName()

Create a security role that has a table filter on the Sales_Manager table where username = UserName()

Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().

Create a security role that has a table filter on the Sales_Manager table where name = UserName().

Create a security role that has a table filter on the Sales_Manager table where name = UserName().

Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.
Suggested answer: A

Explanation:

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/

asked 05/10/2024
Jenny Maliwanag
48 questions

Question 7

Report
Export
Collapse

You need to create relationships to meet the reporting requirements of the customer service department. What should you create?

an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a one-to-many relationship from Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

an additional date table named ShipDate, a many-to-many relationship from Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from Sales[sales_ship_date_id] to ShipDate[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]

a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many relationship from Sales[sales_ship_date_id] to Date[date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]

a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
Suggested answer: A

Explanation:

Scenario: The customer service department requires a visual that can be filtered by both sales month and ship month independently.

Reference:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

asked 05/10/2024
Cintron, Rigoberto
37 questions

Question 8

Report
Export
Collapse

HOTSPOT

You need to create a visualization to meet the reporting requirements of the sales managers.

How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


Microsoft PL-300 image Question 8 106232 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 8 106232 10052024010716000

Explanation:

Scenario: The sales managers require a visual to analyze sales performance versus sales targets.

Box 1: KPI

A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. Box 2: Sales[sales_amount]

Box 3: Date[month]

Time > FiscalMonth. This value will represent the trend.

Box 4: Targets[sales_target]

Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

asked 05/10/2024
Steven Bertoldi
28 questions

Question 9

Report
Export
Collapse

HOTSPOT

You publish the dataset to powerbi.com.

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 9 106233 10052024010716000
Correct answer: Microsoft PL-300 image answer Question 9 106233 10052024010716000
asked 05/10/2024
Farshin Golpad
38 questions

Question 10

Report
Export
Collapse

You need to get data from the Microsoft SQL Server tables. What should you use to configure the connection?

import that uses a Microsoft account

import that uses a Microsoft account

DirectQuery that uses the end-user s credentials

DirectQuery that uses the end-user s credentials

DirectQuery that uses a database credential

DirectQuery that uses a database credential

Import that uses a database credential

Import that uses a database credential
Suggested answer: B
asked 05/10/2024
alex aguirre
43 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.