PL300-Quiz9

Category: None

PL300-Q280

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors

in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the

data, which would likely prevent the errors you encountered in the Power BI semantic model.

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

table has the following date foreign keys.

* Due Date

* Order Date

* Delivery Date

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

Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the inactive relationships

between sales table and the date table.

Does this meet the goal?

Yes

No

Category: None

PL300-Q281

Adding an index key and normalizing casing in the data source would help resolve issues with undefined values and errors

in a case-sensitive column. The index key can provide a unique identifier, and normalizing casing ensures consistency in the

data, which would likely prevent the errors you encountered in the Power BI semantic model.

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

table has the following date foreign keys.

* Due Date

* Order Date

* Delivery Date

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

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

Does this meet the goal?

Yes

No

Category: None

PL300-Q282

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.

You attempt to refresh the data and receive the following error message.

Expression.Error: The Colum ‘cost’ of the table wasn’t found.

What is a possible cause of the error?

The Cost column was renamed in the data source.

The data in the Cost column cannot be converted into the target data type.

The privacy level of the data source does not allow combining the data with other data sources.

The source file was moved to a new location.

Category: None

PL300-Q283

You have a Power BI semantic model named Model! that contains two table named

DimDate and FactSales. There is an active relationship between DimDate and FactSales.

DimDate is marked as the date table. FactSales contains the following data.

Model1 contains the following measure:

Previous Year Seles – CALCULATE([Sales Amount], PREVIOUSYEAR( ‘Date [Date] } }

You have a report that uses Model1. The report has a single report page that has a page level filter set to may 9,

2024. The result of the Previous Year measure is displayed in a card visual.

Which value appear in the card visual?

10

15

35

60

Category: None

PL300-Q284

You have a Power BI semantic model that contains a table named Table1. Table1

contains the following columns:

* WebsiteName

* URL

You need to create a report named Report] that will contain a table visual. The solution must

meet the following requirements.

* Display the website name

* Enable users to navigate to the website’s URL by selecting the website name.

What should you use?

Inline hierarchy labels

Data categories

URL icons

Conditional Formatting

Category: None

PL300-Q285

You need to address the data concerns before creating the data model. What

should you do in Power Query Editor?

Select Column distribution.

Select the sales amount column and apply a number filter.

Select Column profile, and then select the sales_amount column.

Transform the sales_amount column to replace negative values with 0.

Category: None

PL300-Q286

You need to create a calculated column to display the month based on the

reporting requirements. Which DAX expression should you use?

