SAP HANA CERTIFICATION

If you need to define help cel s for formulas In the cell editor,what must you do first?

• Define two structures in a query

• Define two selections In a s1ructure

• Reuse a structure in a second query

• Define two formulasIn a structure

For which of the following revenue reporting requirements do you create restricted key figures?

• Compare this year's planned revenue withlast year's actual revenue

• Convert revenue Into a number without currency

• Identify the top five countries by revenue for each month

• Determine the a\,!erage revenue per customer

Which advantages can you leverage while importing data into a new SAP HANA table using a Rat file? Note· There are 2 correct answers to this question.

• Availabilty of deltalogic

• Easiness ofloading

• Adjustment for column type.length.and name is possible

• Transformation cap-abilities

Which objects can be affected by the key dale in a BW query?

Note: There are 2 correct answers to this question.

• Conditions

• Key figures

• Attributes

• Hierarchies

You need 10 restrict a sales repon to the products that make up 50% of the totalrevenue.

Which BW query feature do you use?

• Restricted key figure

• Exception

• Condition

• Calculated key figure

Whichlayers are part of 1'1elayered scalab e archecture for SAP BW/4HANA (LSA++)?

Note: There are 2 correct answers to this question.

• Data acquisition layer

• Open Hub layer

• BW Workspace layer

• Open Operational Data Store layer

You needto enable real time streaming using SAP HANA smart data integration (SOI)to load data into a OataStore object (advanced) What ace prerequisites f0t th s cequirement?

Note There are 2 correct answers to the question

• The data target is a partitiontd DataStort object (advanced )

• The adapter is real-time enabled

• The pcocess chain ts running in streaming mode

• The source system is pushing data into SAP BW/4HANA

Which SAP HANA objects are generated when you Switch on the "'Extemat SAP HANA View" property for dataStore objects (advanced)?

Note There are 2 conecl ani'hif'i to thi5 question

• SAP HANA HDI containers

• SAP HANA privilege

• SAP HANA CDS View

• SAP HANA calculation views

Which property settings can you assign for a characteristic?

Note· There are 3 correct answers to this question.

• High Precision

• Enhanced Master Data Update

• Useable as lnfoProvider

• Stock Coverage

• Attribute Only

What is the effect of using the RODPS_REPL_ TEST program to test SAP ERP operational Data Provisioning (ODP) Data Sources?

Note There are 2 conect answers to this question

• The program behaves like the RSA3 extractor checker

• The apprication data is physically written to the queue.

• The Reset Della function affects all ODP delta queues

• The program behaves at an additional subscriber