Deck 3: Database, Data Warehouse, and Data Mining

Question 1

Many database management systems use the ______________________ for programming queries.

A) Syntax Query Language SQL)
B) Structured Query Language SQL)
C) Statistical Query Language SQL)
D) Standard Query Language SQL)

Answer 1

B

Question 2

___________________ technology is used to archive the growing amount of physical data

A) Document management
B) USB drive
C) File management
D) Mashup
E)g. paper forms, letters, contracts, etc.) and digital data to meet business needs, as well as regulatory and legal requirements.

Answer 2

A

Question 3

In terms of IS dependability, _________________data management technologies means zero-downtime, zero data loss, and continuous access to data, analytics, and reporting.

A) Redundant process
B) Priority process
C) Fault tolerant
D) High performance

Answer 3

C

Question 4

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

A) Databases
B) Data warehouses
C) Data collectors
D) Data silos

Question 5

Systems designed to manage volatile transaction data are called _________________________.

A) Volatile data management VDM) systems
B) Online transaction processing OLTP) systems
C) Online analytical processing OLAP) systems
D) Transaction analysis TA) systems

Question 6

What are the two basic types of databases?

A) Simple and complex
B) Static and dynamic
C) Centralized and distributed.
D) Transaction and analytical

Question 7

__________________ refers to an organization's ability to get information to the people who need it to make decisions or react appropriately to business events.

A) Business Intelligence
B) Operational intelligence
C) Information Accessibility
D) Information Fluidity

Question 8

In a distributed database configuration, the computers and mobile devices that access data from remote servers are called ________________.

A) Servers
B) Query Tools
C) Clients
D) Computing accesories

Question 9

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

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

Question 10

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

A) Databases
B) Data warehouses
C) Data marts
D) Data silos

Question 11

_____________________ tools and techniques process data and do statistical analysis for insight and discovery-that is, to discover meaningful relationships in the data, keep informed of real time, gain insight, detect trends, and identify opportunities and risks.

A) Metric analysis
B) Market research
C) Business intelligence BI)
D) Pattern recognition

Question 12

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

A) Report
B) Analysis
C) Digest
D) Query

Question 13

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

A) Distributed database system
B) Portable database system
C) Flexible database system
D) Centralized database system

Question 14

An) ________________ stores all related files in one physical location.

A) Centralized database
B) Simple database
C) Static database
D) Analytical database

Question 15

The primary benefits of centralized database configuration are better _____________ and ________________.

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

Question 16

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

A) OLTP - Online Transaction Processing
B) Data mining
C) Business Intelligence BI)
D) Decision support

Question 17

________________________ are computer programs used to manage additions, updates, and deletions of data in a database as transactions occur; and support data queries and reporting.

A) Database management systems DBMS)
B) Data warehouse management systems DWMS)
C) Data silo management systems DSMS)
D) Data mart management systems DMMS)

Question 18

The primary disadvantage of centralized database configurations is

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

Question 19

Distributed databases use an) _____________ architecture to process information requests.

A) Client/server
B) Unstructured
C) High speed
D) Select Query SQ)

Question 20

Databases are optimized for extremely fast processing of ____________-or ad hoc user requests for specific data.

A) Reports
B) Decision support
C) Queries
D) Statistical analysis

Question 21

In terms of the major functions performed by a DBMS, data synchronization refers to which of the following?

A) Correcting, standardizing, and verifying the integrity of the data.
B) Integrating, matching, or linking data from disparate sources.
C) Enhancing data using information from internal and external data sources.
D) Checking and controlling data integrity over time.

Question 22

According to your text, which of the following is not a major data function performed by a DBMS?

A) Data filtering and profiling
B) Data integrity
C) Data synchronization
D) Data analysis

Question 23

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 24

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) Multi-source data file
B) Master reference file
C) Maximized data file
D) Mission central directory

Question 25

There are three kinds of enterprise data. Which of the following is not one of the types of enterprise data identified in your text?

A) Transactional data
B) Master data
C) Functional data
D) Analytical data

Question 26

According to your text, ___________________ are responsible for increasing the cost of health care by billions of dollars, not to mention, putting lives at risk.

A) Data errors
B) Physicians who refuse to convert paper files to digital files
C) Outdated computers
D) Untrained or under-trained medical staff

Question 27

In terms of the major functions performed by a DBMS, data enrichment refers to which of the following?

A) Correcting, standardizing, and verifying the integrity of the data.
B) Integrating, matching, or linking data from disparate sources.
C) Enhancing data using information from internal and external data sources.
D) Checking and controlling data integrity over time.

Question 28

In terms of the major functions performed by a DBMS, "maintaining data integrity" refers to which of the following?

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

Question 29

A majority of data is seldom accessed after a 3 month period. Which of the following principles is based on this observation?

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

Question 30

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. According to your text, what three 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 31

Data in databases are said to be volatile because ____________________.

A) Faulty data storage technology sometimes overwrites or deletes data accidently.
B) Of issues related primarily to "human error".
C) Of rounding errors or software apps that lack the appropriate precision when making calculations.
D) Data is constantly being added or updated by new transactions.

Question 32

In terms of the major functions performed by a DBMS, data maintenance refers to which of the following?

A) Correcting, standardizing, and verifying the integrity of the data.
B) Integrating, matching, or linking data from disparate sources.
C) Enhancing data using information from internal and external data sources.
D) Checking and controlling data integrity over time.

Question 33

The data ____________________ is a model that illustrates the way in which data moves through an organization.

A) Life cycle
B) Pathway
C) Flow chart
D) Flow plan

Question 34

Which of the following is not one of the costs of "dirty" or poor quality data cited in your text?

A) Value of lost business
B) Cost to prevent errors
C) Cost to correct errors
D) Cost of repeating analyses on corrected data)

Question 35

Which of the following is not a stage in the data life cycle model?

A) Data sources and data bases
B) Data storage
C) Data cleaning and verification
D) Data analysis

Question 36

Because of data _______________ in a database that is constantly being updated with real-time transactions, data must be exported to a data warehouse prior to data mining, use by DSS apps and business intelligence analyses.

A) Chaos
B) Errors
C) Volatility
D) Security

Question 37

__________________________ 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) Universal data management UDM)
B) Unified data management UDM)
C) Master data management MDM)
D) Integrated data management IDM)

Question 38

Most organizations cannot operate at peak performance with blind spots lack of data availability) of 30 days or longer. For instance, many global financial services institutions need near real time data for peak performance. This is due to which of the following principles?

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

Question 39

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 40

The process of moving data from a transactional database to a data warehouse can be complex because of the need to integrate data from multiple sources or enterprise applications. _____________ serves as a layer between transactional data in a database and analytical data in a data warehouse.

A) Transient data
B) Master data
C) Integrated data
D) Unified data

Question 41

__________________ is the process of analyzing large sets of data to find patterns, correlation, trends, or other meaningful relationships that can be used to increase revenues, decrease costs, or both.

A) Statistical analysis
B) Data mining
C) Business Intelligence BI)
D) Business analysis

Question 42

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 43

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

A) Data marts
B) Enterprise data warehouses EDW)
C) Transaction data warehouses TDW)
D) Universal data warehouses UDW)

Question 44

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

A) Statistical analysis programs
B) Data mining tools
C) Business Intelligence BI) Systems
D) Business analysis tools

Question 45

Databases that receive real-time transaction data are called Online Transaction Processing OTLP) systems. Data is then transferred to data warehouses, known as ______________________ for further analysis.

A) Data Cloud Storage DCS) Systems
B) Online Analytical Processing OLAP) Systems
C) Online Batch Processing OLBP) Systems
D) Online Metric Processing OLMP) Systems

Question 46

________________ unites data, technology, analytics, and human knowledge to optimize business decisions by transforming data into usable, actionable business information.

A) Strategic business analysis
B) Strategic planning
C) Business Intelligence BI)
D) Strategic modeling

Question 47

When a customer calls an organization's customer service center, the service representative has access to a complete history of the customer's previous calls as well as a list of the services they have purchased and a 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 ADW)
D) Online Transaction Processing OLTP) System

Question 48

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

A) Online analytical processing OLAP)
B) Online transaction processing OLTP)
C) Dynamic Data
D) Stable Data Analytic SDA)

Question 49

A recent trend in the field of Business Intelligence BI) involves mining very large data sets that come from billions upon billions of recorded transactions, social media interactions and records of individual user online activities. The trend in using these very large data sets is known as ____________.

A) Global data
B) Universal data
C) Vast data
D) Big data

Question 50

Organizations often store data in applications with the following characteristics: -Designed and optimized to ensure that every transaction gets recorded and stored immediately.
-Volatile because data are constantly being updated, added, or edited.
-Online transaction processing OLTP) systems because transactions must be recorded and processed as they occur, in real time.
These three characteristics best describe which of the following?

A) Decision Support System
B) Management Information System
C) Database System
D) Data warehouse or Data Mart

Question 51

Because the high costs of a data warehouse can make them too expensive for a company to operate, some organizations turn to an alternative, called an) _______________ which is smaller, less expensive and designed to serve the needs of a specific SBU, department or function, such as finance, marketing, or operations.

A) Analytical database
B) Data backup system
C) Operational data store
D) Data mart

Question 52

What is the key advantage of an active data warehouse ADW) 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 information than a traditional data warehouse
D) The ADW is more widely available from a larger number of vendors

Question 53

_________________ is are) 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.

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

