1 Who enables advanced analytics capabilities through reports and visualizations?

• A.Data Visualizer

• B.Data Scientist

• C.Data Engineer

• D.Data Analyst

2 Which data analyst task has a critical performance impact on reporting and data analysis?

• A.Analyze

• B.Visualize

• C.Mining

• D.Model

3 Which of the following is an important step for understanding and interpreting the information that is displayed on the report?

• A.Analytics

• B.Complex Reports

• C.Informed Business Decisions

• D.Complex Dashboards

4 Select the building blocks of Power BI.

• A.Tiles and Dashboards

• B.Visual Studio, C#, and JSON files

• C.Datasets, Visualizations, Reports, Dashboards, and Tiles

• D.Databases and Mobile Devices

5 The common flow of activity in Power BI is described by?

• A.Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards

• B.Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

• C.Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.

• D.Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.

6 Which of the following is a collection of ready-made visuals which is pre-arranged in dashboards and reports?

• A.Canvas

• B.App

• C.Dataset

• D.Scheduled refresh

7 Which of the following is used to query the data from Microsoft SQL Server?

• A.DAX

• B.T-SQL

• C.MDX

• D.DML

8 You are creating a Power BI report with data from an Azure Analysis Services Cube. The data should be available immediately in the Power BI report whenever the data refreshes in the cube. How should you connect?

• A.Connect Live

• B.Import

• C.Direct Query

• D.Indirect Query

9 What should you do to improve performance while getting data in Power BI?

• A.Only pull data into the Power BI service not Power BI Desktop

• B.Use the Select SQL statement in your SQL queries when you are pulling data from a relational database

• C.Combine date and time columns into a single column

• D.Do some calculations in the original data source

10 Which storage mode leaves the data at the data source?

• A.Import

• B.DirectQuery

• C.Dual

• D.None of the Above