Search
Browse
Create
Log in
Sign up
Log in
Sign up
IT410 FINAL EXAM: Chapter 2
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Terms in this set (67)
...
...
false
in the isle of capri case, the only capability added by the new software was increased processing speed. T or F?
true
the "islands of data" problem in the 1980s describes the phenomenon of unconnected data being stored in numerous locations within an organization. T or F?
false
subject oriented databases for data warehousing are organized by detailed subjects as disk drives, computers, and networks. T or F?
false
data warehouses are subsets of data marts. T or F?
true
one way an operational data store differs from a data warehouse is the recency of their data. T or F?
false
organizations seldom devote a lot of effort to creating metadata because it is not important for the effective use of data warehouses. T or F?
true
without middleware, different BI programs cannot easily connect to the data warehouse. T or F?
false
two-tier data warehouse/BI infrastructures offer organizations more flexibility but cost more than three-tier ones. T or F?
false
moving the data into a data warehouse is usually the easiest part of its creation. T or F?
true
the hub-and-spoke data warehouse model uses a centralized warehouse feeding dependent data marts. T or F?
true
because of performance and data quality issues, most experts agree that the federated architecture should supplement data warehouses, not replace them. T or F?
false
bill inmon advocates the data mart bus architecture whereas ralph Kimball promotes the hub-and-spoke architecture, a data mart bus architecture with conformed dimensions. T or F?
false
the ETL process in data warehousing usually takes up a small portion of the time in a data-centric project. T or F?
true
in the starwood hotels case, up-to-date data and faster reporting helped hotel managers better manage their occupancy rates. T or F?
false
large companies, especially those with revenue upwards of $500 million consistently reap substantial cost savings through the use of hosted data warehouses. T or F?
false
OLTP systems are designed to handle ad hoc analysis and complex queries that deal with many data items. T or F?
true
the data warehousing maturity model consists of six stages: prenatal, infant, child, teenager, adult, and sage. T or F?
false
a well-designed data warehouse means that user requirements do not have to change as business needs change. T or F?
false
data warehouse administrators (DWAs) do not need strong business insight since they only handle the technical aspect of the infrastructure. T or F?
false
because recession has raised interest in low-cost open source software, it is now set to replace traditional enterprise software. T or F?
decision makers have unfettered access to all data in the warehouse
the "single version of the truth" embodied in data warehouse such as capri casinos' means all of the following EXCEPT
subject-oriented and nonvolatile
operational or transactional databases are product oriented, handling transactions that update the database. in contrast, data warehouses are
independent data mart
which kind of data warehouse is created separately from the enterprise data warehouse by department and not reliant on it for updates?
for most organizations, data warehouse metadata are an unnecessary expense
all of the following statements about metadata are true EXCEPT
three tier architecture
a web client that connects to a web server, which is in turn connected to a BI application server, is reflective of a
parallel processing
which of the following BEST enables a data warehouse to handle complex queries and scale up to handle many more requests?
federated architecture
which data warehouse uses metadata warehouses to create a hybrid logical data warehouse comprised of data from the other warehouses?
hub-and-spoke data warehouse architecture
which data warehouse architecture uses a normalized relational warehouse that feeds multiple data marts?
enterprise application integration
which approach to data warehouse integration focuses more on sharing process functionality than data across systems?
transformation
in which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated?
cleanse
in which stage of extraction, transformation, and load (ETL) into a data warehouse are anomalies detected and corrected?
improved customer service
data warehouses provide direct and indirect benefits to using organizations. which of the following is an indirect benefit of data warehouses?
greater control of data
all of the following are benefits of hosted data warehouses EXCEPT
star schema
when representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?
drill down
when querying a dimensional database, a user went from summarized data to its underlying details. the function that served this purpose is
ROLAP
which of the following online analytical processing (OLAP) technologies does NOT require the precomputation and storage of information?
speed of data transfer
active data warehousing can be used to support the highest level of decision making sophistication and power. the major feature that enables this in relation to handling the data is
large numbers or users, including operational staffs
which of the following statements is more descriptive of active data warehouses in contrast with traditional data warehouses?
hardware resources are dynamically allocated as use increases
how does the use of cloud computing affect the scalability of a data warehouse?
it is the same as in-memory storage technology
all of the following are true about in-database processing technology EXCEPT
real-time
with ___________________ data flows, managers can view the current state of their businesses and quickly identify problems.
product
in _____________________ oriented data warehousing, operational databases are tuned to handle transactions that update the database.
data stores
the three main types of data warehouses are data marts, operational ___________________, and enterprise data warehouses.
metadata
______________________ describe the structure and meaning of the data, contributing to their effective use.
relational
most data warehouses are built using _________________ database management systems to control and manage the data.
hub-and-spoke
a(n) _____________________ architecture is used to build a scalable and maintainable infrastructure that includes a centralized data warehouse and several dependent data marts.
federated
the __________________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple resources to meet changing needs or business conditions.
integration
data __________________ comprises data access, data federation, and change capture.
enterprise application integration (EAI)
_______________________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse.
enterprise information integration (EII)
_______________________ is a mechanism for pulling data from source systems to satisfy a request for information. it is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, web services, and multidimensional databases.
extraction, transformation, and load (ETL)
performing extensive _____________________ to move data to the data warehouse may be a sign of poorly managed data and a fundamental lack of a coherent data management strategy.
Inmon
the __________________ model, also known as the EDW approach, emphasizes top-down development, employing established database development methodologies and tools, such as entity-relationship diagrams (ERD), and an adjustment of the spiral development approach.
Kimball
the _________________ model, also known as the data mart approach, is a "plan big, build small" approach. a data mart s a subject-oriented or department-oriented data warehouse. it is a scaled-down version of a data warehouse that focuses on the requests of a specific department, such as marketing or sales.
dimensional
______________________ modeling is a retrieval-based system that supports high-volume query access.
analytical processing
online ____________________ is arguably the most commonly used data analysis technique in data warehouses.
transaction processing
online _________________________ is a term used for a transaction system that is primarily responsible for capturing and sorting data related to day-to-day business functions such as ERP, CRM, SCM, and point of scale.
enterprise
in Michigan State Agencies case, the approach used was a(n) ____________________ one, instead of developing separate BI/DW platforms for each business area or state agency.
data warehouse administrator (DWA)
the role responsible for successful administration and management of a data warehouse is the ___________________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight.
SaaS (software as a service)
______________________, or "the extended ASP model," is a creative way of deploying information system applications where the provider licenses its applications to customers for use as a service on demand (usually over the Internet)
in-database processing
____________________ (also called in-database analytics) refers to the integration of the algorithmic extent of data analytics into data warehouse.
a pool of data produced to support decision making; it is also a repository of current and historical data of potential interest to managers throughout the organization.
what is the definition of a data warehouse (DW) in simple terms?
a subset of a data warehouse, typically consisting of a single subject area. whereas a data warehouse combines databases across an entire enterprise. they are also usually smaller and focuses on a particular subject or department.
what is the definition of a data mart?
they are data about data. they describe the structure of and some meaning about data, thereby contributing to their effective or ineffective use.
Mehra (2005) indicated that few organizations really understand metadata, and fewer understand how to design and implement a metadata strategy. how would you describe metadata?
to provide context to the reported data; that is, it provides enriching information that leads to the creation of knowledge.
according to Kassam (2002), business metadata comprise information that increases our understanding of traditional (i.e., structured) data. what is the primary purpose of metadata?
generally speaking, these architectures are commonly called client/server or n-tier architectures, of which two-tier and three-tier architectures are the most common, but sometimes there is simply one tier.
there are several basic information system architectures that can be used for data warehousing. what are they?
it is the process of loading and providing data via the data warehouse as they become available.
more data, coming in faster and requiring immediate conversion into decisions, means that organizations are confronting the need for real-time data warehousing (RDW). how would you define real-time data warehousing?
YOU MIGHT ALSO LIKE...
Accounting Information Systems
TextbookMediaPremium
$9.99
STUDY GUIDE
data midterm chapter 3
53 Terms
flaxbeards
Big Data test 1 Ch. 2
70 Terms
mtidball
quiz 2
70 Terms
annie_ho75
OTHER SETS BY THIS CREATOR
Life & Health Exam: Chapter 1
37 Terms
Jessica_C29
IT 317 Quizzes
47 Terms
Jessica_C29
IT 317 Final Exam Review
86 Terms
Jessica_C29
IT 317 Module 7 & 8 Terms
82 Terms
Jessica_C29
THIS SET IS OFTEN IN FOLDERS WITH...
Business Intelligence - Chapter 1
20 Terms
aloehmann
MGTS2202 Lecture MCQs
28 Terms
zululion
MSIS Business Analytics chapter 2
20 Terms
chas_kenessey
Business Intel and Analytics - Chapter 1
20 Terms
lshawa1129
;