← Back to exam page

Free C_HANAIMP_18 – SAP Certified Application Associate - SAP HANA 2.0 SPS06 Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–3 of 10 questions

Question 1

Which of the following are capabilities of SAP HANA smart data access?Note: There are 2 correct answers to this question.

Select all that apply, then click Submit answer.

  • ○

    Replication of remote data
  • ○

    Push-down of queries to remote data sources
  • ○

    Exposure of real-time data from remote tables
  • ○

    Cleansing and harmonization of data from disparate sources

Question 2

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

Select all that apply, then click Submit answer.

  • ○

    Count-distinct results are incorrect
  • ○

    Results are read from static cache
  • ○

    Query processing time improves
  • ○

    SQL compilation time increases

Question 3

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