CSE 511 CERTIFICATION EVALUATION TEST
PAPER COMPLETE QUESTIONS AND
SOLUTIONS
●● What is the goal of data processing?
Answer: To extract data that is useful
●● Why is the volume of data that is available so large?
Answer: Increasing number of data sources (social media, wearable tech,
sensors, cameras, etc), formats, and data points
●● How much data is possibly generated in a day?
Answer: A petabyte (1 million GB)
●● What is scalable data processing?
Answer: Allows database processing systems to cope with the volume,
velocity, and variety aspects that big data brings into the system
●● What are the different types of data processing systems?
Answer: Relational DBMS, NoSQL Graph/Document Key Value Stores,
and Hadoop/Spark
,●● What are the characteristics of a Relational DBMS?
Answer: Operational workload, presents entities and objects in the world
using tables and relations between tables
●● What are the characteristics of a NoSQL Graph, Document, Key
Value Stores?
Answer: Unstructured data, highly available systems. Runs queries that
extract knowledge from the data.
●● What are the characteristics of Hadoop/Spark?
Answer: Not operational, for analytics over massive scale data
●● What is a database?
Answer: A very large, integrated collection of data that models real
world enterprises using entities and relationships between those entities
●● What are the three goals of a DBMS?
Answer: To store, retrieve, and manage data
●● What are the benefits of using a DBMS?
Answer: Data independnce (don't need to know how data is organized),
Efficient data access (indexes), data administration (one location where
data is stored), concurrent access + crash recovery, data integrity +
, security, reduced app development time (don't have to worry about
scalability of database or database performance)
●● What is a data model
Answer: collection of concepts for describing data. The mathematical
equation that defines a relationship.
●● What is a schema?
Answer: A description of a particular collection of data in tables using a
given data model. Description of data using tables in the relational
model
●● What are the three levels of abstraction?
Answer: External Schema (Views), Conceptual Schema, and Physical
Schema
●● What are the external schema (views)?
Answer: Describes how users see the data. Can have multiple views on
top of a conceptual schema.
●● What is the conceptual schema?
Answer: Defines the logical structure of the relation. The attributes that
make up the database. Only one conceptual schemal per relation.
PAPER COMPLETE QUESTIONS AND
SOLUTIONS
●● What is the goal of data processing?
Answer: To extract data that is useful
●● Why is the volume of data that is available so large?
Answer: Increasing number of data sources (social media, wearable tech,
sensors, cameras, etc), formats, and data points
●● How much data is possibly generated in a day?
Answer: A petabyte (1 million GB)
●● What is scalable data processing?
Answer: Allows database processing systems to cope with the volume,
velocity, and variety aspects that big data brings into the system
●● What are the different types of data processing systems?
Answer: Relational DBMS, NoSQL Graph/Document Key Value Stores,
and Hadoop/Spark
,●● What are the characteristics of a Relational DBMS?
Answer: Operational workload, presents entities and objects in the world
using tables and relations between tables
●● What are the characteristics of a NoSQL Graph, Document, Key
Value Stores?
Answer: Unstructured data, highly available systems. Runs queries that
extract knowledge from the data.
●● What are the characteristics of Hadoop/Spark?
Answer: Not operational, for analytics over massive scale data
●● What is a database?
Answer: A very large, integrated collection of data that models real
world enterprises using entities and relationships between those entities
●● What are the three goals of a DBMS?
Answer: To store, retrieve, and manage data
●● What are the benefits of using a DBMS?
Answer: Data independnce (don't need to know how data is organized),
Efficient data access (indexes), data administration (one location where
data is stored), concurrent access + crash recovery, data integrity +
, security, reduced app development time (don't have to worry about
scalability of database or database performance)
●● What is a data model
Answer: collection of concepts for describing data. The mathematical
equation that defines a relationship.
●● What is a schema?
Answer: A description of a particular collection of data in tables using a
given data model. Description of data using tables in the relational
model
●● What are the three levels of abstraction?
Answer: External Schema (Views), Conceptual Schema, and Physical
Schema
●● What are the external schema (views)?
Answer: Describes how users see the data. Can have multiple views on
top of a conceptual schema.
●● What is the conceptual schema?
Answer: Defines the logical structure of the relation. The attributes that
make up the database. Only one conceptual schemal per relation.
