Exam4Training

SAP E_BW4HANA214 SAP Certified Application Specialist-SAP BW/4HANA 2021 Delta Online Training

Question #1

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 SAP BW Query?

  • A . ABAP CDS View
  • B . Open ODS View
  • C . Badl Provider
  • D . DataStore object (advanced)

Reveal Solution Hide Solution

Correct Answer: A
Question #2

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

  • A . SAP ABAP CDS View
  • B . Composite Provider
  • C . SAP HANA Calculation View
  • D . BW Query
  • E . Open ODS View

Reveal Solution Hide Solution

Correct Answer: B, C, E
Question #3

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

  • A . Both approaches require the SAP BW/4HANA Starter Add-on to be installed on the sending system
  • B . Both approaches convert unsupported object types during import into the new SAP BW/4HANA system
  • C . Both approaches uninstall the unsupported BW Add-ons from the sending BW system as the first activity
  • D . Both approaches are setup by installing required SAP notes via the SAP BW Notes Analyzer
  • E . Both approaches result in a SAP BW/4HANAsystem which has a new system ID Notes Analyzer

Reveal Solution Hide Solution

Correct Answer: B, D, E
Question #4

The SAP BW/4HANA StarterAdd-on is installed and set to the Compatibility mode.

How is the SAP BW system affected? Note: There are 2 correct answers o this question.

  • A . Virtual InfoProviders for Planning are still allowed.
  • B . New InfoCubes can be created after getting approval by a whitelist.
  • C . All objects can be changed after getting approval by a whitelist.
  • D . The SAP BEx Analyzer is decommisioned.

Reveal Solution Hide Solution

Correct Answer: C, D
Question #5

In SAP BW/4HANA you decide to switch on the External Tier (COLD Store) for a DataStore object (advanced) based on the Data Tiering Optimization (DTO)concept.

Where can the data be managed? Note: there are 2 correct answers to this question.

  • A . In SAP HANA on an extension node
  • B . In the file system of a Hadoop cluster
  • C . In an SAP IQ database
  • D . In SAP HANA Native Storage Extension

Reveal Solution Hide Solution

Correct Answer: B, C
Question #6

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

  • A . SDA is integrates into the SAP HANA Indexserver while you need to setup an additional SAP 1-1 HANA Data Provisioning server for SDI
  • B . SAP BW/4HANA DataSources of source system type "SAP HANA" can connect to SDA sources, U but NOT to SDI sources.
  • C . SDI provides options for data replication in real-time, while SDA does NOT provide this capability.
  • D . SAP BW/4HANA Open ODS View can be modelled on SDI sources, but NOT on U SDA sources.

Reveal Solution Hide Solution

Correct Answer: A, C
Question #7

Why do you use the ‘ "Enhanced Master Data Update"" setting InfoObject? Note: there are 2 correct answers to this question.

  • A . To enable delta capability
  • B . To enable XXL attributes
  • C . To enable parallel loading
  • D . To enable transitive attributes

Reveal Solution Hide Solution

Correct Answer: A, C
Question #8

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

  • A . To reduce the SAP HANA memory consumption of data that is only used infrequently"
  • B . To create an offline archive for data, to ensure legal requirement are fulfilled
  • C . To aggregate data and improve the reporting performance for year-to-date values
  • D . To move historical data that only needs to be read exceptionally to an external storage

Reveal Solution Hide Solution

Correct Answer: A
Question #9

Which transformation rules do support SAP HANA Runtime? Note: There are 3 correct answers to this question.

  • A . ABAP end routine
  • B . ABAP Field rountine
  • C . SQL procedure in an SAP HANA FlowGraph
  • D . Lookup from DataStore object (advanced)
  • E . SQL script field routine

Reveal Solution Hide Solution

Correct Answer: A, D, E
Question #10

A customers wants to convert from SAP BW powered by SAPHANA to SAP BW/4HANA.

What additional value is offered by SAP BW/4HANA compared to SAP BW powered by SAP HANA?

  • A . Generating external SAP HANA Views for SAP BW Queries
  • B . Creating HANA Analysis Processes (HAP)
  • C . Leveraging the Data Tiering Optimization (DTO) concept
  • D . Storing data of DaraStore objects (advanced) in Extended Tables

Reveal Solution Hide Solution

Correct Answer: C

Question #11

