Online Access Free C-HANAIMP-11 Exam Questions

Which of the following are required elements when you create any type of hierarchy in SAP HANA?

• A.A data foundation
• B.An analytic view
• C.An attribute view
• D.A child node

When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services? (Choose two)

• A.Data filtering
• B.Real-time replication
• C.Data transformations
• D.Upload data via the SAP HANA studio

Which of the following selection types are available when creating a variable in an analytic view? (Choose three)

• A.Column
• B.Direct
• C.Interval
• D.Single value
• E.Range

Which of the following are restrictions of the SAP HANA flat file upload?

• A.A table must have the same column order as the flat file when you append data.
• B.The upload prevents data type changes when appending data.
• C.The upload does not allow to change the column names of new tables.
• D.A new table must have a 1:1 mapping between the flat file columns and the table columns.

You have two analytic views. One contains actual data and the other one contains plan data. You want to combine the two result sets and keep actual and plan data on separate records. In the SAP HANA studio, which of the following can you use to achieve this?

• A.UNION in a calculation view
• B.JOIN in an analytic view
• C.JOIN in a calculation view
• D.PROJECTION in a calculation view