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

QUESTION NO: 1
For which requirements do you suggest an SAP HANA modeling focus rather than an focus? Note: There are
2 correctanswers to this question.

A. Reporting on a harmonized set of master data B. Loading snapshots or deltas from different sources on a periodic basis C. Finding the best match using a fuzzy search D. Leveraging SQL in-house knowledge

Correct Answer: C,D

QUESTION NO: 2
Why should you run an SAP HANA delta merge?Note: There are 2 correctanswers to this question.

A. To decrease memory consumption B. To combine the query cache from different executions C. To improve the read performance of InfoProviders D. To move the most recent data from disk to memory

Correct Answer: A,C

QUESTION NO: 3
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. Table Function B. Flowgraph C. Replication Task D. Virtual Table

Correct Answer: D

QUESTION NO: 4
You have already loaded data from a non-SAP system into . You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA.What do you need to use to combine the data?

A. SAP BW/4HANA Model Transfer B. SAP BW Shell Migration C. SAP ABAP Connection D. SAP BW Remote Migration

Correct Answer: C

QUESTION NO: 5
Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (advanced)? Note: There are 2 correctanswers to this question.

A. SAP Lscape Transformation Replication Server B. SAP Process Integration C. SAP Data Services

Correct Answer: B,C

QUESTION NO: 6
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 BusinessObjects Web Intelligence B. SAP Analysis for Microsoft Office C. SAP Lumira, designer edition D. SAP Crystal Reports for Enterprise

Correct Answer: B

QUESTION NO: 7
In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent texts (right table) using a text join.What should you select to restrict the result set to the logon language?

A. The join cardinality between both tables B. The logon language in the left table C. The language column in the right table D. The language column in the left table

Correct Answer: C

QUESTION NO: 8
Which data deletion options are offered for a Standard DataStore Object (advanced)?Note: There are 3 correctanswers to this question.

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

Correct Answer: A,B,C

QUESTION NO: 9
You want to create a restricted column in an SAP HANA HDI calculation view.What do you need to define?
Note: There are 2 correctanswers to this question.

A. An SAP HANA data type B. A condition criterion C. A reference to an existing measure D. An aggregation method

Correct Answer: B,C

SAP Certified Associate - Data Engineer - SAP BW/4HANA - C-BW4H-2505 Exam Questions