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
