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

Question 1

According to the ________,a majority of data is seldom accessed after a 3 month period.

A)Principle of data in context
B)Principle of 90/90 data use
C)Principle of diminishing data value
D)Principle of data quality

Answer 1

B

Question 2

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

A)Synchronized,low-latency system
B)Decision support system
C)Data warehouse
D)DBMS

Answer 2

C

Question 3

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

A)Unplanned reports
B)Relational reports
C)Volatile
D)Queries

Answer 3

D

Question 4

Despite the need for high-quality data,____________ and technical issues often make it a difficult goal to achieve.

A)High costs
B)Untrained or undertrained IT personnel
C)User errors
D)Organizational politics

Question 5

Data in a ________ are volatile because record transactions.

A)Database
B)Data warehouse
C)Data mart
D)Data silo

Question 6

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

A)spreadsheets
B)big data
C)text mining
D)data marts

Question 7

Distributed databases use ___________ architecture to process information requests.

A)Client/server
B)NoSQL
C)Private clouds
D)Public clouds

Question 8

Sometimes organizations place too much emphasis on the costs associated with acquiring high levels of data quality and ignore the costs of "dirty" or poor quality data.Which of the following sets of factors make up the total costs associated with poor quality data?

A)Technology costs + Training costs + Marketing costs
B)Value of lost business + Cost to prevent errors + Cost to correct errors
C)Cost of repeating analyses + Lost opportunity costs + Cost of unrealized threats
D)Value of lost business + Cost to correct errors + Cost of repeating analyses (on corrected data)

Question 9

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?

A)An orange juice decision model was developed that combines detailed data on the 600+ flavors that make up an orange.
B)A decentralized data model was developed to respond to consumer preferences.
C)Legacy systems were replaced with data silos to manage big data.
D)A data governance program was implemented to ensure that juice preferences are achieved.

Question 10

The primary disadvantage of centralized database systems is ________.

A)Data security
B)Data quality
C)Availability of statistical analysis tools
D)Transmission delay when users are geo-dispersed

Question 11

In terms of the major functions performed by a DBMS,"data filtering and profiling" refers to which of the following?

A)Inspecting the data for errors,inconsistencies,redundancies,and incomplete information.
B)Correcting,standardizing,and verifying the integrity of the data.
C)Integrating,matching,or linking data from disparate sources.
D)Checking and controlling data integrity over time.

Question 12

An accurate and consistent view of data throughout the enterprise is needed so one can make informed,actionable decisions that support the business strategy.A function performed by a DBMS to integrate,match,or link data from disparate sources is data _____________.

A)filtering
B)profiling
C)synchronization
D)maintenance

Question 13

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

A)BI tools
B)SQL
C)Transaction processing
D)Data filtering

Question 14

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

A)Transaction processing
B)Data mining
C)Business intelligence
D)Decision support

Question 15

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

A)scalability
B)fault tolerance
C)handling big data
D)large Web apps

Question 16

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

A)The company loses sales or customers
B)Information workers are constrained in their jobs
C)Decision makers face too much uncertainty to make intelligent decisions
D)The company faces data ownership problems

Question 17

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

A)Reports / Statistical Tools
B)Quality / Security
C)Speed / Access
D)Software / Hardware

Question 18

________ tools and techniques process data and do statistical analysis for insight and discovery.

A)Operational intelligence
B)Business intelligence
C)Information accessibility
D)Information fluidity

Question 19

Which of the following data management technologies store data that are generated by business apps and operations?

A)Data marts
B)Data warehouses
C)Databases
D)Transaction-processing systems (TPS).

Question 20

The principle of ________ explains why most organizations cannot operate at peak performance with blind spots (lack of data availability)of 30 days or longer.Global financial services institutions rely on near-real-time data for peak performance.

A)data in context
B)90/90 data use
C)diminishing data value
D)data quality

Question 21

Which of the following is not a risk associated with cloud-based BI?

A)Slower response time
B)Security risk
C)Backup risk
D)Increased costs

Question 22

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.

A)Active
B)Always-on
C)Dynamic
D)Operational

Question 23

Machine-generated sensor data from________ are becoming a much larger proportion of big data and analytics.

A)physical objects
B)satellites
C)smartphones
D)vehicles

Question 24

When customer X calls an organization's customer service center,the service representative has access to a complete history of X's previous calls,as a list of the services X has purchased,and customer profitability score.All of this information is up-to-date and is accessed from the company's _________.

A)Management information system
B)Transactional database system
C)Active data warehouse
D)Online transaction processing system

Question 25

All of the following are factors contributing to the increased use of BI,except:

A)Smart devices and demand for 24/7 access to insights
B)Proprietary information systems
C)Cloud-enabled BI and analytics
D)Increased amounts of data

Question 26

________ must ensure that their companies comply with legal and regulatory duties by managing electronic records.

A)Senior management
B)CIOs
C)Corporate lawyers
D)Workers

Question 27

With text analytics,information is extracted out of large quantities of various types of textual information.Which of the following is not one of the steps involved in text analytics described in your text?

A)Exploration of documents for preliminary categorization or identification of common topics
B)Preprocessing of documents to standardize content as much as possible
C)Categorization and modeling of document content using statistical models and business rules
D)Visualization - translating text data to graphic format (e.g.charts,graphs)for effective reporting

