PL-300: Microsoft Power BI Data Analyst
Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service.
Which three operations can the developers achieve by using the API?
Retrieve rows from a dataset
Create a dataset
Add rows to a dataset
Refresh an imported dataset
Add a member to a row-level security role
Answer is A-B-C
The Power BI REST API has the following operations:
- Dataset operations: Get and create Datasets.
- Table operations: Get Tables and update Table schema.
- Row operations: Add Rows and Delete Rows.
- Group operations: Get Groups
Reference:
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
You have a service published to a website.
When you connect to the website, you receive the following data.
You need to create a query that retrieves the Categories data and the Customers data.
Which type of source should you use?
JSON
Text/CSV
OData Feed
XML
Answer is OData Feed
OData supports two formats for representing the resources (Collections, Entries, Links, etc) it exposes: the XML-based Atom format and the JSON format.
Reference:
https://www.odata.org/documentation/odata-version-2-0/atom-format/
In Power BI Desktop, you are updating an existing report that connects to a Microsoft SQL Server database.
You use database (SQL authentication) credentials to connect to the source.
The last credentials that were entered are expired.
You need to update the credentials.
Which two actions should you perform?
Open the Data Source Settings dialog box and locate the data source.
Select Edit Permissions and enter new credentials.
Open the Get Data dialog box and make a new connection to the database.
Open the Options dialog box and allow data previews to download in the background.
You plan to populate a table in a Power BI dataset with data from a Microsoft SharePoint Online list.
Which storage mode will be used?
DirectQuery
live connection
Composite
Imported
Which data role enables advanced analytics capabilities through reports and visualizations?
Data analyst
Data scientist
Data engineer
Answer is Data analyst
Which data analyst task has critical performance impact on reporting and data analysis?
Analyze
Visualize
Model
Answer is Model
What is a key benefit of data analysis?
Decisive analytics
Informed business decisions
Complex reports
Answer is Informed business decisions
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
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
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