Practice Quiz

11. Structured Query Language, or SQL, is the standard querying language for what type of data repository?

  • NoSQL
  • Data lake 
  • Flat Files

12. In use cases for RDBMS, what is one of the reasons that relational databases are so well suited for OLTP applications?

  • Minimize data redundancy 
  • Allow you to make changes in the database even while a query is being executed
  • Support the ability to insert, update, or delete small amounts of data
  • Offer easy backup and restore options 

13. Which NoSQL database type stores each record and its associated data within a single document and also works well with Analytics platforms?

  • Key-value store 
  • Document-based
  • Graph-based
  • Column-based

14. What type of data repository is used to isolate a subset of data for a particular business function, purpose, or community of users?

  • Data Lake
  • Data Mart
  • Data Warehouse
  • Data Pipeline

15. What does the attribute “Velocity” imply in the context of Big Data?

  • Quality and origin of data 
  • Diversity of data
  • Scale of data 
  • The speed at which data accumulates

16. Which of the Big Data processing tools provides distributed storage and processing of Big Data?

  • Hive
  • Spark
  • ETL
  • Hadoop

Graded Quiz

17. Data Marts and Data Warehouses have typically been relational, but the emergence of what technology has helped to let these be used for non-relational data?

  • SQL
  • ETL
  • NoSQL
  • Data Lake

18. What is one of the most significant advantages of an RDBMS?

  • Can store only structured data 
  • Is ACID-Compliant 
  • Requires source and destination tables to be identical for migrating data
  • Enforces a limit on the length of data fields

Shuffle Q/A 2

19. Which one of the NoSQL database types uses a graphical model to represent and store data, and is particularly useful for visualizing, analyzing, and finding connections between different pieces of data?

  • Graph-based
  • Key value store 
  • Document-based
  • Column-based 

20. Which of the data repositories serves as a pool of raw data and stores large amounts of structured, semi-structured, and unstructured data in their native formats?

  • Data Marts
  • Relational Databases
  • Data Warehouses
  • Data Lakes

Leave a Reply