Free SAP E_BW4HANA214 Exam Dumps Questions & Answers

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

• A.SAP provides a database view (/BIC/A<technical name>7) for reporting purposes.
• B.In a Data Mart Data Store object (advanced), the inbound table (/BIC/A<technical name>1) is not relevant for reporting.
• C.When data is loaded to a Direct Update Data Store object (advanced), the inbound table (/BIC/A<technical name>1) is loaded first
• D.The reference point table (BIC/A<technical name>5) is created if the Data Store object (advanced) is inventory-enabled.
• E.SAP BW/4HANA provides a database view (BIC/A<technical name>8) for external SQL access

From an SAP BW/4HANA perspective, what is the difference between SAP HANA Smart Data Access (SDA) and SAP HANA Smart Data Integration (SDI)? Note: There are 2 correct answers to this question

• A.SDA is integrated into the SAP HANA Index server while you need to set up an additional SAP HANA Data Provisioning server for SDI.
• B.SDI provides options for data replication in real-time, while SDA does NOT provide this capability.
• C.SAP BW/4HANA Open ODS Views can be modelled on SDI sources, but NOT on SDA sources
• D.SAP BW/4HANA Data Sources of source system type "SAP HANA Smart Data Access (HANA_SDA)" can connect to SDA sources only, but NOT to SDI sources

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

• A.A column can be processed at the same time by different CPU cores.
• B.A column is read-optimized by reading from the delta store only
• C.A column contains all of the information for one record.
• D.A column is managed in a compressed way

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.Create a Data Archiving Process (DAP) for the Data Store object (advanced).
• B.Define the planned temperature for each partition
• C.Specify partitions for the Data Store object (advanced)
• D.Choose between Temperature Maintenance "On Partition Level" or "On Object Level".

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.

• A.Using OData Services for data extraction
• B.Disabling update of SID values
• C.Delta handling of extracted data.
• D.Parallel processing of multiple loads.