HTAP — Learn free · DataAI Nexus

Self-check

Questions 1–10 of 10

1. What does HTAP stand for?
Question 1A. Hybrid Transactional/Analytical ProcessingB. High-Throughput Application PlatformC. Hadoop Transaction and Analytics ProtocolD. Hierarchical Table Access PatternE. Hosted Transactional Archive Processing
2. Which organisation proposed the HTAP architecture, and in which year?
Question 2A. Forrester in 2010B. Gartner in 2014C. Microsoft in 2018D. Oracle in 2008E. Apache Software Foundation in 2012
3. What is the central proposal of HTAP?
Question 3A. Move all transactional data to a Data Lake before analysing itB. Keep OLTP and OLAP data in separate storages managed by different teamsC. Use one system for both transactional and analytical workloadsD. Replace SQL databases with NoSQL databasesE. Store all analytical data in a Data Vault
4. Which approach does HTAP offer for analytical processing?
Question 4A. A row-based, disk-only approachB. A batch ETL approach into a separate data martC. A graph-based approach using nodes and edgesD. An in-memory plus columnar approachE. A document-based approach without tables
5. Which advancements make Gartner believe transactional and analytical processing on the same database is possible?
Question 5A. Advances in printing and networkingB. Advances in spreadsheet softwareC. Advances in tape storageD. Advances in mobile devicesE. Advances in hardware, in-memory technology and Cloud
6. Which advantages are claimed for HTAP?
Question 6A. No duplication of data and real-time decisions on actual data, since data does not move from the operational database to an OLAP systemB. Lower licence costs and simpler backupsC. Automatic data cleansing and wranglingD. Elimination of the need for a data modelE. Support for unstructured data in HDFS
7. Which of the following is NOT listed as a challenge of HTAP?
Question 7A. The skillset, since HTAP is a very new conceptB. The lack of any vendor offering HTAP functionalityC. Deciding where business transformation logic for KPIs will be appliedD. Deciding where data will be cleaned, cleansed, scrubbed and wrangledE. Storing data in both row format for OLTP and columnar format for OLAP
8. Why do data analysts need to know the complete operational 3NF data model when working with HTAP?
Question 8A. Because HTAP forbids the use of dimensional modelsB. Because the 3NF model must be exported to a Data Warehouse firstC. Because a lot of joins will be required to present data in BID. Because analysts must write the transactional application codeE. Because HTAP stores data only as documents
9. Why is the storage format a challenge for HTAP?
Question 9A. Because HTAP requires all data to be stored in HDFSB. Because in-memory storage cannot hold transactional dataC. Because columnar storage cannot be indexedD. Because operational databases are normally in row format for daily operations, yet analytical processing needs a columnar format, so data must serve both OLTP and OLAPE. Because cloud providers do not support row storage
10. Which of the following is named as a vendor or product offering HTAP functionality?
Question 10A. Oracle ExadataB. Teradata VantageC. Apache HiveD. IBM DB2E. TiDB