← Back to exam page

Free C_HANAIMP_17 – SAP Certified Application Associate - SAP HANA 2.0 (SPS05) Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question.

Select all that apply, then click Submit answer.

  • ○

    You want to create a dynamic analytic privilege.
  • ○

    A temporary table must be created within the code.
  • ○

    Optimal performance is a priority.
  • ○

    The code should modify data in a table.
  • ○

    You need to use conditional logic.

Question 2

Why would you partition a table in an SAP HANA Cloud database?Note: There are 2 correct answers to this question.

Select all that apply, then click Submit answer.

  • ○

    To improve response time when multiple users access the same table
  • ○

    To overcome the 2 billion record limit
  • ○

    To improve data replication performance on large row tables
  • ○

    To improve query performance when accessing large column tables

Question 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 a table located in an external schema within the same local database.Which of the following items do you need?Note: There are 2 correct answers to this question.

Select all that apply, then click Submit answer.

  • ○

    Authorization
  • ○

    Synonym
  • ○

    SQL view
  • ○

    Remote source