Question 1

What is the primary difference between an entity and an attribute?

Accepted Answer

A) An attribute is a table, an entity is a column from the attribute table 
B) An entity is specific, where as an attribute is not data at all but brainstorming ideas that take place before the entity is created 
C) An attribute refers to applications, and an entity refers to executives 
D) An entity is a table that stores information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entity 
A) An attribute is a table, an entity is a column from the attribute table 
B) An entity is specific, where as an attribute is not data at all but brainstorming ideas that take place before the entity is created 
C) An attribute refers to applications, and an entity refers to executives 
D) An entity is a table that stores information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entity

Question 2

What is the term for the time it takes for data to be stored or retrieved?

Accepted Answer

A) Data governance. 
B) Data latency. 
C) Data validation. 
D) Data gap analysis. 
A) Data governance. 
B) Data latency. 
C) Data validation. 
D) Data gap analysis.

Question 3

Which of the following is the common term for the representation of multidimensional information?

Accepted Answer

A) Block 
B) Square 
C) Column 
D) Cube 
A) Block 
B) Square 
C) Column 
D) Cube

Question 4

The four primary traits of the value of information include type, timeliness, quality, and governance.

Accepted Answer

A) True 
 B)False

Question 5

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following would not be considered part of the timely characteristic of high-quality information?

Accepted Answer

A) Is the zip code missing in the address? 
B) Is the information current with respect to business needs? 
C) Is the customer address current? 
D) Is the information updated weekly or hourly? 
A) Is the zip code missing in the address? 
B) Is the information current with respect to business needs? 
C) Is the customer address current? 
D) Is the information updated weekly or hourly?

Question 7

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?

Accepted Answer

A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of the above. 
A) A historical perspective offers important variables for determining trends and patterns. 
B) Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C) Setting strategic direction is critical for planning and creating solid business strategies. 
D) None of the above.

Question 8

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

Accepted Answer

A) Entity 
B) Relationships 
C) Attribute 
D) Foreign Key 
A) Entity 
B) Relationships 
C) Attribute 
D) Foreign Key

Question 9

A content editor is the person responsible for updating and maintaining website content.

Accepted Answer

A) True 
 B)False

Question 10

Business analysis is difficult from operational databases. Which of the following is a reason why?

Accepted Answer

A) Every department has its own method for recording data. 
B) Lack of data standards across departments. 
C) The data, if available, were often incorrect or incomplete. 
D) All of the above. 
A) Every department has its own method for recording data. 
B) Lack of data standards across departments. 
C) The data, if available, were often incorrect or incomplete. 
D) All of the above.

Question 11

Kassandra Young is a business manager at Weith Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

Accepted Answer

A) Data point 
B) Information cleansing 
C) Dashboard 
D) Data set 
A) Data point 
B) Information cleansing 
C) Dashboard 
D) Data set

Question 12

Organizational information has three characteristics including timeliness, quality, and governance.

Accepted Answer

A) True 
 B)False

Question 13

What is immediate, up-to-date information?

Accepted Answer

A) Real-time information 
B) Real-time systems 
C) Information granularity 
D) Information governance 
A) Real-time information 
B) Real-time systems 
C) Information granularity 
D) Information governance

Question 14

What are the two main objectives associated with data mining?

Accepted Answer

A) Uncovering tactics and plans 
B) Uncovering trends and patterns 
C) Uncovering intelligence and unstructured data issues 
D) Uncovering competitors and market advantages 
A) Uncovering tactics and plans 
B) Uncovering trends and patterns 
C) Uncovering intelligence and unstructured data issues 
D) Uncovering competitors and market advantages

Question 15

Which of the following is a problem associated with dirty data?

Accepted Answer

A) Accurate data 
B) Integrated data 
C) Violates business rules 
D) All of the above 
A) Accurate data 
B) Integrated data 
C) Violates business rules 
D) All of the above

Question 16

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 17

What is a data steward responsible for?

Accepted Answer

A) Acting as a liaison between the MIS department and the business. 
B) Ensuring policies and procedures are implemented across the organization. 
C) Both acting as a liaison between the MIS department and the business and ensuring policies and procedures are implemented across the organization. 
D) None of the above. 
A) Acting as a liaison between the MIS department and the business. 
B) Ensuring policies and procedures are implemented across the organization. 
C) Both acting as a liaison between the MIS department and the business and ensuring policies and procedures are implemented across the organization. 
D) None of the above.

Question 18

What is big data?

Accepted Answer

A) A collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools. 
B) Processes and manages algorithms across many machines in a computing environment. 
C) Focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization. 
D) Extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information. 
A) A collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools. 
B) Processes and manages algorithms across many machines in a computing environment. 
C) Focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization. 
D) Extracts knowledge from data by performing statistical analysis, data mining, and advanced analytics on big data to identify trends, market changes, and other relevant information.

Question 19

What is data stewardship?

Accepted Answer

A) The time it takes for data to be stored or retrieved. 
B) The management and oversight of an organization's data assets. 
C) The person responsible for ensuring policies and procedures are implemented across the organization. 
D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps. 
A) The time it takes for data to be stored or retrieved. 
B) The management and oversight of an organization's data assets. 
C) The person responsible for ensuring policies and procedures are implemented across the organization. 
D) When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.

Question 20

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A) To create an entity 
B) To create physical relationships 
C) To create logical relationships 
D) To create an attribute 
A) To create an entity 
B) To create physical relationships 
C) To create logical relationships 
D) To create an attribute

What is the primary difference between an entity and an attribute?

What is the term for the time it takes for data to be stored or retrieved?

Which of the following is the common term for the representation of multidimensional information?

The four primary traits of the value of information include type, timeliness, quality, and governance.

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Which of the following would not be considered part of the timely characteristic of high-quality information?

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?

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

A content editor is the person responsible for updating and maintaining website content.

Business analysis is difficult from operational databases. Which of the following is a reason why?

Kassandra Young is a business manager at Weith Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

Organizational information has three characteristics including timeliness, quality, and governance.

What is immediate, up-to-date information?

What are the two main objectives associated with data mining?

Which of the following is a problem associated with dirty data?

Which of the following statements is true?

What is a data steward responsible for?

What is big data?

What is data stewardship?

Why do relational databases use primary keys and foreign keys?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Emerging Trends and Technologies

Filters

Exam 6: Data: Business Intelligence

What is the primary difference between an entity and an attribute?

What is the term for the time it takes for data to be stored or retrieved?

Which of the following is the common term for the representation of multidimensional information?

The four primary traits of the value of information include type, timeliness, quality, and governance.

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Which of the following would not be considered part of the timely characteristic of high-quality information?

Managers can use BI to answer tough business questions. Which of the following describes the value of knowing where the business is now?

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

A content editor is the person responsible for updating and maintaining website content.

Business analysis is difficult from operational databases. Which of the following is a reason why?

Kassandra Young is a business manager at Weith Productions. Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions. To make her job easier, what can she customize to display data quickly and run custom reports?

Organizational information has three characteristics including timeliness, quality, and governance.

What is immediate, up-to-date information?

What are the two main objectives associated with data mining?

Which of the following is a problem associated with dirty data?

Which of the following statements is true?

What is a data steward responsible for?

What is big data?

What is data stewardship?

Why do relational databases use primary keys and foreign keys?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Databases

Emerging Trends and Technologies

Filters