SNHU DAD 220 COMPREHENSIVE STUDY GUIDE 2026
FULL QUESTIONS AND SOLUTIONS GRADED A+
● Data. Answer: raw information, collected raw facts and values - stock prices
● Information. Answer: data that has been processed and analyzed to give the facts more
value and meaning - a graph of stock prices over time
● Types of data formats. Answer: text, image, audio, video
● Types of data sources. Answer: industries, governments, individuals, and more
● common sources of data - Social Networks. Answer: Facebook, twitter, youtube, blogs,
search engines, etc
● common sources of data - business systems. Answer: medical records, commercial
transactions, bank records, e-commerce
● common sources of data - Internet of Things. Answer: home automation, weather sensors,
traffic sensors, webcams, surveillance videos, security images
● Data.gov. Answer: A U.S. government geoportal that allows access to U.S. Federal
Executive Branch datasets. provides more than 250,000 U.S. government data sets to
support research and application development
● NASA's Data Portal. Answer: provides numerous data sets in categories such as
aerospace, earth science, and space science
● National Cancer Institute. Answer: The federal government's principal agency for cancer
research. Collects and reports data and information relative to all forms of cancer. Also
provides support for research, grants, and training in the pursuit for a cure for cancer.
● Data Science Central. Answer: Supports Big Data (large data sets provided for
computational analysis) initiatives. Also supports Big Data practitioners in scientific industries
such as machine learning, artificial intelligence, and deep learning.
● NYCOpenData. Answer: Data collected by the New York City government. The data is used
to support continuous monitoring and improvements of the health and well being of NYC and
its residents.
, ● Database. Answer: a collection of data in a structured format that correlates related data
values. The database structure enables fast storing, retrieving, updating, and deleting of data.
● Database Management System (DBMS). Answer: commonly called a database system, is a
software application used to support data organization in a database. A database system
provides additional functionality to secure data and ensure data is accurate.
● application. Answer: software used to interact with a database system to access data in a
database
● Database Administrator (DBA). Answer: is responsible for securing the database system
against unauthorized users. A database administrator enforces procedures for end user
access and database system availability.
● database designer. Answer: defines a database's tables, views, constraints, and indexes.
The database design supports data storage, retrieval, modification, and deletion actions.
● End User. Answer: are the consumers of data in a database. End users request, update, or
use stored data to generate reports or information.
● SQL Statement Categories. Answer: CRUD - Create, Read, Update, Delete
● IDE (Integrated Development Environment). Answer: a programming environment that
includes an editor, compiler, and debugger. In this course we are using Codio.
● SQL (Structured Query Language). Answer: an international standard language for
processing a database. It contains 3 parts: 1. data definition language including statements
that help you define the database and its objects: tables, views, triggers, stored procedures 2.
data manipulation language contains statements that allow you to update and query data. 3.
data control language allows you to grant permission to a user to access specific data in the
database
● ACID. Answer: an acronym referring to properties atomicity, consistency, isolation, and
durability. To provide a reliable database to end users, all four properties must be achieved for
transactions to change data in a database
● SELECT. Answer: MySQL query that shows you how to use simple SELECT statement to
query the data from a single table.
● ORDER BY. Answer: A MySQL statement used for sorting data that is useful for ordering
the output of a SELECT query (for example, in ascending or descending order).
● WHERE. Answer: MySQL Filtering data clause to filter rows based on specified conditions.
FULL QUESTIONS AND SOLUTIONS GRADED A+
● Data. Answer: raw information, collected raw facts and values - stock prices
● Information. Answer: data that has been processed and analyzed to give the facts more
value and meaning - a graph of stock prices over time
● Types of data formats. Answer: text, image, audio, video
● Types of data sources. Answer: industries, governments, individuals, and more
● common sources of data - Social Networks. Answer: Facebook, twitter, youtube, blogs,
search engines, etc
● common sources of data - business systems. Answer: medical records, commercial
transactions, bank records, e-commerce
● common sources of data - Internet of Things. Answer: home automation, weather sensors,
traffic sensors, webcams, surveillance videos, security images
● Data.gov. Answer: A U.S. government geoportal that allows access to U.S. Federal
Executive Branch datasets. provides more than 250,000 U.S. government data sets to
support research and application development
● NASA's Data Portal. Answer: provides numerous data sets in categories such as
aerospace, earth science, and space science
● National Cancer Institute. Answer: The federal government's principal agency for cancer
research. Collects and reports data and information relative to all forms of cancer. Also
provides support for research, grants, and training in the pursuit for a cure for cancer.
● Data Science Central. Answer: Supports Big Data (large data sets provided for
computational analysis) initiatives. Also supports Big Data practitioners in scientific industries
such as machine learning, artificial intelligence, and deep learning.
● NYCOpenData. Answer: Data collected by the New York City government. The data is used
to support continuous monitoring and improvements of the health and well being of NYC and
its residents.
, ● Database. Answer: a collection of data in a structured format that correlates related data
values. The database structure enables fast storing, retrieving, updating, and deleting of data.
● Database Management System (DBMS). Answer: commonly called a database system, is a
software application used to support data organization in a database. A database system
provides additional functionality to secure data and ensure data is accurate.
● application. Answer: software used to interact with a database system to access data in a
database
● Database Administrator (DBA). Answer: is responsible for securing the database system
against unauthorized users. A database administrator enforces procedures for end user
access and database system availability.
● database designer. Answer: defines a database's tables, views, constraints, and indexes.
The database design supports data storage, retrieval, modification, and deletion actions.
● End User. Answer: are the consumers of data in a database. End users request, update, or
use stored data to generate reports or information.
● SQL Statement Categories. Answer: CRUD - Create, Read, Update, Delete
● IDE (Integrated Development Environment). Answer: a programming environment that
includes an editor, compiler, and debugger. In this course we are using Codio.
● SQL (Structured Query Language). Answer: an international standard language for
processing a database. It contains 3 parts: 1. data definition language including statements
that help you define the database and its objects: tables, views, triggers, stored procedures 2.
data manipulation language contains statements that allow you to update and query data. 3.
data control language allows you to grant permission to a user to access specific data in the
database
● ACID. Answer: an acronym referring to properties atomicity, consistency, isolation, and
durability. To provide a reliable database to end users, all four properties must be achieved for
transactions to change data in a database
● SELECT. Answer: MySQL query that shows you how to use simple SELECT statement to
query the data from a single table.
● ORDER BY. Answer: A MySQL statement used for sorting data that is useful for ordering
the output of a SELECT query (for example, in ascending or descending order).
● WHERE. Answer: MySQL Filtering data clause to filter rows based on specified conditions.
