Question 1

(Magnetic)  Disk storage is:

Accepted Answer

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

Question 2

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.

Question 3

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.

Question 4

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.

Question 5

Magnetic tape is a form of

Accepted Answer

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

Question 6

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.

Question 7

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.

Question 8

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.

Question 9

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.

Question 10

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.

Question 11

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.

Question 12

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

Question 13

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

Question 14

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.

Question 15

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

Accepted Answer

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

Question 16

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.

Question 17

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.

Question 18

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.

Question 19

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.

Question 20

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.

Exam 13: Data and Databases

Drill down within OLAP is:

Correct AnswerverifiedShow Answer

Magnetic tape is a form of

Correct AnswerverifiedShow Answer

Select the true statement from those provided below.

Correct AnswerverifiedShow Answer

The data warehouse:

Correct AnswerverifiedShow Answer

With structured query language (SQL) :

Correct AnswerverifiedShow Answer

The purpose of the data warehouse does NOT include:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Standardizing data:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In today's IT environment:

Correct AnswerverifiedShow Answer

Data collected would be all but the:

Correct AnswerverifiedShow Answer

It is the ethical responsibility of employees:

Correct AnswerverifiedShow Answer

(Magnetic) Disk storage is:

Correct AnswerverifiedShow Answer

Data within the data warehouse is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Real-time data item processing is more complex because:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified