BADM 374 7WB EXAM 1 STUDY GUIDE QUESTIONS ANSWERED CORRECTLY LATEST UPDATE 2026
What is a data mart? - Answers A subset of a data warehouse used by small- and medium-sized
businesses and departments within large companies to support decision making.
What is the function of a database management system (DBMS)? - Answers It serves as an interface
between an application program and a database.
Which component of Leavitt's Diamond is an IS manager focusing on when ensuring help desk
availability? - Answers The people component.
What is a workgroup information system? - Answers A system that supports teamwork and enables
people to work together effectively, also known as a collaboration system.
What is a server? - Answers A computer employed by many users to perform a specific task, such as
running network or Internet applications.
Where are instructions and data held during the instruction phase of execution? - Answers In a
storage register.
What are the five key characteristics of big data? - Answers Volume, Velocity, Value, Variety, and
Veracity.
When is regression analysis useful? - Answers When you wish to predict the value of a quantitative
variable based on another quantitative variable.
What are the three steps of the ETL process? - Answers Extract data from sources, Transform data
into warehouse format, and Load data into the warehouse.
What are the four categories of NoSQL databases? - Answers Key-value, Document, Graph, and
Column NoSQL databases.
What is a data lake? - Answers A repository that takes a 'store everything' approach to big data,
saving all data in its raw and unaltered form.
How is data defined? - Answers Raw facts.
How is information defined? - Answers A collection of organized and processed data that has
additional value beyond the individual facts.
How is knowledge defined? - Answers Awareness and understanding of a set of information that
shows how it can support a specific task or decision.
What is big data veracity? - Answers A measure of the accuracy, completeness, and currency of the
data.
What is an in-memory database? - Answers A database system that stores the entire database in
random access memory.
What system does Hadoop use to process data? - Answers A Java-based system called MapReduce.
What is a domain in a relational database model? - Answers A range of allowable values for an
attribute.
What is a record in a database? - Answers A collection of characteristics that belong to a single
person, place, or thing for which data is maintained.
What is Structured Query Language (SQL)? - Answers A special-purpose programming language for
accessing and manipulating data stored in a relational database.
What is data normalization? - Answers The process of dividing a relational database into two or more
tables and defining relationships between them.
What is a data definition language? - Answers A collection of instructions and commands used to
define and describe data and relationships in a specific database.
What is a data center? - Answers A climate- and access-controlled building that houses the computer
hardware delivering an organization's data and information services.
What are the three types of system software? - Answers Operating systems, utility programs, and
middleware.
What is a thin client? - Answers A low-cost, centrally managed computer with limited capabilities and
no internal or external attached drives for data storage.
What is parallel processing? - Answers The use of computers to execute the same task on multiple
processors simultaneously to model, simulate, and analyze large amounts of data.
What is server virtualization? - Answers Logically dividing the resources of a single physical server to
create multiple logical servers to improve hardware utilization.
What is joining in the context of database tables? - Answers The combining of two or more tables
through common data attributes to form a new table with only the unique data attributes.
What is a data mart? - Answers A subset of a data warehouse used by small- and medium-sized
businesses and departments within large companies to support decision making.
What is the function of a database management system (DBMS)? - Answers It serves as an interface
between an application program and a database.
Which component of Leavitt's Diamond is an IS manager focusing on when ensuring help desk
availability? - Answers The people component.
What is a workgroup information system? - Answers A system that supports teamwork and enables
people to work together effectively, also known as a collaboration system.
What is a server? - Answers A computer employed by many users to perform a specific task, such as
running network or Internet applications.
Where are instructions and data held during the instruction phase of execution? - Answers In a
storage register.
What are the five key characteristics of big data? - Answers Volume, Velocity, Value, Variety, and
Veracity.
When is regression analysis useful? - Answers When you wish to predict the value of a quantitative
variable based on another quantitative variable.
What are the three steps of the ETL process? - Answers Extract data from sources, Transform data
into warehouse format, and Load data into the warehouse.
What are the four categories of NoSQL databases? - Answers Key-value, Document, Graph, and
Column NoSQL databases.
What is a data lake? - Answers A repository that takes a 'store everything' approach to big data,
saving all data in its raw and unaltered form.
How is data defined? - Answers Raw facts.
How is information defined? - Answers A collection of organized and processed data that has
additional value beyond the individual facts.
How is knowledge defined? - Answers Awareness and understanding of a set of information that
shows how it can support a specific task or decision.
What is big data veracity? - Answers A measure of the accuracy, completeness, and currency of the
data.
What is an in-memory database? - Answers A database system that stores the entire database in
random access memory.
What system does Hadoop use to process data? - Answers A Java-based system called MapReduce.
What is a domain in a relational database model? - Answers A range of allowable values for an
attribute.
What is a record in a database? - Answers A collection of characteristics that belong to a single
person, place, or thing for which data is maintained.
What is Structured Query Language (SQL)? - Answers A special-purpose programming language for
accessing and manipulating data stored in a relational database.
What is data normalization? - Answers The process of dividing a relational database into two or more
tables and defining relationships between them.
What is a data definition language? - Answers A collection of instructions and commands used to
define and describe data and relationships in a specific database.
What is a data center? - Answers A climate- and access-controlled building that houses the computer
hardware delivering an organization's data and information services.
What are the three types of system software? - Answers Operating systems, utility programs, and
middleware.
What is a thin client? - Answers A low-cost, centrally managed computer with limited capabilities and
no internal or external attached drives for data storage.
What is parallel processing? - Answers The use of computers to execute the same task on multiple
processors simultaneously to model, simulate, and analyze large amounts of data.
What is server virtualization? - Answers Logically dividing the resources of a single physical server to
create multiple logical servers to improve hardware utilization.
What is joining in the context of database tables? - Answers The combining of two or more tables
through common data attributes to form a new table with only the unique data attributes.
