SAP C_BW4HANA_20 Online Practice Questions and Exam Preparation

SAP C_BW4HANA_20 Online Questions & Answers

• Question 1:

  You need to view the SAP HANA calculation views, SAP BW DataSources, and InfoAreas in the same SAP HANA studio perspective. What should you do?

  A. Attach an SAP BW project to an SAP HANA system.
  B. Attach an SAP HANA system to an SAP BW project.
  C. Attach an ABAP project to an SAP BW project.
  D. Attach an SAP BW project to an ABAP project.
  B. Attach an SAP HANA system to an SAP BW project.

• Question 2:

  What are key capabilities of SAP Agile Data Preparation Note: There are 3 correct answers to this question.

  A. Data retention
  B. Data exporting
  C. Data cleansing
  D. Data compliance
  E. Data acquisition
  B. Data exporting
  C. Data cleansing
  E. Data acquisition

• Question 3:

  For which InfoProvider types can you select navigation attributes? Note: There are 2 correct answers to this question.

  A. CompositeProvider
  B. Open ODS views
  C. DataStore object (advanced) of type standard DataStore object
  D. DataStore object (advanced) of type InfoCube
  A. CompositeProvider
  B. Open ODS views

• Question 4:

  Why do you define a custom table as a row store table? Note: There are 2 correct answers to this question.

  A. The table will be integrated into a native SAP HANA calculation view.
  B. Aggregation and fast search is required for query execution.
  C. When the table is accessed, all columns of a single record are processed.
  D. The values in the columns are different. Therefore, data compression would NOT have much effect.
  C. When the table is accessed, all columns of a single record are processed.
  D. The values in the columns are different. Therefore, data compression would NOT have much effect.

• Question 5:

  You plan to regularly transfer changes from an SAP ERP custom table to SAP BW/4HAN

  A. An additional custom development may NOT be implemented in the source system. Which Operational Data Provisioning (ODP) source system type do you recommend?
  B. ODP-SLT
  C. ODP-SAP
  D. ODP-BW
  E. ODP-CDS
  A. An additional custom development may NOT be implemented in the source system. Which Operational Data Provisioning (ODP) source system type do you recommend?

• Question 6:

  Which layers are part of the layered scalable architecture for SAP BW/4HANA (LSA++)? Note: There are 2 correct answers to this question.

  A. Open Operational Data Store
  B. Native SAP HANA data mart
  C. Virtual data mart
  D. Source system
  A. Open Operational Data Store
  C. Virtual data mart

• Question 7:

  Which settings can you define in a data transfer process (DTP) if you load data into a DataStore object (advanced)? Note: There are 3 correct answers to this question.

  A. Extraction mode
  B. Error handling
  C. Activation handling
  D. Data tiering
  E. Semantic groups
  A. Extraction mode
  B. Error handling
  E. Semantic groups

• Question 8:

  You want to model an SAP HANA calculation view by combining the sales orders with the corresponding customer status, which was assigned to the customer when the order was issued. Which join properties do you assign to the required join type?

  A. Inner join with Dynamic Join properties
  B. Referential join with Temporal Join properties
  C. Inner join with Temporal Join properties
  D. Referential join with Dynamic Join properties
  B. Referential join with Temporal Join properties

• Question 9:

  You model a second SAP BW/4HANA CompositeProvider to integrate tables from an SAP HANA database schema with an existing SAP BW/4HANA CompositeProvider. What must you do first?

  A. Set The CompositeProvider Can Be Added to Another CompositeProvider flag.
  B. Assign consumption properties to the new SAP HANA calculation view.
  C. Connect an export DataSource from the exisiting CompositeProvider to the new CompositeProvider.
  D. Create an Open ODS view with consumption properties to consume the data in the SAP BW/4HANA schema.
  A. Set The CompositeProvider Can Be Added to Another CompositeProvider flag.

• Question 10:

  You need to restrict a sales report to the products that make up 50% of the total revenue. Which BW query feature do you use?

  A. Condition
  B. Calculated key figure
  C. Restricted key figure
  D. Exception
  A. Condition