Updated C_HANATEC_17 Dumps Questions For SAP HANA 2.0 SPS05 Exam

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

2. Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to

3. Which tools are integrated into the SAP HANA cockpit? There are 3 correct answers to this question.

4. How are save points triggered? There are 2 correct answers to this question

5. Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?

6. Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer.

7. 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?

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

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

10. For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

11. The SAP HANA database is NOT reachable, and the root cause is unclear .

Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

12. 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 2TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.

13. Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.

14. Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this questions.

15. 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.

16. You setup email notification for a specific alert threshold by using Alerts Configuration.

When are the email notification sent? Note: There are 2 correct answers.

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

18. What can you assign to a user with the User Management app in SAP HANA cockpit? There are 2 correct answers to this question.

19. What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question.

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

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

22. Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.

23. Which trace do you use to create a graphical representation of an individual SQL Statement?

24. You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and user management .

Which deployment scenario do you use?

25. Which information is provided via the SUM UI? There are 3 correct answers to this question.

26. Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correct answers to this question.

27. How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

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

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

29. You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers .

Which rules apply? There are 2 correct answers to this question.

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

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

32. What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question.

33. Which role do you need in order to assign users to groups in the SAP HANA cockpit? Please choose the correct answer.

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

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

36. Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start? Please choose the correct answer.

37. What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer.

38. What can a user do when the backup operator system privileges is assigned?

39. Which connections do you need to enable explicitly for a Restricted user? There are 2 correct answers to this question.

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

41. 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?

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

43. 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.

44. 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.

45. Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question.

46. Why do we still need a persistent layer? There are 2 correct answers to this question.

47. Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question

48. What are advantages of column store tables? There are 3 correct answers to this question.

49. How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.

50. A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.

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

52. 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.

53. Which of the following tools can be used for User Administration? There are 3 correct Answers to this question.

54. 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.

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

56. You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration .

Which steps take place during downtime? There are 2 correct answers to this question.

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

58. Which diagnostic file can you use to monitor the status of database recovery?

59. You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database.

From which location does the Recover Database app read the recovery information by default?

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

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

62. Which SUM database migration option utility do you use to check and monitor table splitting?

63. You suspect an authorization issue while executing SAP HANA reports that contain calculation views .

How do you configure the authorization trace? There are 2 correct answers to this question.

64. Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit? There are 3 correct answers to this question.

65. 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

66. What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer.

67. Which operating system process takes care of starting the SAP HANA database system services?

Please choose the correct answer.

68. 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.

69. In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function? There are 2 correct answers to this question.

70. Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? There are 3 correct answers to this question.

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

72. Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.

73. Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor? There are 3 correct answers to this question.

74. 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.

75. SAP HANA system replication is configured and active between two SAP HANA systems.

After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.

76. What cryptographic libraries are supported in SAP HANA by default? There are 2 correct answers to this question.

77. How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.

78. 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.

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

80. What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.