Practice C_BW4H_214 Exam Online

Question 1

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

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.

Answer: A,B

Question 2

You use the key figure Sales Order Amount in the Columns section of a BW query and restrict it to the months January and February 2021. How many columns will be displayed in the report?

A : One column with Sales Order Amount January and February 2021

B : Two columns, one for Sales Order Amount January 2021 and one for Sales Order Amount February 2021

Answer: A

Question 3

'You created an Open ODS View on an SAP HANA database table to virtually consume the data in SAP BW/4HAN

A : 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.'

B : Data source

C : Composite Provider

D : Transformation

E : Data Store object (advanced)

F : SAP HANA calculation view.

Answer: A,B,C,D

Question 4

For which SAP BW/4HANA objects is it possible to create an external SAP HANA view?

There are 2 correct answers to this question

A : Open ODS View

B : Composite Providers

C : Key Figures

D : Characteristics

Answer: B,D

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 righ table

C : The logon language in the left table

D : The join cardinality between both tables

Answer: B

Name:	SAP Certified Application Associate - Reporting, Modeling and Data acquisition with SAP BW/4HANA
Exam Code:	C_BW4H_214
Certification:	SAP Certified Application Associate
Vendor:	SAP
Total Questions:	418
Last Updated:	Apr 23, 2024

SAP C_BW4H_214