SAP E_BW4HANA214 Exam Practice Test Instant Access

Question 1

You want to load master data for an Info Object Which benefits are offered by the setting "Enhanced Master Data Update" in the definition of the Info Object? Note: There are 2 correct answers to this question.

AUsing OData Services for data extraction

BParallel processing of multiple loads.

CDelta handling of extracted data.

DDisabling update of SID values

Answer : B, C

Question 2

A customer wants to know the difference between LSA and LSA++ when defining a layered scalable architecture. Which layers are only presented in LSA++? Note: There are 2 correct answers to this question

ACorporate Memory

BArchitected Data Mart Layer

COpen Operational Data Store Layer

DBW Workspace Layer

Answer : C, D

Question 3

Which objects can be used as components in a Composite Provider in SAP BW/4HANA? Note: There are 3 correct answers to this question

ABW Query

BComposite Provider

CABAP CDS View

DHANA HDI Calculation View

EOpen ODS View

Answer : A, B, E

Question 4

You create a Data Store object (advanced) with only the settings "Staging Data Store Object" and "Reporting-Enabled" selected. Which table or combination of tables is used when data is extracted from this Data Store object (advanced) in a data flow?

AInbound table only

BActive Data table only

CThe union of the Inbound table and the Active Data table

DChangelog table only

Answer : C

Question 5

What are valid characteristics of the database objects related to a DataStore object (advanced)? Note: There are 3 correct answers to this question

AIn a Data Mart Data Store object (advanced), the inbound table (/BIC/A<technical name>1) is not relevant for reporting.

BSAP BW/4HANA provides a database view (BIC/A<technical name>8) for external SQL access

CWhen data is loaded to a Direct Update Data Store object (advanced), the inbound table (/BIC/A<technical name>1) is loaded first

DSAP provides a database view (/BIC/A<technical name>7) for reporting purposes.

EThe reference point table (BIC/A<technical name>5) is created if the Data Store object (advanced) is inventory-enabled.

Answer : B, D, E

Question 6

How can you check if a Data Source is released for ODP?

ATable RSOLTPSOURCE in the SAP BW/4HANA system

BTable ROOSOURCE in the source system

CTable ROOSATTR in the source system

DReport BS_ANLY_DS_RELEASE_ODP in the SAP BW/4HANA system

Answer : C

Question 7

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

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