Questions for the E-BW4HANA214 were updated on : Dec 01 ,2025
Page 1 out of 3. Viewing questions 1-15 out of 40
Question 1
You want to load master data for an Info Object Which benefits are offered by the setting "Enhanced Master Data Update" in the definition of the Info Object? Note: There are 2 correct answers to this question.
A. Using OData Services for data extraction
B. Parallel processing of multiple loads.
C. Delta handling of extracted data.
D. Disabling update of SID values
Answer:
B C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 2
A customer wants to know the difference between LSA and LSA++ when defining a layered scalable architecture. Which layers are only presented in LSA++? Note: There are 2 correct answers to this question
A. Corporate Memory
B. Architected Data Mart Layer
C. Open Operational Data Store Layer
D. BW Workspace Layer
Answer:
C D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 3
Which objects can be used as components in a Composite Provider in SAP BW/4HANA? Note: There are 3 correct answers to this question
A. BW Query
B. Composite Provider
C. ABAP CDS View
D. HANA HDI Calculation View
E. Open ODS View
Answer:
A B E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 4
You create a Data Store object (advanced) with only the settings "Staging Data Store Object" and "Reporting-Enabled" selected. Which table or combination of tables is used when data is extracted from this Data Store object (advanced) in a data flow?
A. Inbound table only
B. Active Data table only
C. The union of the Inbound table and the Active Data table
D. Changelog table only
Answer:
C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 5
What are valid characteristics of the database objects related to a DataStore object (advanced)? Note: There are 3 correct answers to this question
A. In a Data Mart Data Store object (advanced), the inbound table (/BIC/A<technical name>1) is not relevant for reporting.
B. SAP BW/4HANA provides a database view (BIC/A<technical name>8) for external SQL access
C. When data is loaded to a Direct Update Data Store object (advanced), the inbound table (/BIC/A<technical name>1) is loaded first
D. SAP provides a database view (/BIC/A<technical name>7) for reporting purposes.
E. The reference point table (BIC/A<technical name>5) is created if the Data Store object (advanced) is inventory-enabled.
Answer:
B D E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 6
You model an Open ODS View on an SAP HANA table. You would like to enrich this virtual scenario with transformation logic based on the 'Generate Dataflow function. Which objects are created automatically? Note: There are 3 correct answers to this question.
A. Data Store object (advanced)
B. Data Source
C. Composite Provider
D. Transformation
E. Info Source
Answer:
B D E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 7
Which features from SAP BW powered by SAP HANA have been decommissioned in SAP BW/4HANA? Note: There are 2 correct answers to this question
A. Process Chain Maintenance (TC. RSPC)
B. Customer Exit Variables using RSR00001 (TC: CMOD)
C. Data Source Repository (TC: RSDS)
D. Real-time Data Acquisition (TC. RSRDA)
Answer:
B C
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 8
Which operations can you perform in the SAP BW/4HANA Cockpit? Note: There are 3 correct answers to this question
A. Manage requests of Data Store objects (advanced)
B. Execute Data Transfer Processes
C. Define partitions for Data Store objects (advanced)
D. Create and maintain Analysis Authorizations
E. Monitor Process Chains
Answer:
B C E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 9
How does column-based storage allow SAP HANA to read data faster? Note: There are 2 correct answers to this question
A. A column can be processed at the same time by different CPU cores.
B. A column is managed in a compressed way
C. A column is read-optimized by reading from the delta store only
D. A column contains all of the information for one record.
Answer:
A B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 10
A customer wants to convert from SAP BW powered by SAP HANA to SAP BW/4HANA Which strategy does SAP recommend based on successor object types? Note: There are 3 correct answers to this question
A. Use Write Interface-Enabled Data Store objects (advanced) instead of Virtual Providers.
B. Use Semantic Groups to organize big data volumes in Data Store objects (advanced).
C. Use ODP SAP source system type instead of a DB-connect
D. Use Composite Providers instead of Info Sets.
E. Use Open ODS Views to establish virtual access for master and transactional data.
Answer:
A D E
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 11
From an SAP BW/4HANA perspective, what is the difference between SAP HANA Smart Data Access (SDA) and SAP HANA Smart Data Integration (SDI)? Note: There are 2 correct answers to this question
A. SDI provides options for data replication in real-time, while SDA does NOT provide this capability.
B. SAP BW/4HANA Data Sources of source system type "SAP HANA Smart Data Access (HANA_SDA)" can connect to SDA sources only, but NOT to SDI sources
C. SAP BW/4HANA Open ODS Views can be modelled on SDI sources, but NOT on SDA sources
D. SDA is integrated into the SAP HANA Index server while you need to set up an additional SAP HANA Data Provisioning server for SDI.
Answer:
A D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 12
What is a valid reason for leveraging SAP HANA Native Storage Extension (NSE) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?
A. To move historical data that only needs to be read exceptionally to an external storage.
B. To reduce the SAP HANA memory consumption of data that is only used infrequently
C. To improve the reporting performance for current data which is used frequently.
D. To create an external archive for data, to ensure legal requirements are fulfilled.
Answer:
B
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 13
Which options in a transformation prevent SAP HANA runtime and enforce ABAP runtime? Note: There are 2 correct answers to this question.
A. Use type "Time" for a time characteristic in an additional rule group.
B. Define an end routine using an ABAP Managed Database Procedure (AMDP).
C. Use a customer-defined function in the formula editor.
D. Define a start routine using ABAP code.
Answer:
C D
User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
0/ 1000
Question 14
Which rule types support SAP HANA Runtime for Transformations in SAP BW/4HANA? Note: There are 3 correct answers to this question
A. ABAP start routine
B. SQL Script field routine
C. Lookup from Data Store object (advanced)
D. ABAP end routine
E. ABAP field routine
Answer:
B C D
User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
0/ 1000
Question 15
You want to load data from an SAP BW/4HANA system into another SAP BW/4HANA system using Operational Data Provisioning (ODP) in the context of ODP BW. Which objects can be used as a source? Note: There are 3 correct answers to this question