SAP C_BW4HANA_20 Online Practice Questions and Exam Preparation

SAP C_BW4HANA_20 Online Questions & Answers

• Question 51:

  Which SAP BW/4HANA features support the code-to-data principle? Note: There are 3 correct answers to this question.

  A. SAP HANA models as part providers in CompositeProviders
  B. ABAP Managed Database Procedures in an SAP BW/4HANA transformation
  C. Query settings fo read near-line storage data
  D. Activation of a DataStore object (advanced)
  E. Global transfer routines for master data harmonization
  B. ABAP Managed Database Procedures in an SAP BW/4HANA transformation
  C. Query settings fo read near-line storage data
  E. Global transfer routines for master data harmonization

• Question 52:

  Which transformation options can be executed in an SAP HANA database? Note: There are 2 correct answers to this question.

  A. Formulas
  B. Read master data
  C. Transfer routines
  D. ABAP expert routines
  A. Formulas
  B. Read master data

• Question 53:

  Which objects can you combine using a CompositeProvider? Note: There are 2 correct answers to this question.

  A. SAP HANA calculation views
  B. CompositeProvider
  C. InfoSources
  D. Key figures
  A. SAP HANA calculation views
  B. CompositeProvider

• Question 54:

  What happens when you execute the Trigger Delta Merge operation for a given data target?

  A. The data from the delta queue is extracted and merged into the data target.
  B. The delta between the new data and the already loaded data is removed.
  C. Data is transferred from the delta store to the main store.
  D. The before and after images of the delta queues are merged.
  C. Data is transferred from the delta store to the main store.

• Question 55:

  Which SAP HANA objects are automatically generated if you set the External SAP HANA Calculation View flag for an SAP BW/4HANA object? Note: There are 2 correct answers to this question.

  A. SAP HANA attribute views
  B. SAP HANA calculation views
  C. SAP HANA privileges
  D. SAP HANA analytic views
  B. SAP HANA calculation views
  C. SAP HANA privileges

• Question 56:

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

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

• Question 57:

  Your main BW query contains a characteristic value variable with a replacement path from a query. When is the pre-query executed?

  A. Each time the main query is executed, before the filter values are applied.
  B. Each time the main query is executed, after the filter values are applied.
  C. Directly after a predefined broadcasting event was triggered to calculate the pre-query.
  D. Directly after data is loaded to the InfoProvider of the pre-query.
  A. Each time the main query is executed, before the filter values are applied.

• Question 58:

  Why do you recommend the virtual data mart layer? Note: There are 2 correct answers to this question.

  A. To build an interface for queries and reports
  B. To combine different InfoProviders using Join operations or Union operations
  C. To combine centrally managed data with local files
  D. To build corporate memory for reconstructions
  A. To build an interface for queries and reports
  B. To combine different InfoProviders using Join operations or Union operations

• Question 59:

  Which advantages does the SAP Lumira template for generic analysis provide? Note: There are 2 correct answers to this question.

  A. You can create a bookmark to a navigation state and link it on any Web page.
  B. You can use Visual Basic for Applications to improve the design.
  C. You can compare two DataSources in one report.
  D. You can use it for any BW query or SAP HANA calculation view.
  A. You can create a bookmark to a navigation state and link it on any Web page.
  D. You can use it for any BW query or SAP HANA calculation view.

• Question 60:

  Which actions can you perform with an SAP HANA calculation view that has the DIMENSION data category assigned? Note: There are 2 correct answers to this question.

  A. Join serveral tables.
  B. Define text joins.
  C. Persist master data.
  D. Aggregate measures.
  A. Join serveral tables.
  B. Define text joins.