Question 1

With structured query language (SQL):

Accepted Answer

A) One-to-one relationships can be determined. 
B) One-to-many relationships can be determined. 
C) Many-to-one relationships can be determined. 
D) All of the possibilities are correct. 
A) One-to-one relationships can be determined. 
B) One-to-many relationships can be determined. 
C) Many-to-one relationships can be determined. 
D) All of the possibilities are correct.

Question 2

While an employee may have access to privileged information, an example of unethical activities would be a

Accepted Answer

A) Nurse viewing the medications of the next patient. 
B) Car salesman viewing the credit rating of a customer with a car in for warranty repairs. 
C) Manager reviewing the hours worked of an assigned employee. 
D) Warehouseman viewing the availability of materials needed for production. 
A) Nurse viewing the medications of the next patient. 
B) Car salesman viewing the credit rating of a customer with a car in for warranty repairs. 
C) Manager reviewing the hours worked of an assigned employee. 
D) Warehouseman viewing the availability of materials needed for production.

Question 3

Drill down within OLAP is:

Accepted Answer

A) Identifying trends in the comparison of data in several databases. 
B) The aggregation or collection of similar data from several databases. 
C) The presentation of variances from the expected in dollar value. 
D) Is the successive expansion of data as lower levels of data are exposed. 
A) Identifying trends in the comparison of data in several databases. 
B) The aggregation or collection of similar data from several databases. 
C) The presentation of variances from the expected in dollar value. 
D) Is the successive expansion of data as lower levels of data are exposed.

Question 4

The purpose of the data warehouse does NOT include:

Accepted Answer

A) Giving managers rich sources of current trends and data. 
B) Storing current fiscal data and activity records. 
C) Providing sales with current customer information. 
D) Giving managers rich sources of historical trends and data. 
A) Giving managers rich sources of current trends and data. 
B) Storing current fiscal data and activity records. 
C) Providing sales with current customer information. 
D) Giving managers rich sources of historical trends and data.

Question 5

Which of the following best describes the relationship between data and information?

Accepted Answer

A) Data are interpreted information. 
B) Information is interpreted data. 
C) Data are more useful than information in decision making. 
D) Data and information are not related. 
A) Data are interpreted information. 
B) Information is interpreted data. 
C) Data are more useful than information in decision making. 
D) Data and information are not related.

Question 6

Data collected would be all but the:

Accepted Answer

A) Name of the customer. 
B) Selling company's name. 
C) Address of the customer. 
D) Credit card number of the customer. 
A) Name of the customer. 
B) Selling company's name. 
C) Address of the customer. 
D) Credit card number of the customer.

Question 7

Standardizing data:

Accepted Answer

A) Configures all of the data from one department into a single database for analysis. 
B) Configures all of the data from numerous departments into a single data configuration. 
C) Is not required within relational databases. 
D) Requires sales to keep its own files and references apart from marketing (example). 
A) Configures all of the data from one department into a single database for analysis. 
B) Configures all of the data from numerous departments into a single data configuration. 
C) Is not required within relational databases. 
D) Requires sales to keep its own files and references apart from marketing (example).

Question 8

Magnetic tape is a form of

Accepted Answer

A) Direct access media. 
B) Random access media. 
C) Sequential access media. 
D) Alphabetical access media. 
A) Direct access media. 
B) Random access media. 
C) Sequential access media. 
D) Alphabetical access media.

Question 9

Select the true statement from those provided below.

Accepted Answer

A) Managers use much the same data as operational departments to manage the organization. 
B) All users, managers, sales, production, utilize the features of a data warehouse equally. 
C) Data warehouses are isolated to protect operational information from unauthorized access. 
D) Managers require access to historical data this is generally not available to other individuals. 
A) Managers use much the same data as operational departments to manage the organization. 
B) All users, managers, sales, production, utilize the features of a data warehouse equally. 
C) Data warehouses are isolated to protect operational information from unauthorized access. 
D) Managers require access to historical data this is generally not available to other individuals.

Question 10

It is the ethical responsibility of employees:

Accepted Answer

A) To review customer records not as associated with their division for errors. 
B) Disclose customer data to related parties 
C) To collect only necessary data from customers 
D) To sell customer data to competitors. 
A) To review customer records not as associated with their division for errors. 
B) Disclose customer data to related parties 
C) To collect only necessary data from customers 
D) To sell customer data to competitors.

Question 11

A collection of several years' nonvolatile data used to support strategic decision-making is a (n)

Accepted Answer

A) Operational database. 
B) Data warehouse. 
C) Data mine. 
D) What-if simulation. 
A) Operational database. 
B) Data warehouse. 
C) Data mine. 
D) What-if simulation.

Question 12

Which of the following statement is not correct when considering the following statement: A "Where" condition within a structured query of a relational database:

Accepted Answer

A) Must be limited to a location such as "Warehouse #1." 
B) May establish a requirement where the results are equal to a specific value. 
C) May establish a requirement where the results are not equal to a specific value. 
A) Must be limited to a location such as "Warehouse #1." 
B) May establish a requirement where the results are equal to a specific value. 
C) May establish a requirement where the results are not equal to a specific value.

Question 13

Data within the data warehouse is:

Accepted Answer

A) Volatile - its release is restricted and potentially hazardous to the organization. 
B) Volatile - it may be deleted by specific users. 
C) Nonvolatile - it does not change rapidly. 
D) Nonvolatile - is protected against deletion. 
A) Volatile - its release is restricted and potentially hazardous to the organization. 
B) Volatile - it may be deleted by specific users. 
C) Nonvolatile - it does not change rapidly. 
D) Nonvolatile - is protected against deletion.

