Which data role enables advanced analytics capabilities specifically through reports and vis-
ualizations?
-Data scientist
-Data engineer
-Data analyst - ANSWER Data analyst
-A data analyst uses appropriate visuals to help business decision makers gain deep and
meaningful insights from data.
Which one of the following options is the most important key benefit of data analysis?
-Decisive analytics
-Informed business decisions
-Complex reports - ANSWER Informed business decisions
-A key benefit of data analysis is the ability to gain valuable insights from a business's data
assets to make timely and optimal business decisions.
Which data analyst task has a critical performance impact on reporting and data analysis?
-Model
-Analyze
-Visualize - ANSWER Model
1
,-An optimized and tuned data model performs better and provides a better data analysis ex-
perience.
What is the common flow of activity in Power BI?
-Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in
the Power BI service.
-Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power
BI Desktop.
-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.
-Bring data into Power BI mobile, create a report, then share it to Power BI Desktop. - AN-
SWER Bring data into Power BI Desktop and create a report, share it to the Power BI ser-
vice, view and interact with reports and dashboards in the service and Power BI mobile.
-The Power BI service lets you view and interact with reports and dashboards, but doesn't
let you shape data.
Which of the following are building blocks of Power BI?
-Tiles, dashboards, databases, mobile devices.
-Visualizations, datasets, reports, dashboards, tiles.
-Visual Studio, C#, and JSON files. - ANSWER Visualizations, datasets, reports, dash-
boards, tiles.
2
, -Building blocks for Power BI are visualizations, datasets, reports, dashboards, tiles.
A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in
Power BI?
-The canvas.
-Scheduled refresh.
-An app. - ANSWER An app.
-An app is a collection of ready-made visuals, pre-arranged in dashboards and reports. You
can get apps that connect to many online services from the AppSource.
When connecting to a SQL Server database to get data, what language should you use to ex-
tract data?
-DAX
-T-SQL
-MDX - ANSWER T-SQL
-T-SQL is the query language that you would use for SQL Server.
What can you do to improve performance when you're getting data in Power BI?
-Remove unnecessary columns and rows
3
ualizations?
-Data scientist
-Data engineer
-Data analyst - ANSWER Data analyst
-A data analyst uses appropriate visuals to help business decision makers gain deep and
meaningful insights from data.
Which one of the following options is the most important key benefit of data analysis?
-Decisive analytics
-Informed business decisions
-Complex reports - ANSWER Informed business decisions
-A key benefit of data analysis is the ability to gain valuable insights from a business's data
assets to make timely and optimal business decisions.
Which data analyst task has a critical performance impact on reporting and data analysis?
-Model
-Analyze
-Visualize - ANSWER Model
1
,-An optimized and tuned data model performs better and provides a better data analysis ex-
perience.
What is the common flow of activity in Power BI?
-Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in
the Power BI service.
-Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power
BI Desktop.
-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.
-Bring data into Power BI mobile, create a report, then share it to Power BI Desktop. - AN-
SWER Bring data into Power BI Desktop and create a report, share it to the Power BI ser-
vice, view and interact with reports and dashboards in the service and Power BI mobile.
-The Power BI service lets you view and interact with reports and dashboards, but doesn't
let you shape data.
Which of the following are building blocks of Power BI?
-Tiles, dashboards, databases, mobile devices.
-Visualizations, datasets, reports, dashboards, tiles.
-Visual Studio, C#, and JSON files. - ANSWER Visualizations, datasets, reports, dash-
boards, tiles.
2
, -Building blocks for Power BI are visualizations, datasets, reports, dashboards, tiles.
A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in
Power BI?
-The canvas.
-Scheduled refresh.
-An app. - ANSWER An app.
-An app is a collection of ready-made visuals, pre-arranged in dashboards and reports. You
can get apps that connect to many online services from the AppSource.
When connecting to a SQL Server database to get data, what language should you use to ex-
tract data?
-DAX
-T-SQL
-MDX - ANSWER T-SQL
-T-SQL is the query language that you would use for SQL Server.
What can you do to improve performance when you're getting data in Power BI?
-Remove unnecessary columns and rows
3
