SAP C_BW4H_2404 Online Practice Questions and Exam Preparation

SAP C_BW4H_2404 Online Questions & Answers

• Question 51:

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

  You have already loaded data from a non-sap system into SAP Data Wharehouse Cloud. You want to federate this data with data from an InfoCube of your SAP BW powered by SAP HANA system What do you need to use to combine data?

  A. BW SHEL Migration
  B. BW Remote migration
  C. SAP ABAP Connection
  D. SAP BW/4HANA Model Transfer.
  C. SAP ABAP Connection

  ---

  Explanation/Reference:

  SAP ABAP Connection: This is what you need to use to combine data from a non-sap system and an InfoCube of your SAP BW powered by SAP HANA system using SAP Data Warehouse Cloud. You can use an SAP ABAP connection to connect to your SAP BW system and access the InfoCube data as a remote table. You can then join this remote table with the data from the non-sap system that you have already loaded into SAP Data Warehouse Cloud using a graphical view.

  References: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/0c9d6f0a6c4a4b8e8b3f7e5c0a3d6f9d.html https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/5c9a6c8b6c4a4b8e8b3f7e5c0a3d6f9d.html

• Question 53:

  You want to add a Source System of type Big Data in SAP BW/4HANA. Which adapters can you use to reference the remote source system? Note: There are 2 correct answers to this question.

  A. IQ (ODBC) adapter
  B. SAP HANA Adapter
  C. Spark SQL Adapter
  D. SAP Vora ODBC adapter
  C. Spark SQL Adapter
  D. SAP Vora ODBC adapter

  ---

  Explanation/Reference:

• Question 54:

  You create an SAP HANA HDI Calculation View.

  What are some of the reasons to choose the data category Cube with Star Join instead of data category Dimension? Note: There are 3 correct answers to this question.

  A. Create restricted columns
  B. Provide default time characteristics
  C. Persist transactional data
  D. Combine master data and transactional data
  E. Aggregate measures as a sum
  C. Persist transactional data
  D. Combine master data and transactional data
  E. Aggregate measures as a sum

  ---

  Explanation/Reference:

• Question 55:

  You use a measure with semantic type "Amount with Currency Code" in your SAP HANA HDI calculation view.

  Which kind of currency reference can be assigned to the measure? Note: There are 2 correct answers to this question.

  A. A fixed currency from table TCURC
  B. Another column of the same SAP HANA view
  C. A column from another SAP HANA view
  D. A variable in the same SAP HANA view
  A. A fixed currency from table TCURC
  B. Another column of the same SAP HANA view

  ---

  Explanation/Reference:

• Question 56:

  When loading master data for a material, you want to look at the new values before they are released for reporting. What could you do using modeling features? Note: There are 2 correct answers to this question.

  A. When you define the attributes of material, select the "Time Dependent" setting
  B. When you define the data transfer process, select the "Load records wit new key only" setting
  C. When you define the data transfer process, choose the "Set Manually" setting for "Overrall status of request"
  D. When you define the material characteristic, select the "Enhanced Master data update" setting
  C. When you define the data transfer process, choose the "Set Manually" setting for "Overrall status of request"
  D. When you define the material characteristic, select the "Enhanced Master data update" setting

  ---

  Explanation/Reference:

• Question 57:

  Which objetcs can be affected by the key date in a BW query? Note: There are 3 correct answers to this question.

  A. Navigation attributes
  B. Hierachies
  C. Key figures
  D. Conditions
  E. Display attributes
  A. Navigation attributes
  B. Hierachies
  E. Display attributes

• Question 58:

  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/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 59:

  How does SAP position SAP Data Warehouse Cloud in supporting business users?

  A. Business users can maintain process chains from SAP BW/4HANA dataflows
  B. Business users can create agile models from different sources
  C. Business users can allocate system resources without IT involvement
  D. Business users can generate SQL code that is pushed to SAP BW/4HANA.
  B. Business users can create agile models from different sources

  ---

  Explanation/Reference:

  SAP Data Warehouse Cloud is a cloud-based data service that enables business users to create agilemodels from different sources and access data in real time. Business users can use the graphical user interface or the SQL editor to create data models, join data from various sources, and enrich data with business semantics. Business users can also use SAP Analytics Cloud to visualize and analyze data from SAP Data Warehouse Cloud. SAP Data Warehouse Cloud supports business users by providing self-service capabilities, pre-built business content, and flexible consumption options.

• Question 60:

  You use InfoObject B as a display attribute for InfoObject A. Which object properties prevent you from changing InfoObject B into a navigational attribute for InfoObject A? Note: There are 3 correct nswers to this question."

  A. High Cardinality is set in InfoObject B
  B. Attribute Only is set in InfoObject B
  C. Data Type "Character String" is set in InfoObject A
  D. Conversion Routine "ALPHA" is set in InfoObject A
  E. InfoObject B is defined as a Key Figure.
  A. High Cardinality is set in InfoObject B
  B. Attribute Only is set in InfoObject B
  D. Conversion Routine "ALPHA" is set in InfoObject A

  ---

  Explanation/Reference:

  High Cardinality is set in InfoObject B: This is an object property that prevents you from changing InfoObject B into a navigational attribute for InfoObject A. A characteristic with high cardinality cannot be used as a navigation attribute for another characteristic, and therefore it cannot have navigation attributes itself.

  Attribute Only is set in InfoObject B: This is an object property that prevents you from changing InfoObject B into a navigational attribute for InfoObject A. A characteristic that is marked as an exclusive attribute can only be used as a display attribute for another characteristic, but not as a navigational attribute. In addition, the characteristic cannot be transferred into InfoCubes.

  Conversion Routine "ALPHA" is set in InfoObject A: This is an object property that prevents you from changing InfoObject B into a navigational attribute for InfoObject A. A characteristic that has a conversion routine cannot have navigational attributes, because the conversion routine would have to be applied to the navigational attributes as well, which is not possible.

  References: https://help.sap.com/docs/SAP_BW4HANA/107a6e8a38b74ede94c833ca3b7b6f51/f851415842154e59a5f038e458b97a0b.html https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/f8/51415842154e59a5f038e458b97a0b/content.htm https://help.sap.com/doc/saphelp_scm700_ehp02/7.0.2/en-US/63/f3c416bcbf4730bb86e62ef8a54e17/content.htm https://answers.sap.com/questions/1149854/difference-display-attribute-and-navigational-attr.html https://help.sap.com/doc/saphelp_nw75/7.5.5/en-US/42/f93a83ae5546d3a7cfd7ff09e25a2b/content.htm https://answers.sap.com/questions/10121838/infoobjects-attributes.html