Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Which of the following describes ETL?

Accepted Answer

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 
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 5

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

Accepted Answer

A) True 
 B)False

Question 6

What is a foreign key?

Accepted Answer

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

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

A _______________ key is a field that uniquely identifies a given entity in a table.

Accepted Answer

The answer of A _______________ key is a field that...

Question 10

Which of the following statements is true?

Accepted Answer

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 
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 11

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

Accepted Answer

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 
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 12

What is time-series information?

Accepted Answer

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 
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 13

Data Information in a data warehouse contains layers of columns and rows and this is known as __________ databases.

Accepted Answer

The answer of Data Information in a data warehouse contains...

Question 14

Which of the following represents the different information formats?

Accepted Answer

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

Question 15

What directly accesses a database?

Accepted Answer

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

Question 16

A dimension is a particular attribute of information.

Accepted Answer

A) True 
 B)False

Question 17

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 18

Describe the broad levels,formats,and granularities of information.

Accepted Answer

Information levels include individual,de

Question 19

Data visualization is a kind of information aesthetics.

Accepted Answer

A) True 
 B)False

Question 20

What is the physical view of information?

Accepted Answer

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

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

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

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

Which of the following describes ETL?

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

What is a foreign key?

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

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

A _______________ key is a field that uniquely identifies a given entity in a table.

Which of the following statements is true?

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

What is time-series information?

Data Information in a data warehouse contains layers of columns and rows and this is known as __________ databases.

Which of the following represents the different information formats?

What directly accesses a database?

A dimension is a particular attribute of information.

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Describe the broad levels,formats,and granularities of information.

Data visualization is a kind of information aesthetics.

What is the physical view of information?

Business Information Systems

A Brave New Connected World

E-Business and Mobile Business

Decisions and Processes

Technical Fundamentals

Systems Development and Project Management

Quality Data and Business Intelligence

Enterprise Information Systems: ERP and SCM

Enterprise Information Systems: CRM and Collaboration Systems

Ethics,Privacy,Social Media and Future Trends

About the Modules

Filters

Exam 7: Enterprise Architecture and Security

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

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

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

Which of the following describes ETL?

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

What is a foreign key?

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

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

A _______________ key is a field that uniquely identifies a given entity in a table.

Which of the following statements is true?

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

What is time-series information?

Data Information in a data warehouse contains layers of columns and rows and this is known as __________ databases.

Which of the following represents the different information formats?

What directly accesses a database?

A dimension is a particular attribute of information.

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Describe the broad levels,formats,and granularities of information.

Data visualization is a kind of information aesthetics.

What is the physical view of information?

Business Information Systems

A Brave New Connected World

E-Business and Mobile Business

Decisions and Processes

Technical Fundamentals

Systems Development and Project Management

Quality Data and Business Intelligence

Enterprise Information Systems: ERP and SCM

Enterprise Information Systems: CRM and Collaboration Systems

Ethics,Privacy,Social Media and Future Trends

About the Modules

Filters