SAP E_BW4HANA207 Online Practice Questions and Exam Preparation

SAP E_BW4HANA207 Online Questions & Answers

• Question 1:

  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
  C. The combination of the generated analytic privileges in SAP HANA and the analysis authorizations in SAP BW/4HANA

• Question 2:

  What is a valid data target in an SAPMHANA Analysis Process without using a Data Trasfer Process?

  A. DataStore object (advanced)
  B. InfoObject with Attributes
  C. SAP HANA Database Table
  D. CompositeProvider
  C. SAP HANA Database Table

• Question 3:

  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.
  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.
  D. SAP BW/4HANA Open ODS View can be modelled on SDI sources, but NOT on SDA sources.

• Question 4:

  A customer wants to know the difference between LSA and LSA+ + to define a layered scalable architecture.

  Which layers are only presented in LSA+ + ?

  Note: There are 2 correct answers to this question.

  A. Open Operational Data Store Layer
  B. EDW Propagation Layer
  C. Corporate Memory
  D. BW Workspace Layer
  A. Open Operational Data Store Layer
  B. EDW Propagation Layer

• Question 5:

  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
  A. To move a large amount of historical data needs to be read occasionally in SAP BW Queries

• Question 6:

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

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

• Question 7:

  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.

  Youwant 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
  C. Left Outer Join

• Question 8:

  You model an Open ODS View on an SAP HANA table. You would like to persist the datain an SAP BW/4HANA object based on the 'Generate Dataflow...' function.

  Which objects are created automatically?

  Note: there are 3 correct answers to thi s question.

  A. DataStore object (advanced)
  B. DataSource
  C. InfoPackage
  D. InfoSource
  E. Transformation
  A. DataStore object (advanced)
  B. DataSource
  E. Transformation

• Question 9:

  You are running SAP S/4HANA On-Premise.

  You would like to extract data to SAP BW/4HANA.

  Which tool does SAP recommend to evaluate the metadata of CDS-based extractors?

  A. SAP S/4HANA Query Browser
  B. SAP BW/4HANA Cockpit
  C. SAP BW/4HANA Modeling Tools
  D. SAP S/4HANA View Browser
  C. SAP BW/4HANA Modeling Tools

• Question 10:

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

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

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