SAP C_HANAIMP_17 Exam Questions
SAP Certified Application Associate - SAP HANA 2.0 (SPS05) (Page 3 )

Updated On: 15-Feb-2026

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



What restrictions apply to a Graph node that you include in a calculation view?

  1. It must be the first node in the dataflow.
  2. It must be the final node in the dataflow.
  3. Its data source must be provided by a projection node.
  4. It cannot be included in a calculation view of type dimension.

Answer(s): A



Your Web IDE for SAP HANA was updated to a new version. You want to implement the new features of calculation view modeling in your existing calculation views. You open a graphical calculation view but the new

features are not displayed.

What could be the reason for this?

  1. You need to update the project settings to reference the new revision.
  2. Your calculation views have not been built in the new version of the Web IDE.
  3. The calculation views have not been migrated to the new revision.
  4. The .hdiconfig file has not been updated to the latest calculation view build plug-in.

Answer(s): A






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

Join the C_HANAIMP_17 Discussion