SAP C_BW4HANA_20 Online Practice Questions and Exam Preparation

SAP C_BW4HANA_20 Online Questions & Answers

• Question 71:

  Which condition must you ensure if you want to replicate data based on a view with SAP Landscape Transformation Replication Server?

  A. View-based data result sets must be kept persistent first until data replication can take place.
  B. An SAP HANA source system must be defined to consume the view.
  C. Each table of the view requires a defined trigger to enable data replication.
  D. One table as part of the view has to be defined as primary table and is used to trigger data replication.
  B. An SAP HANA source system must be defined to consume the view.

• Question 72:

  What can you do when you use process chains? Note: There are 2 correct answers to this question.

  A. Trigger delta merge.
  B. Activate requests in DataStore objects (advanced).
  C. Generate transformations.
  D. Activate data transfer processes (DTPs).
  A. Trigger delta merge.
  B. Activate requests in DataStore objects (advanced).

• Question 73:

  You want to validate your SAP HANA data model. What must you ensure to use the data preview functionality?

  A. The _SYS_BIC user is created in the system and the runtime information is written to_SYS STATISTICS.
  B. You are connected as SYSTEM user and all object privileges are assigned to this SYSTEM user.
  C. The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.
  D. Your content package is assigned with sufficient repository privileges to the SYS REPO user.
  C. The _SYS_REPO user must have sufficient object privileges assigned to your desired schema.

• Question 74:

  Your customer is using a pure SAP HANA native data warehouse approach. Which tools should the customer install? Note: There are 2 correct answers to this question.

  A. SAP solutions for enterprise information management
  B. BW Modeling Tools
  C. SAP Information Steward
  D. Process Chain Monitoring app
  B. BW Modeling Tools
  D. Process Chain Monitoring app

• Question 75:

  Which SAP Landscape Transformation Replication Server cockpit operation removes all data from the trigger table?

  A. Suspend Replication and Resume Replication
  B. Stop Replication and Resume Replication
  C. Suspend Replication and Start Replication
  D. Stop Replication and Start Replication
  D. Stop Replication and Start Replication

• Question 76:

  When can you NOT use a characteristic with the High Cardinality property? Note: There are 3 correct answers to this question.

  A. When it will be a navigation attribute
  B. When it will be a time-dependent attribute
  C. When it will be part of a report-to-report interface
  D. When it will be part of a hierarchy
  E. When it will be a compound characteristic
  A. When it will be a navigation attribute
  D. When it will be part of a hierarchy
  E. When it will be a compound characteristic

• Question 77:

  You create a transformation from a DataSource to a DataStore object (advanced). The DataSource provides an after-image delt

  A. Which key figure aggregation type do you select?
  B. Summation
  C. Minimum
  D. Maximum
  E. Overwrite
  D. Maximum

• Question 78:

  Which of the following use cases is classified as operational reporting?

  A. Year-to-date comparison reports containing prior and actual year numbers
  B. Evaluation of trends over several years
  C. Reporting requirements with monthly data refreshes
  D. Near-real-time access to original transactional values
  D. Near-real-time access to original transactional values

• Question 79:

  You need to use an SAP ERP standard DataSource to load data into SAP BW/4HANA.

  Which prerequisite must be fulfilled to use the DataSource in the Operational Data Provisioning context?

  A. lt must exist in table ROOSATTR.
  B. It must be delta-enabled.
  C. It must be in-memory-optimized.
  D. It must have a queue entry in transaction ODQMON.
  A. lt must exist in table ROOSATTR.

• Question 80:

  You need to consume remote HADOOP data in your SAP HANA Native App. Which components can you use? Note: There are 3 correct answers to this question.

  A. SAP HANA smart data access
  B. SAP HANA smart data integration
  C. SAP HANA SQL Controller
  D. Spark SQL adapter
  E. SAP Vora ODBC adapter
  A. SAP HANA smart data access
  D. Spark SQL adapter
  E. SAP Vora ODBC adapter