1. When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question.

2. A user is complaining about missing privileges when executing a query.

How do you configure the indexserver trace to obtain the missing privileges? Please choose the correct answer

3. Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question.

4. Out of complete SAP HANA platform, which from the following components are not part of SAP HANA Database? There are 3 correct answers to this question.

5. You installed an SAP Netweaver-based application on an SAP HANA database.

What is the default secure user store to store the password of the SAP<schema-id> user?

6. Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database? There are 2 correct answers to this question.

7. You need to periodically monitor if the SAP HANA primary system is online.

Which tool do you use?

8. Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system.

Which of the following options are listed? There are 3 correct answers to this question.

9. At the end of the SAP HANA Cockpit 2.0 installations, how can you obtain the URL of the SAP HANA cockpit and the SAP HANA cockpit manager?

10. You created a restricted user in the DB1 database.

Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question.

11. What are prerequisites for changing the SSFS Master Keys? There are 2 correct answers to this question.

12. Which option do you choose to protect your SAP HANA scale-out system using host autofailover?

13. Your customer wants to know when the productive SAP HANA system was updated and to which version.

Where do you find this information? There are 2 correct answers to this question

14. Which target database does the SUM databases migration option provide by default? Note: There are 2 correct answers.

15. Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system? Note: There are 2 correct answers.

16. Which alert configuration properties can you configure in SAP HANA cockpit? There are 3 correct answers to this question.

17. What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.

18. Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.

19. Due to a hardware failure of your persistence area, your SAP HANA database needs to be restored.

Which tasks do you perform to recover the complete system? Note: There are 2 correct answers.

20. Which action do you perform when the data area in an SAP HANA database is running out of space?

21. What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.

22. SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question.

23. What must you do to convert an SAP HANA 1.0 single database system to an SAP HANA 2.0 multitenant database system?

24. Which system privilege must you have to redistribute tables across the hosts in your scale-out system?

25. Which operation is executed before a table is repartitioned?

26. Which actions are always recorded when auditing is active? Note: There are 2 correct answers.

27. Which file system locations are suggested to install an SAP HANA multi-host system? There are 2 correct answers to this question.

28. Which script can you trigger from SAP HANA cockpit to collect diagnosis information?

29. What can you do to shorten the startup time of an SAP HANA system after a reboot?

30. Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.

31. In the General Licensing Process which of the following statements are true regarding Temporary license keys? There are 2 correct answers to this question.

32. You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory allocated and service 2 has 40 GB allocated.

What is the effective allocation limit of service 3?

33. When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question.

34. Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.

35. In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?

36. Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? There are 2 correct answers to this question.

37. Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.

38. You install a productive multi-host system with failover capabilities.

Which storage condition prerequisites must be ensured? Note: There are 2 correct answers.

39. Which of the following actions are audited by default in SAP HANA? There are 2 correct answers to this question.

40. You create a new user by copying an existing user.

Which predelivered role of the existing user is automatically granted to the new user?

41. Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.

42. What are the prerequisites for using the Web user interface for HDBLCM? There are 2 correct answers to this question.

43. To ensures that the database can be restored to the most recent committed state after a restart which of the following Indexserver components make sure such consistency and maintain durable changes?

44. After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?

45. Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers.

46. What do you do to prepare the database migration option of a Software Update Manager procedure? Note: There are 3 correct answers.

47. Which tool do you use to backup the root encryption keys?

48. How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question.

49. In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.

50. Which of the following recovery types is not supported for delta backups?

51. Which tools do you use to delete diagnosis files? There are 2 correct answers to this question.

52. What is the recommended disk space for /hana/shared/<SID> for single-node SAP HANA systems? Please choose the correct answer

53. What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? There are 3 correct Answers to this question.

54. Which R3load mode is used during an inplace SUM database migration option procedure?

55. What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

56. Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? There are 2 correct answers to this question.

57. You upgrade an SAP HANA 1.0 system to SAP HANA 2.0.

Which of the following activities are required to avoid compatibility issues after the upgrade? Note: There are 2 correct answers.

58. What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose

59. Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers.

60. You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?

61. Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? There are 2 correct answers to this question.

62. Assume your current partitioning plan of SAP HANA is NOT optimal.

Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Please choose the correct answer.

63. You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system.

Which of the following installation requirements are mandatory? There are 2 correct answers to this question.

64. Which products do you use for SAP HANA administration? There are 2 correct answers to this question.

65. Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer.

66. Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.

67. USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards.

What happens if you drop USER B from the HANA database?

68. SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason.

Which parameters do you adjust to manage the event log? There are 2 correct answers to this question.

69. You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup? Note: There are 2 correct answers.

70. Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.

71. Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.

72. What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers.

73. Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool? There are 3 correct answers to this question.

74. In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.

75. You need to rename a tenant database using the Manage Database app in the SAP HANA cockpit.

Which prerequisite do you require? Note: There are 2 correct answers.

76. In which circumstances do you create a column store table? There are 3 correct answers to this question.

77. You need to update the location where a copy of the persistent data is saved.

Which of the following parameters do you change? Note: There are 2 correct answers.

78. You need to analyze the high CPU load of running thread in more detail in the Thread Monitor.

Which parameters do you need to change? Note: There are 2 correct answers.

79. What is the additional disk space factor required during delta merge operations? Please choose the correct answer.

80. Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.