Deck 7: Enterprise Architecture and Security

Question 1

Which of the following database structures offers a flexible way of representing objects and their relationships?

A) Hierarchical database
B) Network database
C) Relational database model
D) All of the above

Answer 1

B
Explanation: This is the definition of network database model.

Question 2

Which of the following represents the different information formats?

A) Detail, summary, aggregate
B) Document, presentation, spreadsheet, database
C) Individual, department, enterprise
D) None of the above

Answer 2

B
Explanation: The different information formats include document, presentation, spreadsheet, and database.

Question 3

Which of the following can a database maintain information on?

A) Inventory
B) Transactions
C) Employees
D) All of the above

Answer 3

D
Explanation: A database maintains information on inventory, transactions, and employees.

Question 4

What is it called when each transaction,entity,and event is represented only once in the information?

A) Uniqueness
B) Accuracy
C) Consistency
D) Timeliness

Question 5

Which of the following implies that information is current with respect to the business requirement?

A) Uniqueness
B) Accuracy
C) Consistency
D) Timeliness

Question 6

In the relational database model,what is a person,place,thing,transaction,or event about which information is stored?

A) Entity
B) Entity class
C) Attribute
D) Attribute class

Question 7

Which of the following is not one of the five characteristics common to high quality information?

A) Accuracy
B) Completeness
C) Quantity
D) Consistency

Question 8

Which of the following represents the different information granularities?

A) Detail, summary, aggregate
B) Document, presentation, spreadsheet, database
C) Individual, department, enterprise
D) None of the above

Question 9

All of the following are advantages of database-stored information,except:

A) Increased flexibility
B) Increased performance
C) Increased information redundancy
D) Increased information integrity

Question 10

In the relational database model,what are characteristics or properties of an entity class?

A) Entity
B) Entity class
C) Attribute
D) Attribute class

Question 11

Which of the following represents the different information levels?

A) Detail, summary, aggregate
B) Document, presentation, spreadsheet, database
C) Individual, department, enterprise
D) None of the above

Question 12

Why do relational databases use primary keys and foreign keys?

A) To create a database
B) To create physical relationships
C) To create logical relationships
D) All of the above

Question 13

Which of the following implies that aggregate or summary information is in agreement with detailed information?

A) Uniqueness
B) Completeness
C) Consistency
D) Accuracy

Question 14

Which of the following is the characteristic of quality information?

A) Accuracy
B) Completeness
C) Consistency
D) All of the above

Question 15

In the relational database model,what is a collection of similar entities?

A) Entity
B) Entity class
C) Attribute
D) Attribute class

Question 16

What is a foreign key?

A) A field (or group of fields) that uniquely identifies a given entity in a table
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C) Characteristics or properties of an entity class
D) A field (or group of fields) that uniquely identifies a given attribute in a table

Question 17

What is a primary key?

A) A field (or group of fields) that uniquely identifies a given entity in a table
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C) Characteristics or properties of an entity class
D) A field (or group of fields) that uniquely identifies a given attribute in a table

Question 18

What are characteristics or properties of an entity class called?

A) Attributes
B) Fields
C) Columns
D) All of the above

Question 19

What are the different types of information?

A) Levels, forms, granularities
B) Levels, forms, data
C) Levels, formats, granularities
D) Data, formats, granularities

Question 20

Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships,in such a way that it cannot have too many relationships?

A) Hierarchical database
B) Network database
C) Relational database model
D) All of the above

Question 21

Which of the following measures how quickly a system performs a certain process or transaction?

A) Scalability
B) Performance
C) Redundancy
D) Information integrity

Question 22

When Wal-Mart receives inventory to an individual store,this would be an example of using __________________?

A) Analytical information
B) Transactional data
C) Real-time data
D) Real-time information

Question 23

What directly accesses a database?

A) Accounting system users
B) DBMS
C) Finance system users
D) All of the above

Question 24

When the Royal Bank immediately updates your bank deposit of $500 into your account,this would be an example of __________________?

A) Analytical information
B) Transactional data
C) Real-time data
D) Real-time information

Question 25

Which of the following is a valid type of integrity constraint?

A) Performance integrity constraint
B) Scalability integrity constraint
C) Physical integrity constraint
D) Business-critical integrity constraint

Question 26

Which of the following is true in regards to the elimination of redundant information?

A) Uses additional hard disk space
B) Makes performing information updates harder
C) Improves information quality
D) All of the above

Question 27

Which of the following is incorrect in reference to a database?

A) Can be relational or network
B) Information is accessed by logical structure
C) Information is accessed by physical structure
D) Users can access different views of information

Question 28

What is the physical view of information?

A) Deals with the physical storage of information on a storage device such as a hard disk
B) Deals with the logical storage of information on a storage device such as a hard disk
C) Focuses on how users logically access information to meet their particular business needs
D) Focuses on how users physically access information to meet their particular business needs

Question 29

What are the rules that help ensure the quality of information?

A) Information integrity
B) Integrity constraints
C) Relational integrity constraints
D) Business-critical integrity constraints

Question 30

What are rules that enforce basic and fundamental information-based constraints?

A) Information integrity
B) Integrity constraint
C) Business-critical integrity constraint
D) Relational integrity constraint

Question 31

When Wal-Mart reviews their monthly sales totals and profits by province,this would be an example of using __________________?

A) Analytical information
B) Transactional data
C) Real-time data
D) Real-time information

Question 32

Which of the following is correct in reference to a database?

A) A database can support only one logical view
B) A database can support many physical views
C) A database can support many logical views
D) A database can support up to 3 logical views

Question 33

Which of the following uses a DBMS to interact with a database?

A) Users of accounting programs
B) Users of human resource programs
C) Users of marketing programs
D) All of the above

Question 34

What is the primary problem with redundant information?

A) It is difficult to determine which values are the most current
B) It is often inconsistent
C) It is difficult to determine which values are the most accurate
D) All of the above

Question 35

What refers to how well a system can adapt to increased demands?

A) Scalability
B) Performance
C) Redundancy
D) Information integrity

Question 36

What is information redundancy?

A) Duplication of information
B) Storing the same information in multiple places
C) Storing duplicate information in multiple places
D) All of the above

Question 37

What is the time duration to make transactional data ready for analysis,and loading the summarized,aggregated,cleansed data into a data warehouse?

A) Data latency
B) Analysis latency
C) Decision latency
D) None of the above

Question 38

What is the time from which the analytical information is made available to the time when analysis is complete?

A) Data latency
B) Analysis latency
C) Decision latency
D) None of the above

Question 39

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

A) Relational integrity constraint
B) Business-critical integrity constraint
C) Information-critical integrity constraint
D) None of the above

Question 40

All of the following are relational integrity constraints,except

A) System will not allow an entry for an order for a nonexistent customer
B) System will not allow returns of fresh produce after 15 days past delivery
C) System will not allow shipping a product to a customer who does not have a valid address
D) Systems will not allow shipping of a nonexistent product to a customer

Question 41

When does information cleansing occur in the data warehouse?

A) During the ETL process
B) On the information, once it is in the data warehouse
C) During the ETL process and once it is in the data warehouse
D) During the ETL process and before it is in the data warehouse

Question 42

What benefits are the result of discoveries made by creative users?

A) Direct quantifiable benefits
B) Indirect quantifiable benefits
C) Unpredictable benefits
D) Intangible benefits

Question 43

Which of the following statements is true?

A) The more complete an organization wants to get its information, the less it costs
B) The more accurate an organization wants to get its information, the less it costs
C) The less accurate an organization wants to get its information, the more it costs
D) The more complete and accurate an organization wants to get its information, the more it costs

Question 44

Which of the following statements is true regarding customer information?

A) Customer information can exist in several operational systems
B) Customer information in each operational system could change
C) Customer information in each operational system can be different
D) All of the above

Question 45

What benefits include improved communication throughout the enterprise,improved job satisfaction of empowered users,and improved knowledge sharing?

A) Direct quantifiable benefits
B) Indirect quantifiable benefits
C) Unpredictable benefits
D) Intangible benefits

Question 46

What is a forward integration?

A) Takes information entered into a given system and sends it to the application generation component
B) Takes information entered into a given system and sends it automatically to all downstream systems and processes
C) Takes information entered into a given system and sends it automatically to all upstream systems and processes
D) Takes information entered into a given system and sends it to the DBMS

Question 47

Which of the following describes ETL?

A) A process that extracts information from internal and external databases
B) A process that transforms information using a common set of enterprise definitions
C) A process that loads information into a data warehouse
D) All of the above

Question 48

What is the time it takes a human to comprehend the analytic result and determine an appropriate action?

A) Data latency
B) Analysis latency
C) Decision latency
D) None of the above

Question 49

What is an integration?

A) Allows separate systems to communicate directly with each other
B) Takes information entered into a given system and sends it to the database
C) Takes information entered into a given system and sends it to other processes
D) Takes information entered into a given system and sends it to the DBMS

Question 50

What benefits can be evaluated through indirect evidence-improved customer service means new business from the same customer,and differentiated service brings new customers?

A) Direct quantifiable benefits
B) Indirect quantifiable benefits
C) Unpredictable benefits
D) Intangible benefits

Question 51

