New Year Sale Special 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

SAP C_BW4H_2505 Premium Access     Download Demo    
Page: 2 / 3
Total 80 questions

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 ABAP Connection

B.

SAP BW Shell Migration

C.

SAP BW Remote Migration

D.

SAP BW/4HANA Model Transfer

You create a DataStore object (advanced) using the "Data Mart DataStore Object" modeling property.Which behaviors are specific to this modeling property?Note: There are 2 correctanswers to this question.

A.

The records are treated as if all characteristics are in the key.

B.

Reporting is done based on a union of the inbound and active tables.

C.

Query results are shown only when data has been activated.

D.

The change log table will be filled only after data activation.

In an SAP HANA smart data integration flowgraph, which transformation options are available?Note: There are 3 correctanswers to this question.

A.

Split datasets

B.

Call an ABAP function module

C.

Inctude a stored procedure

D.

Run an SAP HANA analysis process

E.

Combine datasets

You create an SAP HANA HDI Calculation View.What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correctanswers to this question.

A.

You can combine master data transactional data.

B.

You can persist transactional data.

C.

You can provide default time characteristics.

D.

You can create restricted columns.

E.

You can aggregate measures as a sum.

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

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

You want to create an HD! Calculation View (data category Dimension) and integrate it into an HDI Calculation View (data category Cube with Star Join) of the same HDI container.What is the first required step you need to take?

A.

Create and build the HDI Calculation View (data category Dimension).

B.

Create and build the HDI Calculation View (data category Cube with Star Join).

C.

Create a synonym for the HDI Calculation View (data category Cube with Star Join).

D.

Create a synonym for the HDI Calculation View (data category Dimension).

You want to build an SAP HANA HDI calculation view of data category CUBE, but you get a "no measure defined" error.For the business requirement, a measure does not make sense.Besides changing the data category to DIMENSION, what do you have to do?

A.

Switch from an aggregation node to a projection node.

B.

Switch from a projection node to a star join node.

C.

Switch from a projection node to an aggregation node.

D.

Switch from an aggregation node to a star join node.

Which SAP BW/4HANA objects can be used as sources of a data transfer process (DTP)? Note: There are 2 correctanswers to this question.

A.

DataStore Object (advanced)

B.

Open ODS view

C.

InfoSource

D.

CompositeProvider

How does SAP position SAP Datasphere in supporting business users?Note: There are 3 correctanswers to this question.

A.

Business users can leverage embedded analytic Fiori apps for data analysis.

B.

Business users can allocate system resources without IT involvement.

C.

Business users can create agile models from different sources.

D.

Business users can create restricted and calculated columns based on existing models.

E.

Business users can upload their own CSV files.

What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?

A.

Request is set to success, error stack is written, and valid records are updated.

B.

Request is canceled, records are not tracked, and target is not updated.

C.

Request is canceled, first incorrect record is tracked, and target is not updated.

D.

Request is set to failed, error stack is written, and valid records are updated.