Independence Day Special Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 1b2718643m

PL-300 Exam Dumps - Microsoft Power BI Data Analyst

Question # 4

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

A.

Select Column distribution.

B.

Select the sales_amount column and apply a number filter.

C.

Select Column profile, and then select the sales_amount column.

D.

Transform the sales_amount column to replace negative values with 0.

Full Access
Question # 5

You need to create relationships to meet the reporting requirements of the customer service department.

What should you create?

A.

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]

B.

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]

C.

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]

D.

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]

E.

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]

Full Access
Question # 6

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.

Full Access
Question # 7

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 8

You need to create the On-Time Shipping report. The report must include a visualization that shows the percentage of late orders.

Which type of visualization should you create?

A.

bar chart

B.

scatterplot

C.

pie chart

Full Access
Question # 9

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.

NOTE: Each correct select is worth one point:

Full Access
Question # 10

You need to configure access for the sales department users. The solution must me meet the security requirements. What should you do?

A.

Add the sales department as a member of the reports workspace

B.

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

C.

Distribute an app to the users in the Azure Active Directory group of the sales department.

D.

Share each report to the Azure Active Directory group of the sales department.

Full Access
Question # 11

You need to create a relationship in the dataset for RLS.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 12

You need to minimize me size of the dataset. The solution must meet the report requirements What should you do?

A.

Change lite OrderlD column in the Orders table to the text data type.

B.

Filter out discontinued products while importing the Product table.

C.

Remove the QuantityPerUnit column from the Products table

D.

Group the Categories table by the CategorylD column.

Full Access
Question # 13

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.

Full Access
Question # 14

You need to design the data model to meet the report requirements.

What should you do in Power BI Desktop?

A.

From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.

B.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

C.

From Power Bl Desktop, use the Auto date/time option when creating the reports.

D.

From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Full Access
Question # 15

You are creating reports in Power BI Desktop. The model has the following tables.

There is a relationship between the tables.

You plan to publish a report to the Power BI service that displays Order_amount by Order_date by Full_name.

You need to ensure that only the columns required for the report appear in Report View. The solution must minimize the size of the dataset that is published.

How should you configure the columns in Power BI Desktop? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 16

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

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.

Full Access
Question # 17

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

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

Full Access
Question # 18

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A.

Add the same slicer to each page and configure Sync slicers.

B.

Edit the interactions of the KPI visualization.

C.

Configure a page-level filter.

D.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

E.

Configure a report-level filter.

Full Access
Question # 19

You have a folder of monthly transaction extracts.

You plan to create a report to analyze the transaction data.

You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions."

You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 20

You have a large dataset that contains more than 1 million rows. The table has a datetime column named

Date.

You need to reduce the size of the data model.

What should you do?

A.

Round the hour of the Date column to startOfHour.

B.

Change the data type of the Date column to Text.

C.

Trim the Date column.

D.

Split the Date column into two columns, one that contains only the time and another that contains only the date.

Full Access
Question # 21

You have a Microsoft Power Bl dashboard.

You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

What should you use?

A.

Feedback

B.

Subscribe

C.

Comments

D.

Mark as favorite

Full Access
Question # 22

You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

What should you recommend?

A.

Create a shared dataset for each standardized entity.

B.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

C.

For every report, create and use a single shared dataset that contains the standardized data.

D.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

Full Access
Question # 23

Which DAX expression should you use to get the ending balances in the balance sheet reports?

A.

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

DATESQTD( 'Date'[Date] )

)

B.

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

LASTDATE( 'Date'[Date] )

)

C.

FIRSTNONBLANK ( 'Date' [Date]

SUM( BalanceSheet[BalanceAmount] )

)

D.

CALCULATE (

MAX( BalanceSheet[BalanceAmount] ),

LASTDATE( 'Date' [Date] )

)

Full Access
Question # 24

How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Full Access
Question # 25

You need to grant access to the business unit analysts.

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

NOTE: Each correct selection is worth one point.

Full Access
Question # 26

Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Full Access
Question # 27

What is the minimum number of datasets and storage modes required to support the reports?

A.

two imported datasets

B.

a single DirectQuery dataset

C.

two DirectQuery datasets

D.

a single imported dataset

Full Access