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

D.Do some calculations in the original data source

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

11 Which of the following option improves performance by generating a single query statement to retrieve and transform source data?

C.Adding custom columns with complex logic

15 What can be achieved by removing unnecessary rows and columns?

C.Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.

A.It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.

B.Deleting unnecessary rows and columns can damage the structure of the data model.

17 Which of the following is the correct definition of data profiling ?

B.Studying the nuances of the data

A.Aggregating columns containing numeric data

18 Which of the following is the risk of including null values in a numeric column?

C.DAX expressions with AVERAGE data will be incorrect

A.AX expressions with MAX data will be incorrect

B.DAX expressions with SUM data will be incorrect

D.DAX expressions with MIM data will be incorrect

19 Which of the following is not a best practice for naming conventions in Power BI?

ARename columns with spaces in them

B.Replace values that have integers with human-readable results

24 What are the two types of tables in a star schema known?

BQualitative and quantitative data tables

25 What is the difference between a fact table and a dimension table?

A.Fact tables store observations or events while dimension tables contain information about specific entities within the data.

B.Fact tables contain information about specific entities while dimension tables contain information about observational data.

C.Dimension tables explain about specific roles in Power BI while fact tables explain the information about facts that are associated with those roles in Power BI.

26 What is Cardinality?

C.The direction that the data flows in a relationship between two tables is Cardinality.

A.Cardinality is how long it takes for the data to load.

B.Cardinality is the granularity of the data.

D.Cardinality is a type of visual element.

29 You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of these functions. What should you recommend?

A.Merge tables by using Power Query

B.Hide unused columns in the model

C.Split the model into multiple models

37 What benefit do you get from analyzing metadata?

A.The benefit of analyzing metadata is that you can clearly identify data inconsistencies with your dataset.

B.The benefit of analyzing the metadata is to get familiar with your data.

C.The benefit of analyzing the metadata is to know the number of rows, columns, and tables being loaded into your model.

D.The benefit of analyzing the metadata is to easily upload data.

42 A critical aspect of data aggregation is that it allows you to focus on

A.The important and most meaningful data

B.Disabling interactive analysis over big data

C.Larger cache size and decreased query performance

44 What is a dashboard?

C.A canvas of report elements that can be built in the Power BI service

A.A canvas of report elements that can be built in Power BI Desktop

B.Dashboards can be built by using visuals that are developed with an underlying data source

D.The canvas in which you can view the data model of a report

45 Why are parameters important in Power BI paginated reports?

C.They allow the user to control aspects of how the report is rendered when the report is run.

A.They are required so that Power BI can call the paginated report.

B.They allow the report developer to control the refresh interval of the report.

46 What is the best description of a workspace?

D.A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, etc."

"A.A workspace is a feature in the Power BI service that allows you to view reports only.

B.A workspace is a feature that allows you to view and edit the data model, build visualizations, and transform the data.

C.A workspace is a feature of Power BI Desktop that allows you to build only.

49 You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

B.Set Data Connectivity mode to DirectQuery

C.Set the Command timeout in minutes setting

D.Set Data Connectivity mode to Import"

50 You build a report to help the sales team of techtrics to understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

D.Line and clustered column chart

Power BI Quiz

Quiz

•

Computers

•

University

•

Practice Problem

•

Hard

Jhalak Dashora

Used 18+ times

FREE Resource

C.MDX

D.DML

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

XIRPL2_PASQUIZZ

Quiz

•

1st Grade - Professio...

50 questions

IP Address

Quiz

•

University

50 questions

Grade 10 Computer Systems Quiz

Quiz

•

10th Grade - University

45 questions

UAS BSD 1

Quiz

•

University

50 questions

Bisnis Online

Quiz

•

University

50 questions

Application Software Quiz

Quiz

•

12th Grade - University

45 questions

อจ.ฉี

Quiz

•

University

50 questions

VOIP XII

Quiz

•

1st Grade - University

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Computers

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

7 questions

Different Types of Energy

Interactive video

•

4th Grade - University

20 questions

Slopes and Slope-Intercept Form

Quiz

•

8th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

7 questions

Biomolecules (Updated)

Interactive video

•

11th Grade - University

20 questions

Winter/Holiday Trivia

Quiz

•

KG - University

10 questions

WINTER WIN Time - ELA - 12/9/2025

Quiz

•

KG - University

7 questions

Human Impact on Resources

Interactive video

•

4th Grade - University

Power BI Quiz

50 questions

1 Who enables advanced analytics capabilities through reports and visualizations?

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

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

4 Select the building blocks of Power BI.

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

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

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

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?

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

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

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers