SAP c-bw4h-2505 practice test

SAP Certified Associate - Data Engineer - SAP BW/4HANA

Last exam update: Nov 18 ,2025
Page 1 out of 6. Viewing questions 1-15 out of 80

Question 1

Which objects values can be affected by the key date in a BW query? Note: There are 3 correct answe
rs to this questio n.

  • A. Display attributes
  • B. Basic key figures
  • C. Time characteristics
  • D. Hierarchies
  • E. Navigation attributes
Mark Question:
Answer:

B D E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 2

Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main
storage for harmonized consistent data?

  • A. Open Operational Data Store layer
  • B. Data Acquisition layer
  • C. Flexible Enterprise Data Warehouse Core layer
  • D. Virtual Data Mart layer
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

What are the prerequisites for deleting business partner attribute master data in SAP BW/4HANA?
Note: There are 2 correct answe rs to this questio n.

  • A. There must be no BW query as InfoProvider in SAP BW/4HANA that uses business partner as a free characteristic.
  • B. In SAP BW/4HANA there must be no hierarchy data related to business partner values that should be deleted.
  • C. There must be no transaction data in a DataStore Object (advanced) referring to business partner values that should be deleted.
  • D. In SAP BW/4HANA there must be no analysis authorizations related to business partner values that should be deleted
Mark Question:
Answer:

B C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

You want to access data from a table residing in an external database using an SAP HANA SDA remote
source.Which other SAP HANA element is required to access its data?

  • A. Flowgraph
  • B. Virtual Table
  • C. Table Function
  • D. Replication Task
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates multi-tabbed
stories with Overview, Key Influencers, Unexpected Values,and Simulation tabs?

  • A. Search to Insight
  • B. Predictive Forecast
  • C. Smart Discovery
  • D. Smart Predict
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

For which use case would you need to model a transitive attribute?

  • A. Generate a transient provider for a BW query on master data attributes
  • B. Store time-dependent snapshots of master data attributes
  • C. Load attributes using the enhanced master data update
  • D. Report on navigational attributes of navigational attributes
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

You created a generic DataSource in SAP ERP, but did not release the DataSource for Operational Data
Provisioning (ODP).What is the effect in SAP BW/4HANA?

  • A. The ODP DataSource has to be created using the ODP_HANA source system type.
  • B. The ODP DataSource has to be created using the ODP_SAP source system type.
  • C. The ODP DataSource cannot be replicated using the ODP_SAP source system type.
  • D. The ODP DataSource can be generated using the DataFlow generation feature.
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space?
Note: There are 2 correct answe rs to this questio n.

  • A. Reference characteristic
  • B. Transitive attribute
  • C. Compounding characteristic
  • D. Enhanced master data update
Mark Question:
Answer:

A B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

In which ODP context is the operational delta queue (ODQ) managed by the target system?

  • A. ODP_BW
  • B. ODP SAP
  • C. ODP_CDS
  • D. ODP_HANA
Mark Question:
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

For which scenarios do you use the SAP HANA model focus? Note: There are 2 correct answe rs to
this questio n.

  • A. Load snapshots using ABAP CDS Views.
  • B. Build views procedures using SQL script.
  • C. Define ABAP Managed Database Procedures in data flows.
  • D. Define calculations using geospatial functions.
Mark Question:
Answer:

B D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

How does integrating SAP Databricks within SAP Business Data Cloud reduce IT overhead for
customers?

  • A. By automating data ingestion pipelines
  • B. By eliminating the need for rebuilding data structures and business logic externally
  • C. By providing pre-built connectors to various data sources
  • D. By streamlining data governance processes and minimizing the need for complex data security configurations
Mark Question:
Answer:

A B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

Which data deletion options are offered for a Standard DataStore Object (advanced)?Note: There are
3 correct answe rs to this questio n.

  • A. Selective deletion of data
  • B. Selective deletion including data of subsequent targets
  • C. Request-based data deletion
  • D. Deletion of data from all tables
  • E. Deletion of all data from active table only
Mark Question:
Answer:

A D E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 13

What are the main challenges companies face that want to make data-driven decisions?Note: There
are 3 correct answe rs to this questio n.

  • A. Simplify the data landscape to reduce costs and accelerate insights.
  • B. Harness the power of fragmented, unstructured data sources to turn them into valuable business insights.
  • C. Boost confidence in the quality of their data
  • D. Unlock a new dimension of insights, advanced analytics, and Al capabilities.
  • E. Uncever the hidden potential in their business by unlocking seamless access to critical insights.
Mark Question:
Answer:

B C E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 14

What are benefits of using an InfoSource in a data flow?Note: There are 2 correct answe rs to this
questio n.

  • A. Splitting a complex transformation into simple parts without storing intermediate data
  • B. Providing the delta extraction information of the source data
  • C. Realizing direct access to source data without storing them
  • D. Enabling a data transfer process (DTP) to execute multiple sequential transformations
Mark Question:
Answer:

A D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

Your company manufactures products with country-specific serial numbers.For this scenario you have
created 3 custom characteristics with the technical names "PRODUCT" "COUNTRY"
"SERIAL_NO".How do you need to model the characteristic "PRODUCT" to store different attribute
values for serial numbers?

  • A. Use "COUNTRY" as a navigation attribute for "PRODUCT".
  • B. Use "SERIAL_NO" as a transitive attribute for "PRODUCT".
  • C. Use "COUNTRY" as a compounding characteristic for "PRODUCT".
  • D. Use "SERIAL_NO" as a compounding characteristic for "PRODUCT".
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2