C_BW4HANA_20 Online Practice Questions and Answers

Which objects of an SAP HANA calculation view of DIMENSION data category can you re-use if you define an SAP calculation view of CUBE data category with star join? Note: There are 2 correct answers to this question.

A. Aggregation method

B. Hierarchy assignment

C. Attribute assignment

D. Measure assignment

Which tables belong to the hierarchy for characteristic OCOUNTRY? Note: There are 3 correct answers to this question.

A. /BIC/QCOUNTRY

B. D/BIC/KCOUNTRY

C. /BIC/ICOUNTRY

D. /BIC/PCOUNTRY

E. D/BIC/HCOUNTRY

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

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

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

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

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

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.

Which objects can be affected by the key date in a BW query? Note: There are 2 correct answers to this question.

A. Hierarchies

B. Attributes

C. Text variables

D. Key figures

You identified a variable that is based on time characteristic OCALMONTH and returns the current quarter. Which offset do you need to retrieve the corresponding quarter of the previous year?

A. -12

B. -4

C. -1

D. -3