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. -
answermetadata
Nonvolatile in the context of a data warehou...
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?
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.
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
-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)
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Thebright. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.