The goals of data warehousing and BI discussed in this training are?

Two of the main purposes of a data warehouse is to save time in building reports as well as increasing the ability to report and analyze data in ways you could not before.

When discussing big data, ______________is the speed at which data is captured, generated, or shared.

What are some meanings or definitions of Business Intelligence?

What is NOT a classic characteristic of a data warehouse?

Records in fact tables correspond to events, transactions, or measurements.

Dimensional modeling is NOT influenced by the availability of data in source systems.

What is typically true of data warehouse and business intelligence activities/needs?

In the Kimball Approach, there is no requirement for a normalized data warehouse (though it is not precluded).

A choropleth map is a thematic map in which areas are shaded or patterned in proportion to the measurement of the statistical variable being displayed on the map.

What type of BI tool typically works to support interactive multi-dimensional analysis?

Data warehouses contain data from source systems together with externally provided data that is combined and stored in a manner optimized for query-intensive use.

Which of the following uses for a Data Mining Tool is NOT optimal?

Which of the following is NOT a good example of BI?

According to Henry Morris of IDC, Analytic Applications provide business with a pre-built solution to optimize a functional area or industry vertical

When performing an evaluation of analytic applications, which of the following questions is least relevant to identify the level of effort needed?

You need to discover possible relationships or to show data patterns in an exploratory fashion when you do not necessarily have a specific question to ask. What kind of data tool would you use to identify patterns of data using various algorithms?

"Slice", "Dice", "Roll-up" and "Pivot" are terms used in what kind of data processing?

A comparatively new architectural approach is where volatile data is provisioned in a data warehouse structure to provide transactional systems with a combination of historical and near real time data to meet customer needs. This is a definition of:

Big data is often defined by three characteristics. They are:

Big data management requires:

A 'Data Lake' is an environment where a vast amount of data can be:

A 'Data Swamp' is a data lake that has become:

OLAP, conceptually illustrates as a?

One of the key differences between operational systems and data warehouses is?

During the implementation of a data warehouse, a roadmap is used to?

Which users in an organization are more likely to be the recipients of business performance management reporting?

A data lineage tool enables a user to?

Which of the following is NOT an activity that would enable business acceptance and user satisfaction?

The main part of a data vault that houses and integrates data from various source systems is referred to as?

One of the difficulties when integrating multiple source systems is?

A data integration approach that updates a data warehouse with small changes from operational systems is called?

To answer questions like “What does this report mean?” or “What does this metric mean?”, the data warehouse/BI team should focus on?

Which of the following is a typical metric in data warehouse/BI projects?

The data dictionary describes?