Name: Score:
24 Multiple choice questions
Term 1 of 24
Which of the following selections are not best practices for naming conventions in Power BI?
Rename columns to have spaces in them.
Abbreviate column names.
Replace values that have integers with human readable results.
Term 2 of 24
Do you need to import custom visuals each time you want to use them when you're
developing a new report, not an existing report?
No, custom visuals are always available for selection under the Visualization pane.
Yes, custom visuals must be imported from AppSource each time you start developing a
new report.
No, custom visuals only need to be imported once and will always remain in Power BI for
future use in a new report.
Term 3 of 24
What can you do to improve performance when you're getting data in Power BI?
Remove unnecessary columns and rows
Export database files to CSV to load
Combine date and time columns into a single column
Term 4 of 24
What is a risk of having null values in a numeric column?
That function SUM of data will be incorrect.
That function MAX of data will be incorrect.
That function AVERAGE of data will be incorrect.
,Term 5 of 24
What is cardinality?
Cardinality is the measure of unique values in a table.
Cardinality is the granularity of the data.
Cardinality is how long it takes for the data to load.
Cardinality is a type of visual element.
Term 6 of 24
Which one of the following options is the most important key benefit of data analysis?
Decisive analytics
Informed business decisions
Complex reports
Term 7 of 24
What is the difference between a fact table and a dimension table?
Fact tables contain observational data while dimension tables contain information about
specific entities within the data.
Fact tables contain information about specific entities while dimension tables contain
information about observational data.
There is no difference.
Dimension tables tell you about specific roles in Power BI while fact tables tell you
information about facts that are associated with those roles in Power BI.
Term 8 of 24
Which two functions will help you compare dates to the previous month?
CALCULATE and PREVIOUSMONTH
TOTALYTD and PREVIOUS MONTH
CALCULATE and TOTALTYD
, Term 9 of 24
Which data role enables advanced analytics capabilities specifically through reports and
visualizations?
Data scientist
Data engineer
Data analyst
Term 10 of 24
You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When
the data refreshes in the cube, you would like to see it immediately in the Power BI report. How
should you connect?
Import
T-SQL
Live connection
Term 11 of 24
What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
Deleting unnecessary rows and columns will reduce a dataset size and its good practice
to load only necessary data into your data model.
Deleting unnecessary rows and columns can damage the structure of the data model.
Term 12 of 24
When connecting to a SQL Server database to get data, what language should you use to
extract data?
DAX
T-SQL
MDX
24 Multiple choice questions
Term 1 of 24
Which of the following selections are not best practices for naming conventions in Power BI?
Rename columns to have spaces in them.
Abbreviate column names.
Replace values that have integers with human readable results.
Term 2 of 24
Do you need to import custom visuals each time you want to use them when you're
developing a new report, not an existing report?
No, custom visuals are always available for selection under the Visualization pane.
Yes, custom visuals must be imported from AppSource each time you start developing a
new report.
No, custom visuals only need to be imported once and will always remain in Power BI for
future use in a new report.
Term 3 of 24
What can you do to improve performance when you're getting data in Power BI?
Remove unnecessary columns and rows
Export database files to CSV to load
Combine date and time columns into a single column
Term 4 of 24
What is a risk of having null values in a numeric column?
That function SUM of data will be incorrect.
That function MAX of data will be incorrect.
That function AVERAGE of data will be incorrect.
,Term 5 of 24
What is cardinality?
Cardinality is the measure of unique values in a table.
Cardinality is the granularity of the data.
Cardinality is how long it takes for the data to load.
Cardinality is a type of visual element.
Term 6 of 24
Which one of the following options is the most important key benefit of data analysis?
Decisive analytics
Informed business decisions
Complex reports
Term 7 of 24
What is the difference between a fact table and a dimension table?
Fact tables contain observational data while dimension tables contain information about
specific entities within the data.
Fact tables contain information about specific entities while dimension tables contain
information about observational data.
There is no difference.
Dimension tables tell you about specific roles in Power BI while fact tables tell you
information about facts that are associated with those roles in Power BI.
Term 8 of 24
Which two functions will help you compare dates to the previous month?
CALCULATE and PREVIOUSMONTH
TOTALYTD and PREVIOUS MONTH
CALCULATE and TOTALTYD
, Term 9 of 24
Which data role enables advanced analytics capabilities specifically through reports and
visualizations?
Data scientist
Data engineer
Data analyst
Term 10 of 24
You're creating a Power BI report with data from an Azure Analysis Services MDX Cube. When
the data refreshes in the cube, you would like to see it immediately in the Power BI report. How
should you connect?
Import
T-SQL
Live connection
Term 11 of 24
What can be achieved by removing unnecessary rows and columns?
It is not necessary to delete unnecessary rows and columns and it is a good practice to
keep all metadata intact.
Deleting unnecessary rows and columns will reduce a dataset size and its good practice
to load only necessary data into your data model.
Deleting unnecessary rows and columns can damage the structure of the data model.
Term 12 of 24
When connecting to a SQL Server database to get data, what language should you use to
extract data?
DAX
T-SQL
MDX
