Question 1

A data mart is a(n):

Accepted Answer

A data mart is a subset of a data warehouse that is focused on a specific functional area or business unit of an organization. It is smaller in scope than a data warehouse and usually contains only a subset of the data stored in the larger system.

Question 2

Informational systems are designed for all of the following EXCEPT:

Accepted Answer

A

Question 3

Which of the following data-mining techniques identifies clusters of observations with similar characteristics?

Accepted Answer

Clustering and signal processing is the data-mining technique which identifies clusters of observations with similar characteristics. Case reasoning involves making decisions based on past experiences, rule discovery involves identifying relationships between variables, and neural nets involve predicting outcomes based on input data.

Question 4

Which of the following advances in information systems contributed to the emergence of data warehousing?

Accepted Answer

Advances in middleware products that enabled enterprise database connectivity across heterogeneous platforms allowed for data to be collected from various sources and stored in a centralized data warehouse.

Question 5

Which of the following factors drive the need for data warehousing?

Accepted Answer

The need for data warehousing is driven by the need for an integrated view of company information, which allows businesses to make informed decisions based on a complete and accurate understanding of their data. Option B is partially correct as data warehousing involves keeping informational data separate from operational data. Option C and D are not drivers for data warehousing.

Question 6

Which of the following is true of data visualization?

Accepted Answer

Data visualization makes it easier to identify patterns, trends, and correlations in data. It presents data in a visual format that can be quickly scanned, making it useful for decision making. It is not typically used in conjunction with poetry.

Question 7

Which of the following data-mining techniques searches for patterns and correlations in large data sets?

Accepted Answer

Rule discovery is the data-mining technique that searches for patterns and correlations in large data sets. Case reasoning is a technique that uses past experiences to solve new problems. Signal processing deals with the analysis and manipulation of signals such as audio and video. Neural nets are a type of machine learning that try to mimic the way the brain works to identify patterns in data.

Question 8

Rotating the view of a multidimensional database for a particular data point is called data:

Accepted Answer

Rotating the view of a multidimensional database for a particular data point is called data pivoting. Data cubing involves creating a multi-dimensional cube of data, drill-down involves viewing more detailed data for a specific aspect, and dicing allows for viewing a subset of data based on specified dimensions. However, none of these options specifically refer to rotating the view of a multidimensional database.

Question 9

The characteristic that indicates that a data warehouse is organized around key high-level entities of the enterprise is:

Accepted Answer

A data warehouse that is organized around key high-level entities of the enterprise is subject-oriented. This means that the data warehouse is designed to support analysis of specific subject areas, rather than transaction processing or operational systems. By focusing on key entities, the data warehouse can provide a comprehensive view of the organization's activities and operations, allowing decision-makers to gain valuable insights and make informed decisions. The other characteristics of a data warehouse - integrated, time-variant, and nonvolatile - are important as well, but do not specifically relate to the organization of the data around high-level entities.

Question 10

OLAP tools that use the database as a traditional relational database are called:

Accepted Answer

ROLAP stands for Relational Online Analytical Processing, and these OLAP tools use a relational database as their data source. They create a multidimensional view of the data by executing SQL queries against the relational database, instead of storing the data in a separate multidimensional database like MOLAP tools do. Therefore, ROLAP tools offer greater flexibility in handling complex data and large volumes of data, and they can leverage existing SQL-based databases and BI tools.

Question 11

Operational and informational systems are generally separated because of which of the following factors?

Accepted Answer

Operational systems are designed to handle day-to-day transactions and support business processes, while informational systems (such as data warehouses) are designed to provide data for strategic decision-making. Separating these two types of systems allows for a focus on their respective purposes and prevents one system from interfering with the other. Additionally, a data warehouse centralizes data from various operational systems, making it easier for decision makers to access and analyze the data they need.

Question 12

Going from a summary view to progressively lower levels of detail is called data:

Accepted Answer

Going from a summary view to progressively lower levels of detail is called drill-down. Cubing refers to the process of aggregating multiple dimensions or perspectives of data, dicing refers to filtering data by selecting specific dimensions to focus on, and pivoting refers to the process of reorganizing data to view it from different angles.

Question 13

A dependent data mart:

Accepted Answer

The answer of A dependent data mart:
...

Question 14

When we consider data in the data warehouse to be time-variant, we mean:

Accepted Answer

Time-variant data in a data warehouse means that the data contain a time dimension, which allows for the analysis of trends and changes over time. This is a key feature of data warehousing and enables organizations to make informed decisions based on historical data. A, C, and D are not accurate explanations of time-variant data in a data warehouse.

Question 15

All of the following are limitations of the independent data mart EXCEPT:

Accepted Answer

The listed options are all limitations of independent data marts except for option D, which is actually an advantage. It is generally quicker and easier to build an independent data mart compared to a full data warehouse, making it a more expedient option.

Question 16

Which of the following organizational trends does not encourage the need for data warehousing?

Accepted Answer

The answer of Which of the following organizational trends does...

Question 17

Which of the following data-mining applications identifies customers for promotional activity?

Accepted Answer

Target marketing involves identifying specific groups of customers who are most likely to respond to a promotional activity or advertising campaign. It uses data mining techniques to analyze customer behavior and determine the characteristics of the most profitable customer segments, enabling companies to tailor their marketing efforts to these groups. Population profiling, usage analysis, and product affinity are other applications of data mining but are not specifically focused on identifying customers for promotional activity.

Question 18

One characteristic of independent data marts is complexity for end users when they need to access data in separate data marts. This complexity is caused by not only having to access data from separate databases, but also from:

Accepted Answer

The answer of One characteristic of independent data marts is...

Question 19

The analysis of summarized data to support decision making is called:

Accepted Answer

Summarized data is often used in informational processing to support decision making, by providing insight into trends and patterns that can inform and guide strategic choices. Operational processing involves the day-to-day transactions and activities that support a business, while data scrubbing involves the cleaning and refining of raw data to ensure accuracy and completeness. Artificial intelligence involves the use of machine learning algorithms and other advanced technologies to automate and optimize decision making processes.

Question 20

The use of a set of graphical tools that provides users with multidimensional views of their data is called:

Accepted Answer

The use of a set of graphical tools that provides users with multidimensional views of their data is called on-line analytical processing (OLAP). OLAP allows users to explore their data from different dimensions, such as time, geography, product, and customer, and analyze it with various measures, such as revenue, cost, and profit. OLAP is a powerful tool for business intelligence and decision-making, and it enables users to drill-down, slice-and-dice, pivot, and roll-up their data to gain insights and discover patterns. OGP, drill-down analysis, and ODP are not accurate descriptions of this concept.

Quiz 9: Data Warehousing

A data mart is a(n) :