SAP E_BW4HANA214 Exam Questions Instant Access

Question 1

Which of the following statements describe the benefits of the SAP BW/4HANA Content Add-On? Note: There are 2 correct answers to this question

AThe content delivers SAP HANA HDI Calculation Views for Mixed Scenarios.

BThe content delivers Transformations that are optimized to enable push-down to SAP HANA

CThe content follows the LSA++ recommendations and delivers an LSA++ aligned structure.

DThe content delivers predefined settings for SAP BW/4HANA Data Tiering Optimization (DTO).

Answer : B, C

Question 2

Which options in a transformation prevent SAP HANA runtime and enforce ABAP runtime? Note: There are 2 correct answers to this question.

AUse type 'Time' for a time characteristic in an additional rule group.

BDefine an end routine using an ABAP Managed Database Procedure (AMDP).

CUse a customer-defined function in the formula editor.

DDefine a start routine using ABAP code.

Answer : C, D

Question 3

You imported a project into SAP Web IDE for SAP HANA to develop an SAP HANA HD! Calculation View. At which level of the Workspace hierarchy do you have to assign a Space?

AWorkspace

BProject

CHDB Module

DPackage

Answer : B

Question 4

What is a valid reason for leveraging SAP HANA Native Storage Extension (NSE) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?

ATo move historical data that only needs to be read exceptionally to an external storage.

BTo reduce the SAP HANA memory consumption of data that is only used infrequently

CTo improve the reporting performance for current data which is used frequently.

DTo create an external archive for data, to ensure legal requirements are fulfilled.

Answer : B

Question 5

What are characteristics of SAP HANA modelling in XS Advanced? Note: There are 2 correct answers to this question

AUse of SAP HANA Studio as a user interface

BPotential use of GitHub as a source code repository

CImport of SAP HANA HDI Calculation View as a file in a project Deployment of external SAP HANA views generated from BW objects

Answer : B, C

Question 6

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 a UTC time stamp. What is the recommended approach to implement this extraction in the source system?

ACreate a customer DataSource (TC RSO2) that leverages the generic delta based on the time stamp.

BCreate an ABAP CDS View that leverages a procedure to generate the delta based on the time stamp.

CCreate an ABAP CDS View that is enabled for extraction and generates the delta based on the time stamp.

DCreate an ABAP CDS View that is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp.

Answer : D

Question 7

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

AModel a Data Store object (advanced) and use an ABAP CDS View for virtual access.

BGenerate external SAP HANA views of SAP BW/4HANA Info Providers to consume this SAP BW/4HANA data in SAP HANA

CLoad SAP HANA data into SAP BW/4HANA Info Providers based on the Operational Data Provisioning (ODP) framework

DModel a Composite Provider that combines data from multiple SAP BW/4HANA Info Providers and SAP HANA Views

EDefine an Open ODS View that integrates an SAP HANA table into SAP BW/4HANA

Answer : B, C, D

SAP Certified Specialist - SAP BW/4HANA 2021 Delta E_BW4HANA214 Exam Questions