Question 14

In today's IT environment:

Accepted Answer

A) Processing speed is compromised for query capability with relational databases. 
B) Query capability is compromised for processing speed with relational databases. 
C) Neither querying nor processing speed need be compromised with relational databases. 
D) Both querying and processing speed are compromised with relational databases. 
A) Processing speed is compromised for query capability with relational databases. 
B) Query capability is compromised for processing speed with relational databases. 
C) Neither querying nor processing speed need be compromised with relational databases. 
D) Both querying and processing speed are compromised with relational databases.

Question 15

Real-time data item processing is more complex because:

Accepted Answer

A) It must utilize sequential storage medium. 
B) It must group data items together before processing. 
C) The slower response times indicate more systems activity. 
D) There is duplication of effort in processing transactions. 
A) It must utilize sequential storage medium. 
B) It must group data items together before processing. 
C) The slower response times indicate more systems activity. 
D) There is duplication of effort in processing transactions.

Question 16

Many companies use a Big Data storage and analysis system called_______.

Accepted Answer

A) Hulu 
B) Hadoop 
C) WAN 
D) HIPs 
A) Hulu 
B) Hadoop 
C) WAN 
D) HIPs

Question 17

Batch Processing correlates mostly to which of the following data storage techniques?

Accepted Answer

A) Sequential Access 
B) Random Access 
C) Database processing 
D) None of the Above 
A) Sequential Access 
B) Random Access 
C) Database processing 
D) None of the Above

Question 18

(Magnetic) Disk storage is:

Accepted Answer

A) Preferred over magnetic tape storage. 
B) Sequential access. 
C) Not random access. 
D) Not direct access. 
A) Preferred over magnetic tape storage. 
B) Sequential access. 
C) Not random access. 
D) Not direct access.

Question 19

An example of many-to-many relationship would be:

Accepted Answer

A) One customer for one billing date. 
B) Multiple customers for one inventory item. 
C) Multiple vendors for multiple items. 
D) One employee, three timecards for the pay period. 
A) One customer for one billing date. 
B) Multiple customers for one inventory item. 
C) Multiple vendors for multiple items. 
D) One employee, three timecards for the pay period.

Question 20

The data warehouse:

Accepted Answer

A) Contains five to ten years of historical data in detail for planning and analysis. 
B) Contains the current fiscal year in detail for planning, analysis, and reporting. 
C) Contains the historical information needed for planning and analysis. 
D) Is not utilized for planning and analysis, this information is extracted from the operational database. 
A) Contains five to ten years of historical data in detail for planning and analysis. 
B) Contains the current fiscal year in detail for planning, analysis, and reporting. 
C) Contains the historical information needed for planning and analysis. 
D) Is not utilized for planning and analysis, this information is extracted from the operational database.

With structured query language (SQL):

While an employee may have access to privileged information, an example of unethical activities would be a

Drill down within OLAP is:

The purpose of the data warehouse does NOT include:

Which of the following best describes the relationship between data and information?

Data collected would be all but the:

Standardizing data:

Magnetic tape is a form of

Select the true statement from those provided below.

It is the ethical responsibility of employees:

A collection of several years' nonvolatile data used to support strategic decision-making is a (n)

Which of the following statement is not correct when considering the following statement: A "Where" condition within a structured query of a relational database:

Data within the data warehouse is:

In today's IT environment:

Real-time data item processing is more complex because:

Many companies use a Big Data storage and analysis system called_______.

Batch Processing correlates mostly to which of the following data storage techniques?

(Magnetic) Disk storage is:

An example of many-to-many relationship would be:

The data warehouse:

Introduction to AIS

Foundational Concepts of the AIS

Fraud, Ethics, and Internal Control

Internal Controls and Risks in IT Systems

IT Governance

Enterprise Resource Planning ERP Systems

Auditing Information Technology-Based Processes

Revenue and Cash Collection Processes and Controls

Expenditures Processes and Controlspurchases

Expenditures Processes and Controlspayroll and Fixed Assets

Conversion Processes and Controls

Administrative Processes and Controls

E-Commerce and E-Business

Filters

Exam 13: Data and Databases

With structured query language (SQL):

While an employee may have access to privileged information, an example of unethical activities would be a

Drill down within OLAP is:

The purpose of the data warehouse does NOT include:

Which of the following best describes the relationship between data and information?

Data collected would be all but the:

Standardizing data:

Magnetic tape is a form of

Select the true statement from those provided below.

It is the ethical responsibility of employees:

A collection of several years' nonvolatile data used to support strategic decision-making is a (n)

Which of the following statement is not correct when considering the following statement: A "Where" condition within a structured query of a relational database:

Data within the data warehouse is:

In today's IT environment:

Real-time data item processing is more complex because:

Many companies use a Big Data storage and analysis system called_______.

Batch Processing correlates mostly to which of the following data storage techniques?

(Magnetic) Disk storage is:

An example of many-to-many relationship would be:

The data warehouse:

Introduction to AIS

Foundational Concepts of the AIS

Fraud, Ethics, and Internal Control

Internal Controls and Risks in IT Systems

IT Governance

Enterprise Resource Planning ERP Systems

Auditing Information Technology-Based Processes

Revenue and Cash Collection Processes and Controls

Expenditures Processes and Controlspurchases

Expenditures Processes and Controlspayroll and Fixed Assets

Conversion Processes and Controls

Administrative Processes and Controls

E-Commerce and E-Business

Filters