FORMAT(‘Date'[date], “MMM YYYY”)

B. FORMAT(‘Date’ [date], “M YY”)

C. FORMAT(‘Date'[date_id], “MMM”) &”” & FORMAT(‘Date’ [year], “#”)

D. FORMAT(‘Date’ [date_id], “MMM YYYY”)

Category: None

PL300-Q287

You need to create the required relationship for the executive’s visual. What

should you do before you can create the relationship?

Change the data type of Sales[region_id] to Whole Number.

In the Sales table, add a measure for sum(sales_amount).

Change the data type of sales[sales_id] to Text.

Change the data type of sales [region_id] to Decimal Number.

Category: None

PL300-Q288

Whatshould you create to meet the reporting requirements of the sales

department?

ameasure that uses a formula of SUM (Sales [sales_id])

B.a calculated column that use a formula of COUNTA(sales [sales_id])

C.a measure that uses a formula of COUNTROWS (Sales)

acalculated column that uses a formula of SUM (Sales [sales_id])

Category: None

PL300-Q289

You need to create a relationship between the Weekly_Returns table and the Date table to meet the

reporting requirements of the regional managers. What should you do?

Inthe Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd anduse the calculated column to create a relationship to the Date table.

Add the Weekly_Returns data to the Sales table by using related DAX functions.

Create a new table based on the Date table where date-id is unique, and then create a many-to many relationship to Weekly_Return.

Category: None

PL300-Q290

You have a Power B1 report that contains the visuals shown in the following table.

Type	Horizontal coordinate	Vertical coordinate
Table	300	200
Clustered column chart	700	200
Slicer	20	100

You need to modify the location of each visual.

What should you modify for each visual?

the layer order

the padding

the position

the tab order

Category: None

PL300-Q291

You have a Power BI model that contains two tables named Population and Date.

The Population table contains two columns named Population Amount and Date Key.

DateKey contains date values that represent the first day of a year and are used to create a many-to

The Power BI model contains two measures that have the following definitions.

Total Population = Sum (‘Population'[Population Amount])

2023 Population = CALCULATE ([Total Population]”Date'[Year] = 2023)

You create a table visual that displays Date[Year] and [2023 Population].

What will the table visual show?

one row per year that contains blank values for every year except 2023

one row per date that contains the population value for the corresponding year repeated in each row

a single row for the year 2023 that contains the related population value

one row per year that contains the same value repeated for each year

Category: None

PL300-Q292

You have a Rawer BI report That imports a dace 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 Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and

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

Does this meet the goal?

Yes

No

Category: None

PL300-Q293

Solution:

Text Description automatically generated

Box 1: Yes

The Related function returns a related value from another table.

The RELATED function requires that a relationship exists between the current table and the table with related information. You

specify the column that contains the data that you want, and the function follows an existing many-to-one relationship to fetch

the value from the specified column in the related table. If a relationship does not exist, you must create a relationship.

Box 2: Yes

Box 3: No

TX only occurs in the Sales table, but not in the CityData table. Reference:

https://docs.microsoft.com/en-us/dax/related-function-dax https://docs.microsoft.com/en-us/dax/calculate-function-dax

Does this meet the goal?

Yes

No

Category: None

PL300-Q294

You have a report in Power BI named report’ that is based on a shared dataset.

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

affected.

What should you do?

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

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

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

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

Category: None

PL300-Q295

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an

on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.

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

* Minimize online processing operations.

+ Minimize calculation times and render times for visuals.

+ include data from the current year, up to and including the previous day. What should you do?

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

Create a dataflows connection that has DirectQuery mode selected.

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

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

Category: None

PL300-Q296

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: In the Power Query M code, you replace references to the Excel file with DataSourceExcel. Does this meet the

goal?

Yes

No

Category: None

PL300-Q297

You need to configure access for the sales department users. The solution must

me meet the security requirements. What should you do?

Add the sales department as a member of the reports workspace

Add the Azure Active Directory group of the sales department as an Admin of the reports workspace.

Distribute an app to the users in the Azure Active Directory group of the sales department.

Share each report to the Azure Active Directory group of the sales department.

Category: None

PL300-Q298

You have a Power BI tenant.

You have reports that use financial datasets and are exported as PDF files. You need to

ensure that the reports are encrypted.

What should you implement?

dataset certifications

row-level security (RLS)

sensitivity labels

Microsoft Intune policies

Category: None

PL300-Q299

Solution:

Graphical user interface, text Description automatically generated

Does this meet the goal?

Yes

No

Category: None

PL300-Q300

You need to create the On-Time Shipping report.

The report must include a visualization that shows the percentage of late orders. Which

type of visualization should you create?

Scarterplot

bar chart

piechart

Category: None

PL300-Q301

How should you create the dashed horizontal line denoting the 40th percentile of daily sales

for the period shown?

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

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

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

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

Category: None

PL300-Q302

You publish a report to a workspace named Customer Services. The report identifies customers that have

potential data quality issues that must be investigated by the customer services department of your company.

You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.

Which report setting should you configure?

Don’t allow end user to save filters on this report.

Change default visual interaction from cross highlighting to cross filtering.

Enable the updated filter pane, and show filters in the visual header for this report.

Allow users to add comments to this report.

Choose the type of data you allow your end users to export.

Category: None

PL300-Q303

You have a Power BI workspace named Inventory that contains a dataset a report and a dashboard. You need to

add an additional tile to the dashboard. The tile must show inventory by location. This

information is NOT visualized in the report. The solution must minimize the impact on the report.

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

is worth one point.

Use quick insights on the dashboard.

Hide the report page.

Ask a question by using Q&A.

Add the visual to the report.

Pin the visual to the dashboard.

Category: None

PL300-Q304

The following columns contain date information:

– Date[Month] in the mmyyyy format

– Date[Date_ID] in the ddmmyyyy format

– Date[Date_name] in the mm/dd/yyyy format

– Monthly_returns[Month_ID] in the mmyyyy format

The Order table contains more than one million rows.

The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship

between the tables.

You plan to use Power BI Desktop to create an analytics solution for the data.

You need to create a relationship between the Monthly_returns table and Date[Date_ID]. What should you do before you

create the relationship?

In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.

In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.

To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.

To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.

Category: None

PL300-Q305

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 BI service.

Solution: From the Power BI service, get the data from SharePoint Online, and then click Connect Does this meet the goal?

Yes

No

Category: None

PL300-Q306

Solution:

Table Description automatically generated

Does this meet the goal?

Yes

No

Category: None

PL300-Q307

You open a query in Power Query Editor.

You need to identify the percentage of empty values in each column as quickly as

possible. Which Data Preview option should you select?

Show whitespace

Column profile

Column distribution

Column quality

Category: None

PL300-Q308

You have a Power BI report that contains five pages. Pages 1 to 4 are visible and page 5 is hidden.

You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The

solution must minimize development and maintenance effort as pages are added to the report.

What should you do first?

Add a blank button to page 1.

Add a bookmark navigation button to page 1.

Create a bookmark for each page.

Add a page navigation button to page 1.

Category: None

PL300-Q309

Fillet the data to only the NorthWest region sales territory.

Remove the CustomerKey and ProductKey columns.

Remove the TaxAmt and Freight columns.

Set the data type for SatesOrderNumber to Decimal Number

Category: None

PL300-Q310

Does this meet the goal?

Yes

No

Category: None

PL300-Q311

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?

From Power BI Desktop, customize the current theme,

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

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

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

Category: None

PL300-Q312

You have a table that contains sales data and approximately 1,000 rows.

You need to identify outliers in the table. Which type of visualization should you use?

area chart

donut chart

scatter plot

Pie chart

Category: None

PL300-Q313

You have two Power BI 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.

Solution:

Answer is as below.

To access the HR dataset: Grant User! share permissions for the HR dataset. a

B. v

Does this meet the goal?

Yes

No

Category: None

PL300-Q314

You need to ensure that all the users can access the dashboards. What should you do first?

From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

From the Power BI Admin portal, modify the Privacy Settings.

From the properties of each dashboard, modify the Share dashboard settings.

Instruct each user to install Microsoft Office 2016.

Category: None

PL300-Q315

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?

Active Directory groups

tiles

data classifications

comments

Category: None

PL300-Q316

In Power Bi Desktop, you are creating visualizations in a report based on an imported dataset

You need to allow Power Bi users to export the summarized data used to create the visualizations but prevent the

users from exporting the underlying data

What should you do?

From Power BI Desktop, configure the Data Load settings for the current file.

From the Power BI service, configure the dataset permissions.

From Power BI Desktop, configure the Report settings for the current file.

From Power BI Desktop, modify the data source permissions.

Category: None

PL300-Q317

You maintain a Power BI 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.)

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

* Only show single-value visuals.

* Minimize scrolling. What should you do?

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

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

Move the bar chart visuals to the top of the layout Remove the map visual

Decrease the size of the card visuals.

Decrease the size of the card visual

Remove the map and bar chart visuals.

Category: None

PL300-Q318

Solution:

Graphical user interface, text, application, email Description automatically generated

References:

https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps

https://docs.microsoft.com/en-us/power-bi/service-collaborate-power-bi-workspace

Does this meet the goal?

Yes

No

Category: None

PL300-Q319

Does this meet the goal?

A.Yes

B.No

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