Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 32
How many tables were displayed in the Model View once the dataset was loaded?
A
A data structure that included multiple related tables.
B
A single table with one-to-many relationships.
C
A single table with multiple columns that included different data.Correct Answer
QUESTION 2 OF 32
How many rows were present in the dataset after all duplicate rows were removed from the OrderID column in the Adventure Works dataset?
A
37
B
48Correct Answer
C
96
QUESTION 3 OF 32
What was the data type of the Product Price column after you loaded the data to Power BI before applying a transformation to the dataset?
A
Date
B
Whole NumberCorrect Answer
C
Decimal Number
D
Text
QUESTION 4 OF 32
Adventure Works have tasked you with creating a data model to analyze sales data and improve the store’s performance. What should your first step in the data modeling process be?
A
Prepare and transform your data.
B
Configure column and table properties.
C
Connect to your data sources.Correct Answer
QUESTION 5 OF 32
Which of the following are benefits of a schema? Select all that apply.
A
A schema helps to enable efficient data analysis.Correct Answer
B
A schema helps with generating meaningful insights into your data.Correct Answer
C
A schema helps with the creation of visualizations.Correct Answer
D
A schema helps to define the structure of your data.Correct Answer
QUESTION 6 OF 32
Which of the following steps are essential to ensure a well-structured and accurate flat table schema? Select all that apply.
A
Validating the schema.Correct Answer
B
Connecting to data sources.Correct Answer
C
Merging all tables into a single table.
D
Configuring column properties.Correct Answer
QUESTION 7 OF 32
In Power BI, relationships are established between the tables based on _____________ that match between the tables.
A
Rows
B
Column fieldsCorrect Answer
C
Table properties
QUESTION 8 OF 32
What is the primary characteristic differentiating a Snowflake schema from a Star schema?
A
A hierarchical structure.
B
A central Fact table.
C
Denormalized dimension tables.
D
Normalized dimension tables.Correct Answer
QUESTION 9 OF 32
What are the limitations of using a Flat schema in Power BI? Select all that apply.
A
A Flat schema cannot be used to perform aggregations.
B
A Flat schema offers a lack of flexibility for organizing data from multiple sources.Correct Answer
C
A Flat schema offers limited capacity for storing large volumes of data.Correct Answer
QUESTION 10 OF 32
True or False: In Power BI, a schema is automatically created when you import data from various sources and establish relationships between tables.
A
TrueCorrect Answer
B
False
QUESTION 11 OF 32
Which property cannot be adjusted for a table or column in Power BI?
A
Sort order
B
Table relationship Correct Answer
C
Data type
QUESTION 12 OF 32
In the context of Power BI, which of the following descriptions best outlines the main purpose of a Fact table?
A
A Fact table is primarily used for storing descriptive attributes of business dimensions.
B
A Fact table is primarily used for storing detailed, transactional business data.
C
A Fact table is primarily used for storing measured, quantitative data about a business process.Correct Answer
QUESTION 13 OF 32
Which of the following statements are true regarding cardinality and cross-filter direction in Power BI?
A
Cardinality defines the number of unique values in one column compared to another.
B
Cardinality and cross-filter direction are two key elements of model relationships in Power BI.Correct Answer
C
Setting a cross-filter direction to Both allows filters to be applied from either direction in a relationship.Correct Answer
QUESTION 14 OF 32
True or False: In Power BI, you can create a many-to-many relationship between tables.
A
TrueCorrect Answer
B
False
QUESTION 15 OF 32
In data analysis, __________ refers to the level of detail or summarization of your data.
A
Data cardinality
B
Data granularityCorrect Answer
C
Cross-filter direction
QUESTION 16 OF 32
What is the role of dimension tables in Power BI?
A
They store the descriptive attributes of a business process.Correct Answer
B
They store transactional data related to a business process.
C
They store measured, quantitative data about a business process.
QUESTION 17 OF 32
Adventure Works is building a star schema in Power BI. Which of the following tables in the schema can be used to store measurable business data like order and product IDs, quantities, and total cost?
A
A Customer table that holds data on customers.
B
A Product table that contains information on products.
C
A Sales table that contains data on sales transactions.Correct Answer
QUESTION 18 OF 32
You are working on two tables where each record in a column of Table A corresponds to multiple records in a column of Table B, but not vice versa. What kind of relationship, or cardinality, is this an example of?
A
A many-to-many relationship.
B
A one-to-many relationship.Correct Answer
C
A one-to-one relationship.
QUESTION 19 OF 32
Cross-filter direction refers to the direction in which filtering occurs between two tables in a data model.
A
TrueCorrect Answer
B
False
QUESTION 20 OF 32
Which of the following scenarios represents a high level of data granularity for Adventure Works?
A
Monitoring sales revenue by product category monthly.
B
Analyzing hourly sales data for individual products.Correct Answer
C
Tracking overall sales revenue on an annual basis.
QUESTION 21 OF 32
True or False: The Sales table was identified as a dimension table in the exercise.
A
True
B
FalseCorrect Answer
QUESTION 22 OF 32
Which relationship type was configured between the Fact table and dimension tables in the exercise?
A
Many-to-many
B
One-to-one
C
Many-to-oneCorrect Answer
QUESTION 23 OF 32
True or False: The default cross-filter direction is set to Single, meaning that filters applied to the Products table will also apply to the Sales table, but not vice versa.
A
TrueCorrect Answer
B
False
QUESTION 24 OF 32
True or False: The autodetect function must be disabled before loading multiple tables. This is to prevent Power BI from automatically creating relationships between tables.
A
TrueCorrect Answer
B
False
QUESTION 25 OF 32
Which of the following statements is correct regarding a Star schema Fact table?
A
A Fact table stores an accumulation of business events.Correct Answer
B
A Fact table must have a unique column
C
A Fact table stores an accumulation of business entities.
QUESTION 26 OF 32
How are dimension tables structured in a Snowflake schema?
A
They are fully denormalized, with all attributes in a single table.
B
They are connected in a hierarchical structure with multiple levels.
C
They are normalized with a separate table for each attribute.Correct Answer
QUESTION 27 OF 32
What is the primary benefit of normalizing dimension tables in Power BI?
A
It simplifies data querying and reporting.
B
It reduces storage requirements.Correct Answer
C
It improves data quality and accuracy.
QUESTION 28 OF 32
Which of the following statements is true about relationships in Power BI?
A
Relationships can only be created between columns that contain the same data type.
B
Relationships can only be created between tables with the same number of rows.
C
Relationships can be created between tables that contain different types of data.Correct Answer
QUESTION 29 OF 32
True or False: A Star schema is more suitable for complex hierarchies and relationships.
A
True
B
False Correct Answer
QUESTION 30 OF 32
What is the primary advantage of using a Snowflake schema in Power BI over a Star schema?
A
The Snowflake schema reduces query complexity.
B
The Snowflake schema is more suitable for complex data structures.Correct Answer
C
The Snowflake schema requires less storage space.
QUESTION 31 OF 32
True or False: A star schema uses a normalized approach.
A
True
B
FalseCorrect Answer
QUESTION 32 OF 32
True or False: All issues within a data model must be identified before the challenges can be resolved.
A
TrueCorrect Answer
B
False
Ready to test your recall?
How many tables were displayed in the Model View once the dataset was loaded?
A
A data structure that included multiple related tables.
B
A single table with one-to-many relationships.
C
A single table with multiple columns that included different data.