SAP Certified Associate - Data Engineer - SAP BW/4HANA (C_BW4H_2505) Free Practice Test

Question 1

For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the High Cardinality flag.What is the effect on SID values in this scenario?

A. SID values are not stored for InfoObject ADDRESS.

B. SID values are generated when data for InfoObject ADDRESS is loaded.

C. SID values are generated when InfoObject ADDRESS is activated.

D. SID values are generated when InfoObject CITY is activated.

Correct Answer: B

Question 2

Which features of an SAP BW/4HANA InfoObject are intended to reduce physical data storage space? Note:
There are 2 correctanswers to this question.

A. Compounding characteristic

B. Transitive attribute

C. Reference characteristic

D. Enhanced master data update

Correct Answer: B,C

Question 3

What foundation is necessary to use SAP S/4HANA embedded analytics?

A. ABAP CDS view based virtual data model

B. SAP Agile Data Preparation

C. SAP HANA optimized business content

D. Generated external SAP HANA Calculation Views

Correct Answer: A

Question 4

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 5

You need to derive an architecture overview model from a key figure matrix. Which is the first step you need to take?

A. Define data marts.

B. Identify sources.

C. Identify transformations.

D. Analyze storage requirements.

Correct Answer: A

Question 6

Which source types are available to create a generic DataSource in SAP ERP? Note: There are 3 correctanswers to this question.

A. SAP query

B. ABAP class method

C. ABAP managed database procedure

D. Database view

E. ABAP function module

Correct Answer: A,D,E

Question 7

Which of the following are possible delta-specific fields for a generic DataSource in SAP S/4HANA? Note:
There are 3 correctanswers to this question.

A. Calendar day

B. Numeric pointer

C. Record mode

D. Request ID

E. Time stamp

Correct Answer: A,B,E

Question 8

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. Replication Task

C. Flowgraph

D. Virtual Table

Correct Answer: D

Question 9

Which features does SAP Analysis for Microsoft Office provide?Note: There are 3 correct answe rs to this question,

A. Including more than one data source

B. Dragging measures in and out of the report

C. Displaying data simultaneously in a table and a chart

D. Changing context menu entries

E. Creating bookmarks for a navigation state

Correct Answer: A,B,E

Welcome to TestSimulate

SAP Certified Associate - Data Engineer - SAP BW/4HANA (C_BW4H_2505) Free Practice Test