PL300-Quiz11

Category: None

PL300-Q360

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: You create a new query that references DataSourceExcel.

Does this meet the goal?

Yes

No

Category: None

PL300-Q361

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 enable included in app for all assets.

Does this meet the goal?

Yes

No

Category: None

PL300-Q362

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.

You need to reduce the size of the data model.

What should you do?

Round the hour of the Date column to startOfHour.

Change the data type of the Date column to Text.

Trim the Date column.

Split the Date column into two columns, one that contains only the time and another that contains only the date.

Category: None

PL300-Q363

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?

Merge tables by using Power Query.

Hide unused columns in the model.

Split the model into multiple models.

Transpose.

Category: None

PL300-Q364

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

Which type of visualization should you use?

stacked area chart

donut chart

line chart

waterfall chart

Category: None

PL300-Q365

You have an app workspace named Retail Analysis in the Power BI service. You need manage the

members that have access to the app workspace. What should you do?

From the Power BI Admin portal, click Usage metrics.

From the Office 365 Admin center, click Users.

From the Office 365 Admin center, click Groups.

From the Power BI Admin portal, click Tenant settings.

Category: None

PL300-Q366

You have five sales regions. Each region is assigned a single salesperson. You have an imported dataset that has

a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.

Salespeople must see only the data from their region. You publish the dataset to powerbi.com, set RLS role

membership, and distribute the dataset and related reports to the salespeople. A salesperson reports that she

believes she should see more data. You need to verify what data the salesperson currently sees. What should you

do?

Use the Test as role option to view data as the salesperson’s user account.

Use the Test as role option to view data as the Sales role.

Instruct the salesperson to open the report in Microsoft Power BI Desktop.

Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

Category: None

PL300-Q367

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 a historic employee counts and predicts trends during the next six months. Which

type of visualization should you use?

scatter chart

ribbon chart

line chart

key influences

Category: None

PL300-Q368

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: Copy the workbook to Microsoft OneDrive for Business. From Excel, click Publish to Power BI, and then

click Upload Does this meet the goal?

Yes

No

Category: None

PL300-Q369

Your company plans to completely separate development and production assets such as datasets, reports, and

dashboards in Microsoft Power BI. You need to recommend an application lifecycle strategy. The solution must

minimize access to production assets and prevent end users from viewing the development assets.

What should you recommend?

Create production reports in a separate workspace that uses a shared dataset from the development workspac

Grant the end users access to the production workspace.

Create one workspace for developmen

From the new workspace, publish an app for production.

Create a workspace for development and a workspace for productio

From the production workspace, publish an app.

In one workspace, create separate copies of the assets and append DEV to the names of the copied asset H. Grant the end users access to the workspace.

Category: None

PL300-Q370

You are reviewing a query that produces 10,000 rows in the 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.

Column profile

Column distribution

Show whitespace

Column quality

Monospace

Category: None

PL300-Q371

You have a query that returns the data shown in the following exhibit. You need to configure the query to

display the data as shown in the following exhibit. Which step should you use in the query?

