the path to insights: data models and pipelines coursera weekly challenge 1 answers

Test your knowledge: Data modeling, schemas, and databases

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 ecosystem
  • Data structure
  • Data storage
  • Data lake

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

  • 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 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.
  • A primary key forms connections because it is a field within a database table that’s a primary key in another table.

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

  • dimensional
  • responsive
  • geometric
  • snowflake

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

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

Test your knowledge: Choose the right database

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

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

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

  • Tables
  • Schemas
  • Permissions
  • Users

7. 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?

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

Test your knowledge: How data moves

8. What is the term for the predetermined locations where pipeline data is sent in order to be acted on?

  • Application interface
  • Installations
  • Target tables
  • Data models

Shuffle Q/A 1

9. 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?

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

10. 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?

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

Leave a Reply