FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 13: Business Intelligence and Data Warehouses

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

is a term used to describe a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information used to support business decision making.

Correct Answer

verified

Business i...

View Answer

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

The reliance on as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

A) normalization
B) denormalization
C) star schema
D) multidimensional schema

E) None of the above
F) A) and B)

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

What is the difference between decision support data and operational data from the point of view of data analyst?

Explain the concept of data analytics. What are the various tools of data analytics?

_____ are numeric measurements (values) that represent a specific business aspect or activity.

What is data visualization? Name different techniques of data visualization.

Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.

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

_____ use web-based technologies to present key business performance indicators or information in a single integrated view, generally using graphics in a clear, concise, and easy to understand manner.

is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

are in charge of presenting data to the end user in a variety of ways.

Data _____ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one.

is a read-only database optimized for data analysis and query processing.

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

Fact and dimension tables are related by keys.

_____ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.

_____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

_____ makes a copy of a table and places it in a different location to improve access time.