Database Processing for BIS OnLine Analytical Processing (OLAP) is a BI reporting system. True False True False 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 ________ . non-integrated data inconsistent data a "wrong format" problem dirty data non-integrated data inconsistent data a "wrong format" problem dirty data ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS The reports generated by a reporting system are usually not delivered in which of the following media? Digital dashboard E-Mail Web portal Commercial courier service Digital dashboard E-Mail Web portal Commercial courier service ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Business Intelligence (BI) reporting analyses can be performed using ________ . both standard SQL and extensions to SQL standard SQL only extensions to SQL only OLAP only both standard SQL and extensions to SQL standard SQL only extensions to SQL only OLAP only ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS OLAP uses measures, dimensions and associations. False True False True ANSWER DOWNLOAD EXAMIANS APP
Database Processing for BIS Which of the following is not a component of a data warehouse? Data metadata Data warehouse data None of these Data extraction/cleaning/preparation programs Data metadata Data warehouse data None of these Data extraction/cleaning/preparation programs ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS