SAP SAP Certified Application Specialist E_BW4HANA207 Questions & Answers

• Question 1:

  For which SAP Cloud system does SAP recommend using the SAP HANA SDI and its Odata adapter to load data into SAP BW/4HANA?

  A. SAP C/4HANA

  B. SAP SuccessFactors

  C. SAP S/4HANA Cloud

  D. SAP Ariba

  Correct Answer: D

• Question 2:

  You would like to implement a virtual scenario in yur SAP BW/4HANA system. Which approach does SAP recommend for this kind of scenario?

  Note: There are 3 correct answer to this question.

  A. Integrate external data into SAP BW/4HANA based on the Write Interface-ebabledDataStore object.

  B. Model a CompositeProvider which combines data from multiple SAP BW/4HANA InfoProviders and SAP HANA Views.

  C. Generate external SAP HANA view of SAP BW/4HANA InfoProviders to consume SAP BW/4HANA data in SAP HANA.

  D. Define an Open ODS View which integrates an SAP HANA table into SAP BW/4HANA.

  E. Load SAP HANA dat into SAP BW/4HANA InfoProviders based on the Operational Data Provisioning (ODP) framework.

  Correct Answer: BCD

• Question 3:

  You want to load datafrom SAP Ariba to SAP BW/4HANA. Which object in SAP BW/4HANA does SAP recommend to use for this scenario?

  A. DataStore of type ODP_CDS

  B. Write Interface-Enabled DataStore Object

  C. Direct Update DataStore Object

  D. DataStore of type ODP_HANA

  Correct Answer: A

• Question 4:

  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 an SAP IQ database

  B. In SAP HANA on an extension node

  C. In SAP HANA Native Storage Extension

  D. In the file system of a Hadoop cluster

  Correct Answer: AD

• Question 5:

  What are valid reason to generate external SAP HANA View for SAP BW/4HANA objects? Note: there are 2 correct answers to this question.

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

  B. To apply SAP HANA transformational logic instead of SAO ABAP logic

  C. To leverage the SAP HANA-optimezed Analytic Manager to process BWQuery

  D. To create an additional persistent layer of data in SAP HANA

  Correct Answer: AC

• Question 6:

  You want tocreate an SAP BW Query showing data loading statistics provided by the SAP BW/4HANA statisical analysis.

  Which object does SAP deliver to provide data for your SAP BW Query?

  A. Open ODS View

  B. ABAP CDS View

  C. Badl Provider

  D. DataStore object (advanced)

  Correct Answer: B

• Question 7:

  You want to load data from an SAP BW/4HANA system into another SAP BW/4HANA system using

  Operational Data Provisioning (ODP) of type ODP_BW.

  Which objects can be used as a source?

  Note: There are 3 correct answers to this question.

  A. DataStore object (advanced)

  B. ABAP CDS View

  C. InfoObject Characteristic

  D. CompositeProvider

  E. Open ODS View

  Correct Answer: ACD

• Question 8:

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

  A. Individual columns contain all of the information for ine record

  B. Individual columns are read-optimized by writing into a main store and a delta store

  C. Individual columns can be transferred to an SAP HANA optimized row-based format for faster access

  D. Individual columns can be processed at the same time by different CPU cores

  Correct Answer: B

• Question 9:

  You enable a DataStore object(advanced) for reporting by switching on the ""External SAP HANA view"" flag in the settings.

  Which authorizations are used when you consume the generated SAP HANA view directly?

  A. The generated analytic privileges in SAP HANA

  B. The authorizations forthe HDI container access in SAP HANA

  C. The combination of the generated analytic privileges in SAP HANA and the analysis authorizations in SAP BW/4HANA

  D. The analysis authorizations in SAP BW/4HANA

  Correct Answer: C

• Question 10:

  What is a valid scenario using the External Tier (COLD Store) in the SAP BW/4HANA Data Tiering Optimization (DTO) concept?

  A. To move a large amount of historical data needs to be read occasionally in SAP BW Queries

  B. To improve the qery performance of an SAPBW Query for aggregated year-to-date values

  C. To reduce the TCO bases on the implementation of the Active/ Non-Active Data Concept

  D. To create an offline archive for transactional data to ensure legal requirements are fulfilled

  Correct Answer: A