Question 28

Big data volumes that exceed the processing capacity of conventional infrastructures are processed using the ________ platform.

A)Oracle
B)Hadoop
C)ADW
D)MySQL

Question 29

_____________ helps companies tap into the massive volume of customer opinions expressed online.

A)Media metrics
B)Unstructured analytics
C)Text mining
D)Media mining

Question 30

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

A)NoSQL
B)Data mining
C)Hadoop
D)Nexus

Question 31

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

A)The ADW is less expensive to install and operate
B)Data from an ADW can be used for DSS,report generation and Business Intelligence
C)Data in an ADW is constantly updated,providing more current data than a traditional data warehouse
D)The ADW is more widely available from a larger number of vendors

Question 32

___________ is a set of processes that aid organizations in integrating data from various sources or enterprise applications to create and maintain a more unified view of a customer,product,or other core data entity that is shared across systems.

A)Client/server architecture
B)OLAP
C)Master data management
D)Data synchronization

Question 33

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

A)Electronic records management
B)Business management
C)Compliance
D)Digital Document

Question 34

Improperly managed or destroyed business records become ________.

A)archives
B)liabilities
C)breach of contracts
D)lawsuits

Question 35

________ are documentation of business events,actions,decisions,or transactions.

A)data
B)reports
C)information
D)records

Question 36

Companies have always faced the challenge of managing physical documents.Which of the following is the most significant challenge associated with managing physical documents?

A)The volume of documents that must be reviewed to determine if they should be retained or destroyed
B)Loading documents onto company websites
C)Sharing documents across geographic locations
D)Translating documents into other languages

Question 37

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

A)Data silo
B)Master reference file
C)Backup file
D)Central directory

Question 38

________ processes move data from databases into data warehouses or data marts,where the data are available for access,reports,and analysis.

A)Big data analytics
B)Data mining
C)Extract,transformation,load (ETL)
D)Data de-duplication

Question 39

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

A)Big data analytics
B)Data discovery
C)Master data management
D)Information optimization

Question 40

The McKinsey Global Institute (MGI)estimates that retailers using big data analytics increase their operating margin by more than ________ percent.

A)10
B)20
C)40
D)60

Question 41

Big data can have a significant positive impact on the success of any enterprise,or be a low-contributing major expense.

Question 42

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

Question 43

Data warehouses and data marts are optimized for extremely fast transactions processing.

Question 44

Volatile refers to data that change frequently.

Question 45

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

Question 46

Online transaction processing (OLTP)systems are designed to manage transaction data,which are volatile.

Question 47

Many database management systems use the Syntax Query Language (SQL)for programming queries.

Question 48

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

Question 49

Traditional databases are not well suited for managing unstructured data such as customer comments and tweets.

Question 50

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

Question 51

Data are worthless if you cannot analyze,interpret,understand,and apply the results in context.

Question 52

Profit margin is a measure of the percent of a company's revenue left over after paying for its variable costs,such as wages and raw materials.

Question 53

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.

Question 54

SQL is an ad-hoc request for specific data or information from a database or warehouse.

Question 55

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

Question 56

Master data entities are the main entities of a company,such as customers,products,suppliers,employees,and assets.

Question 57

Databases need one or more backups and should be archived either onsite or offsite in case of a crash or security incident.

Question 58

Data latency is the elapsed time or delay between when data are created and when they are available for a query or report.

Question 59

Operational intelligence refers to the credentials,technological skills,decision making abilities,and industry experience of key leaders in an organization.

Question 60

According to the 90/90 data-use principle,a majority of stored data,as high as 90 percent,is often accessed after 90 days.

Question 61

To improve quality,McDonald's bakery operation replaced manual equipment with high-speed photo analyses to inspect thousands of buns per minute for color,size,and sesame seed distribution.

Question 62

Data and text mining are used to discover knowledge that you did not know existed in the databases.

Question 63

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

Question 64

The primary disadvantage of distributed database configurations is transmission delay when users are geo-dispersed.

Question 65

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.

Question 66

Preprocessing text is needed before text mining to standardize it,correct misspelled words,and transform slang.

Question 67

In order to help align business and BI strategies,each department identifies its targets,KPIs,and plans to achieve those targets.

Question 68

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.

Question 69

A limitation of Apache Hadoop is that it imposes conditions on the structure of the data it can process.

Question 70

Using BI,Quicken Loans has increased the speed from loan application to close,which allows it to meet client needs as thoroughly and quickly as possible.

Question 71

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

Question 72

A distributed database allows apps on computers and mobiles to access data from local and remote databases.

Question 73

Companies invest in BI in order to be able to analyze all of their data.

Question 74

Distributed databases use a client/server architecture to process information requests.

Question 75

Low-cost sensors make it possible to monitor and control the behavior of all types of physical things.

Question 76

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

Question 77

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

Question 78

BI programs usually combine a database,dashboard,and platform to transform data into usable,actionable business information.

Question 79

Distributed databases use a Select Query (SQ)architecture to process information requests.

Question 80

BI systems are powerful,but limited to the support of strategic decision making because of their cost and complexity.