Exam4Training

SAP E_BW4HANA207 SAP Certified Application Specialist – SAP BW/4HANA 2.0 Delta Online Training

Question #1

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 U each field
  • B . Create a CompositeProvider on top of the DataStore object (advanced) and define a BW Query on top of it.
  • C . Create a DataStore obhet (advanced) and a Transformation including DTP connecting the BW DataSource
  • D . Create n SAP HANA remote source based on an SAP HANA Smart Data Integration adapter and a 1-1 BW DataSource related to it.
  • E . Create a Process Chain that executes the DTP, set it to "Streaming mode", and schedule it.

Reveal Solution Hide Solution

Correct Answer: A,C,D
Question #2

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

Reveal Solution Hide Solution

Correct Answer: B,D
Question #3

You create a DataStore object (advanced)with only the setting ""Sraging DataStore Object"" and ""Reporting-Enabled"" selected.

Which table or combination of tables is used when data is extracted from this DataStore object (advanced) in a data flow?

  • A . The union of the Inbound table and the Changelog table
  • B . The union of the Inbound table and the Active Data table
  • C . Inbound table only
  • D . Active Data table only

Reveal Solution Hide Solution

Correct Answer: D
Question #4

You use an Open Hub Destination to distribute SAP BW/4HANA data to a table managed by an SAP database.

Which technologies can be used? Note: There are 2 correct answers to this question.

  • A . Operational Data Provisioning (ODP)
  • B . Database Connection (DBCON)
  • C . Smart Data Access (SDA)
  • D . Remote Function Call (RFC)

Reveal Solution Hide Solution

Correct Answer: C,D
Question #5

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

  • A . Monitor Process Chains
  • B . Manage requests of DataStore objects (advanced)
  • C . Create and maintain BW Query variables
  • D . Create and maintain indicesfor DataStore objects (advanced)
  • E . Create and maintain Analysis Authorizations

Reveal Solution Hide Solution

Correct Answer: A,B,E
Question #6

You use the SAP BW/4HANA Transfer Cockpit to prepare your SAP BW system for an in-place conversion to SAP BW/4HANA.

Which functions are provided by this cockpit? Note: There are 2 correct answers to this question.

  • A . Execute Pre-Checks
  • B . Transfer 3.x DataFlow into 7.x DataFlows
  • C . Transfer Bex Queries into BW Queries
  • D . Transfer Standard Authorizations

Reveal Solution Hide Solution

Correct Answer: A,D
Question #7

What is a valid reason to run the program RODPS_OS_EXPOSE?

  • A . To use an SAP ABAP CDS View for ODP
  • B . To have an overview of ODP Consumers of a DataSource
  • C . To release a costomer developed DataSource for ODP
  • D . To investigate extractor logic in an SAP delivered DataSource For ODP

Reveal Solution Hide Solution

Correct Answer: C
Question #8

Why do you create a Semantic Group?

  • A . To create folders for SAP BW Query elements
  • B . To loadInfoObject attribute with Enhanced Master Data Update
  • C . To generate multiple similar DataStore objects (advanced)
  • D . To define settings for Data Tiering Optimization (DTO)

Reveal Solution Hide Solution

Correct Answer: D
Question #9

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 . Open ODS View
  • B . BW Query
  • C . InfoObject Characteristic
  • D . DataSource

Reveal Solution Hide Solution

Correct Answer: B,C
Question #10

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

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

Reveal Solution Hide Solution

Correct Answer: A

Question #11

You use a customer master data table as a left table and a transactional sales data table as a right table within a graphical SAP HANA Calculation View.

You want to focus in your report on transactional data showing both: customers with sales volume and without.

Which join type should be used?

  • A . Full Outer Join
  • B . Referential Join
  • C . Left Outer Join
  • D . Right Outer Join

Reveal Solution Hide Solution

Correct Answer: C
Question #12

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

Reveal Solution Hide Solution

Correct Answer: A,C
Exit mobile version