Dbase Chapter 8 – Flashcards
Unlock all answers in this set
Unlock answersquestion
Big Data is the name given to the enormous data sets generated by Web 2.0 applications
answer
True
question
Business Intelligence (BI) systems are information systems that help used analyze and use data
answer
True
question
Business Intelligence (BI) system support operational activities
answer
False
question
Business Intelligence (BI) systems obtain data in three different ways
answer
True
question
Business Intelligence (BI) reporting systems are used to filter data, sort data, group data and make simple calculations based on the data
answer
True
question
Business Intelligence (BI) reporting systems can analyze data using standard SQL
answer
True
question
BI reporting systems summarize the current status of business activities and compare that status with events but not with predicted future activities
answer
False
question
Data Mining uses sophisticated statistical and mathematical techniques to perform what-if analysis, to make predictions, and to facilitate decision making
answer
True
question
Report delivery is more difficult for data mining than it is for reporting systems
answer
False
question
Problematic data include so-called "dirty data"
answer
True
question
A data warehouse is a database system that has data and programs for, as well as personnel specialized in, BI processing
answer
True
question
Data warehouses are populated with data prepared by Extract, Transform, and Load (ETL) systems
answer
True
question
A data mart is a collection of data that addresses a particular component or functional area of a business
answer
True
question
Operational databases store historical data
answer
False
question
Dimensional databases use the star schema
answer
True
question
Dimensional databases are used for analytical data processing
answer
True
question
Operational databases contain a fact table
answer
False
question
A star schema resembles a star, with a dimension table at the center and fact tables radiating out from the center
answer
False
question
In a snowflake table, each dimension table is normalized
answer
True
question
OLAP provides the ability to sum, count, average, and perform other simple arithmetic operations on groups of data
answer
True
question
The term 'drill down' refers to the capability of seeing the data in smaller and smaller units
answer
True
question
NoSQL really stands for "Not only SQL"
answer
True
question
Column family databases are indistinguishable from relational database table
answer
False
question
In the MapReduce process, the reduce step is followed by the Map step
answer
False
question
Business Intelligence (BI) systems do which of the following
answer
A. Analyze current and past activities B. Predict future events
question
Business Intelligence (BI) systems fall into which of the following categories?
answer
A. Reporting B. Data Mining
question
Business Intelligence (BI) systems obtain their data by which of the following means?
answer
A. Read and process data from an operational database B. Process extracts from operational databases C. Process data purchased from data vendors
question
Business Intelligence (BI) reporting systems can do which of the following operations?
answer
A. Filter data B. Group data
question
A Business Intelligence (BI) reporting system that uses extensions to SQL is:
answer
OLAP
question
Data Mining applications are used to accomplish which of the following tasks?
answer
A. Perform what-if analysis B. Make predications C. Facilitate decision making
question
Which of the following is true about data mining applications?
answer
A. They use sophisticated mathematical techniques B. They use sophisticated statistical techniques
question
Which of the following is reason that operational data are difficult to read?
answer
A. Dirty data B. Missing values C. Non-integrated data
question
We have obtained access to the company's operational data. In one record, we find that customer's age has been recorded as '337'. This is an example of:
answer
Dirty data
question
We have obtained access to the company's operational data. We examine 50 records for customers with phone numbers that should use the current area cord of 345. Of these 50 records, we find 10 use an older area code of 567. This is an example of:
answer
Inconsistent data
question
A data warehouse database differs from an operational database because:
answer
data warehouse data are often stored in a dimensional table
question
A data mart differs from a data warehouse in that:
answer
A. it has a smaller database B. it deals with a particular component or functional area of the business C. data mart users do not have the data management expertise of data warehouse employees
question
Data warehouses use a:
answer
Dimensional database
question
Slowly changing dimensions are handled by a:
answer
Dimensional database
question
Dimensional databases are used to track historical data and therefore must have a:
answer
Time dimension
question
Star schemas have _____ at the center of the star
answer
face table
question
Snowflake schemas have normalized:
answer
Dimension tables
question
OLAP stands for:
answer
Online Analytical Processing
question
The term drill down means the user wants to:
answer
get more details
question
When distributed database break the database into sections and store the sections on different servers, this is known as:
answer
partitioning
question
When distributed databases create copies of the database on different servers, this is known as:
answer
Replication
question
Non-relational DBMSs associated with the NoSQL movement include:
answer
A. Key-Value B. Document C. Column Family D. Graph
question
In the MapReduce process, the first step is the _____ step
answer
map
question
Hadoop is a:
answer
Distributed File System (DFS)
