Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

1st Sem - PRELIM - ( 3rd year ) > ITEC79 QUIZ > Flashcards

ITEC79 QUIZ Flashcards

1
Q

Data Warehousing involves three types of data:

A

Run-the-Business Data
Integrate-the-Business Data
Monitor-the-Business Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Run-the-Business Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Integrate-the-Business Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Monitor-the-Business Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Knowledge

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

is the process of doing something; effective action is the process of doing the right thing

A

Action

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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.

A

Integrated data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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.

A

Integrated data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Time Reference Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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.

A

Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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.

A

Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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.

A

Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

Data Warehousing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Data Marts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

Business Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

On-line Transaction Processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

On-line Transaction Processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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.

A

On-line Analytical Processing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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.

A

Source System

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

Operational Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

Staging Area

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A

Data Quality

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

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.

A

Change Data Capture

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

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

A

Profile the data

28
Q

It transform different input formats into a consolidated output format.

A

Standardize the data

29
Q

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

A

Data Mart

30
Q

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.

A

Virtual data warehouse

31
Q

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

A

Central data warehouse

32
Q

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

A

Distributed data warehouse

33
Q

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.

A

Scope

34
Q

With accurate data, users lose confidence in the data and make improper decisions.

( true/false )

A

false

35
Q

Data can be move to either operational data store, data warehouse, or data marts.

( true/false )

A

true

36
Q

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

A

Data Modeling

37
Q

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

A

Data Modeling

38
Q

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

A

Data Model

39
Q

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

A

Conceptual Data Model (CDM)

40
Q

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

A

Conceptual Data Model (CDM)

41
Q

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

A

Logical Data Model (LDM)

42
Q

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

A

Logical Data Model (LDM)

43
Q

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

A

Physical Data Model (PDM)

44
Q

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

A

Physical Data Model

45
Q

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

A

Physical Data Model (PDM)

46
Q

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

A

Dimensional Modeling

47
Q

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

A

Dimensional Modeling

48
Q

Is a design technique that seeks to eliminate data redundancies?

A

Normalized Modeling

49
Q

Divides the world into measurements and context?

A

Dimensional Modeling

50
Q

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

A

Measurements (Facts)

51
Q

Measurements are usually numeric values; we refer to them as

A

Facts

52
Q

This context is intuitively divided into independent logical clumps called

A

Dimensions

53
Q

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

A

Dimensions

54
Q

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

A

Fact Table’s Grain (Granularity)

55
Q

The dimensions describe the

A

Facts

56
Q

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

A

Facts

57
Q

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

A

Dimensions

58
Q

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

A

Data warehouse quiries

59
Q

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

A

Choose the Business Process

60
Q

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

A

Declare the Grain

61
Q

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

A

Identify the Dimensions

62
Q

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

A

Identify the Facts

63
Q

Is a single integrated data structure which reflects the structure of business functions rather than the processing flow or the physical arrangement of data?

A

Conceptual Data Model (CDM)

64
Q

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

A

Logical Data Model (LDM)

65
Q

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

A

Physical Data Model (PDM)

66
Q

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

A

Normalized Modeling

67
Q

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

A

Dimensional Modeling

1st Sem - PRELIM - ( 3rd year ) (17 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions