SAP C_BW4HANA_20 Online Practice Questions and Exam Preparation

SAP C_BW4HANA_20 Online Questions & Answers

• Question 21:

  You define a temporal condition for a temporal join in a calculation view. Which column data types are supported? Note: There are 3 correct answers to this question.

  A. Integer
  B. Date
  C. Decimal
  D. Boolean
  E. Timestamp
  A. Integer
  C. Decimal
  E. Timestamp

• Question 22:

  You need to combine master data (right table) and transactional data (left table) using a referential join. How will this referential join behave?

  A. It is executed as an inner join when NO fields from the right table are requested.
  B. It always returns all fields from the right table as a result data set.
  C. It is executed as an inner join when a description mapping is defined between the left table and the u right table.
  D. It returns a result data set if the left table has a corresponding entry on the right table.
  D. It returns a result data set if the left table has a corresponding entry on the right table.

• Question 23:

  Which of the following methods supports the SAP HANA data virtualization approach with OBDC technology?

  A. SAP HANA smart data access
  B. SAP HANA smart data integration
  C. SAP Landscape Transformation Replication Server
  D. SAP Data Services
  A. SAP HANA smart data access

• Question 24:

  Which variables types allow filter values to be determined based on the user's authorizations? Note: There are 2 correct answers to this question.

  A. Characteristic value variable
  B. Formula variable
  C. Hierarchy node variable
  D. Hierarchy variable
  A. Characteristic value variable
  C. Hierarchy node variable

• Question 25:

  How do you model plant-specific attributes for the characteristic material?

  A. Compound the material and the plant.
  B. Define navigation attributes for the characteristic material.
  C. Define time-dependent attributes for the characteristic material.
  D. Join the material and the plant.
  A. Compound the material and the plant.

• Question 26:

  Which property settings can you assign for a characteristic? Note: There are 3 correct answers to this question.

  A. Useable as InfoProvider
  B. Authorization-Relevant
  C. High Precision
  D. Stock Coverage
  E. Attribute Only
  A. Useable as InfoProvider
  B. Authorization-Relevant
  E. Attribute Only

• Question 27:

  Which SAP tool do you suggest to create a pixel-precise formatted report?

  A. SAP Lumira, discovery edition
  B. SAP Analysis for OLAP
  C. SAP Crystal Reports for Enterprise
  D. SAP Analytics Cloud
  C. SAP Crystal Reports for Enterprise

• Question 28:

  For which activity do you use the key figure matrix?

  A. Structure the information from the requirement analysis.
  B. Provide information on the relations between characteristics.
  C. List properties of the data sources.
  D. Allocate project resources.
  A. Structure the information from the requirement analysis.

• Question 29:

  You loaded a 5 MB table from a source system to SAP BW/4HAN

  A. How do you explain that the size of the table is reduced to 1 MB?
  B. The target is defined as column store and a delta merge job was executed.
  C. The target is defined as row store and a delta merge job was executed.
  D. The target is defined as row store without delta merge execution.
  E. The target is defined as coiumn store without delta merge execution.
  A. How do you explain that the size of the table is reduced to 1 MB?

• Question 30:

  You create a DataStore object (advanced) using model template Standard DataStore Object. Which flags are set? Note: There are 2 correct answers to this question.

  A. Activate Data
  B. Write Change Log
  C. All Characteristics are Key
  D. Unique Data Records
  A. Activate Data
  B. Write Change Log