PL - 300 Microsoft Power BI Data Analyst Practice
Questions and Answers (GRADED A+)
You have a Power BI dataset that gets data from a table in a SQL Server
database.
From which view in Power BI Desktop can you modify the storage mode of
the table?
A. Data view
B. Model view
C. Page view
D. Report view - VERIFIED ANSWER - B. Model view
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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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
Questions and Answers (GRADED A+)
You have a Power BI dataset that gets data from a table in a SQL Server
database.
From which view in Power BI Desktop can you modify the storage mode of
the table?
A. Data view
B. Model view
C. Page view
D. Report view - VERIFIED ANSWER - B. Model view
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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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 - VERIFIED ANSWER - 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