Bill Inmon,known as the "Father of Data Warehousing" described a Data Warehouse as a collection of data that is:

A) subject-oriented
B) integrated and time-variant
C) non-volatile
D) All of the above

Question 52

What is a backward integration?

A) Takes information entered into a given system and sends it to the application generation component
B) Takes information entered into a given system and sends it automatically to all downstream systems and processes
C) Takes information entered into a given system and sends it automatically to all upstream systems and processes
D) Takes information entered into a given system and sends it to the DBMS

Question 53

What is data mining?

A) The common term for the representation of multidimensional information
B) A particular attribute of information
C) Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behaviour and guide decision making
D) Process of analyzing data to extract information not offered by the raw data alone

Question 54

All of the following are reasons why operational systems are not appropriate for business analysis,except:

A) Does not include information from other operational applications
B) Operational systems are integrated
C) Operational information is mainly current
D) Operational information frequently has quality issues

Question 55

Which of the following occurs during data cleansing?

A) Clean missing records
B) Clean redundant records
C) Clean inaccurate data
D) All of the above

Question 56

What benefits include working time saved in producing reports,selling information to suppliers,and so on?

A) Direct quantifiable benefits
B) Indirect quantifiable benefits
C) Unpredictable benefits
D) Intangible benefits

Question 57

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?

A) $500 million
B) $60 billion
C) hundred of billions of dollars
D) It is impossible to determine

Question 58

A data warehouse is a _________ collection of information-gathered from many different ___________ databases-that supports business analysis activities and decision-making tasks.

A) Physical; transactional
B) Physical; operational
C) Logical; transactional
D) Logical; operational

Question 59

Which of the following does not draw a parallel between the challenges in business and the challenges of war?

A) Collecting information
B) Discerning patterns and meaning in the information
C) Accurate and complete information
D) Responding to the resultant information

Question 60

What is information that people use to support their decision-making efforts?

A) Information cleansing and scrubbing
B) Data-mining tools
C) Data mining
D) Business intelligence

Question 61

Which of the following is a form of statistical analysis?

A) Forecasting
B) Market basket analysis
C) Cluster analysis
D) All of the above

Question 62

Data latency is the time from which the analytical information is made available to the time when analysis is complete.

Question 63

Information are raw facts that describe the characteristics of an event.

Question 64

Which of the following represents market basket analysis?

A) Analyzes Web site information
B) Analyzes checkout scanner information
C) Detects customers' buying behaviour
D) All of the above

Question 65

Intangible benefits include improved communication throughout the enterprise,improved job satisfaction of empowered users,and improved knowledge sharing.

Question 66

What is a technique used to divide an information set into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

A) Association detection
B) Market basket analysis
C) Cluster analysis
D) Intelligent agent

Question 67

Reports for each sales person,product,and part are examples of detail or fine information granularities.

Question 68

Organizational information comes at different levels and in different formats and granularities.

Question 69

Analysis latency is the time it takes a human to comprehend the analytic result and determine an appropriate action.

Question 70

What is time-series information?

A) Analyzes checkout scanner information
B) Time-stamped information collected at a particular frequency
C) Reveals the degree to which variables are related
D) All of the above

Question 71

Which company uses statistical analysis toally detect potential issues,provide quick and easy access to reports,and perform multidimensional analysis on all warranty information?

A) Burlington Northern and Santa Fe Railroad
B) BostonCoach
C) Verizon Communications
D) Whirlpool

Question 72

What reveals the degree to which variables are related and the nature and frequency of these relationships in the information?

A) Association detection
B) Market basket analysis
C) Cluster analysis
D) Intelligent agent

Question 73

Which of the following is data visualization?

A) Data in the form of Venn diagrams
B) Graphical representation of taxonomy of ideas representing the data
C) Schematic representation of data
D) All of the above

Question 74

A key idea within data warehousing is to take data from multiple platforms/technologies and place them in a common location that uses a common querying tool.

Question 75

The data warehouse is a location for all of a business's information.

Question 76

High-quality data and information can significantly improve the chances of making a good decision and directly increase an organization's bottom line.

Question 77

What are forecasts?

A) Predictions made on the basis of time-series information
B) Time-stamped information collected at a particular frequency
C) Reveals the degree to which variables are related
D) All of the above

Question 78

Transactional data encompasses all of the data contained within a single business process or unit of work,and its primary purpose is to support the performing of daily operational tasks.

Question 79

Why is Ben & Jerry's using business intelligence?

A) To improve quality
B) To create new flavours of ice cream
C) To improve financials
D) To manage distribution

Question 80

Analytical information,on the other hand,encompasses all organizational information,and its primary purpose is to support the performing of higher-level analysis tasks.