C_BW4H_2404 Online Practice Questions and Answers

Correct Answer: D

Correct Answer: A

Correct Answer: ABD

Correct Answer: AC

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

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

References: https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/f851415842154e59a5f038e458b97a0b.html https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/88a51330c046426091f3730d0c42c0de.html https://blogs.sap.com/2019/01/14/high-cardinality-characteristics-in-bw4hana/

Correct Answer: ACD

Separating master data from transactional data in SAP BW/4HANA has the following benefits:

1.

It allows different data load frequency for master data and transactional data, which can improve the performance and flexibility of data loading processes. Forexample, master data can be loaded daily or weekly, while transactional data

can be loaded hourly or near real-time.

2.

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.

3.

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.

Correct Answer: ACE

Combine InfoProviders using Join and Unions: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider is an InfoProvider that combines data from several analytic indexes or from other InfoProviders (by union or inner join or left outer join), and makes this data available for reporting and analysis. Storing the data in BW Accelerator or in an SAP HANA database also ensures faster access to data in the query.

Define new restricted key figures: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can define new restricted key figures based on the existing key figures of the underlying InfoProviders. Restricted key figures are key figures that are restricted by one or more characteristics.

Integrate SAP HANA HDI calculation views: This is what a Composite Provider allows you to do in SAP BW/4HANA. A Composite Provider can integrate SAP HANA HDI calculation views as part of its data sources, using a virtual table or an external SAP HANA view. This can enable mixed modeling scenarios that leverage both SAP BW/4HANA and SAP HANA capabilities.

References: https://help.sap.com/doc/saphelp_scm700_ehp02/7.0.2/en-US/63/f3c416bcbf4730bb86e62ef8a54e17/content.htm https://blogs.sap.com/2018/12/14/implementing-mixed-modeling-in-bw4hana-using-composite-provider/ https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/42/f93a83ae5546d3a7cfd7ff09e25a2b/content.htm https://help.sap.com/doc/SAP_BW4HANA_CONTENT/06e872f914a44d77b6c692b0273ca400/20b4b01f5baf46af8fbd439c741adf00.html

Correct Answer: CD

Characteristic value: This type of variable can use the SAP HANA Exit processing type to determine default values for variables using an AMDP class implementation. This can improve the performance and flexibility of queries that are generated as external SAP HANA views12.

Hierarchy node: This type of variable can use the SAP HANA Exit processing type to determine default values for variables using an AMDP class implementation. This can improve the performance and flexibility of queries that are generated as external SAP HANA views12.

References: https://help.sap.com/docs/r/107a6e8a38b74ede94c833ca3b7b6f51/1.0.8/en-US/b77f3073e9d842d6959e03e74dcefa09.html https://blogs.sap.com/2017/09/29/usage-of-sap-hana-exit-variables-for-a-standard-reporting-scenario/

Correct Answer: A

Correct Answer: A

Correct Answer: B