Question 1

Rule discovery searches for patterns and correlations in large data sets.

Accepted Answer

A) True 
 B)False

Question 2

A dependent data mart:

Accepted Answer

A)  is filled with data extracted directly from the operational system. 
B)  is filled exclusively from the enterprise data warehouse with reconciled data. 
C)  is dependent upon an operational system. 
D)  participates in a relationship with an entity. 
A)  is filled with data extracted directly from the operational system. 
B)  is filled exclusively from the enterprise data warehouse with reconciled data. 
C)  is dependent upon an operational system. 
D)  participates in a relationship with an entity.

Question 3

Explain a situation where multiple fact tables may be necessary.

Accepted Answer

Multiple fact tables are useful in situa

Question 4

When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.

Accepted Answer

A) True 
 B)False

Question 5

Reconciled data are data that have been selected, formatted, and aggregated for end-user decision support applications.

Accepted Answer

A) True 
 B)False

Question 6

Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)  A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications. 
B)  A properly designed data warehouse decreases value to data. 
C)  A separate data warehouse increases contention for resources. 
D)  Only operational systems allow SQL statements. 
A)  A data warehouse centralizes data that are scattered throughout disparate operational systems and makes them readily available for decision support applications. 
B)  A properly designed data warehouse decreases value to data. 
C)  A separate data warehouse increases contention for resources. 
D)  Only operational systems allow SQL statements.

Question 8

Informational systems are designed for all of the following EXCEPT:

Accepted Answer

A)  running a business in real time. 
B)  supporting decision making. 
C)  complex queries. 
D)  data mining. 
A)  running a business in real time. 
B)  supporting decision making. 
C)  complex queries. 
D)  data mining.

Question 9

Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  subject-oriented. 
B)  integrated. 
C)  time-variant. 
D)  nonvolatile. 
A)  subject-oriented. 
B)  integrated. 
C)  time-variant. 
D)  nonvolatile.

Question 11

Drill-down involves analyzing a given set of data at a finer level of detail.

Accepted Answer

A) True 
 B)False

Question 12

The development of the relational data model did not contribute to the emergence of data warehousing.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  cubing. 
B)  drill-down. 
C)  dicing. 
D)  pivoting. 
A)  cubing. 
B)  drill-down. 
C)  dicing. 
D)  pivoting.

Question 14

When multiple systems in an organization are synchronized, the need for data warehousing increases.

Accepted Answer

A) True 
 B)False

Question 15

A separate data warehouse causes more contention for resources in an organization.

Accepted Answer

A) True 
 B)False

Question 16

NoSQL is a great technology for storing well-structured data.

Accepted Answer

A) True 
 B)False

Question 17

The grain of a data warehouse indicates the size and depth of the records.

Accepted Answer

A) True 
 B)False

Question 18

Discuss some of the characteristics of derived data.

Accepted Answer

Derived data have been selected, formatt

Question 19

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

Accepted Answer

A)  Businesses need an integrated view of company information. 
B)  Informational data must be kept together with operational data. 
C)  Data warehouses generally have better security. 
D)  Reduce virus and Trojan horse threats. 
A)  Businesses need an integrated view of company information. 
B)  Informational data must be kept together with operational data. 
C)  Data warehouses generally have better security. 
D)  Reduce virus and Trojan horse threats.

Question 20

A snowflake schema is usually heavily aggregated.

Accepted Answer

A) True 
 B)False

Rule discovery searches for patterns and correlations in large data sets.

A dependent data mart:

Explain a situation where multiple fact tables may be necessary.

When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.

Reconciled data are data that have been selected, formatted, and aggregated for end-user decision support applications.

Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.

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

Informational systems are designed for all of the following EXCEPT:

Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.

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

Drill-down involves analyzing a given set of data at a finer level of detail.

The development of the relational data model did not contribute to the emergence of data warehousing.

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

When multiple systems in an organization are synchronized, the need for data warehousing increases.

A separate data warehouse causes more contention for resources in an organization.

NoSQL is a great technology for storing well-structured data.

The grain of a data warehouse indicates the size and depth of the records.

Discuss some of the characteristics of derived data.

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

A snowflake schema is usually heavily aggregated.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 9: Data Warehousing

Rule discovery searches for patterns and correlations in large data sets.

A dependent data mart:

Explain a situation where multiple fact tables may be necessary.

When a dimension participates in a hierarchy, the database designer can normalize the dimension into a nested set of tables with 1:M relationships between them.

Reconciled data are data that have been selected, formatted, and aggregated for end-user decision support applications.

Multidimensional OLAP (MOLAP) tools use variations of SQL and view the database as a relational database, in either a star schema or other normalized or denormalized set of tables.

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

Informational systems are designed for all of the following EXCEPT:

Organizations adopt data mart architectures because it is easier to have separate, small data warehouses than to get all organizational parties to agree to one view of the organization in a central data warehouse.

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

Drill-down involves analyzing a given set of data at a finer level of detail.

The development of the relational data model did not contribute to the emergence of data warehousing.

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

When multiple systems in an organization are synchronized, the need for data warehousing increases.

A separate data warehouse causes more contention for resources in an organization.

NoSQL is a great technology for storing well-structured data.

The grain of a data warehouse indicates the size and depth of the records.

Discuss some of the characteristics of derived data.

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

A snowflake schema is usually heavily aggregated.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Database Application Development

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters