Question 1

Information integrity issues occur when the same data element has different values.

Accepted Answer

A) True 
 B)False

Question 2

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Accepted Answer

A) data-driven website 
B) interactive website 
C) database performing website 
D) data processing website

Question 3

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database.What does the elimination of information redundancy do for a database?

Accepted Answer

A) reduces disk space requirements 
B) makes updating information easier 
C) improves information quality 
D) All of these are correct.

Question 4

Estimation determine which things go together.

Accepted Answer

A) True 
 B)False

Question 5

What is a statistical process for estimating the relationships among variables?

Accepted Answer

A) prediction 
B) optimization 
C) forecasting 
D) regression

Question 6

Timely information asks if the information is current with respect to the business needs.

Accepted Answer

A) True 
 B)False

Question 7

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following represents the different information levels?

Accepted Answer

A) detail, summary, aggregate 
B) document, presentation, spreadsheet, database 
C) individual, department, enterprise 
D) executives, managers, operational employees

Question 9

What is another term for data that does not exist in a fixed location?

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

Employees need to compare different types of information for what they commonly reveal to make strategic decisions.Which of the choices below represents the three common types of information found throughout an organization?

Accepted Answer

A) levels, forms, granularities 
B) levels, forms, data 
C) levels, formats, granularities 
D) data, formats, granularities

Question 12

Determining if information is updated weekly, daily, or hourly is an example of a timely characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 13

The primary purpose of a data warehouse is to perform analytical processes.

Accepted Answer

A) True 
 B)False

Question 14

What is text analytics?

Accepted Answer

A) analyzes text flowing across the Internet, including unstructured text from blogs and messages 
B) 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 
C) analyzes unstructured data to find trends and patterns in words and sentences 
D) analyzes unstructured data associated with websites to identify consumer behavior and website navigation

Question 15

In terms of big data, what includes the scale of data?

Accepted Answer

A) variety 
B) veracity 
C) volume 
D) velocity

Question 16

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 17

What is data-driven website?

Accepted Answer

A) the person responsible for creating the original website content 
B) includes data that change based on user action 
C) information stored in a dynamic catalog, or an area of a website that stores information about products in a database 
D) an interactive website kept constantly updated and relevant to the needs of its customers using a database

Question 18

Which of the following represents a reason for low-quality information?

Accepted Answer

A) Online customers intentionally enter inaccurate information to protect the privacy. 
B) Different systems have different information entry standards and formats. 
C) Third-party and external information contains inaccuracies and errors. 
D) All of these are correct.

Question 19

What maintains information about various types of objects, events, people, and places?

Accepted Answer

A) database 
B) data model 
C) data mining 
D) data intelligence

Question 20

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

Accepted Answer

A) marketing, sales, inventory, and billing 
B) data mart 1, data mart 2, data mart 3 
C) competitor and industry information, mailing lists, amp; stock market analysis 
D) marketing information, and stock market analysis numbers

Exam 6: Data: Business Intelligence

Information integrity issues occur when the same data element has different values.

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database.What does the elimination of information redundancy do for a database?

Estimation determine which things go together.

What is a statistical process for estimating the relationships among variables?

Timely information asks if the information is current with respect to the business needs.

Data-mining tools use a variety of techniques to find patterns and relationships in large volumes of information that predict future behavior and guide decision making.

Which of the following represents the different information levels?

What is another term for data that does not exist in a fixed location?

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

Employees need to compare different types of information for what they commonly reveal to make strategic decisions.Which of the choices below represents the three common types of information found throughout an organization?

Determining if information is updated weekly, daily, or hourly is an example of a timely characteristic of high-quality information.

The primary purpose of a data warehouse is to perform analytical processes.

What is text analytics?

In terms of big data, what includes the scale of data?

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

What is data-driven website?

Which of the following represents a reason for low-quality information?

What maintains information about various types of objects, events, people, and places?

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?