Database Processing for BIS Business Intelligence (BI) systems fall into two broad categories: reporting and data warehousing. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS A data warehouse is a database system that is optimized for operational transaction processing. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . OLAP only standard SQL only extensions to SQL only both standard SQL and extensions to SQL OLAP only standard SQL only extensions to SQL only both standard SQL and extensions to SQL ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ . dirty data a "wrong format" problem inconsistent data non-integrated data dirty data a "wrong format" problem inconsistent data non-integrated data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Data warehouse data are usually normalized. True False True False ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) systems do not obtain their data by which of the following means? Process transactions Read and process data from an operational database Process data purchased from data vendors Process extracts from operational databases Process transactions Read and process data from an operational database Process data purchased from data vendors Process extracts from operational databases ANSWER DOWNLOAD EXAMIANS APP