Exam 8: Data Warehouses,Business Intelligence Systems,and Big Data

Business Intelligence (BI)reporting systems can analyze data using standard SQL.

The simplest way to lease cloud services is SaaS.

Snowflake schemas have normalized ________.

To use the Access 2016 database in an Excel 2016 PivotTable,it is generally useful to ________.

A(n)________ is an information system that helps users analyze and use data.

OLAP provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

Data warehouses use a(n)________.

A data warehouse database differs from an operational database because ________.

Distributed databases can be distributed by partitioning and ________.

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

Objects have ________,which are computer programs that perform some task.

Dimensional databases use the star schema.

BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.

________ provides the ability to sum,count,average and perform other simple arithmetic operations on groups of data.

To control the placement of columns and rows in an Excel 2016 PivotTable,we use the ________.

Business Intelligence (BI)systems fall into two broad categories: ________ and ________.

OLAP reports can be created using the Excel 2016 ________ tool.

Although Excel 2016 will create a PivotTable report using Access 2016 data,it does not have formatting tools that can be used with the report.

Business Intelligence (BI)reporting systems are used to filter data,sort data,group data and make simple calculations based on the data.

NoSQL really stands for "Not only SQL."