Winter Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

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

Demo: 24 questions
Total 80 questions

SAP Certified Associate - Data Engineer - Data Fabric Questions and Answers

Question 1

What does a Composite Provider allow you to do in SAP BW/4HANA? Note: There are 3 correct answers to this question.

Options:

A.

Join two ABAP CDS views.

B.

Create new calculated fields.

C.

Define new restricted key figures.

D.

Integrate SAP HANA calculation views.

E.

Combine InfoProviders using Joins Unions.

Question 2

Which feature of a DataStore object (advanced) should be made available to improve the performance for data analysis?

Options:

A.

Snapshot Support

B.

Partitioning

C.

Inventory Management

D.

ChangeLog

Question 3

For which reasons should you run an SAP HANA delta merge? Note: There are 2 correct answers to this question.

Options:

A.

To decrease memory consumption

B.

To combine the query cache from different executions

C.

To move the most recent data from disk to memory

D.

To improve the read performance of InfoProviders

Question 4

Where is the button that automatically generates a process chain?

Options:

A.

In the app called Process Chain Editor

B.

In the editor of a data transfer process

C.

In the SAP GUI transaction for Process Chain Maintenance

D.

In the editor of a data flow object

Question 5

How can the delta merge process be initiated in SAP BW/4HANA? Note: There are 2 correct answers to this question.

Options:

A.

By using a specific process type in a process chain

B.

By using the SAP BW/4HANA data load monitor

C.

By setting a specific flag in the transformation

D.

By setting a specific flag in the data transfer process

Question 6

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?

Options:

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

Question 7

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

Options:

A.

Create linked components.

B.

Include fewer drill-down characteristics in the initial view.

C.

Use matory characteristic value variables.

D.

Use the include mode within filter restrictions.

E.

Use the dereference option for reusable filters.

Question 8

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

Options:

A.

Hierarchy

B.

InfoObject type Key Figure

C.

Open ODS View

D.

DataStore Object (advanced)

E.

Composite Provider

Question 9

In which ODP context is the operational delta queue (ODQ) managed by the target system?

Options:

A.

ODP_BW

B.

ODP SAP

C.

ODP_CDS

D.

ODP_HANA

Question 10

You have already loaded data from a non-SAP system into SAP Datasphere. 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?

Options:

A.

SAP ABAP Connection

B.

SAP BW Shell Migration

C.

SAP BW Remote Migration

D.

SAP BW/4HANA Model Transfer

Question 11

What are some of the prerequisites for using SAP S/4HANA ABAP CDS views for extraction into SAP BW/4HANA in an ODP context? Note: There are 2 correct answers to this question.

Options:

A.

The ABAP CDS views must be released through the program RODPS_OS_EXPOSE for BW extraction.

B.

The Operational Data Provisioning Framework must be configured in SAP BW/4HANA.

C.

An ODP source system with context ODP_CDS must be created in SAP BW/4HANA.

D.

The ABAP CDS views must be defined with the appropriate data extraction annotations.

Question 12

Which tasks are part of the Business Blueprint phase in an SAP BW/4HANA project? Note: There are 2 correct answers to this question.

Options:

A.

Analyze key performance indicators of the business processes

B.

Associate an InfoObject to a field in an Open ODS view

C.

Activate SAP business content objects that comply with the layered scalable architecture (LSA++) architecture

D.

Collect central individual information requirements

Question 13

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

Options:

A.

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

B.

Query results are shown only when data has been activated.

C.

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

D.

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

Question 14

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue.

Using key figure properties in the BW query which two scenarios regarding result presentation can be achieved? Note: There are 2 correct answers to this question.

Options:

A.

One result row with the sales revenue sum of all 100 customers

B.

One result row with the sales revenue sum of the top 10 customers a second result row with the sales revenue sum of all 100 customers

C.

One result row with the sales revenue sum of the top 10 customers

D.

One result row with the sales revenue sum of the top 10 customers a second result row with the sales revenue sum of the other 90 customers

Question 15

While running a query insufficient analysis authorization causes an error message.

Which transaction can be used to trace the missing authorization for the specific characteristic values?

Options:

A.

Transaction ST01

B.

Transaction RSUDO

C.

Transaction STAUTHTRACE

D.

Transaction SU53

Question 16

You have an existing field-based data flow that follows the layered scalable architecture (LSA++) concept. To meet a new urgent business requirement for field you want to leverage a hierarchy of an existing characteristic without changing the transformation.

How can you achieve this? Note: There are 2 correct answers to this question.

Options:

A.

Assign hierarchy properties to the field in the BW Query

B.

Add the characteristic to the DataStore object (advanced)

C.

Associate the field with the characteristic in the Open ODS View

D.

Associate the field with the characteristic in the CompositeProvider

Question 17

You created an Open ODS view of type Facts.

With which object types can you associate a field in the Characteristics folder? Note: There are 2 correct answers to this question.

Options:

A.

Open ODS view of type Master Data

B.

InfoObject of type Characteristic

C.

Open ODS view of type Facts

D.

HDI Calculation View of data category Dimension

Question 18

How can you protect all InfoProviders against displaying their data?

Options:

A.

By flagging all InfoProviders as authorization-relevant

B.

By flagging the characteristic 0TCAIPROV as authorization-relevant

C.

By flagging all InfoAreas as authorization-relevant

D.

By flagging the characteristic 0INFOPROV as authorization-relevant

Question 19

What are the reasons for implementing Composite Providers? Note: There are 2 correct answers to this question.

Options:

A.

To persist combined data for reporting

B.

To directly expose an SAP HANA table from an external schema

C.

To provide an interface for using BW queries

D.

To provide a virtual data mart layer that combines existing BW models

Question 20

Which development object needs to be built to generate an HDI Container?

Options:

A.

Space

B.

HDB module

C.

Package

D.

SQL script procedure

Question 21

Why do you use an authorization variable?

Options:

A.

To provide dynamic values for the authorization object S_RS_COMP

B.

To filter a query based on the authorized values

C.

To protect a variable using an authorization object

D.

To provide an analysis authorization with dynamic values

Question 22

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 23

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

Options:

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

Question 24

In SAP BW/4HANA a query has been defined on a Datastore Object (advanced).

Which authorizations does an SAP BW/4HANA user need at minimum to change the query definition? Note: There are 2 correct answers to this question.

Options:

A.

Authorizations for the Authorization Object S_RS_COMP

B.

Authorizations for the Authorization Object S_RS_AUTH

C.

Authorizations for the Authorization Object S_RS_COMP1

D.

Authorizations for the Authorization Object S_RS_ADSO

Demo: 24 questions
Total 80 questions