New Year Special Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: mxmas70

Home > SAP > SAP Certified Associate > C_BW4H_2404

C_BW4H_2404 SAP Certified Associate - Data Engineer - Data Fabric Question and Answers

Question # 4

"You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HANA. Real-time reporting requirements have now changed and 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 correct answers to this question."

A.

Data source

B.

Composite Provider

C.

Transformation

D.

Data Store object (advanced)

E.

SAP HANA calculation view.

Full Access
Question # 5

You created an Open ODS view of type Facts. Which object type can you associate with a view field in the characteristics folder? Note: There are 2 correct answers to this question.

A.

Open ODS view of type Facts

B.

Calculation View of type Dimension

C.

Open ODS view of type Master Data

D.

InfoObjetc of type Characteristic

Full Access
Question # 6

You create a generic DataSource in SAP ERP. "How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in casa it is not available by default?"

A.

Release the DataSource in SAP BW/4HANA for ODP

B.

Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource

C.

Generate the PSA table of the DataSource in SAP BW/4HANA

D.

Add a subscription in SAP ERP using the program RODPS_REPL_TEST.

Full Access
Question # 7

"You have already loaded data from a non-sap system into SAP Data Wharehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system" What do you need to use to combine data?

A.

BW SHEL Migration

B.

BW Remote migration

C.

SAP ABAP Connection

D.

SAP BW/4HANA Model Transfer.

Full Access
Question # 8

The Database Explorer in the Web IDE for SAP HANA proveides a data file improt wizard to create a table in SAP HANA from a flat file. What are possible actions adter the system suggests the target structure?? Note: There are 3 correct answers to this question.

A.

Change the order of the fields in the target table

B.

Switch the table type between row store and column store

C.

Define sorting properties for a target table field

D.

Adjust the suggested data type of the target table fileds

E.

Map InfoObjetcs to fields in the target tavle

Full Access
Question # 9

For a BW query, you want to have the first month of the current quarter as a default value for an input-ready BW variable for the characteristic OCALMONTH. Which processing tyoe do you use?

A.

Customer Exit

B.

Manual Input with offset value

C.

Replacement Path

D.

Manuel Input with default value

Full Access
Question # 10

In an SAP HANA HDI Calculation View, you need to combine attributes data (left table) and the data's language-dependent text (right table) using a text join. What should you select to restrict the result set to the logon language?

A.

the language column in the left table

B.

the language column in the right table

C.

The logon language in the left table

D.

The join cardinality between both tables

Full Access
Question # 11

You are involved in an SAP BW/4HANA project focusin on General Ledger reporting and want to use the SAP ERP Estandar DataSource oFI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question.

A.

Transaction RSA1 (BI Content) in the SAP BW/4HANA system

B.

Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system

C.

Transaction RS02 (Maintain Generic DataSource) in the SAP source system

D.

Transaction ODQMON (Monitor Delta Queues) in the SAP Source system

Full Access
Question # 12

What are some of the variable types n a BW query that can use the processing tupe SAP HANA Exit. Note: There are 2 correct answers to this question.

A.

Formula

B.

Text

C.

Charateristic value

D.

Hierarchy node

Full Access
Question # 13

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

A.

Create restricted columns

B.

Provide default time characteristics

C.

Persist transactional data

D.

Combine master data and transactional data

E.

Aggregate measures as a sum

Full Access
Question # 14

What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA? Note: There are 2 correct answers to this question.

A.

There must be no BW analysis authorizations defined thta use any of the cost centers

B.

There must be no transaction data referring to the cost centers

C.

There must be no hierarchy for the cost centers

D.

There must be no BW query that uses cost cenetr as a free characteristics.

Full Access
Question # 15

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

A.

SAP HANA optimized business content

B.

SAP Agile Data Preparation

C.

Generated external SAP HANA Calculation Views

D.

ABAP CDS view based virtual data model.

Full Access
Question # 16

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

A.

ODP_BW

B.

ODP_CDS

C.

ODP_SAP

D.

ODPJHANA

Full Access
Question # 17

Which disadvantages should you keep in mind when you set the High Cardinality flag for a characteristic? Note: There are 2 correct answers to this question.

A.

You cannot use navigation attributes for this characteristic

B.

You cannot load more than 2 billion master data records for this characteristic

C.

SID numbers are created at runtime which might negatively affetct the reporting performance

D.

You cannot use this characteristic as a navigation attribute for another characteristic.

Full Access
Question # 18

Which data deletion options are offered for a standard DataStore object (advanced)? Note: There are 3 correct answers to this question.

A.

Deletion of all data from active table only

B.

Request-based data deletion

C.

Selective deletion of data

D.

Deletion of data from all tables

E.

Selection deletion incluiding data of subsequent targets

Full Access
Question # 19

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

A.

Use the ODQ maintance in SAP BW/4HANA

B.

Use transaction RSA3 (Extractor checker) in SAP ERP

C.

Check entries in table RSDDSTATEXTRACT in SAP ERP

D.

Use program RODPS_REPL_TEST in SAP ERP

Full Access
Question # 20

You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source. Which tool can you use to create this analysis view?

A.

SAP BusinessObjetc Web Intelligence

B.

SAP Lumira, designer edition

C.

SAP Crustal Reportis for Enterprise

D.

SAP Analysis for Microsoft Office

Full Access
Question # 21

Which SAP solutions can leverage the Write Interface for DataStore objects (advanced) to push data into the inbound table of DataStore objects (Advanced)?

There are 2 correct answers to this question.

A.

SAP Data Services

B.

SAP Landscape Transformation Replication Server

C.

SAP Process Integration

D.

SAP Data Warehouse Cloud.

Full Access
Question # 22

You open an SAP Analysis for Microsoft Office workbook. On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.

A.

Analysis

B.

Components

C.

Information

D.

Design Rules

Full Access
Question # 23

Which of the following are possible delta-specific field for a generic DataSource in SAP ERP? Note: There are 3 correct answers to this question.

A.

Record mode

B.

Calendar day

C.

Request ID

D.

Time stamp

E.

Numeric pointer

Full Access
Question # 24

You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows?

A.

Only one result row with the sales revenue sum of all 100 customers

B.

Only one result row with the sales revenue sum of the top 10 customers

C.

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

D.

One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 100 customers

Full Access