SAP C_BW4H_2404 Online Practice Questions and Exam Preparation

SAP C_BW4H_2404 Online Questions & Answers

• Question 21:

  Which features of an SAP BW/4HANA InfoObjet are intended to reduce the physical data volume? Note:There are 2 correct answers to this question.

  A. Reference charateristic
  B. Transitive attribute
  C. Compounding charateristic
  D. Enhanced master data update
  A. Reference charateristic
  B. Transitive attribute

• Question 22:

  Which recommendations should you follow to optimize BW query performance? Note: There are 3 correct answers to this question

  A. Use fewer drill-down characteristics in the initial view
  B. Use characteristic filters that overlap
  C. Use exclude functions in the restricted key figures
  D. Use mandatory characteristic value variables
  E. Use include functions in the restricted key figures.
  A. Use fewer drill-down characteristics in the initial view
  D. Use mandatory characteristic value variables
  E. Use include functions in the restricted key figures.

  ---

  Explanation/Reference:

  Use fewer drill-down characteristics in the initial view: This can improve the query performance by reducing the amount of data that needs to be transferred and displayed at the start of the query execution. The user can drill down to more

  details later if needed.

  Use mandatory characteristic value variables: This can improve the query performance by restricting the data selection to a smaller set of values that are relevant for the user. The user can also change the variable values later if needed.

  Use include functions in the restricted key figures: This can improve the query performance by avoiding unnecessary calculations and aggregations that are done when using exclude functions. Include functions are also more efficient than

  selections or restricted key figures when filtering data.

  References:

  https://blogs.sap.com/2015/04/20/query-performance-optimisation-tips-in-bw-73/

  https://blogs.sap.com/2022/02/02/query-performance-optimization-in-bw-few-tips/

  https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2022.12/en-us/0471d0ecea4e4677ba29d9ac1496c24c.html

  https://blogs.sap.com/2021/06/02/sap-bw-4hana-performance-optimization-part-i/

• Question 23:

  You want to define a restricted column in an SAP HANA calculation view.

  What do you need to define? Note: There are 2 correct answers to this question.

  A. A reference to an existing measure
  B. An aggregation method
  C. A condition criterium
  D. An SAP HANA data type
  B. An aggregation method
  C. A condition criterium

  ---

  Explanation/Reference:

• Question 24:

  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
  C. SID numbers are created at runtime which might negatively affetct the reporting performance

  ---

  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/

• Question 25:

  Which of the Augmented Analytics Smart Features in SAP Analytics Cloud generates fully populated, multi-tabbed stories?

  A. Search to insight
  B. Smart Discovery
  C. Smart Predict
  D. Forecasting
  B. Smart Discovery

• Question 26:

  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.
  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.
  E. Add COUNTRY as a transitive attribute for CUSTOMER in InfoObject definition.

• Question 27:

  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. BAPIs (Business Application Programming Inetrface)
  B. Calculation views
  C. AMDPs (ABAP Manged Database Procedures)
  D. Stored procedures
  B. Calculation views
  D. Stored procedures

• Question 28:

  In which ODP context is the operational delta queue (ODQ) managed by the target system?

  A. ODP_BW
  B. ODP_CDS
  C. ODP_SAP
  D. ODPJHANA
  D. ODPJHANA

• Question 29:

  You create a DataStore Object(advanced) using the Data Mart DataStore Object modeling property.

  Which behaviors are specific to this modelling property? Note: There are 2 correct answers to this question.

  A. The change log table will be filled only after data activation
  B. Reporting is done based on a union of the inbound and active tables
  C. Query result are shown only when data has been activated
  D. The records are treated as if all characteristics are in the key.
  B. Reporting is done based on a union of the inbound and active tables
  D. The records are treated as if all characteristics are in the key.

  ---

  Explanation/Reference:

  Reporting is done based on a union of the inbound and active tables: This is a behavior that is specific to the Data Mart DataStore Object modeling property. The query reads data from both the inbound table and the active table of the DataStore object, which means that it is not necessary to activate the data to be able to see all the data. The data read is consistent and stable, since data is only included up to the first inconsistent request.

  The records are treated as if all characteristics are in the key: This is a behavior that is specific to the Data Mart DataStore Object modeling property. No keys can be specified for this type of DataStore object, but when the data is activated, it is grouped according to the aggregation behavior of all characteristics. Therefore, key figures cannot be overwritten and only additive deltas can be loaded.

  References: https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/1961a9b62f054cc5a4f0d98485b82fa9.html https://help.sap.com/docs/r/dd104a87ab9249968e6279e61378ff66/11.1.0/en-US/9cf20bb96e254f6b9b5bf1c9c1413f35.html

• Question 30:

  You are involved in an SAP BW/4HANA project focusin on General Ledger reporting and want to use the SAP ERP Estandar DataSource oFI_GL_14 (New GL Items). Which transactions can be used to activate this DataSource? Note: There are 2 correct answers to this question.

  A. Transaction RSA1 (BI Content) in the SAP BW/4HANA system
  B. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system
  C. Transaction RS02 (Maintain Generic DataSource) in the SAP source system
  D. Transaction ODQMON (Monitor Delta Queues) in the SAP Source system
  A. Transaction RSA1 (BI Content) in the SAP BW/4HANA system
  B. Transaction RSA5 (Installation of DataSource from Business Content) in the SAP source system

  ---

  Explanation/Reference: