Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

Home > Microsoft > Microsoft Certified: Power BI Data Analyst Associate > PL-300

PL-300 Microsoft Power BI Data Analyst Question and Answers

Question # 4

You have a Power Bl table named Customer that contains a field named Email Address.

You discover that multiple records contain the same email address.

You need to create a calculated column to identify which records have duplicate email addresses.

How should you complete the OAX expression for the calculated column? 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.

Full Access
Question # 5

You have a Power Bl report.

You have the following tables.

You have the following DAX measure.

Full Access
Question # 6

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 have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

You need to recreate the Power View sheets as reports in the Power Bl service.

Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect

Does this meet the goal?

A.

Yes

B.

No

Full Access
Question # 7

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

A.

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

B.

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

C.

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.

D.

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

Full Access
Question # 8

You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

What should you do?

A.

Edit the details of each tile.

B.

Change the report theme.

C.

Change the dashboard theme.

D.

Create a custom CSS file.

Full Access
Question # 9

You have a Power B1 report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

A.

Sync the slicers on Page1 and Page3

B.

On each page, modify the interactions of the slicer.

C.

Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.

Full Access
Question # 10

In Power BI Desktop, you are building a sales report that contains two tables. Both tables have row-level security (RLS) configured.

You need to create a relationship between the tables. The solution must ensure that bidirectional cross-filtering honors the RLS settings.

What should you do?

A.

Create an active relationship between the tables and select Assume referential integrity.

B.

Create an inactive relationship between the tables and select Assume referential integrity.

C.

Create an inactive relationship between the tables and select Apply security filter in both directions.

D.

Create an active relationship between the tables and select Apply security filter in both directions.

Full Access
Question # 11

You are creating an analytics report that will consume data from the tables shown in the following table.

There is a relationship between the tables.

There are no reporting requirements on employeejd and employee_photo.

You need to optimize the data model

What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.

Full Access
Question # 12

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

Full Access
Question # 13

You have a semantic model that contains two tables named Sales and Date. The Sales table relates to the Date table by using a many-to-one relationship. The Sales table contains the following columns:

• Date

• Product

• SalesAmount

You need to create a DAX measure for a rolling 31 -day sales total that will return the total sales amount for a selected date and the previous 30 days.

Which DAX expression should you use?

A.

CALCULATE(SUM(Sales[SalesAmount]), DATESBETWEEN(Date[Date], Max('Date'[Date])-36, Max('Date'[Date])))

B.

CALCUlATE(SUM

C.

CALCULATE(SUM(Sales[SalesAmount]), DISTINCTCOUNT(Date[Date]) = 31)

D.

CALCULATE(SUM(Sales[SalesAmount]), DATESHTD(Date[Date]))

Full Access
Question # 14

Vow have a Power B1 semantic model named Modell that runs in Import storage mode. Vou need to reduce the size of Model 1. The solution must NOT increase report query response times. What should you do?

A.

Unpivot unnecessary columns.

B.

Rename unnecessary columns.

C.

Change Model1 to DirectQuery storage mode.

D.

Remove unnecessary columns.

Full Access
Question # 15

You have a Microsoft SharePoint Online site that contains several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.

You need to load only the manufacturing reports to a table for analysis.

What should you do in Microsoft Power Bl Desktop?

A.

Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.

B.

Get data from a SharePoint Online list and enter the site URL. Edit the query and filter by the path to the manufacturing reports library.

C.

Get data from a SharePoint Online folder and enter the site URL. Edit the query and filter by the path to themanufacturing reports library.

D.

Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Full Access
Question # 16

You have a Power Bl report that contains the visual shown in the following exhibit.

Full Access
Question # 17

You have four sales regions. Each region has multiple sales managers.

You implement row-level security (RLS) in a data model. You assign the relevant distribution lists to each role.

You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.

A sales manager changes to a different region.

You need to ensure that the sales manager can see the correct sales data.

What should you do?

A.

From Microsoft Power Bl Desktop, edit the Row-Level Security setting for the reports.

B.

Change the Microsoft Power Bl license type of the sales manager.

C.

Manage the permissions of the underlying dataset

D.

Request that the sales manager be added to the correct Azure Active Directory group.

Full Access
Question # 18

You have a collection of reports for the HR department of your company.

You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.

Which type of visualization should you use?

A.

key influences

B.

ribbon chart

C.

line chart

D.

scatter chart

Full Access
Question # 19

A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.

You need to use the dataflow in a report. The solution must meet the following requirements:

• Minimize online processing operations.

• Minimize calculation times and render times for visuals.

• include data from the current year, up to and including the previous day.

What should you do?

A.

Create a dataflows connection that has Import mode selected and schedule a dairy refresh.

B.

Create a dataflows connection that has DirectQuery mode selected.

C.

Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset

D.

Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

Full Access
Question # 20

You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

A.

decomposition tree

B.

Q&A

C.

smart narrative

D.

key influences

Full Access
Question # 21

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the data, which would likely prevent the errors you encountered in the Power BI semantic model.

You have a Power BI data model that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys.

•Due Date

•Order Date

•Delivery Date

You need to support the analysis of sales over time based on all three dates at the same time.

Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.

Does this meet the goal?

A.

Yes

B.

No

Full Access
Question # 22

You have a dataset that is used infrequently and refreshes every hour.

You receive a notification that the refresh was disabled due to inactivity.

Which two actions will cause the scheduled refresh schedule to resume? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Enable query caching for the dataset.

B.

Import the dataset to Microsoft Excel.

C.

From the Power BI service, open a dashboard that uses the dataset.

D.

From the Power BI service, open a report that uses the dataset.

E.

From PowerShell, run the get-powerbireport cmdlet.

Full Access
Question # 23

You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?

A.

Share the dashboard to the user.

B.

Create a subscription.

C.

Create a data alert.

D.

Tag the user in a comment.

Full Access
Question # 24

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?

A.

Yes

B.

No

Full Access
Question # 25

You have a report in Power Bl named report1 that is based on a shared dataset.

You need to minimize the risk of data exfiltration for report1. The solution must prevent other reports from being affected.

What should you do?

A.

Clear Allow recipients to share your dashboard and Allow users to build new content using the underlying datasets for the dataset.

B.

Select the Allow end users to export both summarized and underlying data from the service or Report Server Export data option for the report.

C.

Select the Don't allow end users to export any data from the service or Report Server Export data option for the report.

D.

Apply row-level security (RLS) to the shared dataset.

Full Access
Question # 26

You have a Microsoft Excel spreadsheet that contains the data shown in the following table.

You plan to build a data model for a Power Bl report.

You need to prepare the data so that it is available to the model in the format shown in the following table.

Which three actions should you perform in sequence in Power Query Editor? 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

You are creating a Power Bi report that will contain multiple visuals. Vou need to ensure that the report Is accessible to users who use a screen reader. Which two configurations should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.

alt text for each visual

B.

consistent fonts for each visual

C.

consistent colors for each visual

D.

the tab order for each page

E.

Play Axis for each page

Full Access
Question # 28

You have a Power 81 semantic model that contains a table named Table1. Table1 runs in Import storage mode. You need to update the model to change the storage mode of Table1 to DirectQuery. What should you do?

A.

Delete Table1. and then add the table to the model again in DirectQuery storage mode.

B.

From Power Query Editor, duplicate the query for Table1.

C.

From Model view, change the storage mode of Table1 to DirectQuery

D.

Add an aggregation table to the model.

Full Access
Question # 29

You have a Power BI dashboard that displays different visualizations of company sales.

You enable Q&A on the dashboard.

You need to provide users with sample questions that they can ask when using Q&A.

Which settings should you modify from the Power BI Settings?

A.

Subscriptions

B.

Dashboards

C.

Datasets

D.

Workbooks

Full Access
Question # 30

You have a Power B1 semantic model named Model 1 that runs in import storage node.

You need to reduce the size of Model.

Which two action should you perform? Each connect answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A.

Summarize the detail data.

B.

Change the active relationship between table to inactive relationship.

C.

Optimize the column data types.

D.

Upgrade to Power BI premium.

E.

Implement row-level security (RLS).

Full Access
Question # 31

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.

Which role should you assign to the user?

A.

Viewer

B.

Contributor

C.

Member

D.

Admin

Full Access
Question # 32

You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a report named RPT1.

A user wants to create a report by using the data In DS1 and publish the report to another workspace.

You need to provide the user with the appropriate access. The solution must minimize the number of access permissions granted to the user.

What should you do?

A.

Share RPT1 with the user.

B.

Add the user as a Viewer of Workspace1.

C.

Add the user as a member of Workspace1.

D.

Grant the Build permission for DS1 to the user.

Full Access
Question # 33

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.

Full Access
Question # 34

You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?

A.

Apply row-level security (RLS) to the Region table based on the sales manager username.

B.

Configure a bi-directional relationship between Region and Sales.Region.

C.

Create a DAX calculated column that retrieves the region manager from the Weekly.Returns table based on the sales.regionjd column.

D.

In the Region table, create a hierarchy that has the manager name, and then the sales manager name.

Full Access
Question # 35

You publish the semantic model 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.

Full Access
Question # 36

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 fromSales[sales_date_id] to Date[date_id], and a one-to-many relationship fromSales[sales_ship_date_id] to ShipDate[date_id]

B.

an additional date table named ShipDate, a many-to-many relationship fromSales[sales_date_id] to Date[date_id], and a many-to-many relationship fromSales[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-manyrelationship 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 # 37

You create a report by using Microsoft Power BI Desktop.

The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal network.

You plan to publish the report to the Power BI Service.

What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-date data from the cube?

A.

a subscription

B.

a scheduled refresh of the dataset

C.

an OData feed

D.

an On-premises data gateway

Full Access
Question # 38

For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel We located in a Microsoft SharePoint folder The data model contains several measures You need to create a Power Bl report from the existing data. The solution must minimize development effort. Which type ol data source should you use?

A.

a SharePoint folder

B.

Power Bl dataflows

C.

an Excel workbook

D.

Power Bl dataset

Full Access
Question # 39

You use Power Query Editor to review a query that contains a column named Country.

You need to view the following information in the Data preview view for the Country column:

• The percentage of values that contain errors.

• The count of empty values.

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

Full Access
Question # 40

You need to create a calculated column to display the month based on the reporting requirements. Which DAX expression should you use?

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 41

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 # 42

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Full Access
Question # 43

You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

What occurred at 12:03:06 PM?

A.

A user pressed F5

B.

A new transaction was added to the data source.

C.

A user added a comment to a tile.

D.

The dashboard tile cache refreshed.

Full Access
Question # 44

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 # 45

You need to ensure that the data is updated to meet the report requirements. The solution must minimize configuration effort.

What should you do?

A.

From each report in powerbi.com. select Refresh visuals

B.

From Power Bl Desktop, download the PBIX file and refresh the data.

C.

Configure a scheduled refresh without using an on-premises data gateway.

D.

Configure a scheduled refresh by using an on-premises data gateway

Full Access
Question # 46

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A.

a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.

B.

a clustered column chart that shows balances by date (x-axis) and account category (legend) withoutfilters.

C.

a clustered column chart that shows balances by quarter filtered to account categories that are long-term liabilities.

D.

a pie chart that shows balances by account category without filters.

E.

a ribbon chart that shows balances by quarter and accounts in the legend.

Full Access
Question # 47

You are creating a Power Bi model and report.

You have a single table in a data mode) named Product Product contains the following fields:

• ID

• Name

• Color

• Category

• Total Sales

You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales.

How should you complete the DAX expression? To answer, drag the appropriate values to the coned 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.

Full Access
Question # 48

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 # 49

You need to create the relationship between the product list and the revenue results. The solution must minimize the time it takes to render visuals.

What should you set as the relationship cardinality?

A.

One to one

B.

Many to one

C.

One to many

D.

Many to many

Full Access
Question # 50

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 # 51

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 # 52

You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.

How should you complete the measure? 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.

Full Access
Question # 53

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 # 54

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
Question # 55

You need to minimize the size of the semantic model. The solution must meet the report requirements.

What should you do?

A.

Filter out discontinued products while importing the Products table.

B.

Group the Categories table by the CategorylD column.

C.

Change the OrderlD column in the Orders table to the Text data type.

D.

Remove the QuantityPerUnit column from the Products table.

Full Access
Question # 56

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 # 57

You need to create the semantic model.

Which storage mode should you use for the tables in the semantic model?

A.

live connection

B.

Dual

C.

Import

D.

DirectQuery

Full Access
Question # 58

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.

Full Access
Question # 59

You need to create a measure that will return the percentage of late orders.

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.

Full Access