SAP E_BW4HANA214 Exam Practice Test Instant Access

Question 1

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

ATo leverage the SAP BW Analytic Manager to process BW Queries.

BTo access data in the COLD tier of SAP BW/4HANA Data Tiering Optimization (DTO)

CTo consume SAP BW/4HANA data and manage access with native SAP HANA concepts

DTo apply SAP HANA transformational logic instead of SAP BW/4HANA logic.

Answer : C, D

Question 2

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

AChoose between Temperature Maintenance 'On Partition Level' or 'On Object Level'.

BDefine the planned temperature for each partition

CSpecify partitions for the Data Store object (advanced)

DCreate a Data Archiving Process (DAP) for the Data Store object (advanced).

Answer : A, B

Question 3

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

AThe content delivers SAP HANA HDI Calculation Views for Mixed Scenarios.

BThe content delivers Transformations that are optimized to enable push-down to SAP HANA

CThe content follows the LSA++ recommendations and delivers an LSA++ aligned structure.

DThe content delivers predefined settings for SAP BW/4HANA Data Tiering Optimization (DTO).

Answer : B, C

Question 4

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

AA column can be processed at the same time by different CPU cores.

BA column is managed in a compressed way

CA column is read-optimized by reading from the delta store only

DA column contains all of the information for one record.

Answer : A, B

Question 5

You want to create an SAP BW Query showing data loading statistics provided by the SAP BW/4HANA statistical analysis. Which object does SAP deliver to provide data for your requirement?

ATransient Provider

BOpen ODS View

CBAdi Provider

DComposite Provider

Answer : A

Question 6

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?

AThe existing Data Store object (advanced) analysis authorizations in SAP BW/HANA.

BThe existing Data Store object (advanced) object authorizations in SAP BW/4HANA.

CThe generated privileges in SAP HANA

DThe generated authorizations for the HDI container access in SAP HANA

Answer : C

Question 7

Which operations can you perform in the SAP BW/4HANA Cockpit? Note: There are 3 correct answers to this question

AManage requests of Data Store objects (advanced)

BExecute Data Transfer Processes

CDefine partitions for Data Store objects (advanced)

DCreate and maintain Analysis Authorizations

EMonitor Process Chains

Answer : B, C, E

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