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

Microsoft PL-300 Microsoft Power BI Data Analyst Exam Practice Test

Demo: 68 questions
Total 450 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 1

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?

Options:

A.

Subscriptions

B.

Dashboards

C.

Datasets

D.

Workbooks

Question 2

You are profiling data by using Power Query Editor.

You have a table that contains a column named column1. Column statistics and Value distribution for column1 are shown in the following exhibit.

Options:

Question 3

You build a Power Bi report that displays loT temperature data streaming from a refrigerator.

You publish the report to the Power BI service.

You need to be notified when the temperature rises above four degrees Celsius.

What should you do?

Options:

A.

Set an alert on a KPI visual in the report.

B.

Pin a card visual to a dashboard and create a subscription.

C.

Pin a card visual to a dashboard and set an alert on the tile.

D.

Pin a report page to a dashboard and set an alert on the page.

Question 4

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?

Options:

A.

decomposition tree

B.

Q&A

C.

smart narrative

D.

key influences

Question 5

You create a Power B1 report named RPT1 that contains sales data. The data contains 10 million rows. RPT1 contains 15 different visuals.

Users state that RPT1 is slow to load.

You need to investigate the cause of the issue.

What should you use?

Options:

A.

Power Query Editor

B.

Performance analyzer

C.

Query Diagnostics

D.

DAX query view

Question 6

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each compliant occurred. The data in Logged is in the fol-lowing format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

Options:

A.

Create a column by example that starts with 2018-12-31.

B.

Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

C.

Apply a transformation to extract the first 11 characters of the Logged column.

D.

split the Logged column by using at as the delimiter.

Question 7

You are creating a sales report in Power Bl for the NorthWest region sales territory of your company. Data will come from a view in a Microsoft SQL Server database. A sample of the data is shown in the following table:

The report will facilitate the following analysis:

• The count of orders and the sum of total sales by Order Date

• The count of customers who placed an order

• The average quantity per order

You need to reduce data refresh times and report query times.

Which two actions should you perform? Each correct answer presents part of the solution

NOTE: Each correct selection is worth one point.

Options:

A.

Fillet the data to only the NorthWest region sales territory.

B.

Remove the CustomerKey and ProductKey columns.

C.

Remove the TaxAmt and Freight columns.

D.

Set the data type for SatesOrderNumber to Decimal Number

Question 8

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

The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

Options:

A.

Add alt text that lists the values in the table.

B.

Change the icons to use a different shape for each color.

C.

Remove the icons and use red, yellow, and green background colors instead

D.

Move the conditional formatting icons to a tooltip report

Question 9

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.

Options:

Question 10

You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.

You need to keep only the last modified row for each customer ID.

Which three 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.

Options:

Question 11

You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:

    Customer ID

    Customer Name

    Phone

    Email Address

    Address ID

Address contains the following columns:

    Address ID

    Address Line 1

    Address Line 2

    City

    State/Region

    Country

    Postal Code

The Customer ID and Address ID columns represent unique rows.

You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.

What should you do?

Options:

A.

Merge the Customer and Address tables.

B.

Transpose the Customer and Address tables.

C.

Group the Customer and Address tables by the Address ID column.

D.

Append the Customer and Address tables.

Question 12

You have five sales regions. Each region is assigned a single salesperson.

You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.

Salespeople must see only the data from their region.

You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.

A salesperson reports that she believes she should see more data.

You need to verify what data the salesperson currently sees.

What should you do?

Options:

A.

Use the Test as role option to view data as the salesperson's user account.

B.

Use the Test as role option to view data as the Sales role.

C.

Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

D.

Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Question 13

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?

Options:

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.

Question 14

You manage a Power BI model has a table named Sales and product.

You need to ensure that a sales team can view only data that has a CountryRegionName value of United States and a ProductCategory value of Clothing.

What should you do from Power BI Desktop?

Options:

A.

From Power BI Desktop, create a new role that has the following filter.[countryRegionName]= “United States” && [ProductCategory]= “Clothing”

B.

Add the following filters in Query Editor.CountryRegionName is United StatesProductCategory is Clothing

C.

From Power BI Desktop, create a new role that has the following filters.[CountryRegionName]= “United States”

D.

Add the following filters to a report.CountryRegionName is United SatesProductCategory is Clothing

Question 15

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

Options:

A.

Option A

B.

Option B

C.

option C

D.

Option D

Question 16

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You create a new query that references DataSourceExcel.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 17

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 a historic employee counts and predicts trends during the next six months.

Which type of visualization should you use?

Options:

A.

scatter chart

B.

ribbon chart

C.

line chart

D.

