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 data structure that included multiple related tables.

A single table with one-to-many relationships.

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?

48Correct Answer

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?

Date

Whole NumberCorrect Answer

Decimal Number

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?    

Prepare and transform your data.

Configure column and table properties.

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 schema helps to enable efficient data analysis.Correct Answer

A schema helps with generating meaningful insights into your data.Correct Answer

A schema helps with the creation of visualizations.Correct Answer

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.

Validating the schema.Correct Answer

Connecting to data sources.Correct Answer

Merging all tables into a single table.

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.

Rows

Column fieldsCorrect Answer

Table properties

QUESTION 8 OF 32

What is the primary characteristic differentiating a Snowflake schema from a Star schema?

A hierarchical structure.

A central Fact table.

Denormalized dimension tables.

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 Flat schema cannot be used to perform aggregations.

A Flat schema offers a lack of flexibility for organizing data from multiple sources.Correct Answer

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.

TrueCorrect Answer

False

QUESTION 11 OF 32

Which property cannot be adjusted for a table or column in Power BI?

Sort order

Table relationship  Correct Answer

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 Fact table is primarily used for storing descriptive attributes of business dimensions.

A Fact table is primarily used for storing detailed, transactional business data.

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?

Cardinality defines the number of unique values in one column compared to another.

Cardinality and cross-filter direction are two key elements of model relationships in Power BI.Correct Answer

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.

TrueCorrect Answer

False

QUESTION 15 OF 32

In data analysis, __________ refers to the level of detail or summarization of your data.

Data cardinality

Data granularityCorrect Answer

Cross-filter direction

QUESTION 16 OF 32

What is the role of dimension tables in Power BI?

They store the descriptive attributes of a business process.Correct Answer

They store transactional data related to a business process.

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 Customer table that holds data on customers.

A Product table that contains information on products.

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 many-to-many relationship.

A one-to-many relationship.Correct Answer

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.

TrueCorrect Answer

False

QUESTION 20 OF 32

Which of the following scenarios represents a high level of data granularity for Adventure Works?

Monitoring sales revenue by product category monthly.

Analyzing hourly sales data for individual products.Correct Answer

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.

True

FalseCorrect Answer

QUESTION 22 OF 32

Which relationship type was configured between the Fact table and dimension tables in the exercise? 

Many-to-many

One-to-one

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.

TrueCorrect Answer

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.

TrueCorrect Answer

False

QUESTION 25 OF 32

Which of the following statements is correct regarding a Star schema Fact table?

A Fact table stores an accumulation of business events.Correct Answer

A Fact table must have a unique column

A Fact table stores an accumulation of business entities.

QUESTION 26 OF 32

How are dimension tables structured in a Snowflake schema?

They are fully denormalized, with all attributes in a single table.

They are connected in a hierarchical structure with multiple levels.

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?

It simplifies data querying and reporting.

It reduces storage requirements.Correct Answer

It improves data quality and accuracy.

QUESTION 28 OF 32

Which of the following statements is true about relationships in Power BI?

Relationships can only be created between columns that contain the same data type.

Relationships can only be created between tables with the same number of rows.

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.

True

False  Correct Answer

QUESTION 30 OF 32

What is the primary advantage of using a Snowflake schema in Power BI over a Star schema?

The Snowflake schema reduces query complexity.

The Snowflake schema is more suitable for complex data structures.Correct Answer

The Snowflake schema requires less storage space.

QUESTION 31 OF 32

True or False: A star schema uses a normalized approach.

True

FalseCorrect Answer

QUESTION 32 OF 32

True or False: All issues within a data model must be identified before the challenges can be resolved.

TrueCorrect Answer

False

Ready to test your recall?

How many tables were displayed in the Model View once the dataset was loaded?

A data structure that included multiple related tables.

A single table with one-to-many relationships.

A single table with multiple columns that included different data.

How confident are you in this answer?

Practice Quiz

How many tables were displayed in the Model View once the dataset was loaded?

How many rows were present in the dataset after all duplicate rows were removed from the OrderID column in the Adventure Works dataset?

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?

Adventure Works have tasked you with creating a data model to analyze sales data and improve the store&#8217;s performance. What should your first step in the data modeling process be? &nbsp; &nbsp;

Which of the following are benefits of a schema? Select all that apply.

Which of the following steps are essential to ensure a well-structured and accurate flat table schema? Select all that apply.

In Power BI, relationships are established between the tables based on _____________ that match between the tables.

What is the primary characteristic differentiating a Snowflake schema from a Star schema?

What are the limitations of using a Flat schema in Power BI? Select all that apply.

True or False: In Power BI, a schema is automatically created when you import data from various sources and establish relationships between tables.

Which property cannot be adjusted for a table or column in Power BI?

In the context of Power BI, which of the following descriptions best outlines the main purpose of a Fact table?

Which of the following statements are true regarding cardinality and cross-filter direction in Power BI?

True or False: In Power BI, you can create a many-to-many relationship between tables.

In data analysis, __________ refers to the level of detail or summarization of your data.

What is the role of dimension tables in Power BI?

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?

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?

Cross-filter direction refers to the direction in which filtering occurs between two tables in a data model.

Which of the following scenarios represents a high level of data granularity for Adventure Works?

True or False: The Sales table was identified as a dimension table in the exercise.

Which relationship type was configured between the Fact table and dimension tables in the exercise?&nbsp;

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.

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.

Which of the following statements is correct regarding a Star schema Fact table?

How are dimension tables structured in a Snowflake schema?

What is the primary benefit of normalizing dimension tables in Power BI?

Which of the following statements is true about relationships in Power BI?

True or False: A Star schema is more suitable for complex hierarchies and relationships.

What is the primary advantage of using a Snowflake schema in Power BI over a Star schema?

True or False: A star schema uses a normalized approach.

True or False: All issues within a data model must be identified before the challenges can be resolved.

Ready to test your recall?

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?

Which relationship type was configured between the Fact table and dimension tables in the exercise?