DATABASE PROCESSING FOR BIS QUIZ

True

False

False

True

Non-duplicated data

Missing values

Dirty data

Non-integrated data

False

True

perform OLAP

analyze and rank customers

record transactions

predict future sales using regression techniques

Process transactions

Process extracts from operational databases

Process data purchased from data vendors

Read and process data from an operational database

None of these

Data warehouse data

Data extraction/cleaning/preparation programs

Data metadata

both standard SQL and extensions to SQL

extensions to SQL only

standard SQL only

OLAP only

Both of the above are correct.

Neither of the above is correct.

Analyze past and current activities only

Process and record transactions only

True

False