100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
MIS 111 Exam Questions With Correct Answers $12.49   Add to cart

Exam (elaborations)

MIS 111 Exam Questions With Correct Answers

 6 views  0 purchase
  • Course
  • MIS 111
  • Institution
  • MIS 111

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...

[Show more]

Preview 4 out of 31  pages

  • August 29, 2024
  • 31
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • MIS 111
  • MIS 111
avatar-seller
Thebright
©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)

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

72042 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$12.49
  • (0)
  Add to cart