SAP e-bw4hana214 practice test

SAP Certified Specialist - SAP BW/4HANA 2021 Delta

Last exam update: Nov 18 ,2025
Page 1 out of 3. Viewing questions 1-15 out of 40

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.

  • A. Cube with Star Join
  • B. Dimension
  • C. SQL Access Only
  • D. Cube without Star Join
Mark Question:
Answer:

A D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

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

  • A. Info Object Characteristic
  • B. BW Query
  • C. Open ODS View
  • D. Composite Provider
  • E. Open Hub Destination
Mark Question:
Answer:

A B D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 3

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

  • A. Model a Data Store object (advanced) and use an ABAP CDS View for virtual access.
  • B. Generate external SAP HANA views of SAP BW/4HANA Info Providers to consume this SAP BW/4HANA data in SAP HANA
  • C. Load SAP HANA data into SAP BW/4HANA Info Providers based on the Operational Data Provisioning (ODP) framework
  • D. Model a Composite Provider that combines data from multiple SAP BW/4HANA Info Providers and SAP HANA Views
  • E. Define an Open ODS View that integrates an SAP HANA table into SAP BW/4HANA
Mark Question:
Answer:

B C D

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 4

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?

  • A. Workspace
  • B. Project
  • C. HDB Module
  • D. Package
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

You want to create an SAP HANA HDI Calculation View that consumes an External SAP HANA View
representing a Data Store Object (advanced).What needs to be defined? Note: There are 2 correct
answers to this question

  • A. Package
  • B. Synonym
  • C. Cross-schema Service
  • D. Delivery Unit
Mark Question:
Answer:

A C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

What are valid reasons to generate external SAP HANA Views for SAP BW/4HANA objects? Note:
There are 2 correct answers to this question

  • A. To leverage the SAP BW Analytic Manager to process BW Queries.
  • B. To access data in the COLD tier of SAP BW/4HANA Data Tiering Optimization (DTO)
  • C. To consume SAP BW/4HANA data and manage access with native SAP HANA concepts
  • D. To apply SAP HANA transformational logic instead of SAP BW/4HANA logic.
Mark Question:
Answer:

C D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

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?

  • A. The existing Data Store object (advanced) analysis authorizations in SAP BW/HANA.
  • B. The existing Data Store object (advanced) object authorizations in SAP BW/4HANA.
  • C. The generated privileges in SAP HANA
  • D. The generated authorizations for the HDI container access in SAP HANA
Mark Question:
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

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

  • A. Use of SAP HANA Studio as a user interface
  • B. Potential use of GitHub as a source code repository
  • C. Import of SAP HANA HDI Calculation View as a file in a project Deployment of external SAP HANA views generated from BW objects
Mark Question:
Answer:

B C

User Votes:
A
50%
B
50%
C
50%
Discussions
vote your answer:
A
B
C
0 / 1000

Question 9

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

  • A. SAP 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.
  • B. This concept is obsolete in SAP BW/4HANA SAP recommends leveraging the new "PUSH Run Mode" for Streaming Process Chains instead.
  • C. SAP BW/4HANA receives a trigger from a Daemon in the source system. This event triggers the Process Chain immediately.
  • D. An SAP BW/4HANA Process Chain is scheduled as a periodic job with high frequency, up to each minute. The Process Chain runs accordingly.
Mark Question:
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

In an SAP BW/4HANA system you plan 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? Note: There are 2 correct answers to this question

  • A. Choose between Temperature Maintenance "On Partition Level" or "On Object Level".
  • B. Define the planned temperature for each partition
  • C. Specify partitions for the Data Store object (advanced)
  • D. Create a Data Archiving Process (DAP) for the Data Store object (advanced).
Mark Question:
Answer:

A B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

In SAP BW/4HANA, you decide to use the COLD Store of the Data Tiering Optimization (DTO) concept.
Where can the data be managed?

  • A. SAP HANA Cloud, data lake
  • B. SAP IQ Database
  • C. Hadoop Distributed File System
  • D. SAP Data sphere, SAP BW Bridge
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

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

  • A. The content delivers SAP HANA HDI Calculation Views for Mixed Scenarios.
  • B. The content delivers Transformations that are optimized to enable push-down to SAP HANA
  • C. The content follows the LSA++ recommendations and delivers an LSA++ aligned structure.
  • D. The content delivers predefined settings for SAP BW/4HANA Data Tiering Optimization (DTO).
Mark Question:
Answer:

B C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

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?

  • A. Create a customer DataSource (TC RSO2) that leverages the generic delta based on the time stamp.
  • B. Create an ABAP CDS View that leverages a procedure to generate the delta based on the time stamp.
  • C. Create an ABAP CDS View that is enabled for extraction and generates the delta based on the time stamp.
  • D. Create an ABAP CDS View that is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp.
Mark Question:
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

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

  • A. Direct Update Data Store object (advanced)
  • B. Info Object
  • C. Planning Enabled Data Store object (advanced)
  • D. Composite Provider
Mark Question:
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

You are running SAP S/4HANA and would like to extract data to SAP BW/4HANA.Which tools does
SAP recommend to evaluate the metadata of CDS-based extractors? Note: There are 2 correct
answers to this question

  • A. SAP S/4HANA Query Browser App
  • B. SAP S/4HANA Analytical List Page App
  • C. SAP ABAP Development Tools
  • D. SAP S/4HANA View Browser App
Mark Question:
Answer:

C D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2