ITEC79 QUIZ

Question 1

Data Warehousing involves three types of data:

Answer 1

Run-the-Business Data
Integrate-the-Business Data
Monitor-the-Business 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; effective action is the process of doing the right thing

Answer 7

Action

Question 8

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

Answer 8

Data Warehouse

Question 9

refers to de-duplicating information and merging it from many sources into one consistent definition (e.g., when short listing the top banks in the country, you must know that “BPI” and “Bank of the Philippine Islands” are one and the same.

Answer 9

Integrated data

Question 10

refers to de-duplicating information and merging it from many sources into one consistent definition (e.g., when short listing the top banks in the country, you must know that “BPI” and “Bank of the Philippine Islands” are one and the same.

Answer 10

Integrated data

Question 11

essentially refers to its time-valued characteristic (e.g., what were the total sales of Product A for the past three years).

Answer 11

Time Reference Data

Question 12

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.

Answer 12

Data Warehouse

Question 13

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 13

Data Warehouse

Question 14

is a repository of data summarized or aggregated in simplified form from operational systems. End-user orientated data access and reporting tools let user get at the data for decision support.

Answer 14

Data Warehouse

Question 15

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

Answer 15

Data Warehousing

Question 16

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

Answer 16

Data Marts

Question 17

It does not require business intelligence to work. Reporting tools can generate reports from the data warehouse.

Answer 17

Data Warehouse

Question 18

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

Answer 18

Business Analytics

Question 19

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

Answer 19

On-line Transaction Processing

Question 20

This system can be used for payroll that calculates the employee salaries and manages payment records

Answer 20

On-line Transaction Processing

Question 21

it 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 21

On-line Analytical Processing

Question 22

it can be legacy data sources, ERP’s, simple flat files to complex SAP sources, or COBOL sources or other data sources like RDBMS, AS/400, web application data, etc.

Answer 22

Source System

Question 23

It is object oriented, integrated, volatile, current value data store containing only corporate detailed data.

Answer 23

Operational Data

Question 24

It is also required to hold s subset of the source for data profiling activities.

Answer 24

Staging Area

Question 25

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

Answer 25

Data Quality

Question 26

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

Answer 26

Change Data Capture

Question 27

It is a process to access current data conditions, or to monitor data quality over time

Answer 27

Profile the data

Question 28

It transform different input formats into a consolidated output format.

Answer 28

Standardize the data

Question 29

It is a body of decision-support data for a department that has an architectural foundation of a data warehouse.

Answer 29

Data Mart

Question 30

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 30

Virtual data warehouse

Question 31

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

Answer 31

Central data warehouse

Question 32

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

Answer 32

Distributed data warehouse

Question 33

it may be as bored 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

With accurate data, users lose confidence in the data and make improper decisions. ( true/false )

Answer 34

false

Question 35

Data can be move to either operational data store, data warehouse, or data marts. ( true/false )

Answer 35

true

Question 36

Is a structured approach used to identify major components of an information system's specifications?

Answer 36

Data Modeling

Question 37

Is the process used to analyze the data, identify the relationships, and, ultimately, create the data model

Answer 37

Data Modeling

Question 38

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

Answer 38

Data Model

Question 39

Is a structured business view of the data required to support current business processes, business events, and related performance measures?

Answer 39

Conceptual Data Model (CDM)

Question 40

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 40

Conceptual Data Model (CDM)

Question 41

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

Answer 41

Logical Data Model (LDM)

Question 42

Includes more specific entities and attributes, business rules, and relationships?

Answer 42

Logical Data Model (LDM)

Question 43

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

Answer 43

Physical Data Model (PDM)

Question 44

Both software and data storage structures are considered and the model is often modified to meet performance or physical constraints

Answer 44

Physical Data Model

Question 45

Includes tables and columns, physical database objects, and referential integrity rules?

Answer 45

Physical Data Model (PDM)

Question 46

Is a logical design technique for structuring data so that it's intuitive to business users and delivers fast query performance?

Answer 46

Dimensional Modeling

Question 47

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

Answer 47

Dimensional Modeling

Question 48

Is a design technique that seeks to eliminate data redundancies?

Answer 48

Normalized Modeling

Question 49

Divides the world into measurements and context?

Answer 49

Dimensional Modeling

Question 50

Are captured by the organization's business processes and their supporting operational source systems?

Answer 50

Measurements (Facts)

Question 51

Measurements are usually numeric values; we refer to them as

Answer 51

Facts

Question 52

This context is intuitively divided into independent logical clumps called

Answer 52

Dimensions

Question 53

Describe the 'who, what, when, where, why, and how' context of the measurement?

Answer 53

Dimensions

Question 54

Is the business definition of the measurement event that produces the fact row?

Answer 54

Fact Table's Grain (Granularity)

Question 55

The dimensions describe the

Answer 55

Facts

Question 56

Serve as the Key Performance Indicators (KPI) of the organization?

Answer 56

Facts

Question 57

Provide descriptive information about the fact and are composed of attributes used for filtering or labeling data within data warehouse queries?

Answer 57

Dimensions

Question 58

Dimensions are composed of attributes which are used for filtering or labeling data within

Answer 58

Data warehouse quiries

Question 59

Is the first step in the design process to determine the business process or measurement event to be modeled?

Answer 59

Choose the Business Process

Question 60

Is the step where the design team must declare the grain of the fact table?

Answer 60

Declare the Grain

Question 61

Is the step where the choice of dimensions is fairly straightforward once the grain of the fact table is firmly established?

Answer 61

Identify the Dimensions

Question 62

Is the final step in the four-step design process to carefully select the facts or metrics that are applicable to the business process?

Answer 62

Identify the Facts

Question 63

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 63

Conceptual Data Model (CDM)

Question 64

Includes foreign keys, alternate keys, and is independent of specific software and data storage structure?

Answer 64

Logical Data Model (LDM)

Question 65

Includes physical database objects like triggers, stored procedures, and table spaces?

Answer 65

Physical Data Model (PDM)

Question 66

Is immensely beneficial for transaction processing because it makes transaction loading and updating simple and fast?

Answer 66

Normalized Modeling

Question 67

Is the purpose of dimensional modeling to improve performance by matching data structures to queries?

Answer 67

Dimensional Modeling