All Coursera Quiz Answers

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

by Niyander

In this article i am gone to share Coursera Course: The Path to Insights: Data Models and Pipelines by Google | The Path to Insights: Data Models and Pipelines Module 1 challenge Quiz Answers with you..

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

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

 

Module 1 challenge Quiz Answers

Question 1)
Which of the following statements correctly describe Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) tools? Select all that apply.

  • Online Transaction Processing (OLTP) tools are optimized for data processing instead of analysis.
  • Online Analytical Processing (OLAP) tools are optimized for data processing instead of analysis.
  • Online Analytical Processing (OLAP) tools are optimized for analysis in addition to processing and can analyze data from multiple databases.
  • Online Transaction Processing (OLTP) tools are optimized for analysis in addition to processing and can analyze data from multiple databases.

Question 2)
What does a design pattern enable business intelligence professionals to accomplish? Select all that apply.

  • Create a model that supports business needs
  • Set user permissions
  • Use relevant measures and facts
  • Aggregate data

Question 3)
Fill in the blank: A foreign key is a field within a database table that is a _____ in another table.

  • schema
  • model
  • query
  • primary key

Question 4)
A dimensional model is a type of relational model that has been optimized in order to achieve what goal?

  • Quickly retrieve data from a warehouse
  • Avoid redundant data
  • Anonymize stored data
  • Clean and filter data

Question 5)
Fill in the blank: In a dimensional model, a foreign key is used to connect a _____ table to the appropriate fact table.

  • measurement
  • dimension
  • relationship
  • primary

Question 6)
What are the key benefits of star and snowflake schemas? Select all that apply.

  • High-scale information delivery
  • Efficient data analysis
  • More efficient output
  • Effective data monitoring

Question 7)
A business intelligence team wants to improve the state of their database schemas. While working toward this goal, they move data from one source platform to another target database. What process does this situation describe?

  • Data partitioning
  • Database migration
  • Data throughput
  • Database iteration

Question 8)
What are some key benefits of columnar databases? Select all that apply.

  • Identifying appropriate data to solve a business problem
  • Retrieving information from specific columns
  • Processing analytical queries effectively
  • Sorting data quickly by row

Question 9)
A business intelligence team is working with a database system that is a collection of data systems spread across multiple physical locations. What type of database system are they using?

  • Combined database system
  • Single-homed database system
  • Distributed database system
  • Separated storage and computing system

Question 10)
There are four key elements within database schemas. The first is relevant data. What are the other three? Select all that apply.

  • Elimination of all database permissions
  • Unique keys for every database entry and object
  • Consistent formatting across data entries
  • Names and data types for each column in each table

Question 11)
Which of the following statements accurately describe the loading stage of the ETL process? Select all that apply.

  • Data is delivered to its target destination.
  • Data is returned to its source.
  • Once the data has been delivered, it can exist within multiple locations.
  • Once the data has been delivered, it can exist in multiple formats.

Question 12)
Fill in the blank: Python is a programming language that is _____, which means it’s modeled around chunks of code that capture certain information.

  • code-based
  • object-oriented
  • formulaic
  • information-centered

 

Question 13)
Which type of tool can analyze data from multiple databases and is optimized for both analysis and processing?

  • Online Transaction Processing (OLTP)
  • Online Analytical Processing (OLAP)
  • Data mart
  • Data lake

Question 14)
Fill in the blank: A primary key references a _____ to uniquely identify records in the table.

  • column or group of columns
  • row or group of rows
  • query
  • schema

Question 15)
In a dimensional model, what is used to connect a dimension table to the appropriate fact table?

  • Primary key
  • Foreign key
  • Index
  • Data map

Question 16)
What are the key benefits of star and snowflake schemas? Select all that apply.

  • Efficient data analysis
  • More efficient output
  • Effective data monitoring
  • High-scale information delivery

