70-778 Microsoft Power BI Practice
Exam Questions & Answers (Grade
A+)
You plan to use Power BI Desktop to import 100 CSV files. The files
contain data from different stores. The files have the same
structure and are stored in a network share. You need to import the
CSV files into one table. The solution must minimize administrative
effort. What should you do?
a. Add a folder data source and use the Merge Queries command
b. Add a Microsoft Excel data source and use the Merge Queries
comand
c. Add a folder data source and use the Combine Files command
d. Add test/CSV data sources and use the Append Queries
command -
correct answer ✅c. Add a folder data source and use the Combine
Files command
A data analyst publishes several Power BI visualizations to a blog.
You discover that some of the visualizations contain data that is
considered private by your company. You need to prevent the
visualizations from being published to the blog. What should you
do?
,70-778 Microsoft Power BI Practice
Exam Questions & Answers (Grade
A+)
a. From the Power BI Admin portal. disable the Publish to web
setting
b. From the dashboard settings, modify the Share dashboard
settings
c. From the Power BI Admin portal, diable the Share content with
external users setting
d. From the Power BI settings, delete the embedded codes -
correct answer ✅a. From the Power BI Admin portal. disable the
Publish to web setting
Note: This question is part of a series of questions that present the
same scenario. Each question in the series contains a unique
solution that might meet the stated goals. Some question sets
might have more than one correct solution, while others might not
have a correct solution. After you answer a question in this section,
you will NOT be able to return to it. As a result, these questions will
not appear in the review screen. You have an app workspace that
contains a report. The report contains sensitive data. You need to
ensure that you can embed the report into a custom application
that will be accessed by external users. The external users will NOT
have a Microsoft Azure Active Directory user account or Power BI
licenses. Solution: Configure the app workspace to be read-only for
members and to run in a shared capacity. Does this meet the goal?
, 70-778 Microsoft Power BI Practice
Exam Questions & Answers (Grade
A+)
-
correct answer ✅no
You have a sales report in an app workspace. The report displays a
map of sales by location and a bar chart of sales by year. The report
has a slicer to filter the data by year. You need to create a
dashboard that contains visualizations. The solution must ensure
that you can use the slicer to filter the data by year. What should
you do?
a. Add a page level filter, and then pin each visualization to the
dashboard
b. Publish the app workspace
c. Pin each visualization to the dashboard, and then add a web
content tile
d. Pin the report as a live page -
correct answer ✅d. Pin the report as a live page
Note: This question is part of a series of questions that present the
same scenario. Each question in the series contains a unique
solution that might meet the stated goals. Some question sets
Exam Questions & Answers (Grade
A+)
You plan to use Power BI Desktop to import 100 CSV files. The files
contain data from different stores. The files have the same
structure and are stored in a network share. You need to import the
CSV files into one table. The solution must minimize administrative
effort. What should you do?
a. Add a folder data source and use the Merge Queries command
b. Add a Microsoft Excel data source and use the Merge Queries
comand
c. Add a folder data source and use the Combine Files command
d. Add test/CSV data sources and use the Append Queries
command -
correct answer ✅c. Add a folder data source and use the Combine
Files command
A data analyst publishes several Power BI visualizations to a blog.
You discover that some of the visualizations contain data that is
considered private by your company. You need to prevent the
visualizations from being published to the blog. What should you
do?
,70-778 Microsoft Power BI Practice
Exam Questions & Answers (Grade
A+)
a. From the Power BI Admin portal. disable the Publish to web
setting
b. From the dashboard settings, modify the Share dashboard
settings
c. From the Power BI Admin portal, diable the Share content with
external users setting
d. From the Power BI settings, delete the embedded codes -
correct answer ✅a. From the Power BI Admin portal. disable the
Publish to web setting
Note: This question is part of a series of questions that present the
same scenario. Each question in the series contains a unique
solution that might meet the stated goals. Some question sets
might have more than one correct solution, while others might not
have a correct solution. After you answer a question in this section,
you will NOT be able to return to it. As a result, these questions will
not appear in the review screen. You have an app workspace that
contains a report. The report contains sensitive data. You need to
ensure that you can embed the report into a custom application
that will be accessed by external users. The external users will NOT
have a Microsoft Azure Active Directory user account or Power BI
licenses. Solution: Configure the app workspace to be read-only for
members and to run in a shared capacity. Does this meet the goal?
, 70-778 Microsoft Power BI Practice
Exam Questions & Answers (Grade
A+)
-
correct answer ✅no
You have a sales report in an app workspace. The report displays a
map of sales by location and a bar chart of sales by year. The report
has a slicer to filter the data by year. You need to create a
dashboard that contains visualizations. The solution must ensure
that you can use the slicer to filter the data by year. What should
you do?
a. Add a page level filter, and then pin each visualization to the
dashboard
b. Publish the app workspace
c. Pin each visualization to the dashboard, and then add a web
content tile
d. Pin the report as a live page -
correct answer ✅d. Pin the report as a live page
Note: This question is part of a series of questions that present the
same scenario. Each question in the series contains a unique
solution that might meet the stated goals. Some question sets
