What is the purpose of creating relationships between tables in Power BI?

To enable accurate data analysis and visualization across multiple tables

To reduce the file size of the dataset

In Power BI, what is the primary role of the "Model" view?

To create relationships between tables

You want to calculate the account age for each customer using the Account Opening Date. What should you use?

Group By feature in Power Query Editor

Two tables (Customers and Transactions) both contain a Region column, but not a unique list. How should you handle this in the model?

Create a Region lookup table and relate both tables to it

Directly relate both tables on Region

Remove duplicates from both tables

You notice that slicers are not affecting your card visual even though they use the same fields. What could be the issue?

Visual interactions are disabled

You have a visual that breaks when you remove a column from your model. What is the likely issue?

The column was used in a calculated measure

The report needs to be published again

The table was not formatted properly

Which of the following is a limitation of Power Query in Excel compared to Power BI?

Limited data model size and visualization capabilities

Which of the following enhances automation in Power BI reporting?

Standardized data forms and file names

You’ve imported Excel files from a folder in Power Query. One of the files has an extra header row. What should you do to avoid errors?

Use conditional logic to remove unexpected rows

What happens if you remove a column used in a later transformation step in Power Query?

The query breaks and gives an error

In Power Query, what happens when you change column names manually but later refresh the source file and it has different headers?

Refresh fails due to a missing column error

Power BI automatically maps new columns

It merges the new and old columns

What is the most efficient way to reduce Power BI file size if you have a large table with unnecessary columns?

Remove them in Power Query before loading

You are working on a project where you need to analyze data from multiple Excel files and perform data transformations using Power Query. However, you face the issue of not being able to open the Excel file directly while using Power Query in Excel. In contrast, when working in Power BI, you are able to perform the transformations without this restriction. Which of the following is the reason why you cannot open an Excel file directly while using Power Query in Excel, but you can do so in Power BI?

Power Query in Excel requires the source Excel file to be closed before it can access and transform the data.

Power Query in Power BI loads the entire data model into memory, allowing it to work with open files.

Excel locks the file when using Power Query, preventing further access to it while it's open.

Power BI integrates seamlessly with the Power Query engine, allowing it to access open Excel files.

What is the primary benefit of dynamic data retrieval in Power BI?

To enable real-time or near real-time data analysis by fetching the latest data from the source.

To provide historical data snapshots for reporting purposes.

To store and import large volumes of static data for long-term analysis.

T o reduce the need for data modeling and transformation in Power BI.

As a data analyst for a large retail chain, you have created a scatter chart in Microsoft Power BI to compare store size ( X-axis ) against annual sales ( Y-axis ) for various stores. You have also used a categorical variable Region for the color legend. While presenting the chart in a meeting, your manager asks you why some stores of the same size have different colors. How would you respond?

The colors represent different regions.

The colors represent different annual sales.

The colors are assigned randomly.

Which of the following DAX formulas correctly calculates the average balance on 31-Dec-2024 for accounts with status "Regular"?

CALCULATE(AVERAGE(Accounts[Balance 31-Dec-2024]),Accounts[Account Status] = "Regular")

AVERAGE(Accounts[Balance 31-Dec-2024], Accounts[Account Status] = "Regular")

CALCULATE(SUM(Accounts[Balance 31-Dec-2024]),FILTER(Accounts, Accounts[Account Status] = "Regular"))

CALCULATE(AVERAGE(Accounts[Balance 31-Dec-2024]), FILTER ("Regular", Accounts[ Account Status]))

What is the main difference between SUM() and SUMX()?

SUM() adds values from a column, SUMX() iterates row by row over a table

SUM() works only on text columns

SUMX() is faster than SUM() in all cases

You receive a new Excel file every month from the auditee with a different sheet name but the same structure. What is the best practice to handle this in Power BI?

Folder query to dynamically connect to the latest file

Replace the file manually in the query source step each time

Ask the auditee to keep the same file name

Keep creating a new report for each file

What does a Matrix visual provide that a Table visual does not?

Data grouping with row and column hierarchies

What happens if two tables in Power BI have no defined relationship?

Measures using fields from both tables may return incorrect or blank results

Visuals will combine their data automatically

Power BI will create hidden links

The tables will be merged automatically

What happens when you use COUNTROWS() on a filter table in DAX?

It returns the number of rows that meet the filter criteria

It counts only visible rows in the visual

It always returns the total number of rows in the table

Power BI Training

Authored by Audit Risk Review

Computers

Professional Development

Used 1+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

35 questions

Show all answers

MULTIPLE SELECT QUESTION

30 sec • 1 pt

Which of the following are key features of Power BI Desktop? (Select all that apply)

Data transformation using Power Query

Publish reports to Power BI Service

Data connection to multiple sources

Limited to viewing only existing reports

Creating and editing dashboards

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which language is primarily used for creating measures and calculated columns in Power BI?

SQL

DAX

M Language

Python

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does cardinality refer to in Power BI relationships?

The number of rows in a table

The type of relationship between tables

The direction of data flow between tables

The uniqueness of values in a column

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the key difference between a measure and a calculated column in Power BI?

Measures are row-by-row, calculated columns are aggregated.

Measures are calculated at runtime, calculated columns are stored.

Calculated columns are used in visuals, measures are not.

Measures require DAX, calculated columns do not.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of relationship occurs when both tables have unique values in the related columns?

One-to-Many

Many-to-Many

One-to-One

None

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which visualization type is best suited for showing trends over time?

Pie Chart

Line Chart

Bar Chart

Scatter Plot

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the "Drill Through" feature in Power BI allow users to do?

Filter data across all visuals

Navigate to a detailed report page based on a specific data point

Export data to Excel

Create a new calculated column

Access all questions and much more by creating a free account

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

30 questions

Đề tham khảo Tin học - 1

Quiz

•

Professional Development

30 questions

City and Guilds Award in Mobile and Operating System

Quiz

•

12th Grade - Professi...

35 questions

Computer Parts and Accessories

Quiz

•

7th Grade - Professio...

30 questions

1-30 Quiz

Quiz

•

Professional Development

30 questions

Part II- Practice Study Guide (ITF+)

Quiz

•

Professional Development

30 questions

C BASICS

Quiz

•

Professional Development

30 questions

GAMES TIK KHUSUS UNTUK JAGOAN

Quiz

•

Professional Development

30 questions

Analisis Data SD Kelas 3

Quiz

•

Professional Development

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

15 questions

LOTE_SPN2 5WEEK3 Day 2 Itinerary

Quiz

•

Professional Development

20 questions

Black History Month Trivia Game #1

Quiz

•

Professional Development

20 questions

90s Cartoons

Quiz

•

Professional Development

42 questions

LOTE_SPN2 5WEEK2 Day 4 We They Actividad 3

Quiz

•

Professional Development

6 questions

Copy of G5_U6_L3_22-23

Lesson

•

KG - Professional Dev...

20 questions

Employability Skills

Quiz

•

Professional Development

Power BI Training

Which of the following are key features of Power BI Desktop? (Select all that apply)

Which language is primarily used for creating measures and calculated columns in Power BI?

What does cardinality refer to in Power BI relationships?

What is the key difference between a measure and a calculated column in Power BI?

Which type of relationship occurs when both tables have unique values in the related columns?

Which visualization type is best suited for showing trends over time?

What does the "Drill Through" feature in Power BI allow users to do?

What is the purpose of creating relationships between tables in Power BI?

In Power BI, what is the primary role of the "Model" view?

You are sharing audit dashboards with the Executive Committee, but not all members should see details for every department. Which Power BI feature ensures data confidentiality?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers