Practice Quiz
11. Structured Query Language, or SQL, is the standard querying language for what type of data repository?
- NoSQL
- Data lake
- RDBMS
- 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