©THEBRIGHT 2024
MIS 111 Exam Questions With Correct
Answers
Information about data sources; database, table, and column names; refresh schedules; and data-
usage measures are collectively define what issue about the information in a data warehouse. -
answer✔✔metadata
Nonvolatile in the context of a data warehouse means _______________
The data can't be changed while reports are running.
The data can only be changed if it is also modified in the system where it was originally
calculated.
The data cannot be changed or updated by users of the data warehouse.
The data mart must be used when modifying information. - answer✔✔The data cannot be
changed or updated by users of the data warehouse.
Operational, transactional and ________ systems are examples of a source system for a data
warehouse. - answer✔✔ERP
A data ________ is a repository of historical data that are organized by subject to support
decision makers in the organization - answer✔✔warehouse
___________ support local control, whereas ____________ support central control -
answer✔✔data marts;data warehouses
In the example we just discussed, the minimum and maximum enrollment for a specific class can
best be described using what database term?A) AttributeB) ConstraintC) Entity ClassD)
Relationship - answer✔✔entity constraint
What term is used to describe a field
(attribute) that identifies a record into
another database table with the goal
of minimizing data redundancy?
, ©THEBRIGHT 2024
A.
Attribute
B.
Primary key
C.
Foreign Key
D.
Entity class - answer✔✔c. foreign key
What aspect of an ERD (Entity
-
relationship diagram) is used to enforce
business rules, such as maximum
number of classes a student can take?
A.
Attribute
B.
Constraint
C.
Entity
D.
Relationship - answer✔✔c. entity
Big data-4vs - answer✔✔volume, variety, velocity, veracity
When you check your credit score for
incorrect information, you're responding
to which of the "4 V's"?
Velocity
B.
, ©THEBRIGHT 2024
Variety
C.
Veracity
D.
Volume - answer✔✔c. veracity
what is the def of data mining - answer✔✔detection ,characterization, and exploitation of
actionalbe patterns in business data
OLAP - answer✔✔on line analytical processing
OLAP - answer✔✔set of functionalities that facilitiate multi-dimensional data analysis for faster,
more informed decision making
he value of the "all
time" total sales
created by this
projection could be
calculated using what
Excel function?
a. average
b. mean
c. sum
d. count - answer✔✔c. sum
When analyzing the performance of
students on Exam 1, which of the
following would
not
be a useful
"dimension" in an OLAP data cube? - answer✔✔a. email adddress
data warehouse - answer✔✔-large multidimensional datasets
, ©THEBRIGHT 2024
-integrates info from indepdent applicatoins
-characterists
-organization (relevance and context)
-consistency (encoded data standards)
-nonvolatile(conssitent info events)
-relational (assocations and efficiency)
data warehouse - answer✔✔integrating data into large repositories of info
data mart - answer✔✔info from data warehouse can be exported to a data mart, which is focused
on a speicfic question (boiling the ocean)
-info in a data mart is pertinent to the decision at hand (info overload)
What term means users that cannot
change or update the data in data
warehouses or data marts?
Integrated
B.
Nonvolatile
C.
Consistent
D.
Relational - answer✔✔b. nonvolatile
data mining legal and ethical issues - answer✔✔privact concerns
-will impact way data is analyzed
-ownership issues
-euro data laws have implications on us
-often data included in data warehouse cannot be legally used in deciison making process
(discriminatory factors: race, gender, age)
MIS 111 Exam Questions With Correct
Answers
Information about data sources; database, table, and column names; refresh schedules; and data-
usage measures are collectively define what issue about the information in a data warehouse. -
answer✔✔metadata
Nonvolatile in the context of a data warehouse means _______________
The data can't be changed while reports are running.
The data can only be changed if it is also modified in the system where it was originally
calculated.
The data cannot be changed or updated by users of the data warehouse.
The data mart must be used when modifying information. - answer✔✔The data cannot be
changed or updated by users of the data warehouse.
Operational, transactional and ________ systems are examples of a source system for a data
warehouse. - answer✔✔ERP
A data ________ is a repository of historical data that are organized by subject to support
decision makers in the organization - answer✔✔warehouse
___________ support local control, whereas ____________ support central control -
answer✔✔data marts;data warehouses
In the example we just discussed, the minimum and maximum enrollment for a specific class can
best be described using what database term?A) AttributeB) ConstraintC) Entity ClassD)
Relationship - answer✔✔entity constraint
What term is used to describe a field
(attribute) that identifies a record into
another database table with the goal
of minimizing data redundancy?
, ©THEBRIGHT 2024
A.
Attribute
B.
Primary key
C.
Foreign Key
D.
Entity class - answer✔✔c. foreign key
What aspect of an ERD (Entity
-
relationship diagram) is used to enforce
business rules, such as maximum
number of classes a student can take?
A.
Attribute
B.
Constraint
C.
Entity
D.
Relationship - answer✔✔c. entity
Big data-4vs - answer✔✔volume, variety, velocity, veracity
When you check your credit score for
incorrect information, you're responding
to which of the "4 V's"?
Velocity
B.
, ©THEBRIGHT 2024
Variety
C.
Veracity
D.
Volume - answer✔✔c. veracity
what is the def of data mining - answer✔✔detection ,characterization, and exploitation of
actionalbe patterns in business data
OLAP - answer✔✔on line analytical processing
OLAP - answer✔✔set of functionalities that facilitiate multi-dimensional data analysis for faster,
more informed decision making
he value of the "all
time" total sales
created by this
projection could be
calculated using what
Excel function?
a. average
b. mean
c. sum
d. count - answer✔✔c. sum
When analyzing the performance of
students on Exam 1, which of the
following would
not
be a useful
"dimension" in an OLAP data cube? - answer✔✔a. email adddress
data warehouse - answer✔✔-large multidimensional datasets
, ©THEBRIGHT 2024
-integrates info from indepdent applicatoins
-characterists
-organization (relevance and context)
-consistency (encoded data standards)
-nonvolatile(conssitent info events)
-relational (assocations and efficiency)
data warehouse - answer✔✔integrating data into large repositories of info
data mart - answer✔✔info from data warehouse can be exported to a data mart, which is focused
on a speicfic question (boiling the ocean)
-info in a data mart is pertinent to the decision at hand (info overload)
What term means users that cannot
change or update the data in data
warehouses or data marts?
Integrated
B.
Nonvolatile
C.
Consistent
D.
Relational - answer✔✔b. nonvolatile
data mining legal and ethical issues - answer✔✔privact concerns
-will impact way data is analyzed
-ownership issues
-euro data laws have implications on us
-often data included in data warehouse cannot be legally used in deciison making process
(discriminatory factors: race, gender, age)
