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

Home > SAP > SAP Application Associate Certification > C_BW4H_214

C_BW4H_214 SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA Question and Answers

Question # 4

With SAP BW/4HANA, the new HANA-optimized business content is designed according to the LSA++ framework. Which tecnical namespace is assigned to identify the new SAP ERP-related business content?

A.

/BW4/

B.

/IMO/

C.

/SFA/

D.

/0SAP/

Full Access
Question # 5

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 righttable

C.

The logon language in the left table

D.

The join cardinality between both tables

Full Access
Question # 6

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

A.

To store snapshots for reporting

B.

To provide an interface for BW queries

C.

To persist combined data for reporting

D.

To provide a virtual data mart layer

Full Access
Question # 7

For which requirements do you suggest an SAP HANA modeling focus rather that an SAP BW/4HANA modeling focus?? Note: There are 2 correct answers to this question.

A.

Enhance existing SAP HANA content models

B.

Report on a harmonized set of master data

C.

Load snapshots or deltas from different sources on a periodic basis

D.

Leverage SQL in-house knowledge

Full Access
Question # 8

In a BW query with cells, you need to overwrite the initial definition of a cell. With which cell tupes can this be achieved?? Note: There are 2 correct answers to this question.

A.

Selection cell

B.

Reference cell

C.

Formula cell

D.

Help cell

Full Access
Question # 9

What can you leverage using the live data connectyions of SAP Analytics Cloud with SAP BW/4HANA? Note: There are 2 correct answers to this question.

A.

Existing authorization concepts

B.

BW data models for analysis

C.

BW data models for planning scenarios

D.

Process chain streaming functionally

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/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 # 11

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

A.

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

B.

Automatic content activation during installation of SAP BW/4HANA

C.

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

D.

Ability to combine business content objects with custom-defined objects.

Full Access
Question # 12

When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? Note: There are 2 correct answers to this question.

A.

When you define the attributes of material, select the "Time Dependent" setting

B.

When you define the data transfer process, select the "Load records wit new key only" setting

C.

When you define the data transfer process, choose the "Set Manually" setting for "Overrall status of request"

D.

When you define the material characteristic, select the "Enhanced Master data update" setting

Full Access
Question # 13

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

A.

By setting a specific flag in the data transfer process

B.

By using a specific process type in a process chain

C.

By setting a specific flag in the transformation

D.

By using the SAP BW/4HANA data load monitor.

Full Access
Question # 14

Which node types are only available for graphical modeling of SAP HANA HDI Calculation Views(XS Advanced), but not for SAP HANA Calculation Views(XS Classic)? Note: There are 2 correct answers to this question.

A.

Rank

B.

Intersect

C.

Aggregation

D.

Graph

Full Access
Question # 15

What is the purpose of an architecture overview model?

A.

To identify the user groups and required authorizations

B.

To automatically generate the LSA++ architecture

C.

To determine the sequence of projects

D.

To identify the required data sources.

Full Access
Question # 16

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 # 17

You would like to highlight the deviation from predefined threshold values for key figures actual revenue. Which BW feature do you use?

A.

Structure

B.

Conditions

C.

Exceptions

D.

Calculated key figures

Full Access
Question # 18

For a BW query, you want to have the first month of the curret 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 # 19

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 # 20

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

A.

ABAP class method

B.

Database view

C.

HDI Calculation View

D.

ABAP function module

E.

SAP query

Full Access
Question # 21

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 # 22

You create a transformation from a DataSource to a DataMart Data Store object (advanced) All key figures are updated as Sum. Which Delta methods indicate that the DataSource provides consistentinformation for this target? Note: There are 2 correct answers to this question.

A.

ABR

B.

ADD

C.

AIM

D.

AIE

Full Access
Question # 23

In a DatStore object (advanced) of type Data Mart, which request-based deletion is possibel?

A.

The lastest not-yet-activated reques in the inbound table

B.

The lastest request in the active data table

C.

Any older activated reqeust in the inbound table

D.

The lastest request in the change log table

Full Access
Question # 24

You define a remote subscription of type UPSERT in an SAP HANA Smart Data Integration (SDI) real-time udate scenario. Which fields are added to the DataSource automatically? Note: There are 3 correct answers to this question.

A.

SDI_CHANGE_TIME

B.

SDI_CHANGE_SEQUENCE

C.

SDI_RECORD_MODE

D.

SDI_CHANGE_TYPE

E.

SDI_ENTITY_COUNTER

Full Access