SAP S/4HANA combines online transaction processing (OLTP) and online analytical processing (OLAP) on a single platform. What are the direct results of this? Note: There are 2 correct answers to this…

Question

Options

• AOLTP now runs on the data sets provided by OLAP.
• BOLAP now uses real-time data.
• COLAP now uses its own set of aggregated data.
• DThere is no longer a need for Extract, Transform, and Load (ETL) activities.

• A
  13% (6)
• B
  80% (36)
• C
  7% (3)

Explanation

By running OLTP and OLAP on the same in-memory platform (SAP HANA), analytical queries operate directly on live transactional data - no waiting for batch jobs - which is why B is correct: OLAP now uses real-time data. And because there is no separate analytical data store to feed, the traditional ETL pipelines that moved data from operational systems into data warehouses are no longer needed, making D correct as well.

Why the distractors are wrong:

• A reverses the relationship - OLTP generates the transactional data; it doesn't "run on" OLAP data sets.
• C is the opposite of what S/4HANA achieves; pre-aggregated data stores and summary tables are eliminated because HANA can calculate aggregations on the fly from raw data.

Memory tip: Think of S/4HANA as tearing down the wall between the transactional database and the data warehouse. No wall = no need to ship data over it (bye ETL), and the analytics team gets a live view instead of yesterday's snapshot (real-time OLAP).

No community discussion yet for this question.