Module 4 - Understanding Data Repositories and Big Data Platforms QUIZ

Structured Query Language, or SQL, is the standard querying language for what type of data repository? A. Flat Files B. RDBMS C. Data lake D. NoSQL

B

In use cases for RDBMS, what is one of the reasons that relational databases are so well suited for OLTP applications? A. Allow you to make changes in the database even while a query is being executed B. Minimize data redundancy C. Support the ability to insert, update, or delete small amounts of data D. Offer easy backup and restore options

C

What does the attribute "Velocity" imply in the context of Big Data? A. Scale of data B. Diversity of data C. The speed at which data accumulates D. Quality and origin of data

C

What type of data repository is used to isolate a subset of data for a particular business function, purpose, or community of users? A. Data Lake B. Data Pipeline C. Data Mart D. Data Warehouse

C

Apache Spark is a general-purpose data processing engine designed to extract and process Big Data for a wide range of applications. What is one of its key use cases? A. Scalable and reliable Big Data storage B. Fast recovery from hardware failures C. Consolidate data across the organization D. Perform complex analytics in real-time

D

What is one of the most significant advantages of an RDBMS? A. Enforces a limit on the length of data fields B. Can store only structured data C. Requires source and destination tables to be identical for migrating data D. Is ACID-Compliant

D

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? A. Data Marts B. Data Warehouses C. Relational databases D. Data Lakes

D

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? A. NoSQL B. SQL C. ETL D. Data Lake

A

What does the attribute "Veracity" imply in the context of Big Data?' A. Accuracy and conformity of data to facts B. The speed at which data accumulates C. Diversity of the type and sources of data D. Scale of data

A

Which NoSQL database type stores each record and its associated data within a single document and also works well with Analytics platforms? A. Key-value store B. Document-based C. Graph-based D. Column-based

A

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? A. Key value store B. Column-based C. Graph-based D. Document-based

C

Which of the Big Data processing tools provides distributed storage and processing of Big Data? A. Hive B. Hadoop C. Spark D. ETL

B