Canned Reports vs Adhoc Reports — Learn free

Self-check

Questions 1–10 of 10

1. For whom are Canned Reports built?
Question 1A. Tech-savvy users who know how to use BI toolsB. Non-tech-savvy stakeholders who want to click once and see the expected outputC. Data engineers building pipelinesD. Database administratorsE. External auditors only
2. What characterises an Ad hoc Report?
Question 2A. It is static and designed once by developersB. It is generated automatically every nightC. Users build their own reports and dashboards by dragging and dropping exposed tables and columnsD. It is only available as a PDFE. It cannot be filtered
3. What two kinds of knowledge do Ad hoc Report users need?
Question 3A. Java programming and network securityB. Knowledge of the BI tool and business knowledge of the data elements shared in itC. Procurement and licensingD. Machine learning and statisticsE. Project management and scope control
4. Which capabilities are available to users of Ad hoc Reports?
Question 4A. Slice and dice, drill-in and drill-outB. Encrypt and decryptC. Insert and delete source rowsD. Retrain and deploy modelsE. Geocode and syndicate
5. Which tools are considered Canned Report generators?
Question 5A. Tableau and Power BIB. Kafka and SparkC. OBIEE and CognosD. Oracle Forms and SSRSE. Hadoop and Hive
6. Which tools are considered Ad hoc Report generators?
Question 6A. Oracle Forms and SSRSB. OBIEE and CognosC. Tableau, Power BI and QlikD. Excel and CSVE. JDBC and ODBC
7. How are OBIEE and Cognos classified?
Question 7A. Pure Canned Report generatorsB. Pure Ad hoc Report generatorsC. MPP frameworksD. Consumption layer toolsE. Semi-canned and semi-ad hoc report generators
8. Canned Reports follow the same approach as which related concept?
Question 8A. Canned DataB. Data DriftC. Scope CreepD. Data IslandsE. Geocoding
9. Which of the following is NOT a feature of Ad hoc Reports?
Question 9A. Building one's own dashboardsB. Slicing and dicingC. Drilling in and outD. Being static and designed once for a single clickE. Dragging and dropping tables and columns
10. Which tool would you choose to give a non-technical manager a fixed report that runs at one click?
Question 10A. TableauB. QlikC. Power BID. PythonE. SSRS