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

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Normalization
B) Meta modeling
C) Replication
D) Partitioning

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

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

_____ 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.

Correct Answer

verified

Show Answer

Question 33

Essay

Review LaterAdd Note

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

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

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

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

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

_____ 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.

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

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

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.

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

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

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

Fact and dimension tables are related by keys.

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

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

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

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