1. What are the row-based and column based approach? 2. What are the advantages and disadvantages of row-based tables? 3. What are the advantages of column-based tables? 4. Why SAP HANA Fast? 5. What are the different types of replication techniques? 6. What is a table type? 7. What is the general syntax used in creating procedure? 8. What is the purpose of procedure 'Call... With Overview' option? 9. What is the difference between BREAK and CONTINUE? 10. What are the two developer roles in HANA SPS05? 11. Explain HANA database Architecture (SP05)? 12. What is SAP XS (Extended Application Service)? 13. What are Development objects? 14. What is Repository? 15. What are the different perspectives available in HANA? 16. Before starting development work in SAP HANA studio, What are the roles a user should have on SAP HANA server ? 17. What is a Delivery Unit? 18. What is a workspace? 19. What is a package and its types? 20. What are the default packages delivered with the repository? 21. What can be the maximum length of a package name? 22. What are package privileges? 23. How each object is uniquely identified in the repository? 24. Can multiple objects of the same type can have the same object name? 25. What are the different tasks you can perform in setting up the basis persistence model for SAP HANA XS? 26. What are the different tasks you can perform in modeler perspective? 27. What are the supported object types in modeler perspective? 28. What are the different modeler preferences and how do you set? 29. What is Schema mapping? How do you do Schema mapping? 30. What is an Attribute, Analytic and Calculation View? 31. What is a Calculated Attribute and Measure? 32. What is a Restricted Measure? 33. What happens when one of the table in Attribute view has modified column with data type? 34. Can you add column views to Analytic view and Calculation view? 35. While creating a Graphical Calculation view, what are the options available in Tools palette? 36. How to create Counters in Graphical Calculation view? 37. What are the different types of Input parameters supported? 38. What is the difference between HANA Variable and Input parameter? 39. What is the difference between Activate and Redeploy? 40. What are the subtypes and data category of Calculation View? 41. What is the reason for going In-memory in SAP HANA?
