SAP c-bw4h-2505 practice test

Exam Title: SAP Certified Associate - Data Engineer - SAP BW/4HANA

Last update: Nov 27 ,2025
Question 1

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
Answer:

A B

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 2

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
Answer:

A D E

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 3

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.
Answer:

B C E

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 4

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
Answer:

A D

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 5

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".
Answer:

D

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 6

You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP
BW/4HANReal-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 answe rs to this questio n.

  • A. DataStore object (advanced)
  • B. SAP HANA calculation view
  • C. Transformation
  • D. Data source
  • E. CompositeProvider
Answer:

A C D

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 7

You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI
calculation view.Which kind of currency reference can be assigned to the measure?Note: There are 2
correct answe rs to this questio n.

  • A. Acolumn from another SAP HANA view
  • B. A fixed currency from table TCURC
  • C. Another column of the same SAP HANA view
  • D. A variable in the same SAP HANA view
Answer:

C D

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 8

Which external hierarchy properties can be changed in the query definition? Note: There are 3
correct answe rs to this questio n.

  • A. Position of child nodes
  • B. Sort direction
  • C. Exp to level
  • D. Display text nodes
  • E. Time dependency
Answer:

A B C

vote your answer:
A
B
C
D
E
A 0 B 0 C 0 D 0 E 0
Comments
Question 9

You create a report with SAP Crystal Reports for Enterprise and need an analysis view as a data
source.Which tool can you use to create this analysis view?

  • A. SAP Lumira, designer edition
  • B. SAP BusinessObjects Web Intelligence
  • C. SAP Analysis for Microsoft Office
  • D. SAP Crystal Reports for Enterprise
Answer:

C

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Question 10

In a BW query with cells, you need to overwrite the initial definition of a cell.Which cell types can you
use?Note: There are 2 correct answe rs to this questio n.

  • A. Formula cell
  • B. Help cell
  • C. Selection cell
  • D. Reference cell
Answer:

A C

vote your answer:
A
B
C
D
A 0 B 0 C 0 D 0
Comments
Page 1 out of 7
Viewing questions 1-10 out of 80
Go To
page 2