SAP C_HANAIMP151 - SAP Certified Application Associate - SAP HANA (Edition 2015) Exam

Page:    1 / 45   
Total 221 questions

In an aggregation node of a calculation view, which is the default aggregation type for an aggregated measure?

  • A. COUNT
  • B. MAX
  • C. SUM
  • D. MIN


Answer : C

What is the lowest level of granularity you can use in an analytic privilege?

  • A. An attribute
  • B. A view
  • C. An attribute value
  • D. A column


Answer : C

How can you improve the performance of a scripted calculation view?

  • A. Read data from column tables using nested SELECT statements
  • B. Convert SQL code to equivalent CE functions
  • C. Combine analytic views using a CE_JOIN function
  • D. Combine data from the row store and column store


Answer : B

You need to create an SAP HANA data model based on a star schema.
Which SAP HANA engine is recommended for analytical purposes?

  • A. Calculation engine
  • B. OLAP engine
  • C. Row store engine
  • D. Join engine


Answer : B

You would like to authorize a user to see data in an analytic view only for company code
1000 and fiscal year 2000 or for company code 1005 and fiscal year 2005.
Which of the following achieves this requirement?

  • A. One analytic privilege. the combination of company code = 1000 and fiscal year = 2000, and the combination of company code = 1005 and fiscal year = 2005
  • B. One analytic privilege: company code = 1000, fiscal year = 2000 One analytic privilege: company code = 1005, fiscal year = 2005
  • C. One analytic privilege: company codes = 1000 and 1005, and fiscal years = 2000 and 2005
  • D. One analytic privilege: company codes = 1000 and 1005 One analytic privilege: fiscal years = 2000 and 2005


Answer : B

Page:    1 / 45   
Total 221 questions