ITEC79 (Ma'am Karen)

Question 1

is composed of individual discreet facts that collect
descriptive, quantitative, and qualitative value of business
interests.

Answer 1

Data

Question 2

produced by corporate
applications, such as the one used to fill customer orders
for its products or the one used to manage financial
transactions.

Answer 2

Run-the-Business Data

Question 3

built to improve the quality
of and synchronize two or more applications, such as a
master list of customers.

Answer 3

Integrate-the-Business Data

Question 4

presented to end users for
reporting and decision support, such as financial
dashboards.

Answer 4

Monitor-the-Business Data

Question 5

is an organized collection of data presented
in a specific and meaningful way

Answer 5

Information

Question 6

it encompasses the familiarity, awareness,
understanding, and perceptions of a person about a given
subject

Answer 6

Knowledge

Question 7

is the process of doing something

Answer 7

Action

Question 8

is a subject-oriented, integrated, non-
volatile, time-variant collection of data in support of management’s decisions.

• is a powerful database model that
  significantly enhances the user’s ability to quickly analyze
  large, multidimensional data sets. It cleanses and
  organizes data to allow users to make business decisions
  based on facts.
  ◼ is a collection of integrated, subject
  oriented databases designed to support the decision
  support function where each unit of data is relevant to
  some moment of time.

Answer 8

data warehouse

Question 9

refers to de-duplicating information and
merging it from many sources into one consistent definition

Answer 9

Integrated Data

Question 10

is a way of storing data and creating information through
leveraging data marts.

Answer 10

Data Warehousing

Question 11

are segments or categories
of information and/or data that are grouped together to provide
insights into that segment or category.

Answer 11

Data Mart

Question 12

is the leveraging of a data warehouse to help make business
decisions and recommendations.

Answer 12

◼ Business Analytics

Question 13

A system that keeps track of an organization’s daily
transactions and updates the warehouse at periodic intervals

Answer 13

On-Line Transaction Processing

Question 14

A technology that uses a multi-dimensional view of aggregate
data to provide quick access to strategic information for further
analysis

Enables end-users to perform ad-hoc analysis of data in
multiple dimensions, thereby providing the insight and
understanding they need for better decision making

Answer 14

OLAP: On-Line Analytical Processing

Question 15

A subject-oriented, integrated, volatile, current-valued data
store containing only corporate detailed data

Answer 15

ODS: Operational Data Store

Question 16

of a data warehouse can
be legacy data sources,

is either pushed or pulled
into the landing area in a pre-determined
format from respective source systems.

Answer 16

Source Systems

Question 17

is a volatile intermediate
area for operational data before
transformation takes place.

Answer 17

Landing Area

Question 18

is a place where you
hold temporary tables on the data
warehouse server.

Answer 18

Staging Area

Question 19

is defined as standardizing and
consolidating customer and/or business
data.

Answer 19

Data quality

Question 20

is
a set of software design patterns
used to determine the data that
has changed in a database so that
action can be taken on the
changed data.

-occur mostly in data
warehouse environments

Answer 20

Change Data Capture (CDC)

Question 21

This involves analysis of metadata and
data values, and detection of
differences between defined and
inferred properties.

Answer 21

Analyze the Data

Question 22

is a process to assess
current data conditions, or to monitor
data quality over time. It begins with
collecting measurements about data,
and then looking at the results
individually and in various combinations
to see where anomalies exits.

Answer 22

Profile the Data / Data profiling

Question 23

is the act of detecting and
correcting (or removing) corrupt or
inaccurate records from a record set,
table, or database.

Answer 23

Cleanse the Data / Data cleansing

Question 24

This involves integration and
consolidation of data from various
source systems to form a single system
of record.

Answer 24

Integrate the Data

Question 25

transforms
different input formats into a
consolidated output format; helps in:
creating single domain fields,
incorporating business, industry
standards.

Answer 25

Standardize the Data

Question 26

Is a subject-oriented, integrated, volatile,
current-valued, detailed-only collection of data

in support of an organization’s need for up-to-
the second, operational, integrated, collective

information

Answer 26

Operational Data Store

Question 27

Is a body of decision-support data for a
department that has an architectural foundation
of a data warehouse; can also represent a
business process that can proliferate across
many departments

Answer 27

Data Mart

Question 28

is defined as the extensive use of
data, statistical and quantitative analyses,
explanatory and predictive modeling, and
fact-based management to drive decision
making.

Answer 28

Analytics

Question 29

provides information about
the past state or performance of a business and
its environment. It provides regular reports for
events that already happened and ad hoc
reports to help examine facts about what
happened, where, how often, and with how
many.

Answer 29

Descriptive analytics

Question 30

helps predict (based on
data and statistical techniques) with confidence
what will happen next so that you can make
well-informed decisions and improve business
outcomes. It uses simulation models to suggest
what could happen.

Answer 30

Predictive analytics

Question 31

recommends high-value
alternative actions or decisions given a complex
set of targets, limits, and choices. It predicts
future outcomes and suggests courses of
actions to take so that you can benefit from
those predictions.

Answer 31

Prescriptive analytics

Question 32

is “data about data.” It refers to data that tries to
describe a data set in terms of its value, content, quality,
and significance.

Answer 32

Metadata

Question 33

a data warehouse may be as broad as all the
informational data for the entire enterprise from the beginning
of time, or it may be as narrow as a personal data warehouse
for a single manager for a single year.

Answer 33

Scope

Question 34

allow end users to get at operational
databases directly; it provides the ultimate in flexibility as well
as the minimum amount of redundant data that must be loaded
and maintained.

Answer 34

Virtual data warehouses

Question 35

are single physical databases that
contains all data for a specific functional area, department,
division, or enterprise.

Answer 35

Central data warehouses

Question 36

are those in which certain
components are distributed across a number of different
physical databases.

Answer 36

Distributed data warehouses

Question 37

Is the specification of data structures and business rules to
represent business requirements

Answer 37

Data Model

Question 38

Is a structured approach used to identify major components of an
information system’s specifications
◼ Is the process used to analyze the data, identify the relationships, and,
ultimately, create the data model

Answer 38

Data Modeling

Question 39

is a structured business view
of the data required to support current business processes,
business events, and related performance measures
It is a single integrated data structure which reflects the
structure of business functions rather than the processing flow
or the physical arrangement of data

Answer 39

Conceptual Data Model (CDM)

Question 40

builds upon the business
requirements and includes a further level of detail that supports
both the business and system requirements

Answer 40

Logical Data Model (LDM)

Question 41

is specific to the software and
performance constraints of the specific database management
system to be used in the implementation

Answer 41

Physical Data Model (PDM)

Question 42

is a logical design technique for structuring data so that it’s
intuitive to business users and delivers fast query performance.

is widely accepted as the preferred approach for data
warehouse presentation.

Answer 42

Dimensional Modeling

Question 43

is quite different from dimensional modeling.
a design technique that seeks to eliminate data redundancies.

Answer 43

Normalized modeling

Question 44

are captured by the organization’s
business processes and their supporting operational
source systems.

• are usually numeric values; we refer to
  them as facts.

Answer 44

Measurements

Question 45

are surrounded by largely textual context that is true
at the moment the fact is recorded.

serve as the Key Performance
Indicators (KPI) of the organization.

Answer 45

Fact

Question 46

is the business
definition of the measurement event that produces the
fact row.

Answer 46

fact table’s grain (granularity)

Question 47

provide descriptive information about the fact.

• are composed of
  attributes which are used for filtering
  or labeling data within data
  warehouse queries.

Answer 47

Dimensions