Question 54

Because of the very large amount of data and the costs associated with BI applications, small and mid-sized companies with limited IT staff and budgets sometimes use a new BI architecture called _______________ .

A) Pre-defined BI models
B) Limited feature BI tools
C) BI in the cloud
D) Simple BI

Question 55

According to a study conducted by MIT Sloan Management Review and IBM, top performing companies use BI and business analytics for both tactical financial insights

A) Developing competitive advantages
B) Tracking social media activity
C) Analyzing use of company website
D) Tracking employee productivity
E)g. forecasting, budgeting and supply chain management) as well as strategic issues like _____________________.

Question 56

Organizations often store data in applications with the following characteristics: -Designed and optimized for analysis and quick response to queries.
-Are nonvolatile, which means that when data are stored, they can be read only and never deleted so that they can be used for comparison with newer data.
-Online analytic processing OLAP) systems
-Subject-oriented, which means that the data captured is organized to have similar data linked together.
These four characteristics best describe which of the following?

A) Decision Support System
B) Management Information System
C) Database System
D) Data warehouses or Data Marts

Question 57

A 2011 study by MIT Sloan Management Review and IBM studied over 4500 firms and their use of BI and business analytics. Which of the following was not cited in your text as one of the study's findings?

A) Top-performing organizations use analytics five times more than lower performers.
B) There is widespread belief that analytics offers value.
C) Approximately 1/3 34%) of the respondents indicated they were planning to reduce expenditures related to BI and business analytics because of high costs.
D) Half of the respondents said that improvement of information and analytics was a top priority in their organizations.

Question 58

An) _____________________ is a database for transaction processing systems that uses data warehouse concepts to provide clean data. It is used for short-term decisions involving mission-critical applications rather than for the medium- and long-term decisions associated with the regular data warehouse.

A) Analytical database
B) Data backup system
C) Operational data store
D) Data mart

Question 59

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 for real-time data warehousing so that analysis and decision support apps are able to use the most current data. These new types of data warehouses are called _____________________.

A) Active Data Warehouse ADW)
B) Always-on Data Warehouse ADW)
C) Dynamic Data Warehouse DDW)
D) 24/7 Data Warehouse

Question 60

Because of volatility, data from databases are transferred to a ________________ so that they are ready for quick responses to inquiries.

A) Statistical engine
B) Data repository
C) Data cloud
D) Data warehouse

Question 61

Companies in some industries are required by law to retain financial documents for at least seven years. In large companies, being able to locate and retrieve documents from previous years can be extremely challenging, not to mention the logistical challenge associated with warehousing large amounts of paper. Increasingly, companies that face these challenges are turning to _______________.

A) Digital Document Systems DDS)
B) Regulated Document Storage Systems RDSS)
C) Document Filing Systems DFS)
D) Document management systems DMS)

Question 62

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

Question 63

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

Question 64

According to a recent 2012) study of 176 organizations worldwide by Aberdeen, the volume of physical documents is expected to ______________________.

A) Increase by 30% per year
B) Increase slightly over the next 5 years
C) Remain about the same for the next 5 years
D) Decrease by 30% per year due to digitalization technologies

Question 65

____________________________ consist of hardware and software that manage and archive electronic documents and also convert paper documents into edocuments and then index and store them according to company policy.

A) Paper scanning systems PSS)
B) Document management systems DMS)
C) Document Filing Systems DFS)
D) Digital Document Systems DDS)

Question 66

Companies have always faced the challenge of managing physical documents. However, the most significant current challenge involves ___________________.

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 67

Which of the following was not listed in your text as a benefit experienced by organizations that use a Document Management System DMS)?

A) Enables the company to access and use the content contained in the documents
B) Cuts labor costs by automating business processes
C) Significantly reduces the use of paper documents and physical records
D) Reduces the time and effort required to locate information the business needs to support decision making

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

Which of the following was not listed in your text as a benefit experienced by organizations that use a Document Management System DMS)?

A) Reduction in the cost of discarding documents securely i.e. shredding, destroying, disposal)
B) Enabling the company to access and use the content contained in the documents
C) Improving the security of the content, thereby reducing the risk of intellectual property theft
D) Minimizing the costs associated with printing, storing, and searching for content

Question 73

Databases are optimized for extremely fast processing of queries -or ad hoc user requests for specific data.

Question 74

In terms of IS dependability, fault tolerant data management technologies means zero-downtime, zero data loss, and continuous access to data, analytics, and reporting.

Question 75

Which of the following was not listed in your text as a major document management tool?

A) Workflow software
B) Authoring tools
C) Databases
D) eReader Devices

Question 76

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

Question 77

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

Question 78

Document management technology archives digital and physical data to meet business needs, as well as regulatory and legal requirements.

Question 79

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

Question 80

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