Power BI Exam (Assessment) UPDATED
ACTUAL Exam Questions and CORRECT
Answers
You manage a Power BI workspace.
You need to delegate the task to schedule data refreshes. The solution must use the principle of
least privilege.
Which role should you use?
A) Admin
B) Contributor
C) Member
D) Viewer - CORRECT ANSWER - B) Contributor
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
A) OneDrive for BusinessPersonal
B) OneDrive accountSharePoint
C) Online Team Sites
D) Shared folder on a local network - CORRECT ANSWER - D) Shared folder on a local
network
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 - CORRECT ANSWER - B) OneDrive for Business
D) SharePoint - Team Sites
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?
Select only one answer.
A) Data view
B) Model view
C) Page view
D) Report view - CORRECT ANSWER - B) Model view
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 Import instead of DirectQuery? 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
E) support for per table configuration - CORRECT ANSWER - A) full support for the
Q&A Power BI service
,B) full support for the Quick Insights Power BI service
You have multiple Excel files stored in a folder synced with OneDrive for Business.
You need to import data from the files. The solution must NOT use a data gateway.
Which type of connector should you use?
Select only one answer.
A) Excel workbook
B) Folder
C) SharePoint folder
D) SharePoint list - CORRECT ANSWER - C) SharePoint folder
You plan to publish a dataset from Power BI Desktop.
You need to ensure that a server name can be changed after the dataset has been published to the
Power BI Service.
Which two actions should you perform? Each correct answer presents part of the solution.
Select all answers that apply.
A) Create a parameter.
B) Create a query for the server name.
C) From the Data source settings in Power BI Desktop, update the permissions.
D) From the Data source settings, update the server source to use a parameter.
E) Update the Source applied step of all related queries to reference the server name query. -
CORRECT ANSWER - A) Create a parameter.
D) From the Data source settings, update the server source to use a parameter.
You create a Power BI data source which uses a SQL SELECT statement. The SQL statement
queries multiple tables in a SQL Server database and includes subqueries.
, After you import data from the data source into Power BI, you notice that one of the columns in
the resulting dataset appears blank. You verify that the source table does include data.
What should you do to resolve the issue?
Select only one answer.
A) Clear permissions on the data source in Power BI.
B) Use the CAST function in the SQL statement.
C) Use the DATALENGTH function in the SQL statement.
D) Set the privacy levels on the data source. - CORRECT ANSWER - B) Use the CAST
function in the SQL statement.
You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query
Editor.
You need to identify outliers in a text column within the data source.
Which information should you use from Power Query Editor?
Select only one answer.
A) the min and max values in Column profile
B) the top and bottom entries in Value distribution
C) the value of the Distinct entry in Column statistics
D) the value of the Unique entry in Column statistics - CORRECT ANSWER - B) the top
and bottom entries in Value distribution
You have a query that has a column named Country and columns for each month of sales data.
The names of the sales data columns use a format of Month Year, for example January 2022. The
month columns contain the Sales Amount values for each month.
You need to reshape the table to have all sales amount values in a single column.
A new column should also be added and contain the relevant month year for each row of data.
What should you do from the Power Query Editor?
Select only one answer.
ACTUAL Exam Questions and CORRECT
Answers
You manage a Power BI workspace.
You need to delegate the task to schedule data refreshes. The solution must use the principle of
least privilege.
Which role should you use?
A) Admin
B) Contributor
C) Member
D) Viewer - CORRECT ANSWER - B) Contributor
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
A) OneDrive for BusinessPersonal
B) OneDrive accountSharePoint
C) Online Team Sites
D) Shared folder on a local network - CORRECT ANSWER - D) Shared folder on a local
network
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 - CORRECT ANSWER - B) OneDrive for Business
D) SharePoint - Team Sites
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?
Select only one answer.
A) Data view
B) Model view
C) Page view
D) Report view - CORRECT ANSWER - B) Model view
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 Import instead of DirectQuery? 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
E) support for per table configuration - CORRECT ANSWER - A) full support for the
Q&A Power BI service
,B) full support for the Quick Insights Power BI service
You have multiple Excel files stored in a folder synced with OneDrive for Business.
You need to import data from the files. The solution must NOT use a data gateway.
Which type of connector should you use?
Select only one answer.
A) Excel workbook
B) Folder
C) SharePoint folder
D) SharePoint list - CORRECT ANSWER - C) SharePoint folder
You plan to publish a dataset from Power BI Desktop.
You need to ensure that a server name can be changed after the dataset has been published to the
Power BI Service.
Which two actions should you perform? Each correct answer presents part of the solution.
Select all answers that apply.
A) Create a parameter.
B) Create a query for the server name.
C) From the Data source settings in Power BI Desktop, update the permissions.
D) From the Data source settings, update the server source to use a parameter.
E) Update the Source applied step of all related queries to reference the server name query. -
CORRECT ANSWER - A) Create a parameter.
D) From the Data source settings, update the server source to use a parameter.
You create a Power BI data source which uses a SQL SELECT statement. The SQL statement
queries multiple tables in a SQL Server database and includes subqueries.
, After you import data from the data source into Power BI, you notice that one of the columns in
the resulting dataset appears blank. You verify that the source table does include data.
What should you do to resolve the issue?
Select only one answer.
A) Clear permissions on the data source in Power BI.
B) Use the CAST function in the SQL statement.
C) Use the DATALENGTH function in the SQL statement.
D) Set the privacy levels on the data source. - CORRECT ANSWER - B) Use the CAST
function in the SQL statement.
You import an Excel file into Power BI Desktop and begin to analyze the data in Power Query
Editor.
You need to identify outliers in a text column within the data source.
Which information should you use from Power Query Editor?
Select only one answer.
A) the min and max values in Column profile
B) the top and bottom entries in Value distribution
C) the value of the Distinct entry in Column statistics
D) the value of the Unique entry in Column statistics - CORRECT ANSWER - B) the top
and bottom entries in Value distribution
You have a query that has a column named Country and columns for each month of sales data.
The names of the sales data columns use a format of Month Year, for example January 2022. The
month columns contain the Sales Amount values for each month.
You need to reshape the table to have all sales amount values in a single column.
A new column should also be added and contain the relevant month year for each row of data.
What should you do from the Power Query Editor?
Select only one answer.
