What does SQL script provide to extend standard SQL?
There are 2 correct answers to this question.
Response:

• A.Feature to encourage processing in the database
• B.Integrated source code version management
• C.Additional data types for the definition of text and spatial data
• D.Support for ABAP Syntax

Comment: *

Name: *

Email: *

Verification: *

Why do you use the query debug mode in a calculation view?
Please choose the correct answer.
Response:

• A.To observe the generated SQL for each node
• B.To check if SAP HANA can paralyze the entire query
• C.To measure the overall run-time of the query
• D.To check which database engines will be invoked by each node?

Comment: *

Name: *

Email: *

Verification: *

Your calculation view includes the following SALES_ORDER_ID and ITEM as attributes, and QUANTITY and PRICE as measures. You create a calculated column, ITEM_TOTAL, with the formula QUANTITY*PRICE.
In which node do you define the calculation to display the correct aggregated result?
Please choose the correct answer.
Response:

• A.Join
• B.Projection
• C.Union
• D.Aggregation

Comment: *

Name: *

Email: *

Verification: *

What are the advantages of columnar storage?
There are 2 correct answers to this question.
Response:

• A.Improved compression
• B.Improved data reading performance
• C.Improved data writing performance
• D.Improved performance when all fields are selected

Comment: *

Name: *

Email: *

Verification: *

What is a multistore table?
Please choose the correct answer.
Response:

• A.A table that can hold data in row and column orientation
• B.A table that can distribute its partitions across memory and extended storage tiers
• C.A table that can be shared across multiple instances of SAP HANA Cockpit
• D.A table that can be shared across multiple instances of HANA

Comment: *

Name: *

Email: *

Verification: *