PL-300

Question 1

What are the three features of the column quality in data previewing options in Power Query?

Answer 1

1) Valid
2) Error
3)Empty

Question 2

What are the nine features of the column profiling in data and previewing options in Power Query?

Answer 2

1) Count
2) Error
3) Empty
4) Distinct
5) Unique
6) Empty String
7) Min
8) Max
9) Value Distribution

Question 3

What is the default number of rows that are previewed in Power Query?

Answer 3

1000

Question 4

What are the three features of the column distribution in data and previewing options in Power Query?

Answer 4

1) Distinct
2) Unique
3) Remove Duplicates

Question 5

What are the five data previewing options in Power Query?

Answer 5

1) Column Distribution
2) Column Profile
3) Column Quality
4) Monospaced
5) Show whitespace

Question 6

What are the two types of endorsements for the Power BI service?

Answer 6

1) Promotion
2) Certification

Question 7

What do you need to make certification available in the Power Bi Service?

Answer 7

1) The Power BI administrator has enabled and configure

Question 8

What are the four types of data that can be endorsed in Power BI?

Answer 8

1) Datasets
2) Dataflows
3) Reports
4) Apps

Question 9

How do tooltips show Data by default

Answer 9

They will apply the filter from cross-highlighted data in to the tooltip

Question 10

Describe a ribbon chart

Answer 10

Places the highest ranked value at the top of the stacked column each month and shows those ranked changes over time

Question 11

Describe a scatterplot

Answer 11

Used to compare a relationship between two calculations and their categorical distribution between each other

Question 12

Describe a funnel Visualisation

Answer 12

A funnel visualisation displays a linear process with sequentially connected stages, with one stage transitioning to the next

Question 13

Describe a tree map visualisation

Answer 13

Shows the data as a set of nested rectangles

Question 14

Describe a waterfall

Answer 14

Displays a running total as values are added or subtracted

Question 15

Describe an area char

Answer 15

Visualise quality and magnitude change over time

Question 16

What storage mode is required for Q&A and Quick insights

Answer 16

Import

Question 17

How long can you review questions that users as Q&A

Answer 17

28 days

Question 18

What type of words can you teach Q&A

Answer 18

1) Nouns 2) Adjectives

Question 19

What type of words can you not teach Q&A

Answer 19

Verbs like exceed

Question 20

Can you disable the search for the filters pane

Answer 20

yes you can in the report options

Question 21

Describe what the pivot function does

Answer 21

Converts rows to columns, creating a cross-tabular view of data.

Question 22

Describe what unpivot does

Answer 22

Transforms cols in to rows normalising wide data in to a longer format