Pass Your SAP Certified Application Specialist E_BW4HANA211 Exam on Jan 02, 2024 with 45 Questions [Q19-Q39]

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

ABAP end routine

SQL procedure in an SAP HANA FlowGraph

ABAP Field rountine

SQL script field routine

Lookup from DataStore object (advanced)

Q20. 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?

Storing data of DaraStore objects (advanced) in Extended Tables

Creating HANA Analysis Processes (HAP)

Generating external SAP HANA Views for SAP BW Queries

Leveraging the Data Tiering Optimization (DTO) concept

Q21. Which of the following SAP BW/4HANA objects support the automatic generation of external SAP HANA views? Note: There are 2 correct answers to this question.

Open ODS View

BW Query

InfoObject Characteristic

DataSource

Q22. You want to load a customer table to SAP BW/4HANA in delta mode.
The customer table is managed in SAP S/4HANA Cloud. Each record has an UTC time stamp.
What is recommended approach to implement this extraction?

Create a DataSource in SAP S/4HANA which leverages the generic delta based on the time stamp.

Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp

Create an ABAP CDS View in SAP S/4HANA which is enabled for extraction and generates the delta based on the time stamp.

Create an SAP HANA CDS View in SAP SS/4HANA which leverages a procedure to generate the delta based on the time stamp.

Q23. Which effects do you expect for a BW Query if you set the SAP HANA runtime mode, called “”Operations in SAP HANA””, to the value “”[^(Standard)””? Note: There are 2 correct answers to this question.

A cluster of InfoProviders with a homogenous mapping is created (expert mode 3).

The user can manually choose the expert mode 3,8 or 9 by himself.

The system supports the calculation of condition (expert mode 9).

The system supports formulas with a complex currency or unite (expert mode 8).

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

To move a large amount of historical data needs to be read occasionally in SAP BW Queries

To improve the qery performance of an SAPBW Query for aggregated year-to-date values

To reduce the TCO bases on the implementation of the Active/ Non-Active Data Concept

To create an offline archive for transactional data to ensure legal requirements are fulfilled

Q25. 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.

It is executed only when columns from both tables are requested

It shows all transactional data with an existing master data record

It shows all master data to assure the referential integrity

It is an inner join that assumes that referential integrity is given

Q26. Which steps are required to set up a real-time data streaming process based on the “SAP HANA Smart Data Access (HANA_SDA)” source system in SAP BW/4HANA?Note: There are 3 correct answers to this question.

Create a DataStore object (advanced) and a Transformation including a DTP to connect the BW DataSource.

Create an SAP HANA remote source based on an SAP HANA Smart Data Integration adapter and a BW DataSource related to it.

Create a CompositeProvider on top of the DataStore object (advanced) and define a BW Query on top of it.

Create a Process Chain that runs the DTP, set the Process Chain to “Streaming mode”, and schedule it.

Create an ABAP Project and change the Transformation from ABAP Runtime to HANA Runtime.

Q27. You would like to implement a virtual scenario in yur SAP BW/4HANA system. Which approach does SAP recommend for this kind of scenario? Note: There are 3 correct answer to this question.

Integrate external data into SAP BW/4HANA based on the Write Interface-ebabled DataStore object.

Model a CompositeProvider which combines data from multiple SAP BW/4HANA InfoProviders and SAP HANA Views.

Generate external SAP HANA view of SAP BW/4HANA InfoProviders to consume SAP BW/4HANA data in SAP HANA.

Define an Open ODS View which integrates an SAP HANA table into SAP BW/4HANA.

Load SAP HANA dat into SAP BW/4HANA InfoProviders based on the Operational Data Provisioning (ODP) framework.

Q28. In an SAP BW/4HANA system you olan to leverage Data Tiering Optimization (DTO) for a DataStore object (advanced).
Which activities are required to set up the HOT tier as well as the COLD tier for this object properly? Note:
there are 2 correct answers to this question.

Define partitions for the DataStore object (advanced)

Choose between Temperature Maintencance “On Partition Level” or “On Object Level”

Create a Data Archiving Process (DAP) for the DataStore object (advanced)

Define the planned temperature for each partition

Q29. You enable a DataStore object (advanced) for reporting by switching on the “”External SAP HANA view”” flag in the settings.
Which authorizations are used when you consume the generated SAP HANA view directly?

The generated analytic privileges in SAP HANA

The authorizations for the HDI container access in SAP HANA

The combination of the generated analytic privileges in SAP HANA and the analysis authorizations in SAP BW/4HANA

The analysis authorizations in SAP BW/4HANA

Q30. 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.

DataStore object (advanced)

ABAP CDS View

InfoObject Characteristic

CompositeProvider

Open ODS View

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

DataStore object (advanced)

InfoObject with Attributes

SAP HANA Database Table

CompositeProvider

Q32. Which process types of process chains became obsolete in SAP BW/4HANA comoared to SAP BW powered by SAP HANA? Note: there are 2 correct answers to this question.

Execute Analysis Process (APD)

Execute Data Archiving Process (DAO)

Trigger Delta Merge

Attribute Change Run

Q33. You use an Open Hub Destination to distribute SAP BW/4HANA data to a table managed by an SAP database.
Which technologies can be used? Note: There are 2 correct answers to this question.

Operational Data Provisioning (ODP)

Database Connection (DBCON)

Smart Data Access (SDA)

Remote Function Call (RFC)

Q34. What is the recommended and supported way to virtually consume data in SAP BW/4HANA based on SAP ABAP CDS View?

Model a CompositeProvider which consumes an SAP HANA Calculation View which refers to the u SAP ABAP CDS View.

Model a CompositeProvide which directly consumes the SAO ABAP CDS View.

Model an Open View of source type “Dattabase Table or View” which refers to the SAP ABAP CDS U View.

Model an Open ODS View of source type “DataSource (BW)” which refers to the SAP ABAP CDS U View

Q35. Why do you use the ‘ “Enhanced Master Data Update”” setting in the definition of an InfoObject? Note: there are 2 correct answers to this question.

To enable transitive attributes

To enable XXL attributes

To enable parallel loading

To enable delta capability