What enables the delta buffer technique to speed up both reads and inserts in SAP HANA?
Please choose the correct answer.
Response:

• A.Using both row-based and column-based tables
• B.Using column-based tables only
• C.Using row-based tables only
• D.Using only the insert-only technique

Comment: *

Name: *

Email: *

Verification: *

What are the features of a parent-child hierarchy?
There are 3 correct answers to this question.
Response:

• A.A single dedicated column is used to store the parent of each record of the table.
• B.Heterogeneous fields are combined in a hierarchy.
• C.Recursive data structure defines the hierarchy.
• D.Parent and child field have the same data type.

Comment: *

Name: *

Email: *

Verification: *

Your newly created analytic privilege does NOT want to build. What must you do?
Please choose the correct answer.
Response:

• A.Assign the ::access role to the HDI container user.
• B.Change the analytic privilege to use an SQL Expression.
• C.Grant rights to the _SYS_REPO user.
• D.Change the Apply Privileges property of the view.

Comment: *

Name: *

Email: *

Verification: *

You want to use a field in a formula but don't want to expose the values of the original field to the end users. What do you do?
Please choose the correct answer.
Response:

• A.Mark the field as hidden.
• B.Make the field a key column.
• C.Rename the field.
• D.Change the data type of the field.

Comment: *

Name: *

Email: *

Verification: *

What information can you find in Performance Analysis Mode when you view the analysis for a Join node?
There are 2 correct answers to this question.
Response:

• A.Time taken by the join
• B.Suggested filter for the tables in the Join node
• C.Total number of records returned by the node
• D.Tables used by the join in the node

Comment: *

Name: *

Email: *

Verification: *