Question 17)
Members of a business intelligence team are transitioning their current database schemas to a new, desired state. They add columns, remove elements, and make other improvements. What does this situation describe?

  • Data partitioning
  • Data throughput
  • Database iteration
  • Database migration

Question 18)
Which of the following statements accurately describe row-based and columnar databases? Select all that apply.

  • Columnar databases are often used in data warehouses.
  • In row-based databases, each row in the table is an instance or an entry in the database.
  • Row-based databases are organized by rows; columnar databases are organized by columns.
  • In columnar databases, it’s necessary to pull data using all of the rows within the table.

Question 19)
A business intelligence team is working with a database system that stores and analyzes data in the same place. What type of database system are they using?

  • Single-homed database system
  • Separated storage and computing system
  • Distributed database system
  • Combined database system

Question 20)
Fill in the blank: A database schema must use _____ for each entry within the database in order to build connections between tables and enable users to combine relevant data.

  • data partitions
  • business rules
  • system commands
  • unique keys

Question 21)
In which stage of the ETL process is data delivered to a target system?

  • Transformation
  • Extraction
  • Loading
  • All three stages

Question 22)
Object-oriented programming languages _____ data objects with code, enabling them to be used again later.

  • encode and translate
  • label and define
  • compile and group
  • interpret and analyze

Question 23)
In a snowflake schema, what is used to break down the schema into even more specific tables? Select all that apply.

  • Query plans
  • Subdimensions
  • Fact tables
  • Dimensions

Question 24)
A business intelligence team is performing a database migration to improve the state of their database schemas. Which of the following activities may occur during their database migration? Select all that apply.

  • Maintaining data in its original source platform
  • Splitting existing data fields
  • Changing data types
  • Adding new data tables

Question 25)
Fill in the blank: In order to create an effective data model, business intelligence professionals will often apply a _____, which uses relevant measures and facts to create a model that supports business needs.

  • query plan
  • design pattern
  • target table
  • business rule

Question 26)
In a dimensional model, what might facts represent? Select all that apply.

  • Metrics
  • Events
  • Supporting details
  • Attributes

Question 27)
How many fact tables exist in a star schema?

  • Five
  • An infinite number
  • Zero
  • One

Question 28)
In row-based databases, each row in a table is an instance or an entry in the database. How are details about that instance recorded and organized?

  • By field
  • By table
  • By row
  • By column

Question 29)
Fill in the blank: A database schema must describe ___ because this is necessary when users want to understand how the data is shaped and the relationships within the database.

  • business rules
  • data partitions
  • relevant data
  • system commands

Question 30)
Which of the following statements accurately describes Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) tools?

  • Both are optimized for analysis and processing. But Online Transaction Processing (OLTP) source systems can analyze data from multiple databases.
  • Both are optimized for processing. But Online Transaction Processing (OLTP) tools are also optimized for analysis and can analyze data from multiple databases.
  • Both can analyze data from multiple databases. But Online Transaction Processing (OLTP) tools are optimized for analysis.
  • Both are optimized for processing. But Online Analytical Processing (OLAP) tools are also optimized for analysis and can analyze data from multiple databases.

Question 31)
Which of the following statements accurately describe primary keys? Select all that apply.

  • A primary key uniquely identifies each record in a table.
  • Only one primary key can exist in a table.
  • Several primary keys can exist in a table.
  • Primary keys can appear as foreign keys in other tables.

Question 32)
FIll in the blank: In a dimensional model, a foreign key is used to connect a dimension table to the appropriate _____ table.

  • relationship
  • measurement
  • primary
  • fact

Question 33)
What type of programming language uses another program to read and execute coded instructions?

  • Compiled
  • Object-oriented
  • Interpreted
  • Functional

Question 34)
In a dimensional model, what might dimensions represent? Select all that apply.

  • Metrics
  • Attributes
  • Events
  • Supporting details

Question 35)
In the ETL loading stage, what are typical target destinations to which the data might be delivered? Select all that apply.

  • Data lake
  • Website application
  • Analytics platform
  • Data warehouse