Free SAP C_HANAIMP_17 Exam Braindumps (page: 3)

You import a project that includes an SAP HANA database(HDB) module to your workspace. You need to create a calculation view that uses data from one table located in an external schema. Which of the following items must you build?

Note: There are 2 correct answers to this question.

  1. Synonym
  2. .hdinamespacefile
  3. Authorization
  4. Project

Answer(s): A,C



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

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

Answer(s): A,C



You deleted the design-time file of a calculation view in your HDB module.

Which of the following is the optimal way to ensure that the corresponding runtime object is also removed from the database?

  1. Delete the folder that contained the deleted design-time file.
  2. Build the folder that contained the deleted design-time file.
  3. Build the project that contained the deleted design-time file.
  4. Run a DELETE statement in an SQL console connected to the HDI container.

Answer(s): B,C



You created a table using the SQL conSQLe inside the HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it. What do you observe in the SAP HANA database container?

  1. The build is successful, and you get the expected data.
  2. The build fails, and the table is dropped.
  3. The build fails but the table is not dropped.
  4. The build is successful, but the data preview is empty.

Answer(s): D



Viewing page 3 of 21
Viewing questions 9 - 12 out of 151 questions



Post your Comments and Discuss SAP C_HANAIMP_17 exam prep with other Community members:

C_HANAIMP_17 Exam Discussions & Posts