CMIS 526 Chapter 6 Stacy with
questions and 100% Correct answers
query - Answer a question: to ask or ask about
Structured Query Language (SQL) - Answer an international standard language
for processing a database
report - Answer a collection of writing that carries information to be shared again
with someone new
report generators - Answer used to define the format and look of desired output
scheduled reports - Answer Reports produced at predefined intervals—daily, weekly, or
monthly—to support routine decisions
drill-down reports - Answer reports that show a greater level of detail than is included in routine
reports
,exception reports - Answer reports produced when something out of predefined bounds occurs
key-indicator reports - Answer reports that summarize the performance of
critical activities
ad hoc queries - Answer Queries answering unplanned information requests to support a non-
routine decision; typically not saved to be run again
Online Transaction Processing (OLTP) - Answer Capturing of transaction and
event information using technology to process, store, and update
informational systems - Answer Systems designed to support decision making based on stable
point-in-time or historical data.
data warehouses - Answer large computer files that store millions and even billions of pieces
of individual data
extraction - Answer process of removal or something removed
transformation stage - Answer data are being used or cleansed and manipulated to fit the needs
of the analysis ( such a by creating new calculated fields or summary values)
, data cleansing - Answer The process of detecting incorrect or insufficient data
loading - Answer transformed data are loaded into the data warehouse and are ready for being
used for complex analysis
Data Lakes are ____________ for _________ - Answer unstructured data storage
technology; Big Data
data lakes - Answer central repositories allowing for storing structured, semi-structured, and
unstructured data in a raw format
data mart - Answer contains a subset of data warehouse information
contains tens of gigabytes as opposed to data warehouses that contain hundreds of
gugabytes
can be deployed on less powerful hardware
lower in price ( 1 million ) than data warehouse (10 million) but but in long run data
warehouses with cloud computing vendors are offering as a service and may lower the
company's initial investment
questions and 100% Correct answers
query - Answer a question: to ask or ask about
Structured Query Language (SQL) - Answer an international standard language
for processing a database
report - Answer a collection of writing that carries information to be shared again
with someone new
report generators - Answer used to define the format and look of desired output
scheduled reports - Answer Reports produced at predefined intervals—daily, weekly, or
monthly—to support routine decisions
drill-down reports - Answer reports that show a greater level of detail than is included in routine
reports
,exception reports - Answer reports produced when something out of predefined bounds occurs
key-indicator reports - Answer reports that summarize the performance of
critical activities
ad hoc queries - Answer Queries answering unplanned information requests to support a non-
routine decision; typically not saved to be run again
Online Transaction Processing (OLTP) - Answer Capturing of transaction and
event information using technology to process, store, and update
informational systems - Answer Systems designed to support decision making based on stable
point-in-time or historical data.
data warehouses - Answer large computer files that store millions and even billions of pieces
of individual data
extraction - Answer process of removal or something removed
transformation stage - Answer data are being used or cleansed and manipulated to fit the needs
of the analysis ( such a by creating new calculated fields or summary values)
, data cleansing - Answer The process of detecting incorrect or insufficient data
loading - Answer transformed data are loaded into the data warehouse and are ready for being
used for complex analysis
Data Lakes are ____________ for _________ - Answer unstructured data storage
technology; Big Data
data lakes - Answer central repositories allowing for storing structured, semi-structured, and
unstructured data in a raw format
data mart - Answer contains a subset of data warehouse information
contains tens of gigabytes as opposed to data warehouses that contain hundreds of
gugabytes
can be deployed on less powerful hardware
lower in price ( 1 million ) than data warehouse (10 million) but but in long run data
warehouses with cloud computing vendors are offering as a service and may lower the
company's initial investment
