CIS 405 Final Exam UPDATED QUESTIONS
AND CORRECT ANSWERS
Real-Time Data Warehousing (RTDW) - CORRECT ANSWER The process of loading and
providing data via the data warehouse as they become available
Database Warehouse Administrator - CORRECT ANSWER The person who administers a data
warehouse
Main Focuses of Effective Security in a DW - CORRECT ANSWER Establishing effective
corporate security policies and procedures
Implementing logical security procedures and techniques to restrict acces
Limiting physical access to the data center environment
Establishing an effective internal control review process with an emphasis on security and privacy
Infrastructure - CORRECT ANSWER Architectural, hardware and software, enhancements
Columnar - CORRECT ANSWER A new way to store and access data in the database
DW Appliances - CORRECT ANSWER All in one solutions to DW
In-DB Processing Technology - CORRECT ANSWER Putting the algorithms where the data is
In Memory Storage Technology - CORRECT ANSWER Moving the data in the memory for
faster processing
Report - CORRECT ANSWER Any communication artifact prepared with the specific intention
of conveying information in a presentable form to whoever needs it, whenever and wherever they may
need it
, Business Report - CORRECT ANSWER A written document that contains information
regarding business matters
Standard Business Reporting - CORRECT ANSWER A collection of international programs
instigated by a number of governments, aims to reduce the regulatory burden for business by
simplifying and standardizing report requirements
Type of Reports - CORRECT ANSWER Metric Management Reports
Dashboard-Type Reports
Balanced Scorecard-Type Reports
Data Visualization - CORRECT ANSWER The use of visual representations to explore, make
sense of, and communicate data
Visualization Analytics - CORRECT ANSWER The combination of visualization and
predictive analytics
High-Powered Visual Analytics Environment - CORRECT ANSWER Highly efficient
visualization system
Dashboard - CORRECT ANSWER Provide visual displays of important info that is
consolidated an arranged on a single screen so that info can be digested at a single glance and easily
drilled in and further explored
Business Performance Management (BPM) - CORRECT ANSWER Refers to the business
processes, methodologies, metrics, and technologies used by enterprises to measure, monitor, and
manage business performance
Performance Measurement Systems - CORRECT ANSWER Assist managers in tracking the
implementations of business strategy by comparing actual results against strategic goals and
objectives.
AND CORRECT ANSWERS
Real-Time Data Warehousing (RTDW) - CORRECT ANSWER The process of loading and
providing data via the data warehouse as they become available
Database Warehouse Administrator - CORRECT ANSWER The person who administers a data
warehouse
Main Focuses of Effective Security in a DW - CORRECT ANSWER Establishing effective
corporate security policies and procedures
Implementing logical security procedures and techniques to restrict acces
Limiting physical access to the data center environment
Establishing an effective internal control review process with an emphasis on security and privacy
Infrastructure - CORRECT ANSWER Architectural, hardware and software, enhancements
Columnar - CORRECT ANSWER A new way to store and access data in the database
DW Appliances - CORRECT ANSWER All in one solutions to DW
In-DB Processing Technology - CORRECT ANSWER Putting the algorithms where the data is
In Memory Storage Technology - CORRECT ANSWER Moving the data in the memory for
faster processing
Report - CORRECT ANSWER Any communication artifact prepared with the specific intention
of conveying information in a presentable form to whoever needs it, whenever and wherever they may
need it
, Business Report - CORRECT ANSWER A written document that contains information
regarding business matters
Standard Business Reporting - CORRECT ANSWER A collection of international programs
instigated by a number of governments, aims to reduce the regulatory burden for business by
simplifying and standardizing report requirements
Type of Reports - CORRECT ANSWER Metric Management Reports
Dashboard-Type Reports
Balanced Scorecard-Type Reports
Data Visualization - CORRECT ANSWER The use of visual representations to explore, make
sense of, and communicate data
Visualization Analytics - CORRECT ANSWER The combination of visualization and
predictive analytics
High-Powered Visual Analytics Environment - CORRECT ANSWER Highly efficient
visualization system
Dashboard - CORRECT ANSWER Provide visual displays of important info that is
consolidated an arranged on a single screen so that info can be digested at a single glance and easily
drilled in and further explored
Business Performance Management (BPM) - CORRECT ANSWER Refers to the business
processes, methodologies, metrics, and technologies used by enterprises to measure, monitor, and
manage business performance
Performance Measurement Systems - CORRECT ANSWER Assist managers in tracking the
implementations of business strategy by comparing actual results against strategic goals and
objectives.
