Exam 3: Data Management, Big Data Analytics, and Records Management

Relational databases store data in tables consisting of columns and rows,similar to the format of a spreadsheet.

Data ownership,data quality,and formally managed data are high on the agenda of database managers because they are held personally accountable if their company is found to be in violation of regulations.

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

The supply of oranges used by Coca-Cola has a three-month growing season,but orange juice production is year-round.Therefore,producing orange juice with a consistent taste year-round is complex.How does Coca-Cola deal with this complexity and keep their orange juice taste consistent?

______________ systems consist of hardware and software that manage and archive electronic documents and image paper documents;then index and store them according to company policy.

Data in a ________ are volatile because record transactions.

After data are extracted from a database and processed to standardize their format,they are then loaded into a ________ and ready for analysis.

Which of the following is not a consequence of poor quality or dirty data?

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.

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

Data analytics will produce results,but those results might be meaningless or misleading.

Social commentary and social media are mined for sentiment analysis or to understand consumer intent.

________ enable managers to predict how customers would behave and use that knowledge to be prepared to respond quickly.

_____________ 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.

Before selecting a vendor,it is important to examine workflows and how data,documents,and communications flow throughout the company.

____________ software enables users to analyze data from various dimensions or angles,categorize them,and find correlations or patterns among fields in the data warehouse.

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

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

Users typically access data as needed from a database management system by using ________.

What is the key advantage of an active data warehouse compared to a traditional data warehouse?