SAP E_BW4HANA214 Exam Practice Test Instant Access

Question 1

You create a DataStore object (advanced)with only the setting ""Staging DataStore Object"" and ""Reporting-Enabled"" selected.

Which table or combination of tables is used when data is extracted from this DataStore object (advanced) in a data flow?

AThe union of the Inbound table and the Active Data table

BThe union of the Inbound table and the Changelog table

CInbound table only

DActive Data table only

Answer : C

Question 2

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.

AIt is executed only when columns from both tables are requested

BIt shows all master data to assure the referential integrity

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

DIt shows all transactional data with an existing master data record

Answer : A, C

Question 3

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 can only use attributes in the Semantic nodes?

ASQL Access Only

BCube

CCube with Star Join

DDimension

Answer : D

Question 4

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

AModel an Open ODS View of source type 'DataSource (BW)'which refers to the SAP ABAP CDS U View

BModel an Open View of source type 'Dattabase Table or View' which refers to the SAP ABAP CDS U View.

CModel a Composite Provide which directly consumes the SAO ABAP CDS View.

DModel a Composite Provider which consumes an SAP HANA Calculation View which refers to the SAP ABAP CDS View.

Answer : A

Question 5

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

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

BA cluster of InfoProviders with a homogenous mapping is created (expert mode

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

DThe system supports the calculation of condition (expert mode 9)

Answer : B, C

Question 6

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.

ASet upan Open ODS view based on the SAP HANA remote source and associate InfoObjects to each field

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

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

DCreate a Process Chain that executes the DTP, set it to 'Streaming mode', and schedule it.

ECreate a DataStore obhet (advanced) and a Transformation including DTP connecting the BW DataSource

Answer : A, C, E

Question 7

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.

AChoose between Temperature Maintencance 'On Partition Level' or 'On Object U Level'

BDefine partitions for the DataStore object (advanced)

CDefine the planned temperature for each partition

DCreate a Data ArchivingProcess (DAP) for the DataStore object (advanced)

Answer : B

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