PL - 300 Microsoft Power BI Data Analyst Practice Questions and answers GRADE A+

PL - 300 Microsoft Power BI Data
Analyst Practice Questions and
answers GRADE A+

You plan to get data for a Power BI dataset from flat files. You need
to select a location for the files. The location must provide the
ability to configure scheduled refresh for the dataset by using
Microsoft 365 credentials.
Which two location types should you recommend? Each correct answer
presents a complete solution. Select all answers that apply.

a. local file
b. OneDrive for Business
c. Personal OneDrive account
d. SharePoint - Team Sites
b. OneDrive for Business
d. SharePoint - Team Sites
You plan to add data to Power BI Desktop from a new data source. You
are evaluating whether you should use the DirectQuery storage mode or
the Import storage mode.
What are two benefits of using DirectQuery instead of Import? Each
correct answer presents a complete solution.
Select all answers that apply.

a. full support for the Q&A Power BI service
b. full support for the Quick Insights Power BI service
c. minimized local disk space usage
d. minimized need for data refresh
c. minimized local disk space usage
d. minimized need for data refresh
You have designed a star schema to simplify your data.
You need to understand the relationship between the tables in the
star schema.
What is the relationship between the fact table and dimension tables?
Select only one answer.

a. many-to-many
b. many-to-one

,c. one-to-many
d. one-to-one
b. many-to-one


You create a Power BI Desktop dataset by importing and transforming a
data source based on multiple tables in a SQL Server database.
You need to modify the relationship between the tables.
Which interface should you use in the Power BI Desktop?
Select only one answer.

a. Data view
b. Model view
c. Page view
d. Report view
b. Model view
You are designing a data model in Power BI.
You need to avoid introducing ambiguity into your data model design.
Which type of cardinality should you avoid?
Select only one answer.

a. many-to-many
b. many-to-one
c. one-to-many
d. one-to-one
a. many-to-many
You need to create a Power BI dashboard.
Which tool should you use?
Select only one answer.

a. Power BI Desktop
b. Power Query Editor
c. the Power BI mobile app
d. the Power BI service
d. the Power BI service
You are evaluating whether you need to create a dashboard in Power BI.
In which scenario do you need a dashboard instead of a report in
Power BI?
Select only one answer.

a. You need to add filters.
b. You need to add slicers.
c. You need to display visuals on multiple pages.
d. You need to display visuals that use different datasets.
d. You need to display visuals that use different datasets.

,You need to create a dashboard from a published report in Power BI.
Which option in the report should you use?
Select only one answer.

a. Copy visual as image
b. Export data
c. Pin visual
d. Spotlight
c. Pin visual
You upload reports to the Power BI service and pin several visuals to
a dashboard.
You plan to create alerts rules for several visuals.
What are two locations you can view the alerts? Each correct answer
presents a complete solution.
Select all answers that apply.

a. a report
b. an email
c. Microsoft Teams
d. the Notification Center
b. an email
d. the Notification Center
Your company has a SharePoint server located in a datacentre in
Montreal.
You plan to create a report in the Power BI service that will use
Microsoft Excel files stored on the SharePoint server.
You need to recommend a solution to ensure that the dataset for the
report can automatically refresh daily.
What should you include in the recommendation?
Select only one answer.

a. a Point to Site virtual private network (VPN)
b. a Site-to-Site virtual private network (VPN)
c. an on-premises data gateway
d. Azure Data Box
c. an on-premises data gateway
You have a row level security role (RLS) in a dataset called User
Security Group. This role needs to filter a RLS table that contains a
column with the emails of users in the following format:

Which function should be used in the code for the RLS role to match
the users Microsoft Entra ID login credentials with the emails
contained in the RLS table column?
Select only one answer.

, a. NAMEOF
b. TREATAS
c. USEROBJECTID
d. USERPRINCIPALNAME
d. USERPRINCIPALNAME
You have a Power BI dataset.
You need to set the dataset as discoverable.
Which two configurations will allow the dataset to be marked as
discoverable? Each correct answer presents a complete solution.
Select all answers that apply.

a. Certify the dataset.
b. Enable RLS on the dataset.
c. Promote the dataset.
d. Publish dataset to a Premium workspace.
a. Certify the dataset.
c. Promote the dataset.
You have several on-premises Microsoft SQL Server databases.
You need to provide Power BI Service users access to the data sources
without exposing the database servers directly to the internet.
The solution must minimize the configurations that must be performed
by each user.
What should you deploy?
Select only one answer.

a. a virtual network data gateway
b. an ExpressRoute connection
c. an on-premises data gateway
d. an on-premises data gateway (personal mode)
c. an on-premises data gateway
You plan to use Power BI Desktop to create a report with multiple
visualizations.
You need to create a visual that supports the following:
filters other visuals on the same report page
allows users to search for values by which to filter the other
visuals
Which type of visualization should you use?
Select only one answer.

a. Funnel
b. Matrix
c. Scatter chart
d. Slicer