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

Test your knowledge: Database performance

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.

  • Specialized
  • Subject-oriented
  • Departmental
  • Categorical

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?

  • Optimization
  • Resources
  • Throughput
  • Workload

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

Weekly challenge 2

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

  • 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 benefit business intelligence professionals because they provide a convenient way to access data that is relevant to a particular project.
  • 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.

5. 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 lake
  • ELT
  • ETL
  • Data mart

6. What does database performance measure? Select all that apply.

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

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

8. Which of the following statements accurately describe database resources? Select all that apply.

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

Shuffle Q/A 1

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

  • Data view
  • Response time
  • Scope
  • Contention

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

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

Leave a Reply