Which BW object type do you need to create a Badl Provider?

  • A . DataStore object (advance) with Direct Update
  • B . CompositeProvider
  • C . DataStore object (advance) in Planning Mode
  • D . InfoObject

Reveal Solution Hide Solution

Correct Answer: D
Question #12

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? (3 Answers)

  • A . Use Write Interface-Enabled Data Store object (advanced) instead of Virtual ― Providers
  • B . Use Open ODS Views to establish virtual access for master and transactiona Udata
  • C . Use Semantic Group to organize big data volumes in Data Store object ^ U (advanced)
  • D . Use ODP_SAP source system type instead of a DB-connect
  • E . Use Composite Providers instead of InfoSet

Reveal Solution Hide Solution

Correct Answer: B, C, E
Question #13

Which of the following SAP BW/4HANA objects support the automatic generation of external SAP HANA views? Note: There are 2 correct answers to this question.

  • A . InfoObject Characteristic
  • B . BW Query
  • C . Open ODS View
  • D . DataSource

Reveal Solution Hide Solution

Correct Answer: A, B
Question #14

Which statements about the table structure of the Data Store object (advanced) are correct? 3 Answers

  • A . When data is loaded to a Direct Update Data Store object (advanced), the inbound table is loaded first
  • B . SAP creates compatibility views for Data Store object (advanced) to keep existing custom coding safe
  • C . SAP recommends using the generated external SAP HANA view if the Data Store object (advanced) serves as a source for data extraction
  • D . SAP provides a database view for reporting purposes (/BIC/A<technical LJname>7)
  • E . SAP provides a database view for external SQL access (/BIC/A<technical L-J name>8)

Reveal Solution Hide Solution

Correct Answer: A, C, D
Question #15

You want to create SAP HANA HDI Calculation View that consumes an External SAP HANA view representing a Data Store object (advanced).

What needs to be defined? (2 Answers)

  • A . Synonym
  • B . Cross-schema Service
  • C . Package
  • D . Delivery Unit

Reveal Solution Hide Solution

Correct Answer: C, D
Question #16

Which statement describes the "Intelligent PULL Run Mode" of Streaming Process Chain property?

  • A . SAP BW/4HANA receives a trigger from a Daemon in the source system. This event runs the Process Chain immediately
  • B . SAP BW/4HANA checks once a minute if a new record is generated in the source system. If this check is successful, the Process Chain starts immediately
  • C . The concept is obsolete in SAP BW/4HANA. SAP recommends leveraging the new "PUSH Run Mode" for Streaming Process Chain instead
  • D . An SAP BW/4HANA Process Chain is scheduled as a periodic job with high frequency up to each minutes. The Process Chain runs accordingly

Reveal Solution Hide Solution

Correct Answer: B
Question #17

Which SAP HANA XS classic information view can you convert directly into an SAP HANA HDI Calculation View?

  • A . SAP HANA Calculation View (scripted)
  • B . SAP HANA Attribute View
  • C . SAP HANA Calculation View (graphical)
  • D . SAP HANA Analytic View

Reveal Solution Hide Solution

Correct Answer: C
Question #18

How does column-based storage enable data to be read faster in SAP HANA?

  • A . Individual columns can be processed at the same time by different CPU cores
  • B . Individual columns can be transferred to an SAP HANA optimized row-based format for faster access
  • C . Individual columns are read-optimized by writing into a main store and a delta ^ store
  • D . Individual columns contain all of the information for ine record

Reveal Solution Hide Solution

Correct Answer: B
Question #19

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.

  • A . Choose between Temperature Maintencance "On Partition Level" or "On Object U Level"
  • B . Define partitions for the DataStore object (advanced)
  • C . Define the planned temperature for each partition
  • D . Create a Data ArchivingProcess (DAP) for the DataStore object (advanced)

Reveal Solution Hide Solution

Correct Answer: B
Question #20

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.

  • A . Set upan Open ODS view based on the SAP HANA remote source and associate InfoObjects to each field
  • B . Create a CompositeProvider on top of the DataStore object (advanced) and define a BW Query on top of it.
  • C . Create n SAP HANA remote source based on an SAP HANA Smart Data ‘ Integration adapter and a BW DataSource related to it.
  • D . Create a Process Chain that executes the DTP, set it to "Streaming mode", and schedule it.
  • E . Create a DataStore obhet (advanced) and a Transformation including DTP connecting the BW DataSource

Reveal Solution Hide Solution

Correct Answer: A, C, E
Exit mobile version