Power BI Exam - Module 3 - Model data
with Power BI Graded A+
Which of the following is a valid way to establish a relationship between two tables in Power
BI?
- A) Connecting them by matching column values
- B) Creating a report and visualizing the relationship
- C) Importing the data into Power Query only
- D) Using Excel formulas to link the tables
✔✔ A) Connecting them by matching column values
What kind of table is typically used to store numerical or transactional data in Power BI?
- A) Dimension Table
- B) Fact Table
- C) Calculated Table
- D) Data Table
✔✔ B) Fact Table
Which of the following DAX functions would you use to calculate the total sales amount?
1
,- A) SUM()
- B) COUNT()
- C) AVERAGE()
- D) CONCATENATE()
✔✔ A) SUM()
What is the difference between "One-to-Many" and "Many-to-Many" relationships in Power BI?
- A) One-to-Many means data is always unique in both tables
- B) Many-to-Many allows records in both tables to have multiple matching records
- C) One-to-Many relationships are not allowed in Power BI
- D) Many-to-Many relationships are always more efficient
✔✔ B) Many-to-Many allows records in both tables to have multiple matching records
How do you apply Row-Level Security (RLS) in Power BI?
- A) By selecting “RLS” under the report settings
- B) By creating user roles and defining filters to restrict access
- C) By manually hiding rows of data in Power Query
- D) By applying password protection on the report
2
, ✔✔ B) By creating user roles and defining filters to restrict access
Which of the following is used to transform data into a more usable format in Power BI?
- A) Power Query Editor
- B) Data Analysis Expressions (DAX)
- C) Data Model view
- D) Report view
✔✔ A) Power Query Editor
What type of relationship is generally used between a "Fact Table" and a "Dimension Table"?
- A) One-to-One
- B) Many-to-Many
- C) One-to-Many
- D) Many-to-One
✔✔ C) One-to-Many
Which DAX function would you use to calculate a new column that derives a value based on
existing columns?
3
with Power BI Graded A+
Which of the following is a valid way to establish a relationship between two tables in Power
BI?
- A) Connecting them by matching column values
- B) Creating a report and visualizing the relationship
- C) Importing the data into Power Query only
- D) Using Excel formulas to link the tables
✔✔ A) Connecting them by matching column values
What kind of table is typically used to store numerical or transactional data in Power BI?
- A) Dimension Table
- B) Fact Table
- C) Calculated Table
- D) Data Table
✔✔ B) Fact Table
Which of the following DAX functions would you use to calculate the total sales amount?
1
,- A) SUM()
- B) COUNT()
- C) AVERAGE()
- D) CONCATENATE()
✔✔ A) SUM()
What is the difference between "One-to-Many" and "Many-to-Many" relationships in Power BI?
- A) One-to-Many means data is always unique in both tables
- B) Many-to-Many allows records in both tables to have multiple matching records
- C) One-to-Many relationships are not allowed in Power BI
- D) Many-to-Many relationships are always more efficient
✔✔ B) Many-to-Many allows records in both tables to have multiple matching records
How do you apply Row-Level Security (RLS) in Power BI?
- A) By selecting “RLS” under the report settings
- B) By creating user roles and defining filters to restrict access
- C) By manually hiding rows of data in Power Query
- D) By applying password protection on the report
2
, ✔✔ B) By creating user roles and defining filters to restrict access
Which of the following is used to transform data into a more usable format in Power BI?
- A) Power Query Editor
- B) Data Analysis Expressions (DAX)
- C) Data Model view
- D) Report view
✔✔ A) Power Query Editor
What type of relationship is generally used between a "Fact Table" and a "Dimension Table"?
- A) One-to-One
- B) Many-to-Many
- C) One-to-Many
- D) Many-to-One
✔✔ C) One-to-Many
Which DAX function would you use to calculate a new column that derives a value based on
existing columns?
3
