Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

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?

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

In terms of the major functions performed by a DBMS, "maintaining data integrity" refers to integrating, matching, or linking data from disparate sources.

Accepted Answer

A) True 
 B)False

Question 5

There are three kinds of enterprise data: Transactional data, _____________ data and Analytical data.

Accepted Answer

The answer of There are three kinds of enterprise data:...

Question 6

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?

Accepted Answer

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

Question 7

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.

Accepted Answer

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

Question 8

Business intelligence BI) 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.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

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

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

The principle of ________________ suggests that a majority of data is seldom accessed after a 3 month period.

Accepted Answer

The answer of The principle of ________________ suggests that a...

Question 14

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

Accepted Answer

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

Question 15

Systems designed to manage volatile transaction data are called _________________________.

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The answer of Data generated by business apps, sensors, and...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Tweets and Facebook status updates are typical examples of "structured data" stored in databases.

Accepted Answer

A) True 
 B)False

Question 20

Many database management systems use __________________ for programming queries.

Accepted Answer

Structured

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

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?

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

In terms of the major functions performed by a DBMS, "maintaining data integrity" refers to integrating, matching, or linking data from disparate sources.

There are three kinds of enterprise data: Transactional data, _____________ data and Analytical data.

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.

Business intelligence BI) 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.

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

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

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

The principle of ________________ suggests that a majority of data is seldom accessed after a 3 month period.

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

Systems designed to manage volatile transaction data are called _________________________.

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

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

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

Tweets and Facebook status updates are typical examples of "structured data" stored in databases.

Many database management systems use __________________ for programming queries.

A Look Toward the

Information Management and It Architecture

Networks, Collaboration, and Sustainability

Cybersecurity, Compliance, and Business Continuity

E-Commerce Models and Strategies

Mobile Technologies and Commerce

Web 2.0 and Social Media

Functional Area and Compliance Systems

Enterprise Systems and Applications

Performance Management Using Data Visualization, Mashups, and Mobile Intelligence

It Strategy, Sourcing, and Vendor Relationships

Business Process and Project Management

Global Ecology, Ethics, and Social Responsibility

Filters

Exam 3: Database, Data Warehouse, and Data Mining

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

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?

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

In terms of the major functions performed by a DBMS, "maintaining data integrity" refers to integrating, matching, or linking data from disparate sources.

There are three kinds of enterprise data: Transactional data, _____________ data and Analytical data.

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.

Business intelligence BI) 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.

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

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

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

The principle of ________________ suggests that a majority of data is seldom accessed after a 3 month period.

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

Systems designed to manage volatile transaction data are called _________________________.

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

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

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

Tweets and Facebook status updates are typical examples of "structured data" stored in databases.

Many database management systems use __________________ for programming queries.

A Look Toward the

Information Management and It Architecture

Networks, Collaboration, and Sustainability

Cybersecurity, Compliance, and Business Continuity

E-Commerce Models and Strategies

Mobile Technologies and Commerce

Web 2.0 and Social Media

Functional Area and Compliance Systems

Enterprise Systems and Applications

Performance Management Using Data Visualization, Mashups, and Mobile Intelligence

It Strategy, Sourcing, and Vendor Relationships

Business Process and Project Management

Global Ecology, Ethics, and Social Responsibility

Filters