PL300-Quiz10

Category: None

PL300-Q320

You have a Power BI report named Report’ and a dashboard named Dashboard’. 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 the bar chart displays on

Dashboard’, What should you do?

Refresh the dataset used by Report1 and Dashboard1.

Select Refresh visuals for Dashboard1.

Edit the details for the dashboard tile Of Dashboar1.

Pin the Sales by month bar chart to Dashboard1.

Category: None

PL300-Q321

Solution:

Graphical user interface, text, application Description automatically generated

Box 1: CALCULATE

Box 2: DATEADD

Box 3: DIVIDE

Example: NET_SALES QoQ% = IF(

ISFILTERED(‘Calendar'[Date]),

ERROR(‘Time intelligence quick measures can only be grouped or filtered by the Power Bl-provided date hierarchy or primary date

column.”),

VAR PREV_QUARTER =

CALCULATE(

SUM(‘research ra_qtr_template'[NET_SALES]), DATEADD(‘Calendar'[Date].[Datel], -1, QUARTER)

) RETURN DIVIDE(

SUM(‘research ra_qtr_template'[NET_SALES]) – PREV_QUARTER,

PREV_QUARTER

)

Reference:

https://community.powerbi.com/t5/Desktop/Error-calculating-QO0Q-using-quick-measure/m-p/547054

Does this meet the goal?

Yes

No

Category: None

PL300-Q322

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?

Merge the Customer and Address tables.

Transpose the Customer and Address tables.

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

Append the Customer and Address tables.

Category: None

PL300-Q323

Does this meet the goal?

Yes

No

Category: None

PL300-Q324

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?

Yes

No

Category: None

PL300-Q325

You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.

A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My

organization AppSource for your account.

You need to ensure that User sees App1 from the My organization AppSource. What should you do?

From the app workspace, click Update app, configure the Content settings, and then click Update app.

From the app workspace settings, add a member.

From the app workspace, click Update app, configure the Access setting, and then click Update app.

From the app workspace, share the dashboard.

Category: None

PL300-Q326

You have a Power BI report that uses a dataset based on an Azure Analysis Services live connection. You need

to ensure that users can use Q&A from the Power BI service for the dataset.

What should you do?

From the Power BI service, add an enterprise gateway to the dataset.

From Power BI Desktop, add synonyms and suggested questions.

From Power BI Desktop, add a Q&A visual to the report.

From the Power Bi service, select Turn on Q&A for this dataset.

Category: None

PL300-Q327

A. Disabdie the auto cate/time option.

B. Creste » Date tobdle anc se-ect Mark as Date Table.

C. Create a relationship oetween the Date tad’e and the Seles tadie

D. Oisabie the cad on the Date table

E. Remove the reistionship between the Product tebie ard the Sales tabie.

Option A

Option B

Option C

Option D

Category: None

PL300-Q328

The dataset takes a long time to refresh.

You need to modify Posts and Traffic queries to reduce toad times.

Which two actions will reduce the toad times? Each correct answer presents part of the solution. NOTE: Each correct

selection is worth one point.

Remove the rows m Traffic in which Traffic [Referring URL] does not start with “/”

Remove the rows in Posts in which Post [Publish Date] is in the last seven days.

Remove Traffic [IP Address], Traffic (Browser Agent], and Traffic [Referring URL).

Remove Posts [Full Text] and Posts [Summary].

Remove the rows in Traffic in which Traffic [URL visited] does not contain “blog”

Category: None

PL300-Q329

You have a Power BI workspace named BI Data that contains a dataset named BI Finance.

You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace,

You need to connect to BI Finance and create a report.

Which actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection

is worth one point.

From the Power BI service, create a dataflow to the dataset by using DirectQuery.

From Power BI Desktop, connect to a Dataverse data source.

From the Power BI service, create a new report and select a published dataset

From Power BI Desktop, connect to a shared dataset

Category: None

PL300-Q330

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.

Solution:

Text, table Description automatically generated with medium confidence

Box 1: CONTOSO BIKES report Box 2: three datasets

Images, tweets and the Contoso datasets.

Does this meet the goal?

A.Yes

B.No

Category: None

PL300-Q331

You have a prospective customer list that contains 1,500 rows of data. The list contains the

following fields:

First name

Last name

Email address

State/Region

Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a

marketing campaign.

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

Each correct selection is worth one point.

Open the Advanced Editor.

Select Column quality.

Enable Column profiling based on entire dataset.

Select Column distribution.

Select Column profile.

Category: None

PL300-Q332

You build a Power BI report that displays 10T temperature data streaming from a refrigerator. You publish the

report to the BI service.

You need to be notified when the temperature rises above four degrees Celsius. What should you do?

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

Set an alert on a KPI visual in the report.

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

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

Category: None

PL300-Q333

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

There are four departments in the Departments table.

You need to ensure that users can see the data of their respective department only. What should you do?

Create a row-level security (RLS) role for each department, and then define the membership of the role.

Create a DepartmentID parameter to filter the Departments table.

To the ConfidentialData table, add a calculated measure that uses the currentgroup DAX function.

Create a slicer that filters Departments based on DepartmentID.

Category: None

PL300-Q334

You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle

database and an Azure SQL database by using one query.

You have admin access to the workspace and permission to use an existing On-premises data gateway for which the

Oracle data source is already configured.

You need to ensure that the data is updated every morning. The solution must minimize configuration effort. Which two

actions should you perform when you configure scheduled refresh? Each correct answer presents

part of the solution.

NOTE: Each correct selection is worth one point.

A.Configure the dataset to use the existing On-premises data gateway.

B.Deploy an On-premises data gateway in personal mode.

C.Set the refresh frequency to Daily.

D.Configure the dataset to use the personal gateway.

Category: None

PL300-Q335

Solution:

Box 1: A scatter plot…

A scatter chart always has two value axes to show: one set of numerical data along a horizontal axis and another set of

numerical values along a vertical axis. The chart displays points at the intersection of an x and y numerical value,

combining these values into single data points. Power BI may distribute these data points evenly or unevenly across the

horizontal axis. It depends on the data the chart represents.

Box 2: Automatically find clusters

Scatter charts are a great choice to show patterns in large sets of data, for example by showing linear or non-linear

trends, clusters, and outliers.

Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-scatter

Does this meet the goal?

A.Yes

B.No

Category: None

PL300-Q336

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales

table contains purchase and ship dates.

Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently

and together.

You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number

of queries against the data source.

Which data modeling design should you use?

Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.

Duplicate the Date query in Power Query and use active relationships between both Date tables.

On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Category: None

PL300-Q337

You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows

total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A

user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications.

What should you do?

A.Share the dashboard to the user.

B.Create a subscription.

C.Create a data alert.

D.Tag the user in a comment.

Category: None

PL300-Q338

You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the

dashboard.

Which settings should you modify from the Power BI Settings?

Subscriptions

Dashboards

Datasets

Workbooks

Category: None

PL300-Q339

Solution:

Scenario: The sales managers require a visual to analyze sales performance versus sales targets.

Box 1: KPI

A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable

goal.

Box 2: Sales[sales_amount]

Box 3: Date[month]

Time > FiscalMonth. This value will represent the trend. Box 4: Targets[sales_target]

Reference:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

Does this meet the goal?

Yes

No

Category: None

PL300-Q340

You create a report by using Microsoft Power BI Desktop.

The report uses data from a Microsoft SQL Server Analysis Services (SSAS) cube located on your company’s internal

network.

You plan to publish the report to the Power BI Service.

What should you implement ta ensure that users who consume the report from the Power BI Service have the most up-to-

date data from the cube?

a subscription

a scheduled refresh of the dataset

an OData feed

an On-premises data gateway

Category: None

PL300-Q341

Remove the rows in which sales [status] has a value of Canceled.

Change the data type of sale [Delivery_Time] to Integer

Removes (Canceled Date).

Split Sales [Sale_Date] into separate date and time columns.

Remove sales [Sales_Date].

Category: None

PL300-Q342

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.

Text/CSV

Folder

Excel Workbook

SharePoint folder

Web

Category: None

PL300-Q343

You are developing a report page. Some users will navigate the report by using a keyboard, and some users will

consume the report by using a screen reader. You need to ensure that the users can consume the content on a report

page in a logical order. What should you configure in Microsoft Power BI Desktop?

the bookmark order

the layer order

the tab order

the X position

Category: None

PL300-Q344

Solution:

Diagram, table Description automatically generated

References:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts

Does this meet the goal?

Yes

No

Category: None

PL300-Q345

You need to show the relationship between Total Cost and Total Sales over time. What

should you do?

Add a play axis.

Add a slicer for the year.

From the Analytics pane, add an Average line.

Create a DAX measure that calculates year-over-year growth.

Category: None

PL300-Q346

Does this meet the goal?

Yes

No

Category: None

PL300-Q347

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

department?

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

acalculated column that use a formula of COUNTA(sales [sales_id])

a measure that uses a formula of COUNTROWS (Sales)

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

Category: None

PL300-Q348

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

the reports?

two imported datasets

asingle DirectQuery dataset

two DirectQuery datasets

asingle imported dataset

Category: None

PL300-Q349

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

sheet reports?

CALCULATE (SUM( BalanceSheet [BalanceAmount] ), DATESQTD( ‘Date'[Date] ))

CALCULATE (SUM( BalanceSheet [BalanceAmount] ), LASTDATE( ‘Date'[Date] ))

FIRSTNONBLANK ( ‘Date’ [Date]SUM( BalanceSheet[BalanceAmount] ))

CALCULATE (MAX( BalanceSheet[BalanceAmount] ), LASTDATE( ‘Date’ [Date] ))

Category: None

PL300-Q350

You need to design the data model to meet the report requirements. What should you do in Power BI

Desktop?

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.

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power BI Desktop, use the Auto date/time option when creating the reports.

From Power Query, add a date tabl E. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

Category: None

PL300-Q351

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

DirectQuery

Import

Live connection

Composite

Category: None

PL300-Q352

You have a query for a table named Sales. Sales has a column named CustomerID.

The Data Type of CustomerID is Whole Number.

You refresh the data and find several errors.

You discover that new entries in the Sales table contain nonnumeric values.

You need to ensure that nonnumeric values in the CustomerID column are set to 0.

Solution: From Query Editor, select the CustomerID column and click Remove Errors.

Yes

No

Category: None

PL300-Q353

You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains

the following elements: A line chart that shows the number of defective products manufactured by day. A KPI visual

that shows the current daily percentage of defective products manufactured. You need to be notified when the daily

percentage of defective products manufactured exceeds 3%. What should you create?

a Q&A visual

a subscription

asmart narrative visual

analert

Category: None

PL300-Q355

You have a Microsoft Power BI dashboard. You need to ensure that consumers of the dashboard can give you

feedback that will be visible to the other consumers of the dashboard.

What should you use?

Feedback

Subscribe

Comments

Mark as favorite

Category: None

PL300-Q356

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 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 median line by using the Salary measure.

Does this meet the goal?

Yes

No

Category: None

PL300-Q357

You import a large dataset to Power Query Editor. You need to identify whether a column contains only unique

values. Which two Data Preview options can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point

Show whitespace

Column distribution

Column profile

Column quality

Monospaced

Category: None

PL300-Q358

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

What should you do m Power BI Desktop?

From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

From Power Bi Desktop, use the Auto date/time option when creating the reports.

From Power Query, add a date tabl

Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

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

Category: None

PL300-Q359

You have an app workspace that contains a dashboard and four reports. All the reports are generated from a

single dataset that contains sales data for your company. The reports display the data configured as shown in the

following table. You need to ensure that the users of the reports can locate the correct report by using natural

language queries. What should you do?

From the properties of the dataset, create four Featured Q&A Questions.

From the Format settings of the reports, modify the Page Information.

From the properties of the dataset, modify the Q&A and Cortana settings.

From the properties of the workspace, modify the Language Settings.

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