Month End Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

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

Page: 1 / 3
Total 80 questions

What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correctanswers to this question.

A.

By using a BW query (update value set by query)

B.

By accessing an SAP HANA HDI Calculation View of data category Dimension

C.

By using a transformation data transfer process (DTP)

D.

By entering the values manually

E.

By referencing a table

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 generated when InfoObject ADDRESS is activated.

B.

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

C.

SID values are generated when InfoObject CITY is activated.

D.

SID values are not stored for InfoObject ADDRESS.

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

A.

Identify transformations.

B.

Identify sources.

C.

Analyze storage requirements.

D.

Define data marts.

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

What are benefits of separating master data from transactional data in SAP BW/4HANA?Note: There are 3 correctanswers to this question.

A.

Reducing the number of database tables

B.

Ensuring referential integrity on your transactional data

C.

Avoiding generation of SID values

D.

Allowing different data load frequency

E.

Providing language-dependent master data texts

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.

A reference to an existing measure

B.

An aggregation method

C.

A condition criterion

D.

An SAP HANA data type

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 correctanswers to this question.

A.

DataStore object (advanced)

B.

SAP HANA calculation view

C.

Transformation

D.

Data source

E.

CompositeProvider

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

Which objects in SAP BW/4HANA allow you to use both fields InfoObjects in their definition? Note: There are 3 correctanswers to this question.

A.

Hierarchy

B.

InfoObject type Key Figure

C.

Open ODS View

D.

DataStore Object (advanced)

E.

Composite Provider

What are benefits of using an InfoSource in a data flow?Note: There are 2 correctanswers to this question.

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