=Table.ExpandListColum(Table.TransformColunins(Source, {{“classes” Splitter. SplitTextByDelimiter(“,””, QuoteStyle.None), let itemType – (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), “classes”)

=Table.Unpivot(Source, {“classes”}, “Attribute”, “Value”)

=Table.SplitColumn(Source, “classes”. Splitter.SplitTextByDelimiterf”,”, QuoteStyle.None),{“classes.1”})

=Table.SplitColumn(Source, “classes”. Splitter.SplitTextByPositions({10}), {“classes.1”})

Category: None

PL300-Q372

You have a report that contains three pages. One of the pages contains a KPI visualization. You need to

filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform?

Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Add the same slicer to each page and configure Sync slicers.

Edit the interactions of the KPI visualization.

Configure a page-level filter.

Edit the interactions of the slicer that is on the same page as the KPI visualization.

Configure a report-level filter.

Category: None

PL300-Q373

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

Category: None

PL300-Q374

You have four sales regions. Each region has multiple sales managers. You implement row-level

security (RLS) in a data model. You assign the relevant distribution lists to each role.

You have sales reports that enable analysis by region. The sales managers can view the sales records of their region.

The sales managers are prevented from viewing records from other regions. A sales manager changes to a different

region. You need to ensure that the sales manager can see the correct sales data.

What should you do?

From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.

Change the Microsoft Power BI license type of the sales manager.

Manage the permissions of the underlying dataset

Request that the sales manager be added to the correct Azure Active Directory group.

Category: None

PL300-Q375

You have a sales system that contains the tables shown in the following table. The Date table is marked as

a date table. DatelD is the date data type.

You need to create an annual sales growth percentage measure. Which DAX expression should you use?

SUM(sales[sales_amount]) – CALCULATE(SUM(sales[sales_amount}), SAMEPERIODLASTYEAR(‘Date'[DatelD])

(SUM(‘Sales’[sales_amount]) – CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR( ‘Date’ [DatelD])))/ CALCULATE(SUM(‘Sales’[sales_amount]), SAMEPERIODLASTYEAR( ‘Date’ [DatelD]))

CALCULATE(SUM(sales[sales_amount]), DATESYTD(‘Date’[DatelD]))

CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR( ‘Date’ [DatelD]))

Category: None

PL300-Q376

You have a Power BI report. The report contains visualizations that have interactions. You need to identify which

visualizations take the longest to complete.

What should you use?

SQL Server Profiler

Performance Analyzer in Power BI Desktop

Query Diagnostics in Power Bl

Microsoft Edge DevTools

Category: None

PL300-Q377

In Power BI, calculations that take a large quantity of numbers and distill them down to a single

value that represents the group are called __.

aggregations

aggregates

measures

summations

Category: None

PL300-Q378

In Power Bl, the ____ refers to the charts and graphs, filters and slicers, and all other visual

elements that are used to display business measures and make that data easily consumable.

transformation

dataset

visual

graphic

Category: None

PL300-Q379

Which type of Power BI visual shows the relationship of parts to a whole, and draws your eye to the

center of the visual?

donut chart

column chart

pie chart

scatter plot

Category: None

PL300-Q380

In Power BI, a_____ is a custom calculation that is not actually part of a table, but which can be used

with any data in the table, or related to the table.

service

query

measure

calculated column

Category: None

PL300-Q381

One of the biggest advantages of a_____ in Power BI is that it lets you identify outliers.

donut chart

column chart

pie chart

scatter plot

Category: None

PL300-Q382

In the Power BI visualizations pane, the ____ area usually segments your data by color, and the ___

area segments your data by shape.

Legend, Axis

Axis, Transform

Values, Visuals

Transform, Legend

Category: None

PL300-Q383

To share a Power BI dataset, the data person must first publish their report in _____

their Power BI workspace

the Power BI Service

Power BI Desktop

their Power BI dashboard

Category: None

PL300-Q384

Power BI allows you to easily find and install custom visuals that have been created by Microsoft and

community members and shared with the Power BI community via the ____ tab.

App Source

App Store

Community

Custom

Category: None

PL300-Q385

The syntax used to denote a table in a Power BI formula is ____.

acolon

asingle quote

adouble quote

asemi-colon

Category: None

PL300-Q386

Power BI ____ is an application installed on a computer that allows you to build visuals, query

data, publish reports to the cloud, and more.

Integrated

Desktop

Service

App Source

Category: None

PL300-Q387

The ____ tab in the Power BI interface is the main place where visualizations are created and

arranged.

Model

Visuals

Reports

Data

Category: None

PL300-Q388

In Power Bl’s Power Query, you can create new queries by clicking on ____.

New Source

New Query

Import

Transform

Category: None

PL300-Q389

In Power BI, ____ are the standard for comparing series to each other.

donut charts

column charts

pie charts

scatter plots

Category: None

PL300-Q390

In Power Bl’s Power Query, the ____ option for combining two datasets into one pastes the new data at

the bottom of the existing data.

Match

Insert

Merge

Append

Category: None

PL300-Q391

In Power Bl, the ____ area for a visual is where you should place the calculable data.

Data

Legend

Axis

Values

Category: None

PL300-Q392

In which view of Power BI Desktop can you preview the data that has been loaded?

data view

model view

query view

report view

Category: None

PL300-Q393

In Power Bl, error values in data _____.

are loaded as OTHER

prevent queries from loading

are loaded as blank values

are loaded as #N/A

Category: None

PL300-Q394

The data profiling feature of Power BI Desktop sits in the _____ function.

Power Pivot

Power View

Power Map

Power Query

Category: None

PL300-Q395

In Power BI, the ____ number refers to how many different values there are in a column, once duplicates

are excluded.

regression

distinct

cardinality

unique

Category: None

PL300-Q396

Enabling ____ in Power BI Power Query will show how many distinct and unique items each column

contains, as well as the distribution of these, in the form of a column chart under each header.

column analysis

column distribution

column quality

column profile

Category: None

PL300-Q397

Fill in the blanks: In a Power BI table column, the ____ distinct and ____ unique items are in a

column, the higher the cardinality.

fewer, fewer

more, more

more, fewer

fewer, more

Category: None

PL300-Q398

In Power BI, column _____ include(s) characteristics like count, error, empty, distinct, unique, zero, min,

max, and average.

qualities

charts

statistics

analytics

Category: None

PL300-Q399

In which view of Power BI Desktop can you view the relationship between tables?

data view

model view

query view

report view

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