PL-300: Microsoft Power BI Data Analyst

8%

Question 21

What is a key benefit of data analysis?
Decisive analytics
Informed business decisions
Complex reports




Answer is Informed business decisions


Question 22

What are the building blocks of Power BI?
Tiles, dashboards, databases, mobile devices
Visual Studio, C#, and JSON files
Datasets, Visualizations, Reports, Dashboards, and Tiles




Answer is Datasets, Visualizations, Reports, Dashboards, and Tiles


Question 23

What is the common flow of activity in Power BI?
Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards
Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.
Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.
Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.




Answer is Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards


Question 24

A collection of ready-made visuals, pre-arranged in dashboards and reports is called what?
The canvas
An app
A dataset
Scheduled refresh




Answer is An app


Question 25

Which of the following sources contains sites, document libraries, and folders?
SharePoint Online
Microsoft Dataverse
Power BI Libraries
Filing Cabinets




Answer is SharePoint Online

SharePoint Online organizes information into sites, document libraries, folders, and files within folders.

Question 26

The primary data preparation tool in Power BI is called what?
Report editor
Power Query editor
Data editor




Answer is Power Query editor


Question 27

The process of shaping data by converting your flat data into a table that contains an aggregation value for each unique value in a column is called what?
Group by columns
Pivot (pivoting a column)
Manage aggregations




Answer is Pivot (pivoting a column)

Question 28

What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.
Deleting unnecessary rows and columns can damage the structure of the data model.
Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.




Answer is Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.


Question 29

How many rows does Power Query scan to detect the type of data in the columns?
10,000
1,000
100




Answer is 1,000


Question 30

Data profiling is defined as what?
Aggregating columns containing numeric data
Studying the nuances of the data
Data modeling




Answer is Studying the nuances of the data


< Previous PageNext Page >

Quick access to all questions in this exam