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 - 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 - ANSWER c. minimized local disk space usage
d. minimized need for data refresh
You have designed a star schema to simplify your data.
1
,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 - 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 - 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
2
,d. one-to-one - 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
c. the Power BI mobile app
d. the Power BI service - ANSWER 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. - ANSWER d. You need to dis-
play 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
3
, d. Spotlight - ANSWER 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 - ANSWER 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 automati-
cally 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 - ANSWER c. an on-premises data gateway
4
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 - 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 - ANSWER c. minimized local disk space usage
d. minimized need for data refresh
You have designed a star schema to simplify your data.
1
,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 - 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 - 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
2
,d. one-to-one - 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
c. the Power BI mobile app
d. the Power BI service - ANSWER 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. - ANSWER d. You need to dis-
play 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
3
, d. Spotlight - ANSWER 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 - ANSWER 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 automati-
cally 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 - ANSWER c. an on-premises data gateway
4
