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 2 challenge Quiz Answers with you..

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

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

 

Module 2 challenge Quiz Answers

Question 1)
Which of the following statements accurately describe data marts and data lakes? Select all that apply.

• Data lakes benefit business intelligence professionals because they provide a convenient way to access data that is relevant to a particular project.
• Data marts benefit business intelligence professionals because they provide a convenient way to access data that is relevant to a particular project.
• Data marts are useful when a business intelligence system is ingesting a lot of different data types because they do not require the data to be transformed before storage.
• Data lakes are useful when a business intelligence system is ingesting a lot of different data types because they do not require the data to be transformed before storage.

Question 2)
What are some key benefits of ELT data pipelines in business intelligence?

• ELT can ingest many different kinds of data into a storage system as soon as that data is available.
• ELT enables business intelligence professionals to transform data while it is being transported.
• ELT reduces storage costs and enables businesses to scale storage and computation resources independently.
• ELT enables business intelligence professionals to transform only the data they need.

Question 3)
Fill in the blank: Database performance is a measure of the workload that can be _____ by a database, as well as the associated costs.

• visualized
• measured
• stored
• processed

Question 4)
A business intelligence professional is considering the transactions, queries, analyses, and system commands being processed by a database system. Which of the five factors of database performance are they evaluating?

• Workload
• Throughput
• Optimization
• Contention

Question 5)
When evaluating a database system’s resources, what does a business intelligence professional consider? Select all that apply.

• Software
• Users
• Hardware
• Disk space and memory

Question 6)
A business intelligence team is optimizing the performance of their database. What does this involve? Select all that apply.

• Identifying better data sources and structures
• Comparing workload to cost
• Evaluating the effectiveness of the team’s spreadsheets
• Examining resource use

Question 7)
Fill in the blank: In a relational database system that uses SQL, a _____ describes how the database system will execute a query.

• query plan
• data limitation
• HOW statement
• run method

Question 8)
What are the goals of data partitioning? Select all that apply.

• Improve query processing
• Ensure data segments add up to a whole
• Segment text strings in a query
• Divide a database into distinct, logical parts

Question 9)
Fragmented data is broken up into many pieces that are not stored together. What are some common reasons for this fragmentation? Select all that apply.

• Modifying data files
• Creating new data files
• Deleting data files
• Using the data infrequently

Question 10)
A business intelligence team can cause _____ when two or more data analysts attempt to use a single data resource in a conflicting way.

• repetition
• annotation
• contention
• verification

---

 

Question 11)
Which of the following statements accurately describes workload with regards to database performance?

• Workload is the combination of transactions, queries, analysis, and system commands being processed by the database system at any given time.
• Workload involves two or more components attempting to use a single resource in a conflicting way.
• Workload involves maximizing the speed and efficiency with which data is retrieved in order to ensure high levels of database performance.
• Workload is the overall capability of the database’s hardware and software to process requests.

Question 12)
Optimization involves decreasing _____, which is how long it takes for a database to respond to a user request.

• Scope
• Data view
• Response time
• Contention

Question 13)
A business intelligence professional is investigating the steps their database system takes in order to execute a query. They discover that creating a new table will enhance performance. What does this scenario describe?

• Checking a query plan
• Evaluating contentions
• Limiting data
• Considering run methodology

Question 14)
Fill in the blank: A business intelligence team uses _____ to divide their cloud database system into logical parts. This helps improve query processing and manageability.

• metadata
• the SPLIT function
• database migration
• data partitioning

Question 15)
Fill in the blank: Contention occurs when two or more data analysts attempt to use a _____in a conflicting way.

• data strategy
• series of reports
• single data resource
• section of a spreadsheet

Question 16)
Fill in the blank: A business intelligence professional gathers data, loads it into a unified destination system, and then transforms it into a useful format. They do this using an _____ data pipeline.

• ETL
• oriented
• interpreted
• ELT

Question 17)
What is a measure of the workload that can be processed by a database, as well as the associated costs?

• Scalability
• Database performance
• Maturity
• Distribution

Question 18)
When evaluating the workload of a database system, what does a business intelligence professional consider? Select all that apply.

• Context
• System commands
• Transactions
• Queries and analyses

Question 19)
Fill in the blank: The goal of _____ is to enable a database system to process the largest possible workload at the most reasonable cost.

• application development
• optimization
• business intelligence strategy
• visibility

Question 20)
Fill in the blank: Fragmented data occurs when data is broken up into many pieces that are not_____, often as a result of using the data frequently.

• structured
• labeled
• stored together
• sorted and filtered

Question 21)
What does database performance measure? Select all that apply.

• The workload that can be processed by the database
• Any costs associated with the workload being processed by the database
• The ability of the database to be reconfigured
• Improvements made to data tools and processes

Question 22)
Fill in the blank: A query plan describes the _____ involved with executing a query by a relational database.

• business strategy
• spreadsheets
• reasoning
• steps

Question 23)
There are four main reasons why data becomes fragmented. The first is using the data files frequently. What are the other three?

• Modifying the data files
• Deleting data files
• Creating new data files
• Clearing data files from the cache

Question 24)
When two or more data analysts attempt to use a single data resource in a conflicting way, what is the result?

• Contention
• Argument
• Redundancy
• Duplicates

Question 25)
Which of the following statements accurately describe data marts and data lakes? Select all that apply.

• Data marts are designed to enable information accessibility because their data doesn’t require a lot of processing.
• Data lakes are designed to enable information accessibility because their data doesn’t require a lot of processing.
• Data lakes are subject-oriented, which means they are associated with specific areas or departments of a business.
• Data marts are subject-oriented, which means they are associated with specific areas or departments of a business.

Question 26)
What business intelligence tool enables data to be gathered from different sources, then loaded into a unified destination system and transformed into a useful format?

• Data mart
• Data lake
• ETL
• ELT

Question 27)
Which of the following statements accurately describe data marts and data lakes? Select all that apply.

• A data mart is a subject-oriented database that can be a subset of a larger data warehouse.
• A data lake is a subject-oriented database that can be a subset of a larger data warehouse.
• A data mart is a database system that stores large amounts of raw data in its original format until it’s needed.
• A data lake is a database system that stores large amounts of raw data in its original format until it’s needed.

Question 28)
Which of the following statements accurately describe database resources? Select all that apply.

• Resources include disk space and memory.
• Resources may not be shared with other users.
• Resources can be both internal and external.
• Resources include hardware and software tools.