SAP E_BW4HANA204 Online Practice Questions and Exam Preparation

SAP E_BW4HANA204 Online Questions & Answers

• Question 1:

  What is a valid scenario using the External Tier (COLD Store) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?

  A. To move a large amount of historical data needs to be read occasionally in SAP BW Queries
  B. To improve the qery performance of an SAPBW Query for aggregated year-to-date values
  C. To reduce the TCO bases on the implementation of the Active/ Non-Active Data Concept
  D. To create an offlinearchivefor transactional data to ensure legal requirements are fulfilled
  A. To move a large amount of historical data needs to be read occasionally in SAP BW Queries

• Question 2:

  What is a valid data target in an SAPMHANA Analysis Process without using a Data Trasfer Process?

  A. DataStore object (advanced)
  B. InfoObject with Attributes
  C. SAP HANA Database Table
  D. CompositeProvider
  C. SAP HANA Database Table

• Question 3:

  A customers wants to convert from SAP BW powered by SAO HANA to SAP BW/4HANA.

  What additional value is offered by SAP BW/AHANA compared to SAP BW powered by SAP HANA?

  A. Storing data of DaraStore objects (advanced) in Extended Tables
  B. Creating HANA Analysis Processes (HAP)
  C. Generating external SAP HANA Views for SAP BW Queries
  D. Leveraging the Data Tiering Optimization (DTO) concept
  D. Leveraging the Data Tiering Optimization (DTO) concept

• Question 4:

  You want to load data from an SAP BW/4HANA system into another SAP BW/4HANA system using Operational Data Provisioning (ODP) of type ODP_BW. Which objects can be used as a source? Note: There are 3 correct answers to this question.

  A. DataStore object (advanced)
  B. ABAP CDS View
  C. InfoObject Characteristic
  D. CompositeProvider
  E. Open ODS View
  A. DataStore object (advanced)
  C. InfoObject Characteristic
  D. CompositeProvider

• Question 5:

  What are valid reason to generate external SAP HANA View for SAP BW/4HANA objects? Note: there are 2 correct answers to this question.

  A. To consume SAP BW/4HANA data and manage access with native SAP HANA concepts
  B. To apply SAP HANA transformational logic instead of SAO ABAP logic
  C. To leverage the SAP HANA-optimezed Analytic Manager to process BW Query
  D. To create an additional persistent layer of data in SAP HANA
  A. To consume SAP BW/4HANA data and manage access with native SAP HANA concepts
  C. To leverage the SAP HANA-optimezed Analytic Manager to process BW Query

• Question 6:

  Which transformation rules do support SAP HANA Runtime? Note: There are 3 correct answers to this question.

  A. ABAP end routine
  B. SQL procedure in an SAP HANA FlowGraph
  C. ABAP Field rountine
  D. SQL script field routine
  E. Lookup from DataStore object (advanced)
  A. ABAP end routine
  D. SQL script field routine
  E. Lookup from DataStore object (advanced)

• Question 7:

  You use a customer master data table as a left table and a transactional sales data table as a right table within a graphical SAP HANA Calculation View.

  You want to focus in your report on transactional data showing both: customers with sales volume and without.

  Which join type should be used?

  A. Full Outer Join
  B. Referential Join
  C. Left Outer Join
  D. Right Outer Join
  C. Left Outer Join

• Question 8:

  You want to use a referential join for a combination of transactional data (left table) and master data (right table). How will this referential join be processed? Note: there are 2 correct answers to this question.

  A. It is executed only when columns from both tables are requested
  B. It shows alltransactionaldata with an existing master data record
  C. It shows all master data to assure the referential integrity
  D. It is an inner join that assumes that referential integrity is given
  A. It is executed only when columns from both tables are requested
  D. It is an inner join that assumes that referential integrity is given

• Question 9:

  The SAP BW/4HANA Starter Add-on is installed and set to the Compatibility mode. How is the SAP BW system affected? Note: There are 2 correct answers o this question.

  A. New InfoCubes can be created after getting approval by a whitelist.
  B. The SAP BEx Analyzer is decommisioned.
  C. Virtual InfoProviders for Planning are still allowed.
  D. All objects can be changed after getting approval by a whitelist.
  B. The SAP BEx Analyzer is decommisioned.
  D. All objects can be changed after getting approval by a whitelist.

• Question 10:

  What do the Remote Conversion approach and the Shell Conversion approach have in common? Note: There are 3 correct answers to this question.

  A. Both approaches uninstall the unsupported BW Add-ons from the sending BW system as the first activity
  B. Both approaches convert unsupported object types during import into the new SAP BW/4HANA system
  C. Both approaches result in a SAP BW/4HANA system which has a new system ID
  D. Both approaches require the SAP BW/4HANA Starter Add-on to be installed on the sending system
  E. Both approaches are setup by installing required SAP notes via the SAP BW Notes Analyzer
  B. Both approaches convert unsupported object types during import into the new SAP BW/4HANA system
  C. Both approaches result in a SAP BW/4HANA system which has a new system ID
  E. Both approaches are setup by installing required SAP notes via the SAP BW Notes Analyzer