1. Home
  2. SAP
  3. SAP Certified Associate
  4. C_BW4H_214
  5. SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA Questions and Answers

Pass the SAP SAP Certified Associate C_BW4H_214 Questions and answers with CertsForce

 SAP Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

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?

Options:
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

Expert Solution
Questions # 2:

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.

Options:
A.

Analysis

B.

Components

C.

Information

D.

Design Rules

Expert Solution
Questions # 3:

InfoObject CITY is defined as a display attribute for InfoObject CUSTOMER, and InfoObject COUNTRY is defined as a display attribute for InfoObject CITY. In a master data report you want to display the COUNTRY of a CUSTOMER. Which options do you have to realize the scenario? Note: There are 3 correct answer to this question."

Options:
A.

Combine CUSTOMER, CITY and COUNTRY in a Open ODS View using a sequence of associations.

B.

Generate external views for CUSTOMER, CITY and COUNTRY, and join them in another calculation view.

C.

Combine CUSTOMER, CITY and COUNTRY in a Composite Provider using a sequence of left outer join operators.

D.

Include CUSTOMER to rows in the BW Query on CUSTOMER and activate the Universal Display Hierarchy setting.

E.

Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.

Expert Solution
Questions # 4:

You want to set up the replication process for the SAP Landscape Transformation Replication Server. Which actions can you define for a specific table? Note: There are 2 correct answers to this question.

Options:
A.

Apply mapping rules during the replication

B.

Set the reading type and portion sizes

C.

Change or enrich the table structure

D.

Convert Unicode to non-Unicode

E.

Apply customizing settings to the database redo logs.

Expert Solution
Questions # 5:

Using SAP HANA as modeling focus, you want to combine data from different sources. Which techniques can you use? Note: There are 2 correct answers to this question.

Options:
A.

BAPIs (Business Application Programming Inetrface)

B.

Calculation views

C.

AMDPs (ABAP Manged Database Procedures)

D.

Stored procedures

Expert Solution
Questions # 6:

What is the request handling default setting for error handling in a data transfer process (DTP) in SAP BW/4HANA?

Options:
A.

Request is set to failed, error stack is written, and valid records are updated

B.

Request is canceled, records are not tracked, and tarjet is not updated

C.

Request is set to success, error stack is written, and valid records are updated

D.

Request is canceled, firt incorrect record is tracked, and target is not updated.

Expert Solution
Questions # 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?

Options:
A.

BW SHEL Migration

B.

BW Remote migration

C.

SAP ABAP Connection

D.

SAP BW/4HANA Model Transfer.

Expert Solution
Questions # 8:

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

Options:
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.

Expert Solution
Questions # 9:

You have an existing field-based data flow that follows the LSA++ concept. To meet a new urgent business requirement for a 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.

Associate the field with the characteristic in the CompositeProvider

B.

Add the characteristic to the DataStore object (advanced)

C.

Associate the field with the characteristic In the Open ODS View

D.

Assign hierarchy properties to the field in the SW Query

Expert Solution
Questions # 10:

"For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the high Cardinality flag." What is the effect on SID values in this scenario?

Options:
A.

SID values are not stored for InfoObject ADDRESS

B.

SID values are generated when data for infoObject ADDRESS is loadet

C.

SID values are generated when InfoObject CITY is activated

D.

SID values are generated when InfoObject ADDRESS is activated.

Expert Solution
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions