To upload data from flat files, SAP HANA offers several features. What are these important features? There are 2 correct answers to this question

• A.The supported file types for upload are: .cssv, .xlls, and .xlsxxx
• B.The new table always has a 2:2 mapping between the file and table columns
• C.When loading new data in the table, it gets appended to the existing data
• D.The application suggests the column name and data type for the new tables, and it is possible to edit them

Comment: *

Name: *

Email: *

Verification: *

Which of the following is latest release of SAP HANA?

• A.SAP HANA 1.6 SP03
• B.SAP HANA 1.0 SP06
• C.SAP HANA 1.0
• D.SAP HANA 2.0 SPS 04

Comment: *

Name: *

Email: *

Verification: *

In a Graphical calculation view you want to implement a union between two result sets that differ only in the fact that one of the two has one additional field named ADDRESS. How can you achieve this in a union node? There are 2 correct answers to this question.

• A.Create an input parameter for the ADDRESS field
• B.Exclude the ADDRESS field from the union
• C.Create a restricted column for the ADDRESS field
• D.Map the ADDRESS field to a constant value

Comment: *

Name: *

Email: *

Verification: *

What are the Perspectives and Views of SAP HANA Studio? There are 2 correct answers to this question.

• A.System Properties
• B.Open system properties
• C.Administration console
• D.Development properties

Comment: *

Name: *

Email: *

Verification: *

You define a core data services (CDS) View. For which of the following expressions and built in functions must you provide alias?
There are 3 correct answers to this question.

• A.Nested CASE expression
• B.Currency Conversion
• C.CASTE Expression
• D.Unit conversion
• E.CASE expression

Comment: *

Name: *

Email: *

Verification: *