SAP SAP Certifications C_BW4H_2404 Questions & Answers

• Question 21:

  What are benefits of using an InfoSource in a data flow? Note: There are 2 correct answers to this question.

  A. Reducing the numer of transformations for scenarios with many sources and targets

  B. Connecting sequetial trnsformartions in the data flow without storing the data again

  C. Reducing the numer od data transfer processes (DTP)

  D. Storing the extraction delta information of the data source file

  Correct Answer: CD

• Question 22:

  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

  Correct Answer: AB

• Question 23:

  What is the purpose of an architecture overview model?

  A. To identify the user groups and required authorizations

  B. To automatically generate the LSA++ architecture

  C. To determine the sequence of projects

  D. To identify the required data sources.

  Correct Answer: D

  An architecture overview model is a high-level diagram that shows the main components and data flows of a solution. It helps to identify the required data sources and how they are connected to the target system. An architecture overview model can also show the main business processes and scenarios that are supported by the solution. An architecture overview model is useful for scoping, planning, designing, and communicating a solution.

• Question 24:

  What is the maximum number of characteristics that can be used for a multi-dimensional exception aggregation in a BW query?

  A. 7

  B. 10

  C. 3

  D. 5

  Correct Answer: D

• Question 25:

  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

  Correct Answer: BD

• Question 26:

  For a BW query, you want to have the first month of the current quarter as a default value for an input-ready BW variable for the characteristic OCALMONTH. Which processing tyoe do you use?

  A. Customer Exit

  B. Manual Input with offset value

  C. Replacement Path

  D. Manuel Input with default value

  Correct Answer: A

• Question 27:

  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.

  A. Rank

  B. Intersect

  C. Aggregation

  D. Graph

  Correct Answer: AD

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

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

  References: https://help.sap.com/docs/SAP_HANA_PLATFORM/fc5ace7a367c434190a8047881f92ed8/050f14f7a6d94d2da905b0a4072ba546.html https://help.sap.com/docs/r/e8e6c8142e60469bb401de5fdb6f7c00/2.0.03/en-US/9b9b4b8e0c4d4f0a9c3e7f8a3b5d9b9d.html https://help.sap.com/docs/r/e8e6c8142e60469bb401de5fdb6f7c00/2.0.03/en-US/e8b26f49218648eaa8e2ce9b54a8b812.html

• Question 28:

  Which SAP BW/4HANA objetcs can be used as sources of a data transfer process (DTP)? Note: There are 3 correct answers to this question.

  A. InfoSource

  B. Open Hub Destination

  C. DataStore Objetc (advanced)

  D. CompositeProvider

  E. SAP HANA Analysis Process

  Correct Answer: CDE

• Question 29:

  You create a transformation from a DataSource to a DataMart Data Store object (advanced) All key figures are updated as Sum. Which Delta methods indicate that the DataSource provides consistentinformation for this target? Note: There are 2 correct answers to this question.

  A. ABR

  B. ADD

  C. AIM

  D. AIE

  Correct Answer: BD

  ADD: This delta method indicates that the DataSource provides consistent information for this target. It means that the DataSource delivers additive delta records with after images, which are updated directly in the delta queue. This can support sum aggregation for key figures.

  AIE: This delta method indicates that the DataSource provides consistent information for this target. It means that the DataSource delivers additive delta records with after images, which are updated in the extraction queue and then transferred to the delta queue. This can support sum aggregation for key figures.

  References: https://wiki.scn.sap.com/wiki/display/BI/Delta+type+in+BW+Extractors https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/4f/18f6aa3fca410ae10000000a42189d/content.htm https://help.sap.com/doc/saphelp_nw73ehp1/7.31.19/en-US/4f/18f6b13fca410ae10000000a42189d/content.htm

• Question 30:

  What are some of the variable types n a BW query that can use the processing tupe SAP HANA Exit? Note:There are 2 correct answers to this question.

  A. Formula

  B. Text

  C. Charateristic value

  D. Hierarchy node

  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/