Question 1

Identify the primary functions of a database and data warehouse and explain why enterprises need both of these data management technologies.

Accepted Answer

The answer of Identify the primary functions of a database...

Question 2

___________ are small-scale data warehouses that support a single function or department.

Accepted Answer

The answer of ___________ are small-scale data warehouses that support...

Question 3

Data warehouses are designed as OLAP systems,meaning that the data can be queried and analyzed much more efficiently than __________ application databases.

Accepted Answer

The answer of Data warehouses are designed as OLAP systems,meaning...

Question 4

Companies have a ________ duty to retain business records.

Accepted Answer

The answer of Companies have a ________ duty to retain...

Question 5

______________ is a broad category that involves analyzing and interpreting words and concepts in context.

Accepted Answer

The answer of ______________ is a broad category that involves...

Question 6

Describe the characteristics of dirty data.Explain three negative consequences of dirty data.What is the general formula showing the costs of poor quality data?

Accepted Answer

The answer of Describe the characteristics of dirty data.Explain three...

Question 7

A business ________ is documentation of a business event,action,decision,or transaction.

Accepted Answer

The answer of A business ________ is documentation of a...

Question 8

Data generated by business apps,sensors,and transaction processing systems (TPS)are typically stored first in a ___________.

Accepted Answer

The answer of Data generated by business apps,sensors,and transaction processing...

Question 9

Specialized software used to analyze large data sets to find patterns,correlation,trends,or other meaningful relationships are called __________ tools.

Accepted Answer

The answer of Specialized software used to analyze large data...

Question 10

Data ___________ integrate data from multiple databases and data silos and organize them for complex analysis,knowledge discovery,and to support decision making.

Accepted Answer

The answer of Data ___________ integrate data from multiple databases...

Question 11

In terms of the dependability or reliability of an information system,_________ means the system has zero-downtime,zero data loss,and continuous access to data.

Accepted Answer

The answer of In terms of the dependability or reliability...

Question 12

An ad-hoc request for specific data or information from a database or warehouse is called a ______________.

Accepted Answer

The answer of An ad-hoc request for specific data or...

Question 13

Data ________ are the primary source of cleansed data for analysis,reporting,and BI.

Accepted Answer

The answer of Data ________ are the primary source of...

Question 14

_____________________ is a process used to analyze an organization's non-structured data that comes from word processing documents,social media,text messages,audio,faxes,memos,call center or claims notes,and so on.

Accepted Answer

The answer of _____________________ is a process used to analyze...

Question 15

A widely used big data processing platform is Apache ________.

Accepted Answer

The answer of A widely used big data processing platform...

Question 16

Data warehouses that integrate data from databases across an entire organization are called ____________ data warehouses.

Accepted Answer

The answer of Data warehouses that integrate data from databases...

Question 17

___________ and judgment are needed to interpret the output of data analytics.

Accepted Answer

The answer of ___________ and judgment are needed to interpret...

Question 18

A widely used platform for processing big data is Apache ________.

Accepted Answer

The answer of A widely used platform for processing big...

Question 19

Databases are ________ because data are constantly being updated,added,or edited.

Accepted Answer

The answer of Databases are ________ because data are constantly...

Question 20

_____________ data warehouses are relatively new OLAP systems that are updated in real-time,providing the most current data available for analysis and decision support apps.

Accepted Answer

The answer of _____________ data warehouses are relatively new OLAP...

Quiz 3: Data Management, Business Intelligence, and Data Analytics