PowerBI Check Your Knowledge
Studying Exam Questions & Answers
(Grade A+)
which data role enables advanced analytic capabilities specifically
through reports and visualizations? -
correct answer ✅data analyst
which data analyst task has a critical performance impact on
reporting and data analysis? -
correct answer ✅model - an optimized and tuned semantic model
performs better and provides a better data analysis experience.
which one of the following options is the most important key
benefit of data analysis? -
correct answer ✅informed business decisions
what is the common flow of activity in Power BI? -
correct answer ✅bring data into Power BI Desktop and create a
report, share it to the Power BI service, view and interact with
reports and dashboards in the service and Power BI mobile
which of the following are building blocks of Power BI? -
correct answer ✅visualizations, semantic models, reports,
dashboards, tiles
,PowerBI Check Your Knowledge
Studying Exam Questions & Answers
(Grade A+)
what is a collection of reports and dashboards called in Power BI? -
correct answer ✅an app
when connecting to a SQL Server database to get data, what
language should you use to extract data? -
correct answer ✅T-SQL - T-SQL is the query language that you
would use for SQL Server.
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? -
correct answer ✅live connection - this will reflect cube changes
immediately
what can you do to improve performance when you're getting data
in Power BI? -
correct answer ✅remove unnecessary columns and rows
, PowerBI Check Your Knowledge
Studying Exam Questions & Answers
(Grade A+)
what is the risk of having null values in a numeric column? -
correct answer ✅the function AVERAGE of data will be incorrect -
AVERAGE takes the total and divides by the number of non-null
values. If NULL is synonymous with zero in the data, the average
will be different from the accurate average.
if you have two queries that have different data but the same
column headers, and you want to combine both tables into one
query with all the combined rows, which operation should you
perform? -
correct answer ✅Append - will take 2 tables and combine it into
one query. The combined query will have more rows while keeping
the same number of columns
which of the following selections aren't best practices for naming
conventions in Power BI? -
correct answer ✅abbreviate column names -causes confusion
in a Power BI Desktop model design, which type of object do you
create to connect multiple tables? -
correct answer ✅relationshop
Studying Exam Questions & Answers
(Grade A+)
which data role enables advanced analytic capabilities specifically
through reports and visualizations? -
correct answer ✅data analyst
which data analyst task has a critical performance impact on
reporting and data analysis? -
correct answer ✅model - an optimized and tuned semantic model
performs better and provides a better data analysis experience.
which one of the following options is the most important key
benefit of data analysis? -
correct answer ✅informed business decisions
what is the common flow of activity in Power BI? -
correct answer ✅bring data into Power BI Desktop and create a
report, share it to the Power BI service, view and interact with
reports and dashboards in the service and Power BI mobile
which of the following are building blocks of Power BI? -
correct answer ✅visualizations, semantic models, reports,
dashboards, tiles
,PowerBI Check Your Knowledge
Studying Exam Questions & Answers
(Grade A+)
what is a collection of reports and dashboards called in Power BI? -
correct answer ✅an app
when connecting to a SQL Server database to get data, what
language should you use to extract data? -
correct answer ✅T-SQL - T-SQL is the query language that you
would use for SQL Server.
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? -
correct answer ✅live connection - this will reflect cube changes
immediately
what can you do to improve performance when you're getting data
in Power BI? -
correct answer ✅remove unnecessary columns and rows
, PowerBI Check Your Knowledge
Studying Exam Questions & Answers
(Grade A+)
what is the risk of having null values in a numeric column? -
correct answer ✅the function AVERAGE of data will be incorrect -
AVERAGE takes the total and divides by the number of non-null
values. If NULL is synonymous with zero in the data, the average
will be different from the accurate average.
if you have two queries that have different data but the same
column headers, and you want to combine both tables into one
query with all the combined rows, which operation should you
perform? -
correct answer ✅Append - will take 2 tables and combine it into
one query. The combined query will have more rows while keeping
the same number of columns
which of the following selections aren't best practices for naming
conventions in Power BI? -
correct answer ✅abbreviate column names -causes confusion
in a Power BI Desktop model design, which type of object do you
create to connect multiple tables? -
correct answer ✅relationshop
