Database Systems and Big Data Flashcard

Front

What is a database?

Back

An organized collection of data.

Front

Which component manipulates the database and provides an interface for users?

Back

Database Management System (DBMS)

Front

What is the primary key in a database?

Back

A field or set of fields that uniquely identifies a record

Front

What does the term *data modeling* refer to?

Back

A diagram of data entities and their relationships

Front

Which is NOT a characteristic of Big Data? Volume, Variety, Velocity, Validation

Back

Validation

Front

What is the function of Hadoop Distributed File System (HDFS)?

Back

It is designed for high-throughput access to large datasets.

Front

Which of the following is NOT a type of NoSQL database? Key-Value, Document, Column, Schema

Back

Schema

Front

What are the steps of Big Data processing? 1) Data Collection 2) Data Preprocessing 3) Data Storage 4) Data Analysis 5) Data Visualization Which of the following is the correct order?

Back

1,2,3,4,5

Front

What is the primary advantage of NoSQL databases over traditional relational databases?

Back

They support schema-less data and allow for greater flexibility

Front

What does ETL in Data Warehouses stand for?

Back

Extract, Transform, Load