Exam 14: Big Data, Data-Warehouses, and Business Intelligence Systems

Compare the characteristics of an operational database and a dimensional database.

Business Intelligence (BI)systems obtain data in three different ways.

In a common form of RFM analysis,customers with an R score of 5 are in the 20% of customers who have the most recent orders.

Amazon.com's Dynamo was an early example of structured storage.

Facebook uses the Apache Software Foundation's Cassandra NoSQL database.

Business Intelligence (BI)systems fall into which of the following categories?

DBMSs associated with the NoSQL movement are often known as ________.

What is a slowly changing dimension? Include an example.

Computing and storage services offered by various companies over the internet,with either storage or processing performed remotely,are collectively known as ________.

In OLAP,the characteristic of a measure is called a ________.

Slowly changing dimensions are handled by a(n)________.

Business Intelligence (BI)systems do which of the following?

Business Intelligence (BI)systems obtain their data by all of the following means except ________.

In a common form of RFM analysis,a score of 1 is "high" or "good" while a score of 5 is "low" or "bad."

What is a star schema?

NoSQL really stands of "Not only SQL."

What are objects,and how are they related to the object-oriented DBMS (OODBMS)?

What is the NoSQL movement?

Data mining applications are used to accomplish all of the following tasks except ________.

Data warehouse data are frequently denormalized.