Free SAP Certified Application Associate – Reporting, Modeling and Data Acquisition with SAP BW/4HANA 2.x Exam C_BW4HANA_27 Exam Practice Test

Why can tasks be executed faster if the application uses SAP HANA as a database?

• The application layer takes over tasks of the database layer.
  
• The database layer takes over tasks of the application layer.
  
• The user interface layer takes over tasks of the application layer.
  
• The application layer takes over tasks of the user interface layer.
  

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

• InfoAreas
  
• Key figures
  
• InfoProviders
  
• Transformations
  

For which SAP BW/4HANA objects is it possible to create an external SAP HANA view?There are 2 correct answers to this question.

• Open ODS views
  
• Key figures
  
• CompositeProviders
  
• Characteristics
  

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?

• Counter
  
• Customer
  
• Country
  
• Year
  

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

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

Which query property do you set to minimize the initial run time for the query read mode?

• Read all data at once.
  
• Read data individually from InfoProvider.
  
• Cache is inactive.
  
• Read data when you navigate or expand hierarchies.
  

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

• Define two formulas in a structure.
  
• Define two structures in a query.
  
• Define two selections in a structure.
  
• Reuse a structure in a second query.
  

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.

• SAP HANA smart data access
  
• SAP HANA smart data integration
  
• SAP HANA SQL Controller
  
• Spark SQL adapter
  
• SAP Vora ODBC adapter
  

You loaded a 5 MB table from a source system to SAP BW/4HAN

• How do you explain that the size of the table is reduced to 1 MB?
  
• The target is defined as column store and a delta merge job was executed.
  
• The target is defined as row store and a delta merge job was executed.
  
• The target is defined as row store without delta merge execution.
  
• The target is defined as coiumn store without delta merge execution.
  

What are desired outcomes of an SAP BW/4HANA pilot project?There are 3 correct answers to this question.

• Identify objects from SAP BI content that will be leveraged in subsequent projects.
  
• Identify required changes for the business processes to comply with SAP BW/4HANA standard software.
  
• Confirm increased database size using SAP BW/4HANA instead of a common RDBMS.
  
• Transfer experience of the pilot project to future projects.
  
• Identify customizing and configuration areas to be applied to future projects.