In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

• A.Your stacked model consists of multiple calculation views.
• B.You have a dedicated table lo generate the lists of help values for an input parameter.
• C.You have a large row store table that is consumed in a view with a variable on COUNTRY column.
• D.You have a large column store table that is consumed in a view with a variable on COUNTRY column.

Comment: *

Name: *

Email: *

Verification: *

What is scale-out?
There are 2 correct answers to this question.
Response:

• A.Use of remote servers to store archived data that is rarely used.
• B.Use of commodity servers that are used in high volume steaming applications.
• C.Use of multiple servers to spread processing and improve performance.
• D.Use of standby servers in the event of hardware failure.

Comment: *

Name: *

Email: *

Verification: *

What should you keep in mind when using dynamic SQL?
There are 2 correct answers to this question.
Response:

• A.It delivers the best possible performance.
• B.It could be used for SQL injection.
• C.You can dynamically change your data sources.
• D.It's always bad for security.

Comment: *

Name: *

Email: *

Verification: *

When using the CONTAINS predicate, what are the restrictions you must you keep in mind?
There are 2 correct answers to this question.
Response:

• A.The NOT (-) operator can only be specified directly after the OR operator
• B.Non-physical columns, such as calculated columns, are not search-relevant
• C.If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.
• D.Wild cards* and? Are supported for text columns but not string columns

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: *