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

Data in a ________ are volatile because they record ongoing transactions.

The primary benefits of centralized database configuration are better ___________ and ____________.

Mining text or nonstructural data enables organizations to forecast the future instead of merely reporting the past.

Companies need to be prepared to respond to an audit,federal investigation,lawsuit,or any other legal action against them.

Ad-hoc requests for specific data from a database or warehouse are called ___________.

Data mining is important because any customer can become a brand advocate or adversary by freely expressing opinions and attitudes that reach millions of other customers on social media.

Up to 25 percent of an organization's data are nonstructured word-processing documents,social media,text messages,audio,video,images and diagrams,fax and memos,call center or claims notes,and so on.

Data warehouses and data marts are optimized for all of the following except:

MapReduce breaks up the huge dataset into smaller subsets;then distributes the subsets among multiple servers where they are partially processed.

Adaptive means the system can increase in size to handle data growth or the processing load of an increasing number of concurrent users.

Databases are stored on servers that reside in the company's data centers,a private cloud,or a public cloud.

NoSQL systems have increased in popularity because of the growing need for ________,which means the system can increase in size to handle data growth.

MDM consolidates data from various data sources into a __________,which then feeds data back to the applications,thereby creating accurate and consistent.This helps eliminate redundancies,inaccuracies and omissions that might otherwise hinder business processes.

The principle of diminishing data values suggests that many global financial services institutions need near real time data for peak performance.

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

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

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

Organizations that cannot afford the cost of a data warehouse,but want the benefits of online analytic processing invest in___________.

In the past,data was transferred from OTLP databases to data warehouses periodically,say once a month or even once a week.Now,the trend is toward ___________,or real-time,data warehousing so that analysis and decision support apps use current data.

______________ is the elapsed time between when data are created and when they are made available for a query or report.