Practice C_BW4H_211 Exam Online

Question 1

You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider. What must you do first?

A :

Assign consumption properties to the new SAP HANA calculation view

B : Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema

C : Connect an export DataSource from the existing CompositeProvider to the new CompositeProvider

D : Set "The CompositeProvider Can Be Added to Another CompositeProvider" flag

Answer: D

Question 2

You want to build an SAP HANA HDI calculation view of data category CUBE, but you get the 'no measure defined' error. For the business requirement, a measure does not make sense. Besides changing the data category to DIMENSION, what do you have to do?

A : Switch from an aggregation node to a star join node

B : Switch from an aggregation node to a projection node

C : Switch form a projection node to an aggregation node

D : Switch from a projection node to a star join node

Answer: B

Question 3

For which of the following scenarios can conditions be used?

There are 2 correct answers to this question

A : Filter for business partner numbers beginning with “1”.

B : Filter for business partners for which the number of the open order items is greater than 100.

C : Filter for business partners located in Germany.

D : Filter for business partners which contribute to the upper 75 % of sales revenue.

Answer: A,D

Question 4

You need to create a composite provider to combine data from an SAP HANA calculation view with a Datastore object (advanced). Which of the following Eclipse perspectives do you use?

A : BW modeling perspective

B : JavaScript perspective

C : ABAP perspective

D : SAP HANA Modeler perspective

Answer: A

Question 5

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.

* A. You cannot use navigation attributes for this characteristic: This is a disadvantage of setting the High Cardinality flag for a characteristic. A characteristic with high cardinality cannot be used as a navigation attribute for another characteristic, and therefore it cannot have navigation attributes itself12.

* C. SID numbers are created at runtime which might negatively affect the reporting performance: This is a disadvantage of setting the High Cardinality flag for a characteristic. A characteristic with high cardinality has no persistent SID values and no SID table, which means that the SID numbers are generated on the fly during query execution. This can have a negative impact on the reporting performance, especially if the characteristic is used in filters or aggregations13.

Answer: A,C

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

SAP C_BW4H_211