PL300-Quiz8

Time limit: 0

Quiz Summary

0 of 39 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 39 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

None 0%

Current
Review
Answered
Correct
Incorrect

Question 1 of 39

1. Question

Category: None

PL300-Q240

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date

and time each complaint occurred. The data in Logged is in the following 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?

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

Change the data type of the Logged column to Date.

Split the Logged column by using at as the delimiter.

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

Correct

Incorrect
Question 2 of 39

2. Question

Category: None

PL300-Q241

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

Excel Workbook

Text/CSV

Folder

SharePoint folder

Web

Correct

Incorrect
Question 3 of 39

3. Question

Category: None

PL300-Q242

62) You are creating a query to be used as a Country dimension in a star schema.

A snapshot of the source data is shown in the following table.

Country City

USA Seattle

USA New York

USA Denver

UK Manchester

UK London

Japan Tokyo

Brazil Rio

Brazil Sao Paulo

You need to create the dimension. The dimension must contain a list of unique countries.

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

NOTE: Each correct selection is worth one point.

Delete the Country column.

Remove duplicates from the table.

Remove duplicates from the City column.

Delete the City column.

Remove duplicates from the Country column.

Correct

Incorrect
Question 4 of 39

4. Question

Category: None

PL300-Q243

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

-If the discount column returns an error, a discount of 0.05 must be used.

-All the rows of data must be maintained.

-Administrative effort must be minimized.

What should you do in Power Query Editor?

Select Replace Errors.

Edit the query in the Query Errors group.

Select Remove Errors.

Select Keep Errors.

Correct

Incorrect
Question 5 of 39

5. Question

Category: None

PL300-Q244

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?

Merge queries

Combine files

Append queries

Correct

Incorrect
Question 6 of 39

6. Question

Category: None

PL300-Q245

You are creating a report in Power BI Desktop.

You load a data extract that includes a free text field named coll.

You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the

model.

What should you do?

In the report, add a DAX calculated column that calculates the length of col1

In the report, add a DAX function that calculates the average length of col1

From Power Query Editor, add a column that calculates the length of col1

From Power Query Editor, change the distribution for the Column profile to group by length for col1

Correct

Incorrect
Question 7 of 39

7. Question

Category: None

PL300-Q246

You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many

relationship between Date and Orders and between City and Orders.

The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.

City[State Province] = “Kentucky”

Role2 contains the following filter.

Date[Calendar Year] = 2020

If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.

The user will receive an error and will not be able to see the data in the report.

The user will only see data for which the State Province value is Kentucky.

The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.

Correct

Incorrect
Question 8 of 39

8. Question

Category: None

PL300-Q247

You are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table

named Order that has more than 100 million records.

During the development process, you need to import a sample of the data from the Order table.

Solution: You write a DAX expression that uses the FILTER function.

Does this meet the goal?

Yes

No

Correct

Incorrect

Country	City
USA	Seattle
USA	New York
USA	Denver
UK	Manchester
UK	London
Japan	Tokyo
Brazil	Rio
Brazil	Sao Paulo

Question 9 of 39

9. Question

Category: None

PL300-Q248

You import a Power BI dataset that contains the following tables:

-Date

-Product

-Product Inventory

The Product Inventory table contains 25 million rows. A sample of the data is shown in the following table.

ProductKey	DateKey	MovementDate	UnitCost	UnitsBalance
167	20101228	28-Dec-10	0.19	875
167	20101229	29-Dec-10	0.19	875
167	20110119	19-Jan-11	0.19	875
167	20110121	21-Jan-11	0.19	875
167	20110122	22-Jan-11	0.19	875

The Product Inventory table relates to the Date table by using the DateKey column. The Product Inventory table relates to the Product table by using the ProductKey column.

You need to reduce the size of the data model without losing information.

What should you do?

Change Summarization for DateKey to Don’t Summarize.

Remove the relationship between Date and Product Inventory

Change the data type of UnitCost to Integer.

Remove MovementDate.

Correct

Incorrect

Question 10 of 39

10. Question

Category: None

PL300-Q249

Name	Used field	Filter
Supplier usage by count and value of invoices	Suppliers[ID] Suppliers[Name] LineItems[Invoice ID] LineItems[Price]	None
Spend by supplier location	Suppliers[Country] LineItems[Price]	None
Top 10 largest invoices last month	LineItems[Invoice ID] LineItems[Price]	LineItems[Invoice Date] in last calendar month

You need to minimize the size of the dataset without affecting the visuals.

What should you do?

Merge Suppliers and Lineltems.

Remove the Lineltems[Description] column.

Remove the rows from Lineltems where Lineltems|Invoice Date] is before the beginning of last month.

Group Lineltems by Lineltems[Invoice ID] and Lineltems[Invoice Date] with a sum of Lineltems[Price].

Correct

Incorrect

Question 11 of 39

11. Question

Category: None

PL300-Q250

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

The Sales table contains records of sales by day from the last five years up until today’s date.

You plan to create a measure to return the total sales of March 2021 when March 2022 is selected.

Which DAX expression should you use?

Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date]) *

TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )

Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))

SUM(Sales[Sales])

Correct

Incorrect
Question 12 of 39

12. Question

Category: None

PL300-Q251

From Power Query Editor, you profile the data shown in the following exhibit.

The loT GUID and loT ID columns are unique to each row in the query.

You need to analyze loT events by the hour and day of the year. The solution must improve dataset performance.

Solution: You remove the loT GUID column and retain the loT ID column.

Does this meet the goal?

Yes

No

Correct

Incorrect
Question 13 of 39

13. Question

Category: None

PL300-Q252

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date

and time each complaint occurred. The data in Logged is in the following 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?

Change the data type of the Logged column to Date.

Split the Logged column by using at as the delimiter.

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

Apply the Parse function from the Date transformations options to the Logged column.

Correct

Incorrect
Question 14 of 39

14. Question

Category: None

PL300-Q253

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date

and time each complaint occurred. The data in Logged is in the following 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?

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date

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

Apply a transformation to extract the last 11 characters of the Logged column

Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number

Correct

Incorrect
Question 15 of 39

15. Question

Category: None

PL300-Q254

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

-Employee Name

-Email Address

-Start Date

-Job Title

You are implementing dynamic row-level security (RLS).

You need to create a table filter to meet the following requirements:

-Users must see only their own employee data.

-The DAX expression must work in both Power BI Desktop and the Power BI service.

Which expression should you use?

[Email Address] USERNAME()

[Employee Name] USERPRINCIPALNAME()

[Employee Name] = USERNAME()

[Email Address] = USERPRINCIPALNAME()

Correct

Incorrect
Question 16 of 39

16. Question

Category: None

PL300-Q255

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

-Order Line ID

-Product ID

-Unit Price

-Order ID

-Quantity

Orders are uniquely identified by using the order ID and can have multiple order lines. Each order line within an order contains a

different product ID.

You need to write a DAX measure that counts the number of orders.

Which formula should you use?

Count(‘Sales'[Order ID])

CountA(‘Sales’ [Order ID])

CountRows(‘Sales’)

DistinctCount(‘Sales’ [Order ID])

Correct

Incorrect
Question 17 of 39

17. Question

Category: None

PL300-Q256

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

-Date

-Fiscal Year

-Fiscal Quarter

-Month Name

-Calendar Year

-Week Number

-Month Number

-Calendar Quarter

You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of

values for Calendar Year, Calendar Quarter, and Calendar Month.

Which DAX function should you include in the table definition?

ADDCOLUMNS

CALCULATE

SUMMARIZE

DATATABLE

Correct

Incorrect
Question 18 of 39

18. Question

Category: None

PL300-Q257

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer

segment. The column chart shows sales by month.

You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month

belongs to the customer segment.

How should the visual interactions be set on the column chart when the bar chart is selected?

highlight

filter

no impact

Correct

Incorrect
Question 19 of 39

19. Question

Category: None

PL300-Q258

You need to create a visualization that compares revenue and cost over time.

Which type of visualization should you use?

waterfall chart

stacked area chart

line chart

donut chart

Correct

Incorrect
Question 20 of 39

20. Question

Category: None

PL300-Q259

You build a report to help the sales team understand its performance and the drivers of sales.

The team needs to have a single visualization to identify which factors affect success.

Which type of visualization should you use?

Key influencers

Line and clustered column chart

Q&A

Funnel chart

Correct

Incorrect
Question 21 of 39

21. Question

Category: None

PL300-Q260

What can you identify from the visual?

Customers in Austria order 18.8 more units than the average order quantity.

Customers in Boise order 20.37 percent more than the average order quantity.

Product Category positively influences the quantity per order.

Customers in Cork order lower quantities than average.

Correct

Incorrect
Question 22 of 39

22. Question

Category: None

PL300-Q261

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

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

Add a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,sales[Total Sales],0.40)

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

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

Correct

Incorrect
Question 23 of 39

23. Question

Category: None

PL300-Q262

You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the

default settings.

You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the

data from the selected column.

What should you do?

Select the donut chart and set the column chart interaction to Filter.

Select the column chart and set the donut chart interaction to Filter.

Select the donut chart and set the column chart interaction to None.

Select the column chart and set the donut chart interaction to None.

Correct

Incorrect
Question 24 of 39

24. Question

Category: None

PL300-Q263

You are creating a Power BI report by using Power BI Desktop.

You need to include a visual that shows trends and other useful information automatically. The visual must update based

on selections in other visuals.

Which type of visual should you use?

Q&A

smart narrative

key influencers

decomposition tree

Correct

Incorrect
Question 25 of 39

25. Question

Category: None

PL300-Q264

From the Formatting tab, select Values, and then set URL icons to On for the table.

From the Formatting tab, select Values, and then set URL icons to On for the table.

Set the Data category of the Plant Image field to Web URL.

Set the Data type of the Plant Image field to Binary.

Set the Data category of the Plant Image field to Image URL.

Correct

Incorrect
Question 26 of 39

26. Question

Category: None

PL300-Q265

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the

axis. Salary is present in the data as a numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a constant line and set the value to .5.

