Question 1

A foreign key uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 2

A DBMS uses three primary data models for organizing information-the hierarchical, network, and the relational database.

Accepted Answer

A) True 
 B)False

Question 3

What is the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise?

Accepted Answer

A) social media analytics 
B) speech analytics 
C) text analytics 
D) web analytics 
A) social media analytics 
B) speech analytics 
C) text analytics 
D) web analytics

Question 4

ETL, within a data warehouse model, stands for exit, track, and load.

Accepted Answer

A) True 
 B)False

Question 5

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Accepted Answer

A) True 
 B)False

Question 6

What is another term for data that is already contained in a database or a spreadsheet?

Accepted Answer

A) structured data 
B) unstructured data 
C) text mining 
D) web mining 
A) structured data 
B) unstructured data 
C) text mining 
D) web mining

Question 7

What is unstructured data?

Accepted Answer

A) has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address 
B) created by a machine without human intervention 
C) data that humans, in interaction with computers, generate 
D) not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages 
A) has a defined length, type, and format and includes numbers, dates, or strings such as Customer Address 
B) created by a machine without human intervention 
C) data that humans, in interaction with computers, generate 
D) not defined, does not follow a specified format, and is typically freeform text such as emails, Twitter tweets, and text messages

Question 8

Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 9

Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

Accepted Answer

A) True 
 B)False

Question 10

Data element (or data field) is the smallest or basic unit of information.

Accepted Answer

A) True 
 B)False

Question 11

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

Accepted Answer

A) True 
 B)False

Question 12

What is the technique used to divide information sets 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?

Accepted Answer

A) statistical detection 
B) cluster analysis 
C) association detection 
D) social media analytics 
A) statistical detection 
B) cluster analysis 
C) association detection 
D) social media analytics

Question 13

Static information includes data that changes based on user actions.

Accepted Answer

A) True 
 B)False

Question 14

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 15

Why were data warehouses created?

Accepted Answer

A) Numbers and types of operational databases increased as businesses grew. 
B) Many companies had information scattered across multiple systems with different formats. 
C) Completing reporting requests from numerous operational systems took days or weeks. 
D) All of these are correct. 
A) Numbers and types of operational databases increased as businesses grew. 
B) Many companies had information scattered across multiple systems with different formats. 
C) Completing reporting requests from numerous operational systems took days or weeks. 
D) All of these are correct.

Question 16

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

Accepted Answer

A) inaccurate data 
B) nonintegrated data 
C) violates business rules 
D) All of these are correct. 
A) inaccurate data 
B) nonintegrated data 
C) violates business rules 
D) All of these are correct.

Question 17

Which of the following offers an advantage of using a data-driven website?

Accepted Answer

A) easy to eliminate human errors 
B) easy to manage content 
C) easy to store large amounts of data 
D) All of these are correct. 
A) easy to eliminate human errors 
B) easy to manage content 
C) easy to store large amounts of data 
D) All of these are correct.

Question 18

What do data warehouses support?

Accepted Answer

A) OLAP 
B) analytical processing 
C) OLTP 
D) OLAP and analytical processing 
A) OLAP 
B) analytical processing 
C) OLTP 
D) OLAP and analytical processing

Question 19

What is clustering?

Accepted Answer

A) determines values for an unknown continuous variable behavior or estimated future value 
B) determines which things go together 
C) segments a heterogeneous population of more homogeneous subgroups 
D) assigns records to one of a predefined set of classes 
A) determines values for an unknown continuous variable behavior or estimated future value 
B) determines which things go together 
C) segments a heterogeneous population of more homogeneous subgroups 
D) assigns records to one of a predefined set of classes

Question 20

What are the primary differences between a data warehouse and a data mart?

Accepted Answer

A) Data warehouses make quick decisions, data marts make slow decisions. 
B) Data warehouses tackle ethical issues, data marts tackle hypothetical issues. 
C) Data warehouses have a more organization-wide focus, data marts have functional focus. 
D) Data warehouses have a physical focus, data marts have logical focus. 
A) Data warehouses make quick decisions, data marts make slow decisions. 
B) Data warehouses tackle ethical issues, data marts tackle hypothetical issues. 
C) Data warehouses have a more organization-wide focus, data marts have functional focus. 
D) Data warehouses have a physical focus, data marts have logical focus.

A foreign key uniquely identifies a given record in a table.

A DBMS uses three primary data models for organizing information-the hierarchical, network, and the relational database.

What is the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise?

ETL, within a data warehouse model, stands for exit, track, and load.

Many firms complete data quality audits to determine the accuracy and completeness of its data.

What is another term for data that is already contained in a database or a spreadsheet?

What is unstructured data?

Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

Data element (or data field) is the smallest or basic unit of information.

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

What is the technique used to divide information sets 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?

Static information includes data that changes based on user actions.

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Why were data warehouses created?

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

Which of the following offers an advantage of using a data-driven website?

What do data warehouses support?

What is clustering?

What are the primary differences between a data warehouse and a data mart?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: Mis Business Concerns: Module 2: Technical Foundations of MIS

Infrastructures: Sustainable Technologies

Networks: Mobile Business: Module 3: Enterprise MIS

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporateresponsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Data-Bases-Apply Your Knowledge-Glossary

Filters

Exam 6: Data: Business Intelligence

A foreign key uniquely identifies a given record in a table.

A DBMS uses three primary data models for organizing information-the hierarchical, network, and the relational database.

What is the process of analyzing recorded calls to gather information; brings structure to customer interactions and exposes information buried in customer contact center interactions with an enterprise?

ETL, within a data warehouse model, stands for exit, track, and load.

Many firms complete data quality audits to determine the accuracy and completeness of its data.

What is another term for data that is already contained in a database or a spreadsheet?

What is unstructured data?

Determining if a name is spelled correctly is an example of an accurate characteristic of high-quality information.

Data models are logical data structures that detail the relationships among data elements by using graphics or pictures.

Data element (or data field) is the smallest or basic unit of information.

Dirty data is erroneous or flawed data.The complete removal of dirty data from a source is impractical or virtually impossible.

What is the technique used to divide information sets 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?

Static information includes data that changes based on user actions.

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Why were data warehouses created?

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

Which of the following offers an advantage of using a data-driven website?

What do data warehouses support?

What is clustering?

What are the primary differences between a data warehouse and a data mart?

Management Information Systems: Business Driven MIS

Decisions and Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics and Information Security: Mis Business Concerns: Module 2: Technical Foundations of MIS

Infrastructures: Sustainable Technologies

Networks: Mobile Business: Module 3: Enterprise MIS

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporateresponsibility

Hardware and Software Basics

Networks and Telecommunications

Designing Data-Bases-Apply Your Knowledge-Glossary

Filters