Which rule types support SAP HANA Runtime for Transformations in SAP BW/4HANA? Note: There are 3 correct answers to this question

Lookup from Data Store object (advanced)

Which options in a transformation prevent SAP HANA runtime and enforce ABAP runtime? Note: There are 2 correct answers to this question.

Use a customer-defined function in the formula editor.

Define a start routine using ABAP code.

Use type 'Time' for a time characteristic in an additional rule group.

Define an end routine using an ABAP Managed Database Procedure (AMDP).

Use a customer-defined function in the formula editor.

Define a start routine using ABAP code.

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

Generate external SAP HANA views of SAP BW/4HANA Info Providers to consume this SAP BW/4HANA data in SAP HANA

Load SAP HANA data into SAP BW/4HANA Info Providers based on the Operational Data Provisioning (ODP) framework

Model a Composite Provider that combines data from multiple SAP BW/4HANA Info Providers and SAP HANA Views

Model a Data Store object (advanced) and use an ABAP CDS View for virtual access.

Generate external SAP HANA views of SAP BW/4HANA Info Providers to consume this SAP BW/4HANA data in SAP HANA

Load SAP HANA data into SAP BW/4HANA Info Providers based on the Operational Data Provisioning (ODP) framework

Model a Composite Provider that combines data from multiple SAP BW/4HANA Info Providers and SAP HANA Views

Define an Open ODS View that integrates an SAP HANA table into SAP BW/4HANA

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

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

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

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

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

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

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

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?

The generated privileges in SAP HANA

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

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

The generated privileges in SAP HANA

The generated authorizations for the HDI container access in SAP HANA

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

Potential use of GitHub as a source code repository

Import of SAP HANA HDI Calculation View as a file in a project Deployment of external SAP HANA views generated from BW objects

Use of SAP HANA Studio as a user interface

Potential use of GitHub as a source code repository

Import of SAP HANA HDI Calculation View as a file in a project Deployment of external SAP HANA views generated from BW objects

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

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.

This concept is obsolete in SAP BW/4HANA SAP recommends leveraging the new 'PUSH Run Mode' for Streaming Process Chains instead.

SAP BW/4HANA receives a trigger from a Daemon in the source system. This event triggers the Process Chain immediately.

An SAP BW/4HANA Process Chain is scheduled as a periodic job with high frequency, up to each minute. The Process Chain runs accordingly.

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

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

Define the planned temperature for each partition

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

Define the planned temperature for each partition

Specify partitions for the Data Store object (advanced)

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

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

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

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

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

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

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

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

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?

Create an ABAP CDS View that is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp.

Create a customer DataSource (TC RSO2) that leverages the generic delta based on the time stamp.

Create an ABAP CDS View that leverages a procedure to generate the delta based on the time stamp.

Create an ABAP CDS View that is enabled for extraction and generates the delta based on the time stamp.

Create an ABAP CDS View that is enabled for extraction and model the Change Delta Capture (CDC) logic based on the time stamp.

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

Direct Update Data Store object (advanced)

Planning Enabled Data Store object (advanced)

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

SAP S/4HANA Analytical List Page App

What are valid SAP BW Note Analyzer scenarios? Note: There are 3 correct answers to this question.

Conversion from SAP BW to SAP BW/4HANA

BW transformations with SAP HANA and ABAP execution

SAP Readiness Check for SAP BW/4HANA

SAP BW/HANA Data Tiering Optimization

SAP BW Modeling Tools Query Designer

Conversion from SAP BW to SAP BW/4HANA

BW transformations with SAP HANA and ABAP execution

SAP Readiness Check for SAP BW/4HANA

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

Open Operational Data Store Layer

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.

Parallel processing of multiple loads.

Delta handling of extracted data.

Using OData Services for data extraction

Parallel processing of multiple loads.

Delta handling of extracted data.

During the prepare phase of an in-place conversion to SAP BW/4HANA, you work with the SAP BW/4HANA Transfer Cockpit. Which functions are provided? Note: There are 3 correct answers to this question.

Transfer Standard Authorizations (initial nun)

What are key results provided by the SAP BW/4HANA Readiness Check? Note: There are 3 correct answers to this question

List of all SAP BW/4HANA incompatible BW objects in the system

List of all SAP BW/4HANA incompatible add-ons in the system

List of the largest database tables and additional sizing information

List of all SAP BW/4HANA incompatible BW objects in the system

List of all SAP S/4HANA incompatible SAP ERP Data Sources

List of all missing SAP notes for installing the SAP BW/4HANA Transfer Cockpit

List of all SAP BW/4HANA incompatible add-ons in the system

List of the largest database tables and additional sizing information

What do the Remote Conversion approach and the Shell Conversion approach have in common? Note: There are 3 correct answers to this question

