Online Access Free C-HANADEV-18 Practice Test

To which SAP HANA authorization entities can you grant a role? There are 2 correct answers to this question.

• A.Privilege
• B.User
• C.Role
• D.Object

You want to exclusively use declarative logic in an SQL Script procedure. Which of the following operators can you use? There are 2 correct answers to this question.

• A.COMM IT statement
• B.IF condition
• C.MAP_REDUCE function
• D.TABLE variable

After reviewing the SQL Analyzer results, which of the following would you consider for optimizing the performance? There are 2 correct answers to this question.

• A.Use CE functions.
• B.Change the data model.
• C.Re-prioritize with Workload Management.
• D.Modify SQL hints.

Which of the following joins can be defined only with multi-column join in calculation views? Please choose the correct answer.

• A.Text join
• B.Multi join
• C.Temporal join
• D.Dynamic join

You create a simple data model to store user information. The model contains two tables: one for the user information, and the other for user address details.
The user can only have one address. You also need a view to show the complete information of the user including the address.
Which actions do you perform if you use CDS artifacts only? Please choose the correct answer.

• A.Create two entities for the user and address.
  Create an association in the user entity to the address entity.
  Define a User Details view using select on the address entity and using the association to read the user information.
• B.Define a User Details view using select on the user entity and using the association to read the address information.
  Create two entities for the user and address.
  Extend the user entity with address columns.
• C.Create a view named User Details using select on the user entity.
  x-s Create two entities for the user and address.
  Create a User Details calculation view and join the user and address information.
• D.Create two entities for the user and address.
  Create an association in the user entity to the address entity.