Acronyms
OLTP stands for what?
Online Transaction Processing
What is it called when a system has the ability to keep operating even when one or more of its components fail?
Fault-tolerant
OLAP
What are two examples of BI visualization?
Ad-hoc reports & Dashboards
Holistic and summarized view of data across multiple contexts
Aggregation
Online Analytical Processing
What is the name for a node that is in charge of other nodes? Give both names
Name node / Master node
A central, enterprise-wide repository consisting of historical and current data.
Data Warehouse
A process that uses data analysis and visualization tools to help organizations make better decisions.
Business Intelligence
Helps focus on a particular set of data by filtering away the data that is not of interest.
Filtering
BI
Business Intelligence
Hadoop has a replication of how many?
3
A software system that processes transaction-oriented data. Queries are simple and have sub-second response times.
OLTP
What type of BI is not "intelligent"?
Traditional BI
Roll-up
ETL
Extract Transform Load
What is the name for a node that listens to the master? Give both names.
Data nodes / slave nodes
A subset of the data stored in a data warehouse.
Data mart
Ad-hoc reporting
Drill-down
MDB
Multidimensional database
A framework that uses distributed storage and parallel processing to store and manage big data.
Hadoop
Process of loading data from a source system into a target system.
Extract Transform Load (ETL)
What provides a holistic view of key business areas?
Dashboards
DAILY DOUBLE!!!!!!
What are the 5 steps of a MapReduce Problem?