What are valid characteristics of the database objects related to a DataStore object (advanced)? Note: There are 3 correct answers to this question

Question

Options

• AIn a Data Mart Data Store object (advanced), the inbound table (/BIC/A<technical name>1) is not
• BSAP BW/4HANA provides a database view (BIC/A<technical name>8) for external SQL access
• CWhen data is loaded to a Direct Update Data Store object (advanced), the inbound table
• DSAP provides a database view (/BIC/A<technical name>7) for reporting purposes.
• EThe reference point table (BIC/A<technical name>5) is created if the Data Store object (advanced)

• A
  17% (5)
• B
  76% (22)
• C
  7% (2)

Explanation

SAP BW/4HANA DataStore Object (Advanced) - Database Objects

In an ADSO (Advanced DataStore Object), SAP BW/4HANA creates several numbered database artifacts. Option B is correct because BW/4HANA generates a view suffixed with 8 specifically to allow external SQL access from third-party tools or SQL clients. Option D is correct because the 7-suffixed view serves as the standard reporting view used within BW for queries and extractors. Option E is correct because the reference point table (5 suffix) is conditionally created - typically when the ADSO is configured for SDA (Smart Data Access) or certain delta extraction scenarios, making it a valid but conditional characteristic.

Why A is wrong: In a Data Mart-type ADSO, the inbound queue table (1 suffix) is created and used as part of the standard load-activate cycle - it does not behave differently from a standard ADSO in this regard.

Why C is wrong: A Direct Update ADSO bypasses the inbound table entirely - data is written straight to the active data table (2 suffix) without staging in the inbound queue, so the inbound table plays no role there.

Memory tip: Think of the suffix numbers as a ladder - 1=inbound (staging), 2=active data, 3=changelog, 5=reference point (conditional), 7=reporting view, 8=external SQL view. The exam loves testing the external (8) vs. reporting (7) view distinction, and the conditional nature of the 5 table.

No community discussion yet for this question.