Question No. 1

Which join types can you use in a CompositeProvider? Note: There are 3 correct answers to this question.

AFull outer join

BReferential join

CHierarchy join

DText join

EInner join

Show Answer

Correct Answer: A, B, E

Question No. 2

"What are benefits of separating master data from transactional data in SAP BW/4HANA? Note: There are 3 correct answer to this question."

AAllowing different data load frequency

BReducing the number of data transfer processes

CEnsuring referential integrity on your transactional data

DProviding language dependent master data texts.

EAvoiding generation of SID values.
Separating master data from transactional data in SAP BW/4HANA has the following benefits:
It allows different data load frequency for master data and transactional data, which can improve the performance and flexibility of data loading processes. For example, master data can be loaded daily or weekly, while transactional data can be loaded hourly or near real-time.
It ensures referential integrity on your transactional data by using SID values that link the transactional data to the master data. This way, the transactional data can be consistent and accurate across different InfoProviders and queries.
It provides language dependent master data texts that can be displayed in different languages according to the user's preference. This way, the master data can be more user-friendly and understandable for different audiences.

Show Answer

Correct Answer: A, C, D

Question No. 3

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.

ARank

BIntersect

CAggregation

DGraph
* A. Rank: This node type is only available for graphical modeling of SAP HANA HDI Calculation Views(XS Advanced), but not for SAP HANA Calculation Views(XS Classic). It allows you to rank the data based on a measure and a ranking rule12.
* D. Graph: This node type is only available for graphical modeling of SAP HANA HDI Calculation Views(XS Advanced), but not for SAP HANA Calculation Views(XS Classic). It allows you to model graph data and perform graph operations such as shortest path, neighborhood search, and pattern matching13.

Show Answer

Correct Answer: A, D

* 1 https://help.sap.com/docs/SAP_HANA_PLATFORM/fc5ace7a367c434190a8047881f92ed8/050f14f7a6d94d2da905b0a4072ba546.html

* 2 https://help.sap.com/docs/r/e8e6c8142e60469bb401de5fdb6f7c00/2.0.03/en-US/9b9b4b8e0c4d4f0a9c3e7f8a3b5d9b9d.html

* 3 https://help.sap.com/docs/r/e8e6c8142e60469bb401de5fdb6f7c00/2.0.03/en-US/e8b26f49218648eaa8e2ce9b54a8b812.html

Question No. 4

You have created a custom characteristic with the technical name "COSTOBJ". Depending on the controlling area, you need to have different atribute values assigned. How do you desing the model?

ACompound characteristic 'COSTOBJ' with the characteristic for Controlling Area

BCompound the characteristic for Controlling Area with the characteristic 'COSTOBJ'

CDefine Controlling Areas as a navigation attribute for the characteristic 'COSTOBJ'

DDefine characteristic 'COSTOBJ' as a navigation attribute for Controlling Area

Show Answer

Correct Answer: B

Question No. 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.

ABAPIs (Business Application Programming Inetrface)

BCalculation views

CAMDPs (ABAP Manged Database Procedures)

DStored procedures

Show Answer

Correct Answer: B, D

Free SAP C_BW4H_211 Exam Actual Questions

The questions for C_BW4H_211 were last updated On Nov 17, 2024