Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: myex65

Home > SAP > SAP Certified Associate > C_BW4H_2505

C_BW4H_2505 SAP Certified Associate - Data Engineer - SAP BW/4HANA Question and Answers

Question # 4

You created a generic DataSource in SAP ERP, but did not release the DataSource for Operational Data Provisioning (ODP).What is the effect in SAP BW/4HANA?

A.

The ODP DataSource has to be created using the ODP_HANA source system type.

B.

The ODP DataSource has to be created using the ODP_SAP source system type.

C.

The ODP DataSource cannot be replicated using the ODP_SAP source system type.

D.

The ODP DataSource can be generated using the DataFlow generation feature.

Full Access
Question # 5

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

Full Access
Question # 6

For which use case would you need to model a transitive attribute?

A.

Generate a transient provider for a BW query on master data attributes

B.

Store time-dependent snapshots of master data attributes

C.

Load attributes using the enhanced master data update

D.

Report on navigational attributes of navigational attributes

Full Access
Question # 7

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

Full Access
Question # 8

For a report, you would like to highlight the deviation from predefined threshold values for a key figure.Which BW query feature do you use?

A.

Condition

B.

Exception

C.

Key figure property

D.

Formula cell

Full Access
Question # 9

In a BW query with cells, you need to overwrite the initial definition of a cell.Which cell types can you use?Note: There are 2 correctanswers to this question.

A.

Formula cell

B.

Help cell

C.

Selection cell

D.

Reference cell

Full Access
Question # 10

You notice that an SAP ERP ODP_SAP DataSource is delivering incorrect values into the first persistent data layer in SAP BW/4HANWhich options do you have to analyze a potential extractor issue? Note: There are 2 correctanswers to this question.

A.

Use the program RODPS_REPL_TEST in SAP ERP.

B.

Use the transaction ODQMON (Monitor Delta Queues) in SAP BW/4HANA.

C.

Use the transaction RSA3 (Extractor checker) in SAP ERP.

D.

Check entries in the table RSDDSTATEXTRACT in SAP ERP.

Full Access
Question # 11

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

A.

SAP HANA optimized business content

B.

ABAP CDS view based virtual data model

C.

Generated external SAP HANA Calculation Views

D.

SAP Agile Data Preparation

Full Access
Question # 12

What is the maximum number of reference characteristics that can be used for one key figure with a multi- dimensional exception aggregation in a BW query?

A.

10

B.

7

C.

5

D.

3

Full Access
Question # 13

Which are purposes of the Open Operational Data Store layer in the layered scalable architecture (LSA++) of SAP BW/4HANA? Note: There are 2 correctanswers to this question.

A.

Harmonization of data from several source systems

B.

Transformations of data based on business logic

C.

Initial staging of source system data

D.

Real-time reporting on source system data without staging

Full Access
Question # 14

Which layer of the layered scalable architecture (LSA++) of SAP BW/4HANA is designed as the main storage for harmonized consistent data?

A.

Open Operational Data Store layer

B.

Data Acquisition layer

C.

Flexible Enterprise Data Warehouse Core layer

D.

Virtual Data Mart layer

Full Access
Question # 15

Why is the start process a special type of process in a process chain?Note: There are 2 correctanswers to this question.

A.

Only one start process is allowed for each process chain.

B.

Itcan be a successor of another process.

C.

It is the only process that can be scheduled without a predecessor.

D.

It can be left out when the Process Chain is embedded in a meta chain.

Full Access
Question # 16

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

A.

ABAP class method

B.

SAP query

C.

ABAP managed database procedure

D.

ABAP function module

E.

Database view

Full Access
Question # 17

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.

Full Access
Question # 18

How does SAP Business Data Cloud facilitate the use of diverse data sources for Al-powered analytics?

A.

By integrating diverse data sources through custom APIs

B.

By providing a secure platform for storing and managing diverse data sets

C.

By centralizing data from both SAP and non-SAP sources into a unified semantic layer

D.

By transforming raw data from diverse sources into a standardized format

Full Access
Question # 19

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.

Full Access
Question # 20

Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View? Note: There are 2 correctanswers to this question.

A.

BW query

B.

Open ODS view

C.

Composite Provider

D.

Semantic group object

Full Access
Question # 21

In SAP Web IDE for SAP HANA, you have imported a project including an HDB module with calculation views.What do you need to do in the project settings before you can successfully build the HDB module?

A.

Generate the HDI container

B.

Assign a space

C.

Define a package

D.

Change the schema name

Full Access
Question # 22

What are some of the advantages of using SAP BW/4HANA business content? Note: There are 2 correctanswers to this question.

A.

Automatic content activation during installation of SAP BW/4HANA

B.

Automatic generation of Analysis Authorizations during SAP BW/4HANA content activation

C.

Accelerated SAP BW/4HANA implementation using ready-made models

D.

Ability to modify business content objects to meet customer specific requirements

Full Access
Question # 23

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.

Full Access
Question # 24

What does a CompositeProvicer allow you to do in SAP BW/4HANA?Note: There are 3 correctanswers to this question.

A.

Join two ABAP CDS views

B.

Define new restricted key figures

C.

Create new calculated fields

D.

Combine InfoProviders using Joins and Unions

E.

Integrate SAP HANA calculation views

Full Access