SAP E_BW4HANA214 Exam Practice Test Instant Access

Question 1

You create an SAP HANA HDI Calculation View in SAP Web IDE for SAP HANA and have to select a data category which data category allows you to create restricted columns? Note: There are 2 correct answers to this question.

ACube with Star Join

BDimension

CSQL Access Only

DCube without Star Join

Answer : A, D

Question 2

To create a BAdl Provider, which SAP BW/4HANA object type do you need?

ADirect Update Data Store object (advanced)

BInfo Object

CPlanning Enabled Data Store object (advanced)

DComposite Provider

Answer : B

Question 3

What is SAP's recommendation to extract data from SAP S/4HANA Cloud and load it into SAP BW/HANA?

ACreate a BW Data Source on source system of type ODP HANA and leverage extractors based on HANA Calculation Views.

BCreate a BW Data Source on source system of type ODP BW and leverage extractors based on SAP S/4HANA embedded analytics.

CCreate a BW Data Source on source system of type ODP_CDS and leverage extractors based on Core Data Services

DCreate a BW Data Source on source system of type ODP SAP and leverage extractors based on ABAP Function Modules

Answer : C

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

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 6

Which statement describes the "Intelligent PULL Run Mode" of Streaming Process Chains properly?

ASAP BW/HANA checks once a minute if a new record is generated in the source system. If this check is successful, the Process Chain starts immediately.

BThis concept is obsolete in SAP BW/4HANA SAP recommends leveraging the new 'PUSH Run Mode' for Streaming Process Chains instead.

CSAP BW/4HANA receives a trigger from a Daemon in the source system. This event triggers the Process Chain immediately.

DAn SAP BW/4HANA Process Chain is scheduled as a periodic job with high frequency, up to each minute. The Process Chain runs accordingly.

Answer : A

Question 7

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

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