key influences

Question 18

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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

Solution: You modify the source step of the queries to use DataSourceExcel as the file path.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 19

You have a dataset named Pens that contains the following columns:

    Item

    Unit Price

    Quantity Ordered

You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity.

Which type of visualization and which feature should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 20

You have the following table named Location.

The GeoCode column represents the country where each customer is located.

You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

You need to ensure that the map displays the country locations.

What should you do?

Options:

A.

Replace the values in the GeoCode column with postal codes or zip codes.

B.

Change the name of the GeoCode column to Country.

C.

Change the name of the Location table to Country.

D.

Change the Default Summarization of the GeoCode column.

E.

Add a Geoportal column to the Location table.

F.

Change the Data Type of the GeoCode column.

Question 21

You use Power Query Editor to preview the data shown in the following exhibit.

Options:

Question 22

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 several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You create an Azure Active Directory group that contains all the users. You share each report and dashboard to the group.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 23

You plan to create a report that will display sales data from the last year for multiple regions

You need to restrict access to individual rows of the data on a per region-basis by using roles.

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.

Options:

Question 24

Each Region value appears only on the tow where it first occurred. Each subsequent occurrence of the Region value is blank.

You need to ensure that every row contains the connect non-blank value The solution must minimize development effort.

Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area. NOTE; Each connect selection is worth one point.

Options:

Question 25

You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two datasets named Sales and HR.

You need to provide a user named User1 with access to the workspaces. The solution must meet the following requirements:

• Create reports that use the HR dataset.

• Publish the reports to WorkspaceB.

• Prevent the ability to modify the HR dataset.

• Prevent the ability to add users to WorkspaceB.

Options:

Question 26

You have a BI dataset and a connected report.

You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.

You grant the users the Build permission for dataset

What Should do next?

Options:

A.

Change default visual interaction for the report

B.

For the report change the Export data setting to Summarized data, data with current layout and underlying data

C.

For the report, change the Export data setting to None

D.

Certify the dataset used by the report.

Question 27

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.

Options:

Question 28

You have a Power Bl report named Report1 and a dashboard named Dashboard1, Report1 contains a line chart named Sales by month.

You pin the Sales by month visual to Dashboard1.

In Report1, you change the Sales by month visual to a bar chart.

You need to ensure that bar chart displays on Dashboard1.

What should you do?

Options:

A.

Edit the details for the dashboard tile of Dashboard1.

B.

Select Refresh visuals for Dashboard1.

C.

the Sales by month bar chart to Dashboard1

D.

Refresh the dataset used by Report1 and Dashboard1.

Question 29

You are creating a visual to show the ranking of product categories by sales revenue.

Your company's security policy states that you cannot send data outside of your Microsoft Power Bl tenant

Which approach provides the widest variety of visuals while adhering to the security policy?

Options:

A.

Use default visuals or custom visuals uploaded from a .pbiviz file.

B.

Use only default visuals.

C.

Use default or any custom visuals from the marketplace.

D.

Use default or certified custom visuals.

Question 30

You attempt to use power Query Editor to create a custom column and receive the error message 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.

Options:

Question 31

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 several reports and dashboards in a workspace.

You need to grant all organizational users read access to a dashboard and several reports.

Solution: You assign all the users the Viewer role to the workspace.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 32

You have a data source that contain a column. The column contains case sensitive data.

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You implicitly convert the values into the required types.

Does this meet the goal?

Options:

A.

Yes

B.

No

Question 33

You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:

    Identify months that have order counts above the mean.

    Display the mean monthly order count.

Which three 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.

Options:

Question 34

You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.

What should you do?

Options:

A.

From Power Bl Desktop, customize the current theme,

B.

From power Bl Desktop, use a built in report theme.

C.

Create a theme as a JSON file and import the theme into Power Bl Desktop.

D.

Create a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

Question 35

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

What should you do?

Options:

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.

Question 36

You need to create the dataset. Which dataset mode should you use?

Options:

A.

DirectQuery

B.

Import

C.

Live connection

D.

Composite

Question 37

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

What should you do in Power BI Desktop?

Options:

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.

Question 38

You need to create a relationship in the data model for RLS.

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

NOTE: Each correct selection is worth one point.

Options:

Question 39

You need to create the semantic model.

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

Options:

A.

live connection

B.

Dual

C.

Import

D.

DirectQuery

Question 40

You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.

You need to combine the tables into a single query that contains the unique columns of each table.

What should you select in Power Query Editor?

Options:

A.

Merge queries

B.

Append queries

C.

Combine files

Question 41

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.

Options:

Question 42

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.

Options: