PL300-Quiz17

Time limit: 0

Quiz Summary

0 of 40 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 40 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%
None 0%

Current
Review
Answered
Correct
Incorrect

Question 1 of 40

1. Question

Category: None

PL300-Q541

You have a Power BI data model that contains two tables named Products and Sales.

A one-to-many relationship exists between the tables.

You have a report that contains a report-level filter for Products.

You need to create a measure that will return the percent of total sales for each product. The measure must

respect the report-level filter when calculating the total.

How should you complete the DAX measure? To answer, drag the appropriate DAX functions to the correct

targets. Each function 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.

Correct

Incorrect
Question 2 of 40

2. Question

Category: None

PL300-Q542

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

You need to create a new measure that will return the sum of Total Sales 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.

Correct

Incorrect
Question 3 of 40

3. Question

Category: None

PL300-Q543

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

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.

Correct

Incorrect
Question 4 of 40

4. Question

Category: None

PL300-Q544

You receive annual sales data that must be included in Power BI reports.

From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit.

You need to create a report that meets the following requirements:

+ Visualizes the Sales value over a period of years and months

+ Adds a slicer for the month

+ Adds a slicer for the year

Which three actions should you perform in sequence? To answer, move the appropriate Actions AnswerAred

actions from the list of actions to the answer area Select the Month and MonthNumber

and arrange them in the correct order.

Correct

Incorrect
Question 5 of 40

5. Question

Category: None

PL300-Q545

You publish a dataset that contains data from an on-premises Microsoft SQL Server database.

The dataset must be refreshed daily.

You need to ensure that the Power BI service can connect to the database and refresh the dataset.

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.

Correct

Incorrect
Question 6 of 40

6. Question

Category: None

PL300-Q546

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 Customer.

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.

Correct

Incorrect
Question 7 of 40

7. Question

Category: None

PL300-Q547

You have a Power BI data model that contains a table named Stores. The table has the following columns:

* Store Name

* Open Date

+ Status

+ State

* City

You need to create a calculated column named Active Store Name that meets the following requirements:

* When the value of the Status column is “A”, the value in the Store Name column must be returned.

* When the value of the Status column is NOT “A”, the value in the Store Name column that is prefixed with

“Inactive -” must be returned.

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.

Correct

Incorrect
Question 8 of 40

8. Question

Category: None

PL300-Q548

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

Department Stage School1 School2 School3 School4

Mathematics 1 75 65 90 70

Mathematics 2 80 70 80 75

Geography 1 95 65 80 75

Geography 2 80 70 80 75

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

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

Department School Avg Score

Mathematics School1 77.5

Geography School1 87.5

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.

Select and Place:

Correct

Incorrect
Question 9 of 40

9. Question

Category: None

PL300-Q549

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 in 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.

Correct

Incorrect
Question 10 of 40

10. Question

Category: None

PL300-Q550

In Power Query Editor, you have three queries named ProductCategory, ProductSubCategory, and Product.

Every Product has a ProductSubCategory.

Not every ProductsubCategory has a parent ProductCategory.

You need to merge the three queries into a single query. The solution must ensure the best performance in Power

Query.

How should you merge the tables? To answer, drag the appropriate merge types to the correct queries. Each merge

type 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.

Select and Place:

Correct

Incorrect
Question 11 of 40

11. Question

Category: None

PL300-Q551

You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Sheet1 contains the following table named Table1.

Products

abc

def

ghi

jkl

mno

Sheet2 contains the following table named Table2.

Products

abc

xyz

tuv

mno

pqr

stu

def

ghi

jkl

You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

Products

abc

xyz

tuv

mno

pqr

stu

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.

Correct

Incorrect
Question 12 of 40

12. Question

Category: None

PL300-Q552

You have a folder that contains 100 CSV files.

You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of

the CSV files.

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.

Select and Place:

Correct

Incorrect
Question 13 of 40

13. Question

Category: None

PL300-Q553

You are using Power BI Desktop to connect to an Azure SQL database. mya databae wedows net

The connection is configured as 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 solution is worth one point.

Correct

Incorrect
Question 14 of 40

14. Question

Category: None

PL300-Q554

You have the Azure SQL databases shown in the following table.

Name Stage Server URL

db-powerbi-dev Development dev.database.windows.net

db-powerbi-uat Test uat.database.windows.net

db-powerbi-prod Production prod.database.windows.net

You plan to bulla single PBIX fle to meet the following requirements:

* Data must be consumed from the database that corresponds to each stage of the development lifecycle.

* Power BI deployment pipelines must NOT be used.

* The solution must minimize administrative effort.

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

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 15 of 40

15. Question

Category: None

PL300-Q555

You are creating a Microsoft Power BI data model that has the tables shown in the following table.

Table name Column name

Sales SalesID

ProductID

DateKey

SalesAmount

Products ProductID

ProductName

ProductCategoryID

ProductCategory ProductCategoryID

CategoryName

The Products table is related to the ProductCategory table through the ProductCategorylD column. Each product has one product category.

You need to ensure that you can analyze sales by product category.

How should you configure the relationship from ProductCategory to Products? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 16 of 40

16. Question

Category: None

PL300-Q556

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

You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are

replaced with a discount of 0.05. The solution must minimize administrative effort.

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.

Correct

Incorrect

Department	Stage	School1	School2	School3	School4
Mathematics	1	75	65	90	70
Mathematics	2	80	70	80	75
Geography	1	95	65	80	75
Geography	2	80	70	80	75

Department	School	Avg Score
Mathematics	School1	77.5
Geography	School1	87.5

Products
abc
def
ghi
jkl
mno

Products
abc
xyz
tuv
mno
pqr
stu
def
ghi
jkl

Products
abc
xyz
tuv
mno
pqr
stu

Name	Stage	Server URL
db-powerbi-dev	Development	dev.database.windows.net
db-powerbi-uat	Test	uat.database.windows.net
db-powerbi-prod	Production	prod.database.windows.net

Table name	Column name
Sales	SalesID
ProductID
DateKey
SalesAmount
Products	ProductID
ProductName
ProductCategoryID
ProductCategory	ProductCategoryID
CategoryName

Question 17 of 40

17. Question

Category: None

PL300-Q557

You have a Power BI report. You have the following tables.

Name	Description
Balances	The table contains daily records of closing balances for every active bank account. The closing balances appear for every day the account is live, including the last day.
Date	The table contains a record per day for the calendar years of 2000 to 2025. There is a hierarchy for financial year, quarter, month, and day.

You have the following DAX measure.

Accounts:=

