Welcome to your SAP Certified Technology Associate - SAP HANA 2.0 SPS05-C_HANATEC_17
1. Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question.
2. 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.
3. Which properties can you adjust in SAP HANA admission control? Note: There are 3 correct answers to this question.
4. You are planning an SAP S/4HANA scale-out system. What are the minimal size requirements for CPU and memory? Choose the correct answer.
5. What is the purpose of the SAP HANA secure user store (hdbuserstore)? Note: There are 2 correct answers to this question.
6. What is the correct sequence of the following four steps when you restart the SAP HANA database system? Choose the correct answer.
7. 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.
8. 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.
9. Which schema provides performance data and alert details to review in SAP HANA mini-checks? Choose the correct answer.
10. In a multitenant database container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases? Choose the correct answer.
11. 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.
12. Which operating system process takes care of starting the SAP HANA database system services? Choose the correct answer.
13. 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 standby nodes? Choose the correct answer.
14. 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.
15. Which user credentials are required when performing a database migration option (DMO) procedure to SAP HANA 2.0? Note: There are 3 correct answers to this question.
16. Which feature do you configure to prevent the whole SAP HANA database system from reaching physical processing limits? Note: There are 2 correct answers to this question.
17. What are the merge methods that are triggered by the SAP HANA system? Note: There are 2 correct answers to this question.
18. What is the recommended size for the log volume file system for a 512 GB SAP HANA database system? Choose the correct answer.
19. You are checking and monitoring SAP HANA system replication. Which status indicates a temporary connection loss of the secondary system? Choose the correct answer.
20. Which file systems are supported for the data and log volumes of the SAP HANA 2.0 database system? Note: There are 2 correct answers to this question.
21. Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question.
22. In which scenario do you need SAP expert sizing? Note: There are 2 correct answers to this question.
23. Which feature do you use to dynamically manage SAP HANA database workloads per client session? Choose the correct answer.
24. What cryptographic libraries are supported in SAP HANA by default? Note: There are 2 correct answers to this question.
25. What action(s) can you perform in the SAP HANA cockpit to back up the complete database system? Choose the correct answer.
26. 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.
27. Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question.
28. What additional action do you need to perform after you create a new tenant in an SAP HANA system replication configuration? Choose the correct answer.
29. 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.
30. Which prerequisites must be fulfilled before adding hosts to an SAP HANA scale-out system? Note: There are 2 correct answers to this question.
31. Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure? Note: There are 2 correct answers to this question.
32. What is a characteristic of the delta data shipping operation mode in SAP HANA system replication? Choose the correct answer.
33. How are hosts assigned to the shared storage in the SAP HANA scale-out system? Note: There are 2 correct answers to this question.
34. 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.
35. Which types of backups can you use to copy an SAP HANA tenant database? Note: There are 2 correct answers to this question.
36. Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? Note: There are 2 correct answers to this question.
37. 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.
38. 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.
39. Which features do you need to activate before you can analyze the memory usage of running SQL statements? Note: There are 2 correct answers to this question.
40. How are savepoints triggered? Note: There are 2 correct answers to this question.
41. 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.
42. Which system privilege do you need to redistribute tables across the hosts in a scale-out system? Choose the correct answer.
43. How does SAP HANA encrypt the data persistence layer? Choose the correct answer.
44. Which role do you need in order to assign users to groups in the SAP HANA cockpit? Choose the correct answer.
45. 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.
46. Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system? Choose the correct answer.
47. Which tools are integrated into the SAP HANA cockpit? Note: There are 3 correct answers to this question.
48. 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.
49. You are running an SAP HANA database in log mode "normal". Under what circumstances does the database automatically execute a regular log backup? Note: There are 2 correct answers to this question.
50. Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit? Choose the correct answer.
51. Who owns an SAP HANA Deployment Infrastructure (HDI) role? Choose the correct answer.
52. Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header? Choose the correct answer.
53. Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit? Note: There are 3 correct answers to this question.
54. How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question.
55. Which prerequisites of the primary system and the secondary system are mandatory before you can activate SAP HANA system replication with secondary time travel? Note: There are 2 correct answers to this question.
56. Which connection type is used by default for restricted users? Choose the correct answer.
57. Which system usage types are automatically assigned to tiles in the SAP HANA cockpit? Note: There are 3 correct answers to this question.
58. Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed? Choose the correct answer.
59. You want to implement a 28-day backup cycle. Which scenario uses the least storage? Choose the correct answer.
60. For an SAP HANA tailored data center integration (TDI) approach, what is the additional disk space factor required during delta merge operations? Choose the correct answer.
61. 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.
62. Which technology is utilized by the Performance Warehouse option in the transaction DBACOCKPIT? Choose the correct answer.
63. How are user group administrators and user groups related? Note: There are 2 correct answers to this question.
64. During the delta merge process, to which memory areas is data inserted? Note: There are 2 correct answers to this question.
65. Which prerequisites must be fulfilled to rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question.
66. 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 2 correct answers to this question.
67. Which actions are performed during the database migration option (DMO) procedure when you select the IDo not compare table contentsI option? Note: There are 2 correct answers to this question.
68. What can you check with the SAP HANA hardware and cloud measurement tools (HCMT)? Choose the correct answer.
69. Which SAP HANA cockpit application can you use to investigate a system offline situation? Note: There are 2 correct answers to this question.
70. Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note: There are 2 correct answers to this question.
71. Which system privileges are required for administrating tenant databases when connected to the system database? Choose the correct answer.
72. What do you need in a multitenant database container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question.
73. Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start? Choose the correct answer.
74. 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.
75. 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.
76. 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.
77. Which technology is used to install the SAP Landscape Management tool? Choose the correct answer.
78. How can you ensure that a consistent database status is saved using data snapshots? Choose the correct answer.
79. 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.
80. Which table holds the data used for the dynamic management of partitions and locations? Choose the correct answer.
