In SAP HANA Studio, what would you find in a Package?
There are 3 correct answers to this question.
Response:

• A.Procedures
• B.Calculation Views
• C.Tables
• D.Analytic Privileges

Comment: *

Name: *

Email: *

Verification: *

Which of the following are correct statements relating to the flat file import function of SAP HANA Studio?
There are 3 correct answers to this question.
Response:

• A.The new table always has a 1:1 mapping between the file and table columns
• B.Renaming of columns and changing data types is allowedwhen loading data to new HANA tables
• C.The supported file types for upload are .csv, and .txt
• D.When loading new data in a table that already contains data, the new data is appended to the existing data

Comment: *

Name: *

Email: *

Verification: *

A column table definition includes a spatial column that has the VALIDATION FULL property. You execute an SQL statement to insert a geometry into this column. The statement fails.
Which of the following are possible reasons for the failure?
There are 2 correct answers to this question.
Response:

• A.The geometry is an ST_MULTIPOLYGON that specifies only one polygon.
• B.The geometry is an ST_MULTIPOLYGON where the second polygon is completely contained in the first one.
• C.The geometry is an ST_POLYGON where the last defined point is not the same as the first one.
• D.The geometry is an ST_POLYGON that has an inner ring that is completely inside the outer ring.

Comment: *

Name: *

Email: *

Verification: *

A column in your table will be used for text search. Why do you define the column as a text type instead of a string type?
Please choose the correct answer.
Response:

• A.To enable a linguistic analysis
• B.To enable the full set of SQL operations
• C.To enable lower memory consumption
• D.To allow processing of multiple languages

Comment: *

Name: *

Email: *

Verification: *

What is the preferred way to create a procedure?
Please choose the correct answer.
Response:

• A.Use the Import menu in the SAP Web IDE for SAP HANA.
• B.Use the CREATE PROCEDURE statement in the SQL console.
• C.Create a .hdbprocedure file.
• D.Create a .procedure file.

Comment: *

Name: *

Email: *

Verification: *