You need to identify the percentage of empty values in each column as quickly as possible.
What data preview option do you select? - ANSWER Column Quality
You need to identify outliers in a text column. Which data preview option do you select? -
ANSWER Top and bottom values in Value Distribution
What is the relationship between the fact table and the dimension tables? - ANSWER
Many to One
What kind of data is in a fact table? - ANSWER Observational data (sales orders, shipping
dates, employees)
What kind of data is in a dimension table? - ANSWER Specific entities like product IDs and
calendar dates, details about business entities
You have a Power BI Desktop dataset based on a star schema data source.
You need to use Data Analysis Expression (DAX) to create a date table in the dataset and
populate the table with a range of dates based on the earliest and latest date within the da-
taset.
Which function should you use?
CALENDAR
CALENDARAUTO
DATE
DATEDIFF - ANSWER CALENDARAUTO
1
,In Power BI Desktop, you plan to use M-language to define a common date table spanning a
period of 10 years.
You need identify the M language function that would allow you to specify that rows in the
table should represent consecutive days within the date range you designated. Your solution
must minimize administrative effort.
Which syntax should you use?
#date
#duration
List.Combine
List.Duration - ANSWER #duration
What are 3 items that cannot be assigned a display folder? - ANSWER Measure, Column,
Calculated Column
To create a quick measure in Desktop, which 2 elements can you use? - ANSWER Calcula-
tions, Fields
What is a feature of implicit measure that explicit would not have? - ANSWER End Users
can change the aggregation type of implicit measures from the values of a visual
What do you select to determine query timings for visuals? - ANSWER Performance Ana-
lyzer
Where can you modify storage mode of tables? - ANSWER Model view
2 Main Benefits of DirectQuery over Import? - ANSWER Minimized need for data refresh,
minimized local disk space usage
2 Benefits of Import over Direct Query? - ANSWER Full support of q&a and quick insights
2
,Need to ensure a server name can be changed after the dataset has been published to pbi
service. What 2 actions can you perform? - ANSWER Create a parameter, update server
source to use a parameter in data source settings
Need to identify data anomalies in Excel file. Column distribution must consider all rows in
Excel file. - ANSWER Use Column Profile View in Power Query Editor
Need to ensure column statistics are based on the analysis of an entire dataset - ANSWER
From the status bar, change profiling status to entire dataset
Query named FactSales from SQL. Need to update the query to prevent new columns that
may be added to the table in the future from getting imported during data refreshes. You se-
lect existing columns in the query. What two applied steps can you use in Power Query Edi-
tor to achieve this goal?
Choose Columns
Remove Columns
Remove Other Columns
Transpose - ANSWER Choose Columns, Remove Other Columns
From Power Query Editor, you import a CSV. Data includes ZIP. It is auto applied as whole
number. You need to ensure that ZIP is text with 5 character values. - ANSWER In Power
Query Editor, update the current changed type step and replace convert from number to
text.
You connect Power Query Editor to a database table.
You need to remove the Row ID column. Your solution must ensure that new columns do
NOT display in the table model during a scheduled refresh in the future.
What transformation should you use?
3
, Select Row ID, then use the Remove Other Columns Command
Use the Remove Column command on the Row ID column
Use the select columns command and choose the columns to keep
use the transpose command then filter the rows to remove row id - ANSWER Use select
columns command and choose columns to keep
only select columns command lets you choose columns to keep, delete columns you don't
want and prevent new columns from showing up
You have a fact table that contains sales data. The fact table includes a SalesDate column.
Auto date/time is disabled in global and current file options. You load table. You need to en-
sure that you are able to analyze data using dates. Your solution must minimize the model
size and admin effort. - ANSWER Add a separate date dimension table
You upload reports to Power BI service and pin visuals to a dashboard. You plan to create
alert rules for several visuals. Where can you see alerts? - ANSWER Email, Microsoft
Teams
You need to add new visuals to a Power BI Dashboard. This visual does not exist on a report
in the workspace. What should you do first? - ANSWER Select Ask a question about your
data (Q&A can create a new visual without adding it to a report)
You plan to certify a Power BI dataset.
You need to identify at which level within your organization the permissions to certify a da-
taset are assigned.
Which level should you identify?
Select only one answer.
Dataset
Tenant
Workbook
4
What data preview option do you select? - ANSWER Column Quality
You need to identify outliers in a text column. Which data preview option do you select? -
ANSWER Top and bottom values in Value Distribution
What is the relationship between the fact table and the dimension tables? - ANSWER
Many to One
What kind of data is in a fact table? - ANSWER Observational data (sales orders, shipping
dates, employees)
What kind of data is in a dimension table? - ANSWER Specific entities like product IDs and
calendar dates, details about business entities
You have a Power BI Desktop dataset based on a star schema data source.
You need to use Data Analysis Expression (DAX) to create a date table in the dataset and
populate the table with a range of dates based on the earliest and latest date within the da-
taset.
Which function should you use?
CALENDAR
CALENDARAUTO
DATE
DATEDIFF - ANSWER CALENDARAUTO
1
,In Power BI Desktop, you plan to use M-language to define a common date table spanning a
period of 10 years.
You need identify the M language function that would allow you to specify that rows in the
table should represent consecutive days within the date range you designated. Your solution
must minimize administrative effort.
Which syntax should you use?
#date
#duration
List.Combine
List.Duration - ANSWER #duration
What are 3 items that cannot be assigned a display folder? - ANSWER Measure, Column,
Calculated Column
To create a quick measure in Desktop, which 2 elements can you use? - ANSWER Calcula-
tions, Fields
What is a feature of implicit measure that explicit would not have? - ANSWER End Users
can change the aggregation type of implicit measures from the values of a visual
What do you select to determine query timings for visuals? - ANSWER Performance Ana-
lyzer
Where can you modify storage mode of tables? - ANSWER Model view
2 Main Benefits of DirectQuery over Import? - ANSWER Minimized need for data refresh,
minimized local disk space usage
2 Benefits of Import over Direct Query? - ANSWER Full support of q&a and quick insights
2
,Need to ensure a server name can be changed after the dataset has been published to pbi
service. What 2 actions can you perform? - ANSWER Create a parameter, update server
source to use a parameter in data source settings
Need to identify data anomalies in Excel file. Column distribution must consider all rows in
Excel file. - ANSWER Use Column Profile View in Power Query Editor
Need to ensure column statistics are based on the analysis of an entire dataset - ANSWER
From the status bar, change profiling status to entire dataset
Query named FactSales from SQL. Need to update the query to prevent new columns that
may be added to the table in the future from getting imported during data refreshes. You se-
lect existing columns in the query. What two applied steps can you use in Power Query Edi-
tor to achieve this goal?
Choose Columns
Remove Columns
Remove Other Columns
Transpose - ANSWER Choose Columns, Remove Other Columns
From Power Query Editor, you import a CSV. Data includes ZIP. It is auto applied as whole
number. You need to ensure that ZIP is text with 5 character values. - ANSWER In Power
Query Editor, update the current changed type step and replace convert from number to
text.
You connect Power Query Editor to a database table.
You need to remove the Row ID column. Your solution must ensure that new columns do
NOT display in the table model during a scheduled refresh in the future.
What transformation should you use?
3
, Select Row ID, then use the Remove Other Columns Command
Use the Remove Column command on the Row ID column
Use the select columns command and choose the columns to keep
use the transpose command then filter the rows to remove row id - ANSWER Use select
columns command and choose columns to keep
only select columns command lets you choose columns to keep, delete columns you don't
want and prevent new columns from showing up
You have a fact table that contains sales data. The fact table includes a SalesDate column.
Auto date/time is disabled in global and current file options. You load table. You need to en-
sure that you are able to analyze data using dates. Your solution must minimize the model
size and admin effort. - ANSWER Add a separate date dimension table
You upload reports to Power BI service and pin visuals to a dashboard. You plan to create
alert rules for several visuals. Where can you see alerts? - ANSWER Email, Microsoft
Teams
You need to add new visuals to a Power BI Dashboard. This visual does not exist on a report
in the workspace. What should you do first? - ANSWER Select Ask a question about your
data (Q&A can create a new visual without adding it to a report)
You plan to certify a Power BI dataset.
You need to identify at which level within your organization the permissions to certify a da-
taset are assigned.
Which level should you identify?
Select only one answer.
Dataset
Tenant
Workbook
4
