Question 1

Data warehouses are composed entirely of proprietary corporate data, while data marts take advantage of data purchased from third-party firms.

Accepted Answer

Data warehouses can contain data from both proprietary and third-party sources, while data marts are typically focused on a specific area or department and may utilize only a subset of the organization's data.

Question 2

Conventional database technologies often choke when trying to sift through the massive amounts of data collected by many of today's firms, leading to the rise of Hadoop and other "Big Data" technologies.

Accepted Answer

Conventional database technologies are not designed to handle the volume, velocity, and variety of Big Data that many firms are collecting today, which has led to the rise of specialized Big Data technologies like Hadoop.

Question 3

Why do many organizations have data that cannot be converted to actionable information? What are the hurdles faced by firms that attempt to query transactional databases?

Accepted Answer

The answer of Why do many organizations have data that...

Question 4

The three Vs of "Big Data" are _____,_____, and ______; characteristics that distinguish it from conventional data analysis problems and require a new breed of technology.

Accepted Answer

The answer of The three Vs of "Big Data" are...

Question 5

In data warehousing projects, it is not uncommon for spending on consulting and services to cost five times or more than the cost of the technology itself.

Accepted Answer

Consulting and services are often required for data warehousing projects to properly design, implement, and maintain the technology. These services can be expensive, sometimes costing five times or more than the cost of the technology itself.

Question 6

Why do firms need to create separate data repositories for their reporting and analytics work?
A) Most firms store their data assets offsite to insure themselves against the possibility of data damage through natural disasters.
B) Maintaining huge databases can be a cost-sink for most firms.
C) Most organizations need to differentiate data derived in-house and from data aggregators.
D) Running analytics against transactional data can bog down a TPS.
E) Reporting and analytics are two separate functions, each requiring its own separate database specifically formatted to the needs of the management team.

Accepted Answer

Running analytics against transactional data can slow down the Transaction Processing System (TPS) and affect its performance. Therefore, creating a separate data repository for reporting and analytics work can prevent the TPS from being bogged down and ensure efficient and effective reporting and analysis.

Question 7

How is The EchoNest (part of Spotify) leveraging big data for a better music experience?

Accepted Answer

The answer of How is The EchoNest (part of Spotify)...

Question 8

The open-source project known as ____________ was created to analyze massive amounts of raw information better than traditional, highly structured databases.

Accepted Answer

The answer of The open-source project known as ____________ was...

Question 9

_____ systems are often used to empower employees to track and record data at nearly every point of customer contact.

Accepted Answer

The answer of _____ systems are often used to empower...

Question 10

Which of the following is not considered an advantage of Hadoop?
A) flexibility.
B) relational structure.
C) scalability.
D) cost effectiveness.
E) fault tolerance.

Accepted Answer

Hadoop is not known for its relational structure as it is a distributed file system that is designed to handle unstructured and semi-structured data. The other options, flexibility, scalability, cost effectiveness, and fault tolerance are widely considered advantages of Hadoop.

Question 11

Systems that can absorb any type of data, structured or not, from any type of source are often called schema-less.

Accepted Answer

Schema-less systems do not require a pre-defined structure for the data being processed and can handle different types of data from various sources.

Question 12

Most transactional databases are not set up to be simultaneously accessed for reporting and analysis. As a consequence:
A) navigational databases are being preferred over transactional databases.
B) data is not efficiently transformed into information.
C) firms prefer to outsource data mining operations to third-party firms.
D) analysts must also become transactional specialists.
E) most firms incur additional expenditure to effectively record transactions.

Accepted Answer

Since transactional databases are not optimized for reporting and analysis, it can be difficult and time-consuming to extract meaningful information from them. This can lead to inefficiencies in data utilization, and it is often necessary to transform the data to a more suitable format for reporting and analysis purposes.

Question 13

Systems that can absorb any type of data, structured or not, from any type of source are often called schema-less.

Accepted Answer

Schema-less systems do not require a predefined schema or data model for the data they consume, and can easily accommodate structured, semi-structured, and unstructured data from diverse sources.

Question 14

Systems that record a transaction (some form of business-related exchange), such as a cash register sale, ATM withdrawal, or product return are referred to as _____.

Accepted Answer