Both approaches require the SAP BW/4HANA Starter Add-on to be installed on the sending system.

Both approaches convert unsupported object types during import into the new SAP BW/4HANA system.

Both approaches are set up by installing required SAP notes via the SAP BW Notes Analyzer.

Both approaches uninstall the unsupported BW Add-ons from the sending BW system as the first activity.

Both approaches require the SAP BW/4HANA Starter Add-on to be installed on the sending system.

Both approaches result in an SAP BW/4HANA system with a new system ID

Both approaches convert unsupported object types during import into the new SAP BW/4HANA system.

Both approaches are set up by installing required SAP notes via the SAP BW Notes Analyzer.

What is SAP's recommendation to extract data from SAP S/4HANA Cloud and load it into SAP BW/HANA?

Create a BW Data Source on source system of type ODP_CDS and leverage extractors based on Core Data Services

Create a BW Data Source on source system of type ODP HANA and leverage extractors based on HANA Calculation Views.

Create a BW Data Source on source system of type ODP BW and leverage extractors based on SAP S/4HANA embedded analytics.

Create a BW Data Source on source system of type ODP_CDS and leverage extractors based on Core Data Services

Create a BW Data Source on source system of type ODP SAP and leverage extractors based on ABAP Function Modules

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

Table ROOSATTR in the source system

Table RSOLTPSOURCE in the SAP BW/4HANA system

Table ROOSOURCE in the source system

Table ROOSATTR in the source system

Report BS_ANLY_DS_RELEASE_ODP in the SAP BW/4HANA system

What are valid consumers of the Operational Delta Queue? Note: There are 3 correct answers to this question

SAP Landscape Transformation Server

What is a valid reason for leveraging SAP HANA Native Storage Extension (NSE) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?

To reduce the SAP HANA memory consumption of data that is only used infrequently

To move historical data that only needs to be read exceptionally to an external storage.

To reduce the SAP HANA memory consumption of data that is only used infrequently

To improve the reporting performance for current data which is used frequently.

To create an external archive for data, to ensure legal requirements are fulfilled.

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

Execute Data Transfer Processes

Define partitions for Data Store objects (advanced)

Manage requests of Data Store objects (advanced)

Execute Data Transfer Processes

Define partitions for Data Store objects (advanced)

Create and maintain Analysis Authorizations

Which features from SAP BW powered by SAP HANA have been decommissioned in SAP BW/4HANA? Note: There are 2 correct answers to this question

Customer Exit Variables using RSR00001 (TC: CMOD)

Data Source Repository (TC: RSDS)

Process Chain Maintenance (TC. RSPC)

Customer Exit Variables using RSR00001 (TC: CMOD)

Data Source Repository (TC: RSDS)

Real-time Data Acquisition (TC. RSRDA)

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

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

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

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

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

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

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

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

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

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?

The union of the Inbound table and the Active Data table

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

SDI provides options for data replication in real-time, while SDA does NOT provide this capability.

SDA is integrated into the SAP HANA Index server while you need to set up an additional SAP HANA Data Provisioning server for SDI.

SDI provides options for data replication in real-time, while SDA does NOT provide this capability.

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

SAP BW/4HANA Open ODS Views can be modelled on SDI sources, but NOT on SDA sources

SDA is integrated into the SAP HANA Index server while you need to set up an additional SAP HANA Data Provisioning server for SDI.

A customer wants to convert from SAP BW powered by SAP HANA to SAP BW/4HANA Which strategy does SAP recommend based on successor object types? Note: There are 3 correct answers to this question

Use Write Interface-Enabled Data Store objects (advanced) instead of Virtual Providers.

Use Composite Providers instead of Info Sets.

Use Open ODS Views to establish virtual access for master and transactional data.

Use Write Interface-Enabled Data Store objects (advanced) instead of Virtual Providers.

Use Semantic Groups to organize big data volumes in Data Store objects (advanced).

Use ODP SAP source system type instead of a DB-connect

Use Composite Providers instead of Info Sets.

Use Open ODS Views to establish virtual access for master and transactional data.

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

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

A column is managed in a compressed way

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

A column is managed in a compressed way

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

A column contains all of the information for one record.

SAP E_BW4HANA214 Practice Test 1 - Free Online Exam Prep & Questions

You want to load data from an SAP BW/4HANA system into another SAP BW/4HANA system using Operational Data Provisioning (ODP) in the context of ODP BW.

Which objects can be used as a source? Note: There are 3 correct answers to this question

A.

Open ODS View

B.

Info Object Characteristic

C.

ABAP CDS View

D.

Composite Provider

E.

Data Store object (advanced)

SAP E_BW4HANA214 Practice Test 1

Question

SAP E_BW4HANA214 Practice Tests

Practice Tests