Does this meet the goal?

Yes

No

Correct

Incorrect
Question 27 of 39

27. Question

Category: None

PL300-Q266

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee

as the axis. Salary is present in the data as a numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create an average line by using the Salary measure.

Does this meet the goal?

Yes

No

Correct

Incorrect
Question 28 of 39

28. Question

Category: None

PL300-Q267

You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as

the axis. Salary is present in the data as a numerical amount representing US dollars.

You need to create a reference line to show which employees are above the median salary.

Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.

Does this meet the goal?

Yes

No

Correct

Incorrect
Question 29 of 39

29. Question

Category: None

PL300-Q268

You have a Power BI report hosted on powerbi.com that displays expenses by department for department managers.

The report contains a line chart that shows expenses by month.

You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must

minimize development and maintenance effort.

What should you do?

Enable report readers to personalize visuals.

Create a separate report page for users to view the column chart.

Add a column chart, a bookmark, and a button for users to choose a visual.

Create a mobile report that contains a column chart.

Correct

Incorrect
Question 30 of 39

30. Question

Category: None

PL300-Q269

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 should you do?

Add salary to the drillthrough fields.

Add salary to the visual filters.

Add salary to the tooltips.

Correct

Incorrect

Question 31 of 39

31. Question

Category: None

PL300-Q270

You have a Power BI model that contains the following data.

Table name	Column name	Description	Data type
Date	Date	Calendar date	Date
Date	Month	Calendar month	Text
Date	Year	Calendar year	Integer
Sales	Sale	Sales value	Decimal number
Sales	Date	Calendar date	Date

The Date table relates to the Sales table by using the Date columns.

The model contains the following DAX measure.

Total Sales = SUM(Sales|[Sale])

You need to create another measure named Previous Quarter to display the sales one quarter before the selected

period.

Which DAX calculation should you use?

CALCULATE ( [Total Sales], DATEADD (Date[Date],1, QUARTER ) )

CALCULATE ( [Total Sales], DATESQTD (Date[Date] ) )

TOTALQTD ( [Total Sales], Date[Date] )

CALCULATE ( [Total Sales], PARALLELPERIOD (Date[Date], 1, QUARTER ) )

Correct

Incorrect

Question 32 of 39

32. Question

Category: None

PL300-Q271

You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace

in shared capacity of powerbi.com.

The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is

scheduled to refresh twice a day at 08:00 and 17:00.

The report is a single page that contains 15 AppSource visuals and 10 default visuals.

Users say that the report is slow to load the visuals when they access and interact with the report.

You need to recommend a solution to improve the performance of the report.

What should you recommend?

Change any DAX measures to use iterator functions.

Implement row-level security (RLS).

Replace the default visuals with AppSource visuals.

Split the visuals onto multiple pages.

Correct

Incorrect
Question 33 of 39

33. Question

Category: None

PL300-Q272

You have a Power BI report that contains a table visual The visual contains a column.

The column contains whole numbers ranging from o* 1 to 20.

You need to use conditional formatting to meet the following requirements:

* Visually compare the values without having to read the text containing the number.

* Show a different format for each distinct value

* Hide the numeric value of ColumnA.

* Minimize development effort.

Which formatting should you use?

background color

font color

icons

data bars

Correct

Incorrect
Question 34 of 39

34. Question

Category: None

PL300-Q273

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?

Yes

No

Correct

Incorrect

Question 35 of 39

35. Question

Category: None

PL300-Q274

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

following table.

Name	Type	Description
Group1	Microsoft 365 group	Contains all consultants
Group2	Mail-enabled group	Contains all consultants
Team1	Microsoft Teams org-wide team	Contains all employees and consultants
Sales reports	Power BI workspace	Consultants are assigned the Viewer role for Sales report

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?

Group2

Team1

Sales reports

Group 1

Correct

Incorrect

Question 36 of 39

36. Question

Category: None

PL300-Q275

You have a Power B1 dataset named Finance that is hosted in a Power B1 workspace.

The finance team at your company is NOT currently a member of any Power B1 workspace roles.

You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset.

What should you do?

Create a row-level security (RLS) role and add the finance team to the role as members.

Provide an Excel workbook that is connected to the Finance dataset.

Grant the finance team write permissions to the Finance dataset.

Grant the finance team build permissions to the Finance dataset.

Correct

Incorrect
Question 37 of 39

37. Question

Category: None

PL300-Q277

You have a Power B1 dataset that contains quarterly sales performance data.

You need to enable managers to review the data in a format that meets the following requirements:

* Is optimized for printing.

* Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats.

What should you create?

a paginated report

A template app

an interactive report

a dashboard

Correct

Incorrect
Question 38 of 39

38. Question

Category: None

PL300-Q278

You have a source that contains a comumn. The column contains case sensitive date. 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 add an index key and normalize casing in the data source.

Does this meet the goal?

Yes

No

Correct

Incorrect
Question 39 of 39

39. Question

Category: None

PL300-Q279

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: From the Data pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and

Deliver Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

Yes

No

Correct

Incorrect

PL300-Quiz8

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