SAP HANA 2.0 SPS04 Certification Exam C_HANATEC_16 Real Dumps

1. You register a new resource in SAP HANA cockpit 2.0.

What prerequisite does the resource require?

2. What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

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

4. Which information is provided by the backup catalog. Please choose the correct answer.

5. The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

6. Which SAP recommendations do you follow to create an optimal table partitioning plan for SAP Business Suite powered by SAP HANA? Note: There are 2 correct answers.

7. Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.

8. Which authentication method can you configure for single sign-on in a middleware/application server scenario.

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

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

11. During the delta merge process, to which memory areas is data inserted? There are 2 correct Answers to this question.

12. Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

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

14. Which tools can you use to monitor the response time of individual SQL queries? Note: There are 2 correct answers.

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

16. You plan to set up an SAP HANA2.0 system on intel-based hardware platform.

Which of the following operating systems can you use ? Note: There are 2 correct answers

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

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

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

20. How can you minimize the database migration option (DMO) downtime?

21. Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers.

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

23. What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring

tool for productive SAP HANA databases?

24. Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.

25. logical error occurred in one tenant of your SAP HANA database.

What action do you perform to make the tenant consistent again? Please choose the correct a nswer

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

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

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

29. Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.

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

31. One of your systems show the internal Disk Full (Alert 30) alert.

What is the root cause of this alert?

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

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

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

35. Your SAP HANA database is locked down.

Which action can you still perform?

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

37. Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question.

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

39. Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

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