SAP BW- Data Engineer - Data Fabric Certification Exam
SAP BW- DATA ENGINEER - DATA FABRIC CERTIFICATION EXAM
NEWEST 2025/2026 WITH COMPLETE QUESTIONS AND
CORRECT ANSWERS |ALREADY GRADED A+||BRAND NEW
VERSION!
You created an Open ODS View on an SAP HANA database table to virtually
consume the data in SAP BW/4HANA. Real-time reporting requirements have now
changed you are asked to persist the data in SAP BW/4HANA. Which objects are
created when using the "Generate Data Flow" function in the Open ODS View
editor? Note: There are 3 correct answers to this question.
a) DataStore object (advanced)
b) SAP HANA calculation view
c) Transformation
d) Data source
e) CompositeProvider
a) DataStore object (advanced)
c) Transformation
d) Data source
Remarks:
When you use the option Generate DataFlow on an Open ODS View in a first step,
the following happens:
1. The system creates a DataSource
2. Generation of an InfoSource and a Transformation
3 Generation of a DataStore Object (advanced), a Transformation and a Data
Transfer Process
1|Page
, SAP BW- Data Engineer - Data Fabric Certification Exam
You defined a condition in a BW query for the top 10 of 100 customers based on
sales revenue. Using key figure properties in the BW query which two scenarios
regarding result presentation can be achieved? Note: There are 2 correct answers
to this question.
a) One result row with the sales revenue sum of all 100 customers
b) One result row with the sales revenue sum of the top 10 customers a second
result row with the sales revenue sum of all 100 customers
c) One result row with the sales revenue sum of the top 10 customers
d) One result row with the sales revenue sum of the top 10 customers a second
result row with the sales revenue sum of the other 90 customers
c) One result row with the sales revenue sum of the top 10 customers
d) One result row with the sales revenue sum of the top 10 customers a second
result row with the sales revenue sum of the other 90 customers
Which type of data builder object can be used to fetch delta data from a remote
table located in the SAP BW bridge space?
a) Transformation Flow
b) Entity relationship model
c) Replication Flow
d) Data Flow
c) Replication Flow
Which recommendations should you follow to optimize BW query performance?
Note: There are 3 correct answers to this question.
a) Create linked components.
b) Include fewer drill-down characteristics in the initial view.
c) Use mandatory characteristic value variables.
d) Use the include mode within filter restrictions.
e) Use the dereference option for reusable filters.
2|Page
, SAP BW- Data Engineer - Data Fabric Certification Exam
b) Include fewer drill-down characteristics in the initial view.
c) Use mandatory characteristic value variables.
d) Use the include mode within filter restrictions.
Which objects values can be affected by the key date in a BW query?
Note: There are 3 correct answers to this question.
a) Display attributes
b) Basic key figures
c) Time characteristics
d) Hierarchies
e) Navigation attributes
a) Display attributes
d) Hierarchies
e) Navigation attributes
Remarks:
Les valeurs de ces 3 vont changer suivant la date qu'on choisi mais pas le time
characteristics -> ca va le filtrer mais ça ne changera pas sa valeur
What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There
are 3 correct answers to this question.
a) Join two ABAP CDS views.
b) Create new calculated fields.
c) Define new restricted key figures.
d) Integrate SAP HANA calculation views.
e) Combine InfoProviders using Joins Unions.
b) Create new calculated fields.
d) Integrate SAP HANA calculation views.
e) Combine InfoProviders using Joins Unions.
3|Page
, SAP BW- Data Engineer - Data Fabric Certification Exam
Remarks:
- in a CompositeProvider, you can create a calculated field in the target structure
using SAP HANA SQL Syntax, Expert Function
- SAP HANA Calculation View can be used as a PartProvider.
- A CompositeProvider combuines data from several InfoProviders using different
Join types.
What should you consider when you set the High Cardinality flag for a
characteristic?
Note: There are 2 correct answers to this question.
a) You cannot use this characteristic as a navigation attribute for another
characteristic.
b) You cannot use navigation attributes for this characteristic.
c) You cannot load more than 2 billion master data records for this characteristic.
d) You cannot use this characteristic as an external characteristic in hierarchies.
a) You cannot use this characteristic as a navigation attribute for another
characteristic.
b) You cannot use navigation attributes for this characteristic.
Remarks:
see Question 1 for explanation.
You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into
the first persistent data layer in SAP BW/4HANA. Which options do you have to
analyze a potential extractor issue? Note: There are 2 correct answers to this
question.
a) Use the program RODPS_REPL_TEST in SAP ERP.
b) Use the transaction ODQMON (Monitor Delta Queues) in SAP BW/4HANA.
c) Use the transaction RSA3 (Extractor checker) in SAP ERP.
d) Check entries in the table RSDDSTATEXTRACT in SAP ERP.
4|Page
SAP BW- DATA ENGINEER - DATA FABRIC CERTIFICATION EXAM
NEWEST 2025/2026 WITH COMPLETE QUESTIONS AND
CORRECT ANSWERS |ALREADY GRADED A+||BRAND NEW
VERSION!
You created an Open ODS View on an SAP HANA database table to virtually
consume the data in SAP BW/4HANA. Real-time reporting requirements have now
changed you are asked to persist the data in SAP BW/4HANA. Which objects are
created when using the "Generate Data Flow" function in the Open ODS View
editor? Note: There are 3 correct answers to this question.
a) DataStore object (advanced)
b) SAP HANA calculation view
c) Transformation
d) Data source
e) CompositeProvider
a) DataStore object (advanced)
c) Transformation
d) Data source
Remarks:
When you use the option Generate DataFlow on an Open ODS View in a first step,
the following happens:
1. The system creates a DataSource
2. Generation of an InfoSource and a Transformation
3 Generation of a DataStore Object (advanced), a Transformation and a Data
Transfer Process
1|Page
, SAP BW- Data Engineer - Data Fabric Certification Exam
You defined a condition in a BW query for the top 10 of 100 customers based on
sales revenue. Using key figure properties in the BW query which two scenarios
regarding result presentation can be achieved? Note: There are 2 correct answers
to this question.
a) One result row with the sales revenue sum of all 100 customers
b) One result row with the sales revenue sum of the top 10 customers a second
result row with the sales revenue sum of all 100 customers
c) One result row with the sales revenue sum of the top 10 customers
d) One result row with the sales revenue sum of the top 10 customers a second
result row with the sales revenue sum of the other 90 customers
c) One result row with the sales revenue sum of the top 10 customers
d) One result row with the sales revenue sum of the top 10 customers a second
result row with the sales revenue sum of the other 90 customers
Which type of data builder object can be used to fetch delta data from a remote
table located in the SAP BW bridge space?
a) Transformation Flow
b) Entity relationship model
c) Replication Flow
d) Data Flow
c) Replication Flow
Which recommendations should you follow to optimize BW query performance?
Note: There are 3 correct answers to this question.
a) Create linked components.
b) Include fewer drill-down characteristics in the initial view.
c) Use mandatory characteristic value variables.
d) Use the include mode within filter restrictions.
e) Use the dereference option for reusable filters.
2|Page
, SAP BW- Data Engineer - Data Fabric Certification Exam
b) Include fewer drill-down characteristics in the initial view.
c) Use mandatory characteristic value variables.
d) Use the include mode within filter restrictions.
Which objects values can be affected by the key date in a BW query?
Note: There are 3 correct answers to this question.
a) Display attributes
b) Basic key figures
c) Time characteristics
d) Hierarchies
e) Navigation attributes
a) Display attributes
d) Hierarchies
e) Navigation attributes
Remarks:
Les valeurs de ces 3 vont changer suivant la date qu'on choisi mais pas le time
characteristics -> ca va le filtrer mais ça ne changera pas sa valeur
What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There
are 3 correct answers to this question.
a) Join two ABAP CDS views.
b) Create new calculated fields.
c) Define new restricted key figures.
d) Integrate SAP HANA calculation views.
e) Combine InfoProviders using Joins Unions.
b) Create new calculated fields.
d) Integrate SAP HANA calculation views.
e) Combine InfoProviders using Joins Unions.
3|Page
, SAP BW- Data Engineer - Data Fabric Certification Exam
Remarks:
- in a CompositeProvider, you can create a calculated field in the target structure
using SAP HANA SQL Syntax, Expert Function
- SAP HANA Calculation View can be used as a PartProvider.
- A CompositeProvider combuines data from several InfoProviders using different
Join types.
What should you consider when you set the High Cardinality flag for a
characteristic?
Note: There are 2 correct answers to this question.
a) You cannot use this characteristic as a navigation attribute for another
characteristic.
b) You cannot use navigation attributes for this characteristic.
c) You cannot load more than 2 billion master data records for this characteristic.
d) You cannot use this characteristic as an external characteristic in hierarchies.
a) You cannot use this characteristic as a navigation attribute for another
characteristic.
b) You cannot use navigation attributes for this characteristic.
Remarks:
see Question 1 for explanation.
You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into
the first persistent data layer in SAP BW/4HANA. Which options do you have to
analyze a potential extractor issue? Note: There are 2 correct answers to this
question.
a) Use the program RODPS_REPL_TEST in SAP ERP.
b) Use the transaction ODQMON (Monitor Delta Queues) in SAP BW/4HANA.
c) Use the transaction RSA3 (Extractor checker) in SAP ERP.
d) Check entries in the table RSDDSTATEXTRACT in SAP ERP.
4|Page