CALCULATE(

DISTINCTCOUNT (Balances[AccountID]), LASTDATE (‘Date'[Date])

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Correct

Incorrect

Question 18 of 40

18. Question

Category: None

PL300-Q558

You have two Microsoft Excel workbooks in a Microsoft OneDrive folder.

Each workbook contains a table named Sales. The tables have the same data structure in both workbooks.

You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table.

The solution must ensure that you can publish a separate report and dataset.

Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the

correct files. Each mode 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.

Correct

Incorrect
Question 19 of 40

19. Question

Category: None

PL300-Q559

You create a Power BI dataset that contains the table shown in the following exhibit.

You need to make the table available as an organizational data

type in Microsoft Excel.

How should you configure the properties of the table? To answer,

select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 20 of 40

20. Question

Category: None

PL300-Q560

You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named

Total Sales.

You need to create a measure that calculates the total sales from the equivalent month of the previous year.

How should you complete the calculation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 21 of 40

21. Question

Category: None

PL300-Q561

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.

Select and Place:

Correct

Incorrect
Question 22 of 40

22. Question

Category: None

PL300-Q562

You are enhancing a Power BI model that has DAX calculations.

You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

Which DAX functions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 23 of 40

23. Question

Category: None

PL300-Q563

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.

Correct

Incorrect
Question 24 of 40

24. Question

Category: None

PL300-Q564

You are creating a Power BI model and report.

You have a single table in a data model 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 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.

Select and Place:

Correct

Incorrect
Question 25 of 40

25. Question

Category: None

PL300-Q565

You are creating a Power BI model in Power BI Desktop.

You need to create a calculated table named Numbers that will contain all the integers from100 to 100.

How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 26 of 40

26. Question

Category: None

PL300-Q566

You are creating a Power BI model to analyze inventory.

You load data into three tables named Date, Product, and Inventory. The Inventory table relates to the Date and Product tables

by using one-to-many relationships.

Inventory data is recorded daily with no exceptions. The correct inventory quantity for a given product in a month is the last

recorded value for that month.

You need to write a DAX measure that will show the correct inventory value when a user analyzes inventory by year, month, or

date.

How should you complete the measure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 27 of 40

27. Question

Category: None

PL300-Q567

You are creating a Power BI report that will show the number of current employees over time. The report will use Import

storage mode for all tables.

The employment data will be imported from Azure SQL Database in a monthly snapshot. The data will be stored in a table

named Headcount and will contain the following:

-One row per employee for each month the employee is employed

-In each row, a date key that shows the first day of the month of each snapshot

You have a related date table that contains dates for the years 2020 to 2030.

You need to create a semi-additive DAX measure that will return the count of employees for the last available date in a year,

quarter, or month.

How should you complete the measure? To answer, select the appropriate options in the answer area.

Correct

Incorrect
Question 28 of 40

28. Question

Category: None

PL300-Q568

You have a query named All Sales that imports sales data into a Power BI model.

You plan to create a star schema by separating columns into separate queries and performing further transformations. The

solution must meet the following requirements:

-Use All Sales as the source for three other queries named Sales Fact, Product Dimension, and Customer Dimension.

-Minimize maintenance effort.

What should you do to create the Sales Fact query, and for which query should you clear Enable load? To answer, select the

appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 29 of 40

29. Question

Category: None

PL300-Q569

You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual

from a report named ReportA.

You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA.

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.

Select and Place:

Correct

Incorrect
Question 30 of 40

30. Question

Category: None

PL300-Q570

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.

Hot Area:

Correct

Incorrect
Question 31 of 40

31. Question

Category: None

PL300-Q571

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.

Select and Place:

Correct

Incorrect
Question 32 of 40

32. Question

Category: None

PL300-Q572

You have a Microsoft Excel spreadsheet named Excel! that contains survey results.

You have a Power BI dashboard named DashboardA that has Q&A enabled.

You need to ensure that users who can access DashboardA can ask questions based on the contents of Excell and pin visuals

based on their queries to

DashboardA. The solution must minimize development time.

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.

Correct

Incorrect
Question 33 of 40

33. Question

Category: None

PL300-Q573

You have a dataset that contains revenue data from the past year.

You need to use anomaly detection in Power BI to show anomalies in the dataset.

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

NOTE: Each correct selection is worth one point.

Correct

Incorrect
Question 34 of 40

34. Question

Category: None

PL300-Q574

You are modeling data in table named SalesDetail by using Microsoft Power BI.

You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights

on the completeness of the data and the value distributions.

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.

Correct

Incorrect
Question 35 of 40

35. Question

Category: None

PL300-Q575

You have a Power BI report.

You need to create a calculated table to return the 100 highest spending customers.

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.

Correct

Incorrect
Question 36 of 40

36. Question

Category: None

PL300-Q576

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

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.

Correct

Incorrect
Question 37 of 40

37. Question

Category: None

PL300-Q577

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.

Correct

Incorrect

Question 38 of 40

38. Question

PL300-Q578

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

Table name	Column name	Data type
Sales	sales_id	Integer
	sales_date	Datetime
	Customer_id	Integer
	sales_amount	Floating
	employee_id	Integer
	sales_ship_date	Datetime
	store_id	Varchar(100)
Employee	employee_id	Integer
	first_name	Varchar(100)
	last_name	Varchar(100)
	employee_photo	Binary

There is a relationship between the tables.

There are no reporting requirements on employee_id and employee_photo.

You need to optimize the data model.

What should you configure for employee_id and employee_photo? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Correct

Incorrect

Question 39 of 40

39. Question
PL300-Q579
You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)

The data has the following refresh requirements:

Customer must be refreshed daily.

Date must be refreshed once every three years.

Sales must be refreshed in near real time.

SalesAggregate must be refreshed once per week.

You need to select the storage modes for the tables.

The solution must meet the following requirements:

Minimize the load times of visuals.

Ensure that the data is loaded to the model based on the refresh requirements.

Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.
Correct

Incorrect
Question 40 of 40

40. Question

PL300-Q580

You have two CSV files named Products and Categories.

The Products file contains the following columns:

– ProductID

– ProductName

– SupplierlD

– CategoryID

The Categories file contains the following columns:

– CategoryID

– CategoryName

– CategoryDescription

From Power BI Desktop,you import the files into Power Query Editor.

You need to create a Power B dataset that will contain a single table named Product.The Product will table includes the following columns:

– ProductID

– ProductName

– SupplierID

– CategoryID

– CategoryName

– CategoryDescription

How should you combine the queries, and what should you do on the Categories query To answer, select the appropriate in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Correct

Incorrect

PL300-Quiz17

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

22. Question

23. Question

24. Question

25. Question

26. Question

27. Question

28. Question

29. Question

30. Question

31. Question

32. Question

33. Question

34. Question

35. Question

36. Question

37. Question

38. Question

39. Question

40. Question