Question 1

Describe a data warehouse and the purpose.

Accepted Answer

The answer of Describe a data warehouse and the purpose....

Question 2

Describe the difference between a data warehouse and an operational data base.Also explain how data is added or changed within these two types of databases.

Accepted Answer

The answer of Describe the difference between a data warehouse...

Question 3

Ethical responsibilities are shared by:
A)Company employees only.
B)Company employees and management only.
C)Company employees, IT, and management only.
D)All concerned including employees, customers, and management.

Accepted Answer

Ethical responsibilities are not limited to a particular group of people. All stakeholders, including employees, customers, and management, have a responsibility to act ethically. It is the duty of each and every individual to act with integrity and honesty in all business dealings.

Question 4

Proper IT controls will NOT:
A)Prevent a hacker from penetrating the firewall.
B)Prevent an unauthorized user from using the computer systems.
C)Restrict employee access to any information.
D)Prevent an employee from sharing his password.

Accepted Answer

Proper IT controls cannot prevent an employee from sharing their password, as this is a behavioral issue rather than a technical one.

Question 5

Data is becoming more varied and now includes each of the following EXCEPT:
A)Text messages.
B)Photos and videos.
C)Meetings.
D)Tweets.

Accepted Answer

Meetings are events or occurrences, not data in themselves. However, data can be generated from meetings, such as meeting notes, agendas, and recordings.

Question 6

A bank would consider which of the following as nonprivate information?
A)Customer name.
B)Customer address if the customer is a business.
C)Customer phone number if it is listed number.
D)All of the answers are correct.

Accepted Answer

Nonprivate information can include customer names, addresses (especially for businesses), and listed phone numbers, as these can be found in public directories or records.

Question 7

Which of the following is not true of data visualization?
A)It is a tool for analyzing data
B)It is a way to provide data in charts, graphs, maps, and other graphics
C)It is a replacement for Big Data
D)It allows companies to more easily outline data trends

Accepted Answer

Data visualization is a tool used to present and analyze data in a visual format, such as charts, graphs, and maps. It is not a replacement for big data, but rather a way to make big data more accessible and understandable.

Question 8

Volume refers to:
A)How quickly data is generated or changed.
B)How many data types and sources are available. 
C)The size and capacity of the data.
D)The sound sensitivity of the data network.

Accepted Answer

Volume refers to the size and capacity of the data, not how quickly it is generated or changed, not how many data types and sources are available, and not the sound sensitivity of the data network.

Question 9

Database security includes all EXCEPT:
A)Password protection.
B)Encryption
C)LAN structure.
D)Firewalls.

Accepted Answer

LAN structure does not directly affect the security of the database. The other options provide important security measures for protecting data in a database.

Question 10

The prevention of industrial espionage is aided by all EXCEPT:
A)Password protection
B)Smart cards.
C)Federal and state laws.
D)Encryption of data.

Accepted Answer

While password protection, smart cards, and encryption of data all play important roles in preventing industrial espionage, federal and state laws cannot aid in preventing espionage. However, they can assist in prosecuting those who are caught engaging in espionage activities.

Question 11

Ethical issues associated with data collection and storage include all of the following EXCEPT:
A)Collecting only the necessary information for the transaction.
B)Selling non-sensitive information only to trusted agents.
C)Correcting errors in data as quickly as possible.
D)Precluding unnecessary access of customer data by employees.

Accepted Answer

Collecting only the necessary information (A), correcting errors quickly (C), and preventing unnecessary access by employees (D) are all practices that align with ethical standards in data management. Selling non-sensitive information, even only to trusted agents (B), however, can still raise ethical concerns regarding privacy and consent, making it the exception.

Question 12

While an employee may have access to privileged information, an example of unethical activities would be a
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.

Accepted Answer

The car salesman viewing the credit rating of a customer with a car in for warranty repairs is an example of unethical activity as it is not relevant to the repair of the car and breaches the customer's privacy. The other options given do not necessarily involve breaching privacy or potential harm to a third party.

Question 13

It is the ethical responsibility of employees:
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.

Accepted Answer

It is the ethical responsibility of employees to collect only necessary data from customers. This ensures that customer privacy is maintained and their personal data is not being misused or disclosed unnecessarily. Reviewing customer records not associated with their division for errors can also be important, but it should be done within the bounds of their job responsibilities and not as a means of accessing confidential customer information. Disclosing customer data to related parties without the appropriate permissions is a violation of customer privacy and is unethical. Selling customer data to competitors is a breach of trust and is illegal in many jurisdictions.

Question 14

When a company buys data storage from a cloud provider, the arrangement is referred to as:
A)Online analytical processing
B)Cloud services assessment
C)Distributed data storage
D)Database as a service

Accepted Answer

The term "database as a service" (DBaaS) refers to the practice of using a third-party provider to manage and maintain a company's database infrastructure. This can include everything from data storage to backup and recovery, and can be a cost-effective way to ensure data is secure and accessible.

Question 15

Many companies use a Big Data storage and analysis system called_______.
A)Hulu
B)Hadoop
C)WAN
D)HIPs

Accepted Answer

Hadoop is a widely used framework that allows for the distributed storage and processing of large data sets across clusters of computers using simple programming models. Hulu is a streaming service, WAN stands for Wide Area Network, and HIPs is not commonly associated with big data storage and analysis.

Question 16

The advantages of cloud-based computing includes all of the following, EXCEPT:
A)Scalability - as the company grows, it can easily purchase additional capacity.
B)Expanded access - once the data are store in the cloud, it can be accessed by multiple devices form different locations.
C)Increased infrastructure - the company has more need for servers and data storage.
D)Cost savings - because of the advantages related to cloud-based computing, there are usually significant cost savings recognized.

Accepted Answer

Increased infrastructure is not an advantage of cloud-based computing, as this simply increases the need for servers and data storage, which may not necessarily be cost-effective or efficient. The other options (A, B, and D) are all advantages of cloud-based computing.

Question 17

The three major concerns related to database control and security do NOT include:
A)Unauthorized access.
B)Inadequate backup.
C)Data integrity.
D)Adequate backup.

Accepted Answer

The answer of The three major concerns related to database...

Question 18

Briefly describe the problems regarding data redundancy and concurrency in older methods of data storage (such as in flat-file data bases).Also describe how a relational database eliminates redundancy and concurrency problems.

Accepted Answer

The answer of Briefly describe the problems regarding data redundancy...

Quiz 13: Data and Databases

Describe a data warehouse and the purpose.

Describe the difference between a data warehouse and an operational data base.Also explain how data is added or changed within these two types of databases.

Ethical responsibilities are shared by:

Proper IT controls will NOT:

Data is becoming more varied and now includes each of the following EXCEPT:

A bank would consider which of the following as nonprivate information?

Which of the following is not true of data visualization?

Volume refers to:

Database security includes all EXCEPT:

The prevention of industrial espionage is aided by all EXCEPT:

Ethical issues associated with data collection and storage include all of the following EXCEPT:

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

It is the ethical responsibility of employees:

When a company buys data storage from a cloud provider, the arrangement is referred to as:

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

The advantages of cloud-based computing includes all of the following, EXCEPT:

The three major concerns related to database control and security do NOT include:

Briefly describe the problems regarding data redundancy and concurrency in older methods of data storage (such as in flat-file data bases).Also describe how a relational database eliminates redundancy and concurrency problems.