SAP C_BW4HANA_27 Online Practice Questions and Exam Preparation

SAP C_BW4HANA_27 Online Questions & Answers

• Question 71:

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

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

  For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question.

  A. CompositeProvider
  B. Open ODS views
  C. DataStore object (advanced) of type standard DataStore object
  D. DataStore object (advanced) of type InfoCube
  A. CompositeProvider
  B. Open ODS views

• Question 74:

  Which property settings can you assign for a characteristic? Note: There are 3 correct answers to this question.

  A. Useable as InfoProvider
  B. Authorization-Relevant
  C. High Precision
  D. Stock Coverage
  E. Attribute Only
  A. Useable as InfoProvider
  B. Authorization-Relevant
  E. Attribute Only

• Question 75:

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

  You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use?

  A. Condition
  B. Calculated key figure
  C. Restricted key figure
  D. Exception
  A. Condition

• Question 77:

  Which objects can you use as components in a CompositeProvider in SAP BW/4HANA? Note: There are 2 correct answers to this question.

  A. BW query
  B. Open ODS view
  C. CompositeProvider
  D. Semantic group
  B. Open ODS view
  C. CompositeProvider

• Question 78:

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

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

  You need to consume remote HADOOP data in your SAP HANA Native App. Which components can you use? Note: There are 3 correct answers to this question.

  A. SAP HANA smart data access
  B. SAP HANA smart data integration
  C. SAP HANA SQL Controller
  D. Spark SQL adapter
  E. SAP Vora ODBC adapter
  A. SAP HANA smart data access
  D. Spark SQL adapter
  E. SAP Vora ODBC adapter