SAP C_BW4HANA_20 Online Practice Questions and Exam Preparation

SAP C_BW4HANA_20 Online Questions & Answers

• Question 31:

  What can you create within the SAP BW data flow object? Note: There are 2 correct answers to this question.

  A. InfoAreas
  B. Key figures
  C. InfoProviders
  D. Transformations
  C. InfoProviders
  D. Transformations

• Question 32:

  You need to determine the number of customers in each country that have revenue in 2018. What is the reference InfoObject in an exception aggregation?

  A. Counter
  B. Customer
  C. Country
  D. Year
  B. Customer

• Question 33:

  What must you do first if you need to define help cells for formulas in the cell editor?

  A. Define two formulas in a structure.
  B. Define two structures in a query.
  C. Define two selections in a structure.
  D. Reuse a structure in a second query.
  B. Define two structures in a query.

• Question 34:

  You need to create a CompositeProvider to combine data from an SAP HANA calculation view with a DataStore object (advanced). Which of the following Eclipse perspectives do you use?

  A. JavaScript perspective
  B. BW modeling perspective
  C. ABAP perspective
  D. SAP HANA modeler perspective
  B. BW modeling perspective

• Question 35:

  Which objects can you associate with a source field that is defined as a characteristic within an Open ODS view? Note: There are 2 correct answers to this question.

  A. SAP BW InfoObject
  B. Open ODS view type Master Data for Attributes
  C. Open ODS view type Facts
  D. Open ODS view type Master Data for Hierarchies
  B. Open ODS view type Master Data for Attributes
  C. Open ODS view type Facts

• Question 36:

  What must you do to define an Inventory InfoProvider in SAP BW/4HANA? Note: There are 3 correct answers to this question.

  A. Select the All Characteristics are Key model property.
  B. Select the Unique Data Records model property.
  C. Assign at least one non-cumulative key figure.
  D. Assign at least one cumulative key figure.
  E. Select the Inventory model property.
  A. Select the All Characteristics are Key model property.
  D. Assign at least one cumulative key figure.
  E. Select the Inventory model property.

• Question 37:

  When do you recommend using an external hierarchy? Note: There are 3 correct answers to this question.

  A. The hierarchical structure will be time-dependent.
  B. The structure will contain formulas.
  C. The structure will depend on the order of the row characteristics.
  D. The structure exists in the source system.
  E. The query data will be restricted to a hierarchy node.
  A. The hierarchical structure will be time-dependent.
  D. The structure exists in the source system.
  E. The query data will be restricted to a hierarchy node.

• Question 38:

  You set up the 2LIS_02_ITM (Purchasing Line Item) data source in SAP ERP using the logistics cockpit. Afterward, you successfully run the initialization into SAP BW/4HAN

  A. Your delta load into SAP BW/4HANA shows zero records even though new purchase orders were created. How do you explain that the delta records do NOT appear in SAP BW/4HANA?
  B. A reinitialization for sales orders in SAP ERP was triggered using the logistics cockpit, which deleted the purchase order item initialization.
  C. All old purchase orders in SAP ERP were archived overnight before the delta loads.
  D. Purchasing extractors in SAP ERP were set up with Queued Delta update mode and the collective run job was NOT scheduled.
  E. Another SAP BW/4HANA system already picked up the new purchase orders using a delta load
  C. All old purchase orders in SAP ERP were archived overnight before the delta loads.

• Question 39:

  Which objects of an SAP HANA calculation view of DIMENSION data category can you re-use if you define an SAP calculation view of CUBE data category with star join? Note: There are 2 correct answers to this question.

  A. Aggregation method
  B. Hierarchy assignment
  C. Attribute assignment
  D. Measure assignment
  C. Attribute assignment
  D. Measure assignment

• Question 40:

  You need to enable real-time streaming using SAP HANA smart data integration (SDI) to load data into a DataStore object (advanced). What are prerequisites for this requirement? Note: There are 2 correct answers to this question.

  A. The source system is pulling data into SAP BW/4HANA.
  B. The process chain is running in streaming mode.
  C. The data target is a DataStore object (advanced) of the InfoCube model template.
  D. The adapter is real-time enabled.
  B. The process chain is running in streaming mode.
  C. The data target is a DataStore object (advanced) of the InfoCube model template.