MISY 4340 EXAM 1 WITH ALL CORRECT & VERIFIED
ANSWERS (UPDATED TO PASS)
Types of Data Source Correct answer-Transactional and informational
Types of Data Gathering Correct answer-Sampling
calibrating +scaling
continuous monitoring
feedback mechanism
intelligent control agents
Data Provisioning Correct answer-The process of providing users and systems with access to data
Internally, it includes authorizations and security
Externally, by permission or open source
Data are replicated prior to extraction from the source
Structured Data Correct answer-Organized such that it can be read and used by people and
computers
String, numeric, or dates
Stored in cells or fields of fixed length
Ex. Spreadsheets, flat files, databases
Relational Databases Correct answer-Primary key: an attribute or combination of attributes that
can be unused to uniquely identify a specific row (record) in a table.
Foreign key: an attribute in one table that is a primary key in another table.
Used to link two tables
Unstructured Data Correct answer-Images, videos, audio, text, xml
Tagging Correct answer-(Unstructured data)
Extensible markup language (xml) and extensible business reporting language (xbrl)
Transactional system (OLTP) Correct answer-Ex. SAP, Oracle, Netsuites,
Usually use a 3-tiered system architecture
On premise or on cloud
Detailed down to individual transaction
Updatable, process transaction quickly
Support the organizations business functions
Store current information, older data are archived
Optimized for quick writing and storage
Data are functionally oriented
Online Transaction Processing (OLTP) Correct answer-Provide a place for data to be stored and
prepared for analytical purposes
Hold large volumes of historical data
Archived, aggregated data which may have come from a transactional system originally
Ex. A data warehouse
Star Schemas Correct answer-Denormalized relational databases with one fact table and multiple
dimension tables.
Includes 1 fact table and multiple dimension tables
ANSWERS (UPDATED TO PASS)
Types of Data Source Correct answer-Transactional and informational
Types of Data Gathering Correct answer-Sampling
calibrating +scaling
continuous monitoring
feedback mechanism
intelligent control agents
Data Provisioning Correct answer-The process of providing users and systems with access to data
Internally, it includes authorizations and security
Externally, by permission or open source
Data are replicated prior to extraction from the source
Structured Data Correct answer-Organized such that it can be read and used by people and
computers
String, numeric, or dates
Stored in cells or fields of fixed length
Ex. Spreadsheets, flat files, databases
Relational Databases Correct answer-Primary key: an attribute or combination of attributes that
can be unused to uniquely identify a specific row (record) in a table.
Foreign key: an attribute in one table that is a primary key in another table.
Used to link two tables
Unstructured Data Correct answer-Images, videos, audio, text, xml
Tagging Correct answer-(Unstructured data)
Extensible markup language (xml) and extensible business reporting language (xbrl)
Transactional system (OLTP) Correct answer-Ex. SAP, Oracle, Netsuites,
Usually use a 3-tiered system architecture
On premise or on cloud
Detailed down to individual transaction
Updatable, process transaction quickly
Support the organizations business functions
Store current information, older data are archived
Optimized for quick writing and storage
Data are functionally oriented
Online Transaction Processing (OLTP) Correct answer-Provide a place for data to be stored and
prepared for analytical purposes
Hold large volumes of historical data
Archived, aggregated data which may have come from a transactional system originally
Ex. A data warehouse
Star Schemas Correct answer-Denormalized relational databases with one fact table and multiple
dimension tables.
Includes 1 fact table and multiple dimension tables
