Power BI Training

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

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

• SQL

• DAX

• M Language

• Python

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

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.

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

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

• Pie Chart

• Line Chart

• Bar Chart

• Scatter Plot

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

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

• To reduce the file size of the dataset

• To enable accurate data analysis and visualization across multiple tables

• To automatically clean data

• To generate DAX measures

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

• To clean data

• To visualize data

• To create relationships between tables

• To write DAX measures

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?

• Drill-through

• Power Query

• Row-Level Security (RLS)

• Measure formatting