Question 1

What is a data steward?

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 2

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

Accepted Answer

A) Is the name spelled correctly? 
B) Is the email address invalid? 
C) Does the name and the phone values have the exact same information? 
D) Is aggregate information in agreement with detailed information? 
A) Is the name spelled correctly? 
B) Is the email address invalid? 
C) Does the name and the phone values have the exact same information? 
D) Is aggregate information in agreement with detailed information?

Question 3

What is a data scientist?

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 4

Speech analytics 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) True 
 B)False

Question 5

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Accepted Answer

A) Entity 
B) Extraction 
C) Attribute 
D) Foreign key 
A) Entity 
B) Extraction 
C) Attribute 
D) Foreign key

Question 6

Dirty data is erroneous or flawed data.

Accepted Answer

A) True 
 B)False

Question 7

What is a data lake?

Accepted Answer

A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data. 
A) A business that collects personal information about consumers and sells that information to other organizations. 
B) A storage repository that holds a vast amount of raw data in its original format until the business needs it. 
C) A technique for establishing a match, or balance, between the source data and the target data warehouse. 
D) An approach to business governance that values decisions that can be backed up with verifiable data.

Question 8

Which of the following statements is true regarding customer information?

Accepted Answer

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

Prediction is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Accepted Answer

A) True 
 B)False

Question 10

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following occurs during data cleansing?

Accepted Answer

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

Question 12

What is a logical data structure that details the relationship among data elements using graphics or pictures?

Accepted Answer

A) Data model 
B) Data element 
C) Data mining tool 
D) Data mart tool 
A) Data model 
B) Data element 
C) Data mining tool 
D) Data mart tool

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

What does standardization of data elements accomplish?

Accepted Answer

A) Greater accuracy. 
B) Completeness and completeness. 
C) Increases the quality of information. 
D) All of the above. 
A) Greater accuracy. 
B) Completeness and completeness. 
C) Increases the quality of information. 
D) All of the above.

Question 16

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A) It is only available to high-level executives due to the expense 
B) It is only available in aggregate levels of granularity 
C) It continually changes 
D) It rarely changes 
A) It is only available to high-level executives due to the expense 
B) It is only available in aggregate levels of granularity 
C) It continually changes 
D) It rarely changes

Question 17

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

Accepted Answer

A) A database can be relational or network 
B) Database information is accessed by logical structure 
C) Database information is accessed by physical structure 
D) Database users can have different views of information 
A) A database can be relational or network 
B) Database information is accessed by logical structure 
C) Database information is accessed by physical structure 
D) Database users can have different views of information

Question 18

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

Question 19

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Accepted Answer

A) True 
 B)False

Question 20

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Accepted Answer

A) True 
 B)False

What is a data steward?

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

What is a data scientist?

Speech analytics 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.

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Dirty data is erroneous or flawed data.

What is a data lake?

Which of the following statements is true regarding customer information?

Prediction is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Which of the following occurs during data cleansing?

What is a logical data structure that details the relationship among data elements using graphics or pictures?

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

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

What does standardization of data elements accomplish?

What is one of the biggest pitfalls associated with real-time information?

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

Why were data warehouses created?

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

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 a data steward?

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

What is a data scientist?

Speech analytics 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.

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Dirty data is erroneous or flawed data.

What is a data lake?

Which of the following statements is true regarding customer information?

Prediction is a statistical process that finds the way to make a design, system, or decision as effective as possible, for example, finding the values of controllable variables that determine maximal productivity or minimal waste.

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Which of the following occurs during data cleansing?

What is a logical data structure that details the relationship among data elements using graphics or pictures?

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

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

What does standardization of data elements accomplish?

What is one of the biggest pitfalls associated with real-time information?

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

Why were data warehouses created?

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

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