How does SQL Script extend SQL?
There are 3 correct answers to this question.
Response:

• A.It adds imperative expressions to control data flow.
• B.It enables usage of variables to break up complex code.
• C.It provides the data definition language (DDL) to create column tables.
• D.It improves push-down opportunities.
• E.It allows an alternative syntax to simplify expressions.

Comment: *

Name: *

Email: *

Verification: *

Identify the join that checks the From and To column on the left table.
Please choose the correct answer.
Response:

• A.Full Outer Join
• B.Temporal Join
• C.Right Outer Join
• D.Left Outer Join
• E.Text Join

Comment: *

Name: *

Email: *

Verification: *

When you create a full text index, why do you specify FAST_PREPROCESS OFF?
Please choose the correct answer.
Response:

• A.To avoid the generation of the term document matrix
• B.To enable a full linguistic search
• C.To generate text analysis results in multiple languages
• D.To prevent the creation of a fuzzy search index

Comment: *

Name: *

Email: *

Verification: *

Which technologies does SAP HANA use to load more data into memory?
There are 3 correct answers to this question.
Response:

• A.Store data in column tables
• B.Use ZIP compression
• C.Eliminate indices
• D.Use multicore CPU parallelism
• E.Use dictionary compression

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

Comment: *

Name: *

Email: *

Verification: *