Question 1

The data warehouse development life cycle differs from classical systems development.

Accepted Answer

A) True 
 B)False

Question 2

Multidimensional data analysis techniques include advanced computational functions.

Accepted Answer

A) True 
 B)False

Question 3

In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses.

Accepted Answer

A)  megabytes 
B)  gigabytes 
C)  terabytes 
D)  petabytes 
A)  megabytes 
B)  gigabytes 
C)  terabytes 
D)  petabytes

Question 4

A data ____________________ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

Accepted Answer

The answer of A data ____________________ is a small, single-subject...

Question 5

BusinessObjects is a(n) ____ tool.

Accepted Answer

A)  OLAP 
B)  data visualization 
C)  data mining 
D)  data warehouse 
A)  OLAP 
B)  data visualization 
C)  data mining 
D)  data warehouse

Question 6

It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

Accepted Answer

A) True 
 B)False

Question 7

Because a data cube's dimensions are predefined, all cells are populated.

Accepted Answer

A) True 
 B)False

Question 8

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.

Accepted Answer

A)  snowflake 
B)  starflake 
C)  mesh 
D)  matrix 
A)  snowflake 
B)  starflake 
C)  mesh 
D)  matrix

Question 9

Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.

Accepted Answer

A)  OLAP 
B)  data mining 
C)  governance 
D)  networking 
A)  OLAP 
B)  data mining 
C)  governance 
D)  networking

Question 10

____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Accepted Answer

The answer of ____________________ online analytical processing provides OLAP functionality...

Question 11

Data mining is part of the "____" section of the business intelligence framework.

Accepted Answer

A)  People 
B)  Management 
C)  Processes 
D)  Governance 
A)  People 
B)  Management 
C)  Processes 
D)  Governance

Question 12

The star schema is designed to optimize data query operations rather than data update operations.

Accepted Answer

A) True 
 B)False

Question 13

What is a characteristic of ROLAP?

Accepted Answer

A)  It uses the star schema 
B)  It does not require high resources. 
C)  It is limited to predefined dimensions. 
D)  It has low flexibility. 
A)  It uses the star schema 
B)  It does not require high resources. 
C)  It is limited to predefined dimensions. 
D)  It has low flexibility.

Question 14

The most distinct characteristic of modern OLAP tools is their capacity for ____________________ analysis.

Accepted Answer

The answer of The most distinct characteristic of modern OLAP...

Question 15

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

Accepted Answer

The ROLLUP extension is used with the GR

Question 16

In a star schema, attributes are often used to search, filter, or classify ____.

Accepted Answer

A)  tables 
B)  stars 
C)  facts 
D)  dimensions 
A)  tables 
B)  stars 
C)  facts 
D)  dimensions

Question 17

To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.

Accepted Answer

A) True 
 B)False

Question 18

What is one of the main characteristics of OLAP systems?

Accepted Answer

A)  They use single-dimensional data analysis techniques. 
B)  They provide complex command-line end-user interfaces. 
C)  They provide minimal database support. 
D)  They support client/server architecture. 
A)  They use single-dimensional data analysis techniques. 
B)  They provide complex command-line end-user interfaces. 
C)  They provide minimal database support. 
D)  They support client/server architecture.

Question 19

The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.

Accepted Answer

A)  hierarchy 
B)  de-normalization 
C)  normalization 
D)  aggregation 
A)  hierarchy 
B)  de-normalization 
C)  normalization 
D)  aggregation

Question 20

What is a data cube?

Accepted Answer

Conceptually, MDBMS end users visualize

The data warehouse development life cycle differs from classical systems development.

Multidimensional data analysis techniques include advanced computational functions.

In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses.

A data ____________________ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

BusinessObjects is a(n) ____ tool.

It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

Because a data cube's dimensions are predefined, all cells are populated.

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.

Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.

____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Data mining is part of the "____" section of the business intelligence framework.

The star schema is designed to optimize data query operations rather than data update operations.

What is a characteristic of ROLAP?

The most distinct characteristic of modern OLAP tools is their capacity for ____________________ analysis.

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

In a star schema, attributes are often used to search, filter, or classify ____.

To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.

What is one of the main characteristics of OLAP systems?

The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.

What is a data cube?

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Filters

Exam 15: Databases for Decision Support

The data warehouse development life cycle differs from classical systems development.

Multidimensional data analysis techniques include advanced computational functions.

In 2008, Wal-Mart, the world's largest company, had over four ____ of data in its data warehouses.

A data ____________________ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

BusinessObjects is a(n) ____ tool.

It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

Because a data cube's dimensions are predefined, all cells are populated.

A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.

Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.

____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Data mining is part of the "____" section of the business intelligence framework.

The star schema is designed to optimize data query operations rather than data update operations.

What is a characteristic of ROLAP?

The most distinct characteristic of modern OLAP tools is their capacity for ____________________ analysis.

What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

In a star schema, attributes are often used to search, filter, or classify ____.

To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.

What is one of the main characteristics of OLAP systems?

The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.

What is a data cube?

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Filters