SAP C_BW4H_2404 Online Practice Questions and Exam Preparation

SAP C_BW4H_2404 Online Questions & Answers

• Question 1:

  What is required before you can integrate an HDI Calculation View (data category Dimension) into another HDI Calculation View (data category Cube with Star Join) of the same HDI container?

  A. Create a synonym for the HDI Calculation View (data category Dimension).
  B. Build the design time file of the HDI Calculation View (data category Dimension) to generate a runtime object.
  C. Create a synonym for the HDI Calculation View (data category with Star Join).
  D. Build the runtime object of the HDI Calculation View (data category Cube with Star Join) to generate a design time file.
  B. Build the design time file of the HDI Calculation View (data category Dimension) to generate a runtime object.

  ---

  explanation:

  Explanation/Reference:

• Question 2:

  Which SAP BW/4HANA objects support the feature of generating an external SAP HANA View? Note: There are 2 correct answers to this question.

  A. Open ODS view
  B. Semantic group object
  C. Composite Provider
  D. BW query .
  A. Open ODS view
  C. Composite Provider

  ---

  explanation:

  Explanation/Reference:

  The feature of generating an external SAP HANA view is used to expose SAP BW/4HANA objects as SAP HANA calculation views, which can be consumed by other SAP HANA tools or applications. The following SAP BW/4HANA objects support this feature:

  Open ODS view, which is a flexible object that can be created on top of any source system and can be used as a source for other objects such as CompositeProviders or BW queries. An Open ODS view can have an external SAP HANA view generated automatically during activation or manually using the context menu option Generate External SAP HANA View.

  Composite Provider, which is a powerful object that can combine data from different InfoProviders using join or union operations. A Composite Provider can have an external SAP HANA view generated automatically during activation or manually using the context menu option Generate External SAP HANA View.

• Question 3:

  What are the reasons for implementing CompositeProviders? Note: There are 2 correct answers to this question.

  A. To store snapshots for reporting
  B. To provide an interface for BW queries
  C. To persist combined data for reporting
  D. To provide a virtual data mart layer
  B. To provide an interface for BW queries
  D. To provide a virtual data mart layer

• Question 4:

  You defined a condition in a BW query for the top 10 of 100 customers based on sales revenue (key figure of aggregation type Sum) If you keep the default settings of the BW query, what is presented regarding the result rows?

  A. Only one result row with the sales revenue sum of all 100 customers
  B. Only one result row with the sales revenue sum of the top 10 customers
  C. One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 90 customers
  D. One result row with the saled revenue sum of the top 10 customers and a second result row with the sales revenue sum of the other 100 customers
  A. Only one result row with the sales revenue sum of all 100 customers

• Question 5:

  You create a report with SAP Crystal Reports for Enteprise and need an analysis view as a data source. Which tool can you use to create this analysis view?

  A. SAP BusinessObjetc Web Intelligence
  B. SAP Lumira, designer edition
  C. SAP Crustal Reportis for Enterprise
  D. SAP Analysis for Microsoft Office
  D. SAP Analysis for Microsoft Office

  ---

  explanation:

  Explanation/Reference:

• Question 6:

  What are the prerequisites for deleting master data (for example, cost centers) in SAP BW/4HANA? Note: There are 2 correct answers to this question.

  A. There must be no BW analysis authorizations defined thta use any of the cost centers
  B. There must be no transaction data referring to the cost centers
  C. There must be no hierarchy for the cost centers
  D. There must be no BW query that uses cost cenetr as a free characteristics.
  B. There must be no transaction data referring to the cost centers
  C. There must be no hierarchy for the cost centers

  ---

  explanation:

  Explanation/Reference:

• Question 7:

  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:

  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 8:

  You create a generic DataSource in SAP ERP.

  How can you enable your generic DataSource to be used as an ODP_SAP DataSource in SAP BW/4HANA in casa it is not available by default?

  A. Release the DataSource in SAP BW/4HANA for ODP
  B. Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource
  C. Generate the PSA table of the DataSource in SAP BW/4HANA
  D. Add a subscription in SAP ERP using the program RODPS_REPL_TEST.
  B. Run the program RODPS_OS_EXPOSE in SAP ERP for the DataSource

  ---

  explanation:

  Explanation/Reference:

  Run the program RODPS_OS_EXPOSE in SAP ERP for the Data-Source: This program can enable a generic DataSource in SAP ERP to be used as an ODP_SAP DataSource in SAP BW/4HANA by exposing it to the ODP framework. This

  allows the data to be transferred via RFC or HTTP calls without using a PSA layer12.

  References:

  https://blogs.sap.com/2020/12/25/operational-data-provisioning-simplified/

  https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/c6afacb707764885a6fb62f511c24f34.html

• Question 9:

  In a DatStore object (advanced) of type Data Mart, which request-based deletion is possibel?

  A. The lastest not-yet-activated reques in the inbound table
  B. The lastest request in the active data table
  C. Any older activated reqeust in the inbound table
  D. The lastest request in the change log table
  A. The lastest not-yet-activated reques in the inbound table

• Question 10:

  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:

  Explanation/Reference: