Deck 3: Data,text,and Document Management

Question 1

As a general rule,in order to maximize earnings,companies invest in data management technologies that increase:

A)the opportunity to earn revenues.
B)the ability to cut expenses.
C)employee turnover.
D)both a and b

Answer 1

D

Question 2

Each year,billions of dollars are wasted in the healthcare supply chain because of the lack of __________.

A)data synchronization
B)data processing
C)real-time data
D)document management

Answer 2

A

Question 3

Which of the following best represents a unique identifier field or primary key?

A)zip code
B)customer last name
C)product type
D)product ID

Answer 3

D

Question 4

In __________ file organization,which is the way files are organized on tape,data records must be retrieved in the same physical sequence in which they are stored.

A)direct
B)random
C)sequential
D)primary

Question 5

Businesses that collect data about employees and customers have the legal duty to __________.

A)destroy that data after 30 days
B)protect that data
C)retain that data for seven years
D)Both a and b

Question 6

Which is not a benefit of having a unified view of customers?

A)More accurate customer data to support marketing,sales,support,and service initiatives.
B)Better responsiveness to ensure that customer service representatives have up-to-date,reliable information on the customers.
C)Faster transaction processing by organizing the data in one location.
D)Better revenue management and more responsive business decisions.

Question 7

According to the principle of __________,the more recent the data,the more valuable they are.

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

Question 8

A computer system organizes data into a hierarchy that begins with __________,which are the smallest unit of data a computer can process.

A)bits
B)attributes
C)fields
D)bytes

Question 9

Magnetic tape uses __________ file organization,whereas magnetic disks and DVDs use __________ file organization.

A)sequential;direct
B)primary;secondary
C)random;direct
D)random;sequential

Question 10

Although vendors may claim that their __________ solution creates "a single version of the truth," this claim is probably not true.

A)master data management
B)RFID
C)data mining
D)client/server

Question 11

According to the principle of __________,data must be integrated,processed,analyzed,and formatted into "actionable information."

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

Question 12

__________ is a structured approach for capturing,storing,processing,integrating,distributing,securing,and archiving data effectively throughout their life cycle.

A)Data mining
B)Data management
C)Metadata
D)Data visualization

Question 13

Customer name,invoice number,and order date are examples of __________.

A)attributes
B)bytes
C)sectors
D)primary keys

Question 14

What is the goal of data management?

A)To store data and documents in multiple locations to insure that they are accessible to everyone on demand.
B)To capture financial data in real-time from transactions and Web sites.
C)To provide the infrastructure and tools to transform raw data into usable corporate information of the highest quality.
D)To link databases of supply chain partners so all data can be shared.

Question 15

According to the principle of __________,a majority of data lose much of their value after three months.

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

Question 16

Records can be arranged in several ways on a storage medium.The arrangement of records determines:

A)how individual records can be accessed.
B)how long it takes to access records.
C)how individual records can be accessed and how long it takes to access them.
D)the storage media used for storage.

Question 17

__________ consists of powerful software tools to discover and extract knowledge from text documents.

A)Document mining
B)Master data management
C)Knowledge mining
D)Text mining

Question 18

In the healthcare industry,data errors __________.

A)increase healthcare costs by billions of dollars
B)have minimized healthcare costs
C)have no impact on patient care
D)have been eliminated by the use of data warehousing

Question 19

All companies create __________,which are documents that record business activities and functions such as contracts,research and development,accounting source documents,memos,and customer/client communications.

A)business records
B)transactions
C)computer files
D)databases

Question 20

Which of the following is not a reason why managers and information workers may be constrained by data?

A)data are incomplete
B)data are stored in a data warehouse
C)data are out of context
D)data are so overwhelming that they require too much time to analyze

Question 21

Which is not a characteristic of a data warehouse?

A)Data are organized by subject,such as customer,vendor,or product.
B)Data are coded in a consistent manner.
C)Data are kept for many years to be used for identifying trends,forecasting,and comparisons over time.
D)Most applications of data warehousing are in real-time.

Question 22

Despite their potential benefits,implementations of large data warehouses may fail.Reasons for data warehousing failures are all of the following except:

A)vendors overselling capabilities.
B)lack of attention to cultural issues.
C)poor data quality.
D)integration with operations.

Question 23

The credit card company Capital One uses __________ to track each customer's profitability and uses that score to determine the level of customer service.

A)OLTP
B)a centralized database
C)strategic database management systems
D)active data warehousing

Question 24

Being a smart company involves each of the following except:

A)having on-demand access to relevant data.
B)being able to understand the data,usually with the help of data visualization tools.
C)organizing data in a centralized database management system.
D)using what you learn from the data to increase productivity or profitability.

Question 25

Database management systems range in size and capabilities from the simple __________ to full-featured __________ solutions.

A)Microsoft Access;Oracle
B)Microsoft Excel;Microsoft Access
C)LANs;DB2
D)Oracle;DB2

Question 26

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

A)online transaction processing (OLTP)
B)online analytical processing (OLAP)
C)real-time transaction
D)ETL

Question 27

__________ programs can provide access to all organizational data and overcome many of the problems associated with data file environments.

A)Sequential data
B)Database management
C)Business record
D)ISAM

Question 28

A financial institution's databases are __________ because every deposit,withdrawal,loan payment,or other transaction adds or changes data,which makes data analysis __________.

A)poor quality;unnecessary
B)high quality;easy
C)volatile;too difficult
D)volatile;easy

Question 29

__________ for banking and debit cards are designed to ensure that every transaction gets recorded and processed online and in real-time.

A)File systems
B)Database systems
C)OLAP systems
D)Data warehouses

Question 30

An advantage of __________ is that they provide the response speed of localized files without the need to replicate all changes in multiple locations.

A)centralized databases
B)replicated databases
C)partitioned databases
D)file systems

Question 31

Advantages of data marts over data warehouses are all of the following except:

A)data marts require shorter lead times for implementation,often less than 90 days.
B)data marts allow for local rather than central control,giving end-users more power or control.
C)data marts have higher quality and more complete enterprise data.
D)data marts are easier to understand and navigate because they contain less data.

Question 32

Which is not an advantage and capability of a DBMS?

A)security
B)audit trail
C)backup
D)physical view

Question 33

__________ are facilities containing mission-critical ISs and components that deliver data and IT services to the enterprise.

A)Data servers
B)Data marts
C)Data centers
D)Data warehouses

Question 34

An extremely economical and effective method of delivering data from a data warehouse to decision makers throughout the enterprise is via __________.

A)data marts
B)data cubes
C)an intranet
D)operational data stores

Question 35

Disadvantages of centralized databases are all of the following except:

A)they are vulnerable to a single point of failure.
B)when users are widely dispersed and need data manipulations,they can experience transmission delays.
C)when the centralized database computer fails to function properly,all users are affected.
D)much more expensive to set up and maintain than a distributed database.

Question 36

Data warehousing is most appropriate for organizations that any of the following characteristics except:

A)end users need to access large amounts of data.
B)the organization serves a large,diverse customer base.
C)end-users perform a lot of data analysis.
D)operational data needed to support business processes are centralized.

Question 37

The main difference between a database and data warehouse is that:

A)databases are designed and optimized to store data,whereas data warehouses are designed and optimized to respond to analysis questions that are critical for a business.
B)databases are designed and optimized to analyze data,whereas data warehouses are designed and optimized to store data for sharing.
C)databases are designed to detect trends in the data,whereas data warehouses are designed to support supply chains.
D)databases are designed to support traditional commerce,whereas data warehouses are designed to support e-commerce.

Question 38

Which of the following statements about data warehousing is false?

A)Data in the data warehouse are constantly updated and volatile.
B)Many organizations built data warehouses because they were frustrated with inconsistent decision support data.
C)Data warehouses are infrastructure investments that companies make to support current and future decision making.
D)Data warehouses deliver information more effectively and efficiently than database systems.

Question 39

A(n)__________ is a database for transaction processing systems (TPSs)that uses data warehouse concepts to provide clean data.

A)data mart
B)operational data store
C)strategic data store
D)multidimensional database

Question 40

The high costs of data warehouses can make them too expensive for a company to implement.As an alternative,many firms create lower-cost,scaled-down __________.

A)data marts
B)data stores
C)multidimensional databases
D)SBUs

Question 41

Companies implement __________ systems to retain and archive their business records that are not needed for current operations or decisions,but that must be accessible for legal or auditing obligations.

A)electronic records management
B)database management
C)archive management
D)infrastructure management

Question 42

As businesses become more complex and their volumes of enterprise data expand rapidly,organizations are investing in master data management (MDM)as a way to isolate and archive different types of data.

Question 43

Data management is important because no enterprise can be effective without high quality data that is accessible when needed.

Question 44

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

Question 45

Businesses run on raw data.

Question 46

A spreadsheet mistake created an error that cost TransAlta $24 million because they bought power transmission hedging contracts at higher prices than it would have if the decision had been based on accurate information.

Question 47

Every day,healthcare administrators and others in the healthcare supply chain waste up to 10 percent of their time correcting data errors at an estimated cost of $20 per error to correct.

Question 48

When they are properly managed,electronic records are strategic assets.But when they are improperly managed or destroyed,they are liabilities to an organization.

Question 49

__________ is the process of finding,gathering,and filtering of electronic files and information in preparation for trial,legal or regulatory investigation,or administrative action as required by law.

A)Archiving
B)Discovery
C)Electronic discovery
D)Litigation

Question 50

Creating backups of records is not a form of electronic records management (ERM)because:

A)the content on backups is not organized so that it can be accurately and easily retrieved.
B)business records and documents may need to be modified.
C)records and documents cannot be stored together.
D)the requirement to save records is new.

Question 51

To be retrievable,a company's electronic records must be __________ like structured data in a database.

A)organized
B)indexed
C)organized and indexed
D)organized,indexed,and encrypted

Question 52

According to the market intelligence firm IDC,organizations with at least 1,000 knowledge workers lose over $5 million annually in time wasted by employees reformatting data as they move among applications.

Question 53

Data warehouses are designed as online analytical processing (OLAP)systems,meaning that the data can be queried and analyzed much more efficiently than OLTP application databases.

Question 54

According to the principle of 90/90 data use,most organizations cannot operate at peak performance with blind spots (lack of data availability)of 90 days or longer.

Question 55

Enterprise portals are a set of software applications that consolidate,manage,analyze,and transmit data to users through Web-based interface.

Question 56

Data that are accurate,timely,and clean might not be usable if people do not get data in the format they need to do their jobs.

Question 57

Nearly __________ percent of U.S.corporations become engaged in lawsuits and at any one time,the average $1 billion company in the U.S.faces 147 lawsuits.

A)25
B)50
C)75
D)90

Question 58

Although vendors may claim that their MDM solution creates "a single version of the truth," this claim is not true because constructing a completely unified view of all master data is simply not possible.

Question 59

A data mart is a small data warehouse designed for a strategic business unit (SBU)or a single department.

Question 60

Business records are different from documents in records cannot be modified or deleted,except in controlled circumstances.In contrast,documents generally are subject to revision.

Question 61

A(n)__________ is a specialized type of database that aggregates data from transaction databases so they can be analyzed.

Question 62

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

Question 63

Each record in a database needs an attribute (field)to uniquely identify it so that the record can be retrieved,updated,and sorted.This unique identifier field is called the __________.

Question 64

A program,such as Access and Oracle 11g,that provides access to databases is known as a(n)__________.

Question 65

__________(poor-quality data)lack integrity and cannot be trusted.

Question 66

__________ is the process of gathering electronic files and information in preparation for trial,legal or regulatory investigation,or administrative action as required by law.

Question 67

Although having high-quality data are essential for business success,numerous organizational and technical issues make it difficult to reach this objective.Give two reasons why companies don't achieve high-quality data.

Question 68

Data __________ refers to presenting data in context and in ways that are faster and easier for users to understand.

Question 69

Explain discovery and electronic discovery (e-discovery).Why do companies need to be prepared for discovery?

Question 70

What are three of the major data functions performed by a DBMS? Briefly explain the functions.

Question 71

__________ is a process whereby companies integrate data from various sources or enterprise applications to provide a more unified view of the data.

Question 72

__________ are resources with recognized value that are under the control of an individual or organization.

Question 73

Databases are online __________ systems in which every transaction has to be recorded quickly and correctly.

Question 74

Identify three data management problems arising from the file environment approach.Give an example of each problem.