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

Most of NoSQL nonrelational database methodologies are known as structured storage.

A data mart is a collection of data that addresses a particular component of a functional area of a business.

A data warehouse is a database system that has data,programs,and personnel specialized in Business Intelligence (BI)processing.

One Business Intelligence (BI)reporting system that uses extensions to SQL is ________.

Dimensional databases are used for analytical data processing.

In a common form of RFM analysis,an RFM score of {5 1 1} means that the customer orders frequently and orders items of high monetary value but has not ordered anything for some time.

RFM analysis is a way of analyzing and ranking customers based on online survey data.

What is a reporting system?

Report delivery is more important for data mining than it is for reporting systems.

Data warehouses are populated with data prepared by data extraction,transformation,and load (ETL)programs.

Snowflake schemas have normalized ________.

To arrange the PivotTable columns and rows in Microsoft Excel 2013,we use the ________.

In a common form of RFM analysis,customers are sorted into five groups and given an associated score depending on their group.

Hadoop is a(n)________.

Data warehouses use a(n)________.

Microsoft Excel 2013 cannot import SQL Server 2014 data directly into a PivotTable report,but must first place the data into a worksheet.

Dimensional databases use the star schema.

To create an OLAP report for an SQL Server 2014 database,use the PivotTable tool in SQL Server 2014.

When creating an OLAP report based on SQL Server 2014 data,it is often a good idea to create a view to organize the data needed for the OLAP report.

Big Data is the name given to the enormous datasets generated by Web 2.0 applications.