1. Which actions take place during a database migration option (DMO) procedure when performing an in-place migration? Note: There are 2 correct answers to this question.
2. You want to implement a 28-day backup cycle. Which scenario uses the least storage?
3. Which action can you only choose when using the resident HDBLCM tool as root user? Note: There are 2 correct answers to this question.
4. Which prerequisites are mandatory before you can activate SAP HANA system replication with secondary time travel ? Note: There are 2 correct answers to this question.
5. Which prerequisites must be fulfilled when recovering a tenant database? Note: There are 2correct answers to this question.
6. Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note: There are 3 correct answers to this question.
7. Which table or view holds the rules used for the dynamic management of partitions and locations ?
8. Which file systems are supported for the data and log volumes of the SAP HANA 2.0 database system? Note: There are 2 correctanswers to this question.
9. Which feature do you use to dynamically manage SAP HANA database workloads per client session? Choose the correct answer.
10. Which tool shows you information about the list of tables to bepre-loaded during an SAP HANA system start? Choose the correct answer.
11. Which characteristics describe an SAP HANA scale-out system with one stand by node? Note: There are 2 correct answers to this question.
12. Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol(LDAP) server? Note: There are 2 correct answers to this question.
13. Which migration features are supported when using the database migration option (DMO) of Software Update Manager(SUM)? Note: There are 2 correct answers to this question.
14. Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question.
15. When performing a standard SAP HANA database system installation, which users will be created or validated during that installation? Note: There are 2 correct answers to this question.
16. Which connection type is used by default for restricted users?
17. Which operating system process takes care of starting the SAPHANA database system services?
18. How can you ensure that a consistent database status is saved using data snapshots? Choose the correct answer.
19. How does SAP HANA encrypt the data persistence layer?
20. What is the correct sequence of the following four steps when you restart the SAP HANA database system?
21. Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? Note: There are 2 correct answers to this question.
22. Which feature do you configure to prevent the whole SAP HANA database system from reaching physical processing limits? Note: There are2 correct answers to this question.
23. What is the default single sign-on method when using hdbsql?
24. The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions, and threads? Note: There are 2 correct answers to this question.
25. Your customer has purchased a 3 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 2 TB nodes in an SAP HANA scale-out system consisting of three worker and one stand by nodes?
26. You are running SAP HANA in a system replication setup. What happens to the tenant on the secondary site if the primary tenant is stopped?
27. What can you check with the SAP HANA hardware and cloud measurement tools (HCMT)? Note: There are 2 correct answers to this question.
28. What information can you find in the backup catalog when you analyze your backups? Note: There are2 correct answers to this question.
29. Which features do you need to activate before you can analyze the memory usage of running SQL statements? Note: There are2 correct answers to this question.
30. Which properties can you adjust in SAP HANA admission control? Note: There are 3 correct answers to this question.
31. What can you assign to a user with the User Management app in SAP HANA cockpit? Note: There are 2 correct answers to this question.
32. You want to prevent changes to system properties in tenant databases. Which configuration file stores the blocklisted properties?
33. Which part of the SAP HANA database memory hold the application data being stored to disk ?
34. Which prerequisites must be fulfilled before adding hosts to an SAP HANA scale-out system? Note: There are 2 correct answers to this question.
35. You want to perform the database migration option (DMO) procedure. Which components have to be updated if they are not on the right version level? Note: There are 2 correct answers to this question.
36. Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit? Note: There are3 correct answers to this question.
37. Which rules should you consider when creating a table distribution plan for SAP Business Suite powered by SAP HANA to get the best possible results? Note: There are 2correct answers to this question.
38. What cryptographic libraries are supported in SAP HANA? Note: There are 2 correct answers to this question.
39. Which parameters are mandatory when using the HDBLCM tool to install the SAP HANA database system in batch mode? Note: There are 2 correct answers to this question.
40. What is the recommended disk size for the /HANA / shared file system in a 5 node scale-out SAP HANA system with 512GB RAM per node ?
41. What do you need in a multitenant database container (MDC) system to run queries across tenant databases? Note: There are 2correct answers to this question.
42. Which file system locations do you need to specify when installing the SAP HANA multi-host database system using the default settings? Note: There are 2 correct answers to this question.
43. How can you use the results from a comparable test run to optimize the database migration option (DMO) procedure downtime for a production system? Note: There are 2 correct answers to this question.
44. What is one of the backup options provided by the SAP HANA database?
45. Which activities do you have to carry out to configure your multitenant database container (MDC) system to a higher database isolation level between tenant databases on the operating system (OS)? Note: There are 3 correct answers to this question.
46. Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app? Note: There are 2 correct answers to this question.
47. Which system privileges are required for administrating tenant databases when connected to the system database? Note: There are 2 correct answers to this question.
48. Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES? Note: There are 2correct answers to this question.
49. Which scenario are supported for a database copy using backup and recovery from a source machine to a target machine? Note: There are 2 correct answers to this question.
50. Which of the following is a characteristic of the delta data shipping operation mode in SAP HANA system replication?
51. Who owns an SAP HANA Deployment Infrastructure (HDI)role? Choose the correct answer.
52. Which compression algorithm is supported for SAP HANA system replication?
53. How are hosts assigned to the shared storage in the SAP HANA scale-out system? Note: There are 2 correct answers to this question.
54. Which SAP platform technology is used for on premise SAP Landscape Management?
55. Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed? Choose the correct answer.
56. Which system privilege do you need to redistribute tables across the hosts in a scale-out system?
57. What happens when you rename a tenant database in the SAP HANA cockpit ? Note: There are 2 correct answers to this question.
58. How much free disk space should be available for patching SAP HANA in your working directory ?
59. What are the merge methods that are triggered by the SAPHANA system? Note: There are 2 correct answers to this question.
60. Which tool do you use to reinitialize a non-recoverable system database ?
61. In which scenario do you need SAP expert sizing? Note: There are 2 correct answers to this question.
62. Which steps need to be performed before starting the copy/move process for a tenant database? Note: There are 2 correct answers to this question.
63. Which services are used between the SAP HANA cockpit and its managed resources? Note: There are 2 correct answers to this question.
64. Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit? Choose the correct answer.
65. You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT_MONITOR technical user? Note: There are 2 correct answers to this question.
66. Which tools can you use to disable tenant database functionalities? Note: There are 2 correct answers to this question.
67. Which SAP HANA cockpit application can you use to investigate a system offline situation?
68. In which situations can you resume the failed recovery of your productive SAP HANA tenant database? Note: There are 2 correct answers to this question.
69. You are planning an Intel-based SAP S/4HANA scale-out system. What are the minimal size requirements for CPU and memory? Choose the correct answer.
70. During the delta merge process, to which memory areas is data inserted? Note: There are 2 correct answers to this question.
71. How are user group administrators and user groups related? Note: There are 2 correct answers to this question.
72. You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as an in-place migration. Which steps take place during downtime? Note: There are 2 correct answers to this question.
73. You are running a database migration option (DMO) procedure using in-place migration. Where are the reading and writing R3load processes located during the actual migration? Choose the correct answer
74. Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure? Note: There are 2 correct answers to this question.
75. What are the preinstalled SAP HANA mini-checks stored?
76. Which action is always performed during the database migration option (DMO) procedure when you select the” Do not compare table contents” option?
77. What is the purpose of the SAP HANA secure user store(hdbuserstore)? Note: There are 2 correct answers to this question.
78. Which role do you need in order to assign users to groups in theSAP HANA cockpit? Choose the correct answer.
79. Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question.
80. Which user credentials are required when performing a database migration option (DMO) procedure from Oracle to SAP HANA 2.0? Note: There are 2 correct answers to this question.
