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

Question 1

You want to combine an existing SAP BW/4HANA Data Model with virtual data from a new non-SAP source system for test purposes. Which approach should you consider for rapid prototyping?

A. InfoObject base modeling

B. Business content activation

C. Field-based modeling

D. Generate Data Flow

Correct Answer: C

Question 2

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_TYPE

B. SDI_ENTITY_COUNTER

C. SDI_RECORD_MODE

D. SDI_CHANGE_TIME

E. SDI_CHANGE_SEQUENCE

Correct Answer: A,C,D

Question 3

Which external hierarchy properties can be changed in the query definition? Note: There are 3 correct answers to this question.

A. Allow temporal hierarchy join

B. Sort direction

C. Expand to level

D. Position of child nodes

E. Time dependency

Correct Answer: B,C,D

Question 4

What is required before you can integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join) of the same HDI container?"

A. Create a synonym for the HDI Calculation View (data category with Star Join).

B. Create a synonym for the HDI Calculation View (data category Dimension).

C. Build the runtime object of the HDI Calculation View (data category Cube with Star Join) to generate a design time file.

D. Build the design time file of the HDI Calculation View (data category Dimension) to generate a runtime object.

Correct Answer: D

Question 5

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

A. Calculation View of type Dimension

B. Open ODS view of type Facts

C. InfoObjetc of type Characteristic

D. Open ODS view of type Master Data

Correct Answer: C,D

Question 6

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.

A. Associate the field with the characteristic in the CompositeProvider

B. Assign hierarchy properties to the field in the SW Query

C. Associate the field with the characteristic In the Open ODS View

D. Add the characteristic to the DataStore object (advanced)

Correct Answer: D

Question 7

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

A. 5

B. 10

C. 7

D. 3

Correct Answer: A

Question 8

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.

A. Stored procedures

B. Calculation views

C. AMDPs (ABAP Manged Database Procedures)

D. BAPIs (Business Application Programming Inetrface)

Correct Answer: A,B

Question 9

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 join cardinality between both tables

D. The logon language in the left table

Correct Answer: B

SAP Certified Associate - Reporting, Modeling and Data Acquisition with SAP BW/4HANA - C-BW4H-214 Exam Practice Test

Latest Update

Useful Links

Contact Us