Online Access Free C_HANAIMP_12 Practice Test

What API would you use in SAP HANA SPS 11/12 to display search results in an ABAP system?
Please choose the correct answer.
Response:

• A.The esh_search procedure
• B.SAP HANA Text Analysis XS JavaScript API
• C.SAP HANA Simple Info Access API (SINA)
• D.SAP HANA Text Mining XS JavaScript API

What statement is allowed in a user-defined function?
There are 2 correct answers to this question.
Response:

• A.EXEC
• B.INSERT
• C.COMMIT
• D.JOIN

A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes.
How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.
Response:

• A.Use a right outer join. Filter to show only the NULL values on the right table.
• B.Use a left outer join. Filter to show only the NULL values on the right table.
• C.Use a right outer join. Filter to show only customers on the left table.
• D.Use a left outer join. Filter to show only customers on the right table.

Which of the following are examples for validation rules?
There are 2 correct answers to this question.
Response:

• A.Check formulas in calculated columns
• B.Check that graphical calculation views have no orphan nodes
• C.Check that attribute views have a key attribute specified
• D.Check that tables contain data

You want to use a table to store results for each session but do not want to recreate the table for every session. What type of table should you create?
Please choose the correct answer.
Response:

• A.Virtual table
• B.Global temporary table
• C.Local temporary table
• D.History column table