SAP C_BW4H_2404 Online Practice Questions and Exam Preparation

SAP C_BW4H_2404 Online Questions & Answers

• Question 71:

  Which features does SAP Analysis for Microsoft Office provide? Note: There are 3 correct answers to this question.

  A. Changing context menu entries
  B. Dragging measures in and out of the report
  C. Displaying data simultaneously in a table and a chart
  D. Including more than one data source
  E. Creating bookmarks for a navigation state
  B. Dragging measures in and out of the report
  C. Displaying data simultaneously in a table and a chart
  D. Including more than one data source

• Question 72:

  What are the possible ways to fill a pre-calculated value set (bucket)? Note: There are 3 correct answers to this question.

  A. By using a transformation and data transfer process
  B. By entering the values manually
  C. By referencing a table
  D. By using a query
  E. By accessing an SAP HANA Calculation View of data category Dimension
  B. By entering the values manually
  C. By referencing a table
  D. By using a query

• Question 73:

  You want to build an SAP HANA HDI calculation view of data category CUBE, but you get the "no measure defined" error. For the business requirement, a measure does not make sense. Besides changing the data category to DIMENSION, what do you have to do?

  A. Switch from an aggregation node to a star join node
  B. Switch from an aggregation node to a projection node
  C. Switch form a projection node to an aggregation node
  D. Switch from a projection node to a star join node
  B. Switch from an aggregation node to a projection node

• Question 74:

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

  You open an SAP Analysis for Microsoft Office workbook.

  On which Design Panel tabs can you verify the filter values? Note: There are 2 correct answers to this question.

  A. Analysis
  B. Components
  C. Information
  D. Design Rules
  A. Analysis
  C. Information

  ---

  Explanation/Reference:

• Question 76:

  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
  B. ADD
  D. AIE

  ---

  Explanation/Reference:

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

  SAP provides three data warehouse solutions to provide customers more flexibility. How is SAP Data Warehouse Cloud positioned?

  A. To empower business users to generate SQL code that ispushed to SAP BW/4HANA
  B. To empower business users to create an dmaintain process chain from SAP BW/4HANA dataflows
  C. To support business user who want to simplify theris own ABAP routines
  D. To support business user with a new self-service tool to model their own data flows
  D. To support business user with a new self-service tool to model their own data flows

• Question 78:

  Which tasks are part of the Business Blueprint and Data Model Definition phase in an SAP BW/4HANA project? Note: There are 3 correct answers to this question.

  A. Check the availability of data
  B. Specify necessary data conversion
  C. Implement transport routes and layers
  D. Monitor batch jobs and data volume
  E. Design the data layer concept
  A. Check the availability of data
  B. Specify necessary data conversion
  E. Design the data layer concept

  ---

  Explanation/Reference:

• Question 79:

  For which requirements do you suggest an SAP HANA modeling focus rather that an SAP BW/4HANA modeling focus? Note: There are 2 correct answers to this question.

  A. Enhance existing SAP HANA content models
  B. Report on a harmonized set of master data
  C. Load snapshots or deltas from different sources on a periodic basis
  D. Leverage SQL in-house knowledge
  A. Enhance existing SAP HANA content models
  D. Leverage SQL in-house knowledge

  ---

  Explanation/Reference:

• Question 80:

  "For InfoObject ADDRESS, the High Cardinality flag has been set. However, ADDRESS has an attribute CITY without the high Cardinality flag."

  What is the effect on SID values in this scenario?

  A. SID values are not stored for InfoObject ADDRESS
  B. SID values are generated when data for infoObject ADDRESS is loadet
  C. SID values are generated when InfoObject CITY is activated
  D. SID values are generated when InfoObject ADDRESS is activated.
  A. SID values are not stored for InfoObject ADDRESS

  ---

  Explanation/Reference: