Weekend Sale Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

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

Page: 1 / 46
Total 459 questions

Microsoft Power BI Data Analyst Questions and Answers

Question 1

You need to create a date table in Power B1 that must contain 10 full calendar years, including the current year

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

Question # 1

Options:

Question 2

What is the minimum number of Power BI datasets needed to support the reports?

Options:

A.

a single imported dataset

B.

two imported datasets

C.

two DirectQuery datasets

D.

a single DirectQuery dataset

Question 3

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?

Options:

A.

Yes

B.

No

Question 4

The data model must support the following analysis:

    Total sales by product by month in which the order was placed

    Quantities sold by product by day on which the order was placed

    Number Of sales transactions by quarter in Which the order was placed

For each Of the following statements, select Yes if the statement is true. Otherwise, select NO.

Question # 4

Options:

Question 5

You use Power Query Editor to ingest data into Power Bl Desktop.

The total dataset contains 250,000 rows. All the rows match the format of the data as shown in the following exhibit.

Question # 5

You need to optimize the data model size of the table.

Which type of data should you use for the Value column and the Datetime column? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 5

Options:

Question 6

You have a query that contains customer data in Power Query Editor as shown in the following exhibit.

Question # 6

Question # 6

Options:

Question 7

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

Question # 7

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.

Question # 7

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.

Question # 7

Options:

Question 8

You have a table that contains the following three columns:

    City

    Total Sales

    Occupation

You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

Question # 8

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

NOTE: Each correct selection is worth one point.

Question # 8

Options:

Question 9

You have a Microsoft Power Bl workspace.

You need to grant the user capabilities shown in the following table.

Question # 9

The solution must use the principle of least privilege.

Which user role should you assign to each user? To answer, drag the appropriate roles to the correct users. Each role 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.

Question # 9

Options:

Question 10

You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals.

The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

Question # 10

You need to modify the dashboard mobile layout to meet the following requirements:

• Only show single-value visuals.

• Minimize scrolling.

What should you do?

Options:

A.

Remove the card visual, increase the size of the map and bar chart visuals

B.

Decrease the size of the map and bar chart visuals Move all the card visuals to the top of the layout.

C.

Move the bar chart visuals to the top of the layout Remove the map visuals. Decrease the size of the card visuals.

D.

Decrease the size of the card visuals. Remove the map and bar chart visuals.

Question 11

You are configuring a Microsoft Power Bl data model to enable users to ask natural language questions by using Q&A. You have a table named Customer that has the following measure.

Customer Count = DISTINCTCOUNT(Customer[CustomerID])

Users frequently refer to customers as subscribers.

You need to ensure that the users can get a useful result for "subscriber count" by using Q&A. The solution must minimize the size of the model.

What should you do?

Options:

A.

Add a description of "subscriber count" to the Customer Count measure.

B.

Set Summarize By to None for the CustomerlD column.

C.

Add a description of "Subscriber" to the Customer table.

D.

Add a synonym of "subscriber" to the Customer table.

Question 12

You have a Microsoft 365 subscription that contains the resources shown in the following table.

Question # 12

You create a new dashboard that uses row-level security (RIS) filters You define a new role named Consultants.

To which resource can you assign the Consultants role?

Options:

A.

Group2

B.

Team1

C.

Sales reports

D.

Group 1

Question 13

You have a Power Bl report that contains a measure named Total Sales.

You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. 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.

Question # 13

Options:

Question 14

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.

Question # 14

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?

Options:

A.

Yes

B.

No

Question 15

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.

Question # 15

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.

Question # 15

Options:

Question 16

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

Question # 16

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.

Question # 16

Options:

Question 17

You are building a dataset from a JSON file that contains an array of documents.

You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.

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.

Question # 17

Options:

Question 18

You have multiple dashboards.

You need to ensure that when users browse the available dashboards from powerbi.com. they can see which dashboards contain Personally Identifiable Information (Pll). The solution must minimize configuration effort and impact on the dashboard design.

What should you use?

Options:

A.

Active Directory groups

B.

tiles

C.

data classifications

D.

comments

Question 19

You plan to create the chart shown in the following exhibit.

Question # 19

How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

Options:

A.

Create a horizontal line that has a fixed value of 24,000.

B.

Add a measure to the visual that uses the following DAX expression.Measure - PERCENTUEX.EXC (Sales,Sales[Total Sales],©.40)

C.

Add a new percentile line that uses Total Sales as the measure and 40% as the percentile.

D.

Add a measure to the visual that uses the following DAX expression.Measure = PERCENTILEX.INC (Sales,Sales[Total Sales],6.40)

Question 20

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

Question # 20

Question # 20

Options:

Question 21

You are creating a Power BI model that contains a table named Store. Store contains the following fields.

You plan to create a map visual that will show store locations and provide the ability to drill down from Country to State/Province to City. What should you do to ensure that the locations are mapped property?

Options:

A.

Set the data category of City. State/Province, and Country.

B.

Set Summarization for City. State/Province, and Country to Don't summarize

C.

Change the data type of City. State/Province, and Country.

D.

Create a calculated column that concatenates the values it City, State/Province, and Country.

Question 22

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?

Options:

A.

key influences

B.

ribbon chart

C.

line chart

D.

scatter chart

Question 23

You have a PBiX file that imports several tables from an Azure SQL database.

The data will be migrated to another Azure SQL database.

You need to change the connections in the PBIX file. The solution must minimize administrative effort.

What should you do?

Options:

A.

From Power Query Editor, modify the source of each query.

B.

Create a PBiT file, open the file, and change the data sources when prompted

C.

From Power Query Editor, create new queries.

D.

Modify the Data source settings.

Question 24

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

Options:

A.

Merge tables by using Power Query.

B.

Hide unused columns in the model.

C.

Split the model into multiple models.

D.

Transpose.

Question 25

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 26

You are using Performance analyzer to analyze the performance of a visual in a Power BI report:

You need to identify the following log information:

· The time spent to retrieve data from a source

· The time required to wait for other visuals to complete

Which task categories should you review? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 26

Options:

Question 27

You have a Microsoft Excel file in a Microsoft OneDrive folder.

The file must be imported to a Power Bi dataset

You need to ensure that the dataset can be refreshed in powefbi.com.

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Options:

A.

Text/CSV

B.

Folder

C.

Excel Workbook

D.

SharePoint folder

E.

Web

Question 28

You have a semantic model.

You need to configure row level security (RLS) to restrict data access for users that have the Viewer permissions.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to tie answer area and arrange them in the correct order.

Question # 28

Options:

Question 29

You use Power 81 Desktop to load data from a Microsoft SQL Server database.

While waiting for the data to load, you receive the following error.

Question # 29

You need to resolve the error.

What are two ways to achieve the goal? Each correct answer presents a complete solution

NOTE: Each correct selection is worth one point.

Options:

A.

Split long running queries into subsets Of columns and use power Query to the queries

B.

Disable query folding on long running queries

C.

Reduce number of rows and columns returned by each query.

D.

Use Power Query to combine long running queries into one query.

Question 30

You have the data lineage shown in the following exhibit.

Question # 30

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.

Question # 30

Options:

Question 31

You open powerbi.com as shown in the following exhibit.

Question # 31

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.

Question # 31

Options:

Question 32

You need to create a Power Bl 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.

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

B.

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

C.

From Power Bl Desktop, use a built-in report theme.

D.

From Power Bl Desktop, customize the current theme.

Question 33

You have two Azure SQL databases that contain the same tables and columns.

For each database, you create a query that retrieves data from a table named Customers.

You need to combine the Customer tables into a single table. The solution must minimize the size of the data model and support scheduled refresh in powerbi.com.

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

NOTE: Each correct selection is worth one point.

Question # 33

Options:

Question 34

You have a line chart that shows the number of employees in a department over time.

You need to see the total salary costs of the employees when you hover over a data point.

What is possible way to achieve this goal?

Options:

A.

Add a salary to the tooltips.

B.

Add a salary to the visual filters.

C.

Add salary to the drillthrough fields.

Question 35

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

Question # 35

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 36

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

What should you do?

Options:

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

Question 37

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.

Question # 37

Options:

Question 38

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?

Options:

A.

One to one

B.

Many to one

C.

One to many

D.

Many to many

Question 39

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?

Options:

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.

Question 40

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.

Options:

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.

Question 41

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

Options:

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] ))

Question 42

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.

Question # 42

Options:

Question 43

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.

Question # 43

Options:

Question 44

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

Options:

A.

two imported datasets

B.

a single DirectQuery dataset

C.

two DirectQuery datasets

D.

a single imported dataset

Question 45

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.

Question # 45

Options:

Question 46

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.

Question # 46

Options:

Question 47

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 48

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.

Question # 48

Options: