SAP C_BW4H_2404 Exam Practice Test Instant Access

Question 1

What are valid options when using the Data Flow feature of SAP Datasphere? Note: There are 3 correct answers to this question.

ANumPy Pas are automatically converted to SQL script.

BPython language can be used for complex transformation.

CData can be combined using Union or Join operators.

DRemote tables can be used as target objects.

ETarget mode can be Append Truncate or Delete.

Answer : B, C, E

Question 2

Which type of data builder object can be used to fetch delta data from a remote table located in the SAP BW bridge space?

ATransformation Flow

BEntity relationship model

CReplication Flow

DData Flow

Answer : C

Question 3

Which of the following factors apply to Model Transfer in the context of Semantic Onboarding? Note: There are 2 correct answers to this question.

ASAP BW/4HANA Model Transfer leverages BW Queries for model generation in SAP Datasphere.

BModel Transfer can be leveraged from an On-premise environment to the cloud the other way around.

CSAP BW bridge Model Transfer leverages BW Modeling tools to import entities into native SAP Datasphere.

DSAP S/4HANA Model Transfer leverages ABAP CDS views for model generation in SAP Datasphere.

Answer : A, D

Question 4

What are prerequisites for S-API Extractors to load data directly into SAP Datasphere core tenant using delta mode? Note: There are 2 correct answers to this question.

AReal-time access needs to be enabled

BA primary key needs to exist.

CExtractor must be based on a function module

DOperational Data Provisioning (ODP) must be enabled

Answer : B, D

Question 5

Which modeling decisions may have side effects on runtime performance? Note: There are 3 correct answers to this question.

AUse a transitive attribute instead of an attribute that is directly assigned to a characteristic.

BUncheck the 'Write change log' property for a Stard DataStore Object.

CMove a characteristic within a DataMart DataStore object to a different group.

DChange a time-independent attribute of a characteristic to a time-dependent attribute.

EInclude a characteristic from the underlying DataMart DataStore Object in the CompositeProvider instead of a navigation attribute.

Answer : A, B, E

Question 6

An upper-level CompositeProvider compares current values with historic values based on a union operation. The current values are provided by a DataStore object (advanced) that is updated daily. Historic values are provided by a lower-level CompositeProvider that combines different open ODS views from DataSources.

What can you do to improve the performance of the BW queries that use the upper-level CompositeProvider? Note: There are 2 correct answers to this question.

AReplace the lower-level CompositeProvider with a new DataStore object (advanced) fill it with the same combination of historic data.

BUse a join node instead of the Union node in the upper-level CompositeProvider.

CReplace the DataStore object (advanced) for current data by an Open ODS view that accesses the current data directly from the source system.

DUse the 'Generate Dataflow' feature for the Open ODS views load the historic data to the new generated DataStore objects (advanced).

Answer : A, D

Question 7

Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question.

ACreate linked components.

BInclude fewer drill-down characteristics in the initial view.

CUse matory characteristic value variables.

DUse the include mode within filter restrictions.

EUse the dereference option for reusable filters.

Answer : B, C, D

SAP C_BW4H_2404 SAP Certified Associate - Data Engineer - Data Fabric Exam Practice Test