Coursera Answers

The Path to Insights: Data Models and Pipelines Coursera Quiz Answers

by Niyander

In this article i am gone to share The Path to Insights: Data Models and Pipelines All Weeks Quiz Answers with you. | The Path to Insights: Data Models and Pipelines Coursera Quiz Answers

Enrol Link:  The Path to Insights: Data Models and Pipelines

The Path to Insights: Data Models and Pipelines Coursera Quiz Answers

 

Week 1 Quiz Answers

Test your knowledge: Data modeling, schemas, and databases

Question 1)
A business intelligence professional stores large amounts of raw data in its original format within a database system. Then, they can access the data whenever they need it for their BI project. What type of database are they using?

  • Data structure
  • Data storage
  • Data ecosystem
  • Data lake

Question 2)
Which of the following statements correctly describe primary and foreign keys? Select all that apply.

  • A foreign key references a column or a group of columns in which each row uniquely identifies each record in the table.
  • A primary key forms connections because it is a field within a database table that’s a primary key in another table.
  • A primary key references a column or a group of columns in which each row uniquely identifies each record in the table.
  • A foreign key forms connections because it is a field within a database table that is a primary key in another table.

Question 3)
Fill in the blank: A _____ schema is an extension of a star schema, which contains additional dimensions.

  • snowflake
  • geometric
  • responsive
  • dimensional

Question 4)
What type of database stores relevant data locally for analysis and less relevant data remotely?

  • Distributed databases
  • Combined systems
  • Single-homed databases
  • Separated storage and computing systems

 

Test your knowledge: Choose the right database

Question 1)
When designing a data warehouse, BI professionals take into account which of the following considerations? Select all that apply.

  • The business needs
  • The model that the data warehouse will follow
  • The visualization tools that will be used for the dashboard
  • The shape and volume of the data

Question 2)
Fill in the blank: Logical data modeling involves representing different _____ in a physical data model.

  • Tables
  • Users
  • Permissions
  • Schemas

Question 3)
A BI professional considers the relevant data for a project, the names and data types of table columns, formatting of data entries, and unique keys for database entries and objects. What will these activities enable them to accomplish?

  • Select appropriate elements for their database schema
  • Understand the logic behind their data warehouse design
  • Verify their business rules
  • Differentiate between several types of databases

 

Test your knowledge: How data moves

Question 1)
What is the term for the predetermined locations where pipeline data is sent in order to be acted on?

  • Target tables
  • Data models
  • Application interface
  • Installations

Question 2)
A BI professional uses a pipeline to access source systems, then reads and collects the necessary data from within them. Which ETL stage does this scenario describe?

  • Extract
  • Transform
  • All three stages involve this step
  • Load

Question 3)
Many BI tools are built upon similar principles and often have similar utilities. Therefore, a BI professional’s general understanding of one tool can be applied to others. What is this an example of?

  • Using a preferred vendor
  • System scalability
  • A key performance indicator
  • A transferable skill

 

Visit this link:  The Path to Insights: Data Models and Pipelines Module 1 challenge Quiz Answers

 

 

Week 2 Quiz Answers

Test your knowledge: Database performance

Question 1)
Fill in the blank: A data mart is a _____ database that can be a subset of a larger data warehouse. This means it is a convenient way to access the data pertaining to specific areas or departments of a business.

  • Categorical
  • Specialized
  • Departmental
  • Subject-oriented

Question 2)
A business intelligence team manager wants to support their team’s ability to perform at a high level. They investigate the overall capability of their company’s database hardware and software tools to enable the team to process stakeholder requests. In this situation, which of the factors of database performance do they consider?

  • Workload
  • Throughput
  • Resources
  • Optimization

Question 3)
What term is used to describe data that is broken up into many pieces that are not stored together?

  • Fragmented data
  • Archived data
  • Split data
  • Modified data

 

Visit this link:  The Path to Insights: Data Models and Pipelines Module 2 challenge Quiz Answers

 

 

Week 3 Quiz Answers

Test your knowledge: Optimize pipelines and ETL processes

Question 1)
What is the business intelligence process that involves checking data for defects in order to prevent system failures?

  • Data governance
  • Query planning
  • Business intelligence monitoring
  • Quality testing

Question 2)
Fill in the blank: Completeness is a quality testing step that involves confirming that the data contains all desired ____ or components.

  • Columns
  • Context
  • Fields
  • Measures

Question 3)
A business intelligence professional is considering the integrity of their data throughout its life cycle. Which of the following goals do they aim to achieve? Select all that apply.

  • Data is accurate and complete
  • Data is trustworthy
  • Data is consistent
  • Data is encrypted

 

Test your knowledge: Data schema validation

Question 1)
A team of business intelligence professionals builds schema validation into their workflows. In this situation, what goal do they want to achieve?

  • Ensure the source system data schema matches the target system data schema
  • Consolidate data from multiple source systems
  • Prevent two or more components from using a single resource in a conflicting way
  • Consider the needs of stakeholders in the design of the data schema

Question 2)
Why is it important to ensure primary and foreign keys continue to function after data has been moved from one database system to another?

  • To provide more detail and context about the data
  • To evaluate database performance
  • To read and execute coded instructions
  • To preserve the existing table relationships

Question 3)
Fill in the blank: A _____ describes the process of identifying the origin of data, where it has moved throughout the system, and how it has transformed over time.

  • data lineage
  • data dictionary
  • quality test
  • business rule

 

Test your knowledge: Business rules and performance testing

Question 1)
A business intelligence professional considers what data is collected and stored in a database, how relationships are defined, the type of information the database provides, and the security of the data. What does this scenario describe?

  • Ensuring the formal management of data assets
  • Considering the impact of business rules
  • Confirming that data is consistent
  • Expanding scope in response to stakeholder requirements

Question 2)
At which point in the data-transfer process should incoming data be compared to business rules?

  • No later than 24 hours after being loaded into the database
  • At the same time as it is being loaded into the database
  • Before loading it into the database
  • As soon as it has been loaded into the database

 

Visit this link:  The Path to Insights: Data Models and Pipelines Module 3 challenge Quiz Answers

 

 

 

Week 4 Quiz Answers

Assess your Course 2 end-of-course project

Question 1)
The relevant datasets have been accessed and downloaded.

  • Yes
  • No

Question 2)
The relevant datasets are uploaded to the BigQuery project space.

  • Yes
  • No

Question 3)
The relevant datasets are applied to the project.

  • Yes
  • No

Question 4)
The source tables are merged using SQL code.

  • Yes
  • No

Question 5)
The metrics to be shared in the final dashboard are included.

  • Yes
  • No

Question 6)
The metrics to be included in the final dashboard are in the target table.

  • Yes
  • No

Question 7)
Data is clean to ensure consistency across multiple datasets.

  • Yes
  • No

Question 8)
Data is transformed to ensure consistency across multiple datasets.

  • Yes
  • No

Question 9)
A final reporting table is generated.

  • Yes
  • No

Question 10)
The reporting table includes all required components in order to prepare the dashboard for creation.

  • Yes
  • No