The answer of Systems that record a transaction (some form...

Question 15

E-discovery refers to:
A) identifying and retrieving relevant electronic information to support litigation efforts.
B) something a firm does not account for in its archiving and data storage plans.
C) older information systems that are often incompatible with other systems, technologies, and ways of conducting business.
D) collecting and reselling data.
E) rewards and usage incentive, typically in exchange for a method that provides a more detailed tracking and recording of consumer activity.

Accepted Answer

E-discovery is the process of identifying and retrieving relevant electronic information to support litigation and other legal efforts. This includes locating and securing digital evidence, such as emails, instant messages, documents, and social media posts, that may be relevant to a legal case.

Question 16

Turning data into useable information is hindered by transactional databases set up to be simultaneously accessed for reporting and analysis.

Accepted Answer

Transactional databases are primarily designed for operations such as insert, update, delete, or retrieve data items; they are not inherently hindered in turning data into usable information for reporting and analysis. However, for complex reporting and analysis, data is often moved to specialized systems (like data warehouses) that are optimized for these tasks, but this does not mean transactional databases hinder the process.

Question 17

_____ refer to older information systems that are often incompatible with other systems, technologies, and ways of conducting business.
A) Data aggregator systems
B) Loyalty card systems
C) Legacy systems
D) Transaction systems
E) Mnemonic systems

Accepted Answer

Legacy systems refer to older information systems that are often incompatible with other systems, technologies, and ways of conducting business.

Question 18

Briefly describe the different sources of enterprise data for firms.

Accepted Answer

The answer of Briefly describe the different sources of enterprise...

Question 19

_____ refer to databases focused on addressing the concerns of a specific problem or business unit.
A) Data marts
B) Dashboards
C) Hadoop
D) Data aggregators
E) Data analytics

Accepted Answer

Data marts refer to databases that are focused on addressing the concerns of a specific problem or business unit, and are designed to provide quick access to relevant data for analysis and decision-making. Dashboards are visual representations of data that provide quick and easy access to key performance indicators (KPIs) and other metrics. Hadoop is a framework for distributed storage and processing of large datasets. Data aggregators collect and distribute data from multiple sources. Data analytics involves using statistical and other methods to analyze data and extract insights from it. Only data marts are a specific type of database focused on addressing the concerns of a specific problem or business unit.

Question 20

_____ is the term used to describe some form of business exchange.

Accepted Answer

The answer of _____ is the term used to describe...

Quiz 15: The Data Asset: Databases, Business Intelligence, Analytics, Big Data, and Competitive Advantage

Data warehouses are composed entirely of proprietary corporate data, while data marts take advantage of data purchased from third-party firms.

Conventional database technologies often choke when trying to sift through the massive amounts of data collected by many of today's firms, leading to the rise of Hadoop and other "Big Data" technologies.

Why do many organizations have data that cannot be converted to actionable information? What are the hurdles faced by firms that attempt to query transactional databases?

The three Vs of "Big Data" are ___,_, and ____; characteristics that distinguish it from conventional data analysis problems and require a new breed of technology.

In data warehousing projects, it is not uncommon for spending on consulting and services to cost five times or more than the cost of the technology itself.

Why do firms need to create separate data repositories for their reporting and analytics work?

How is The EchoNest (part of Spotify) leveraging big data for a better music experience?

The open-source project known as ____________ was created to analyze massive amounts of raw information better than traditional, highly structured databases.

_____ systems are often used to empower employees to track and record data at nearly every point of customer contact.

Which of the following is not considered an advantage of Hadoop?

Systems that can absorb any type of data, structured or not, from any type of source are often called schema-less.

Most transactional databases are not set up to be simultaneously accessed for reporting and analysis. As a consequence:

Systems that can absorb any type of data, structured or not, from any type of source are often called schema-less.

Systems that record a transaction (some form of business-related exchange), such as a cash register sale, ATM withdrawal, or product return are referred to as _____.

E-discovery refers to:

Turning data into useable information is hindered by transactional databases set up to be simultaneously accessed for reporting and analysis.

_____ refer to older information systems that are often incompatible with other systems, technologies, and ways of conducting business.

Briefly describe the different sources of enterprise data for firms.

_____ refer to databases focused on addressing the concerns of a specific problem or business unit.

_____ is the term used to describe some form of business exchange.