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

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

• Select the All Characteristics are Key model property.
  
• Select the Unique Data Records model property.
  
• Assign at least one non-cumulative key figure.
  
• Assign at least one cumulative key figure.
  
• Select the Inventory model property.
  

Which tables belong to the hierarchy for characteristic OCOUNTRY? Note: There are 3 correct answers to this question.

• /BIC/QCOUNTRY
  
• D/BIC/KCOUNTRY
  
• /BIC/ICOUNTRY
  
• /BIC/PCOUNTRY
  
• D/BIC/HCOUNTRY
  

What are key capabilities of SAP Agile Data Preparation Note: There are 3 correct answers to this question.

• Data retention
  
• Data exporting
  
• Data cleansing
  
• Data compliance
  
• Data acquisition
  

What happens if a query with time-dependent attributes is executed but NO query key date is set?

• The current date is used as key date.
  
• The system displays only NON-time-dependent attributes.
  
• The valid from date of the attribute is used as key date.
  
• The system displays an error message.
  

Where can you apply a currency conversion? Note: There are 3 correct answers to this question.

• In an SAP BW/4HANA InfoSource
  
• In an SAP BW/4HANA transformation
  
• In an SAP HANA calculation view
  
• In an SAP BW/4HANA data transfer process (DTP)
  
• In a BW query
  

For which of the following revenue reporting requirements do you create restricted key figures?

• Convert revenue into a number without currency.
  
• Identify the top five countries by revenue for each month.
  
• Determine the average revenue per customer.
  
• Compare this year's planned revenue with last year's actual revenue.
  

Which reporting object do you use to combine data from different SAP BW InfoProviders?

• BW query
  
• Analysis workbook
  
• DataProvider
  
• Analysis view
  

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

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

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.

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

Which object is a target of an SAP BW transformation?

• InfoObject of type Characteristic
  
• CompositeProvider
  
• InfoObject of type Key Figure
  
• Open ODS view