SAP E_BW4HANA214 Exam Questions Instant Access

Question 1

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 2

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

Question 3

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 4

How does column-based storage allow SAP HANA to read data faster? Note: There are 2 correct answers to this question

AA column can be processed at the same time by different CPU cores.

BA column is managed in a compressed way

CA column is read-optimized by reading from the delta store only

DA column contains all of the information for one record.

Answer : A, B

Question 5

A customer wants to convert from SAP BW powered by SAP HANA to SAP BW/4HANA Which strategy does SAP recommend based on successor object types? Note: There are 3 correct answers to this question

AUse Write Interface-Enabled Data Store objects (advanced) instead of Virtual Providers.

BUse Semantic Groups to organize big data volumes in Data Store objects (advanced).

CUse ODP SAP source system type instead of a DB-connect

DUse Composite Providers instead of Info Sets.

EUse Open ODS Views to establish virtual access for master and transactional data.

Answer : A, D, E

Question 6

What are valid consumers of the Operational Delta Queue? Note: There are 3 correct answers to this question

ASAP HANA Smart Data Access

BSAP Data Services

CSAP BW 7.5 on any data base

DSAP Landscape Transformation Server

ESAP BW/4HANA

Answer : B, C, E

Question 7

You switch on the "External SAP HANA view flag in the settings for a Data Store object (advanced) and activate it. Which authorizations are used when you consume the SAP HANA view directly for reporting?

AThe existing Data Store object (advanced) analysis authorizations in SAP BW/HANA.

BThe existing Data Store object (advanced) object authorizations in SAP BW/4HANA.

CThe generated privileges in SAP HANA

DThe generated authorizations for the HDI container access in SAP HANA

Answer : C

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