SAP HANA Technology Associate C_HANATEC_12 Real Exam Dumps

1. When is the administration editor in SAP HANA studio opened automatically in diagnosis mode? (Choose two.)

2. Which actions do you need to perform to configure SAP HANA single sign-on?

3. In the navigator tree of the SAP HANA studio, how can you find out which indexes are defined for table CUST_DATA from the SALES schema? (Choose two.)

4. Which of the following must you implement for high availability in an SAP HANA production system? (Choose three.)

5. Where in the SAP HANA studio can you change the path of the backup folder? (Choose two.)

6. An administrator should be enabled to cancel long running commands and end sessions.

Which privilege must the user be granted?

7. When you try to create a delivery unit from the SAP HANA studio you receive the following error message. ‘Cannot create Delivery Unit as content vendor is not defined for this system’.

How do you troubleshoot this issue?

8. You need to retrieve data from SAP HANA that is restricted to a certain region and specific users.

How can you implement this security strategy?

9. A backup catalog became unusable.

What can you do to recover existing backups?

10. What is the minimum required disk space for the data volumes of an SAP HANA system in relation to its memory (RAM)?

11. Which of the following are benefits of implementing SAP HANA? (Choose three.)

12. In Microsoft Windows, to which folder are the logs written by default during the SAP HANA studio installation?

13. When does SAP recommend that you execute the first system backup?

14. Which of the following connection types does Direct Extractor Connection (DXC) use to transfer data to SAP HANA?

15. Which of the following template roles are delivered in the standard system? (Choose two.)

16. Which of the following traces is active by default in SAP HANA?

17. Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?

18. You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active.

Where can you accomplish this?

19. Which of the following update scenarios can be selected for execution in the SAP HANA lifecycle manager? (Choose two.)

20. Which of the following can you use to update SAP HANA?

21. Which of the following tools can you use to create and manage SAP HANA database users? (Choose two.)

22. Of the databases that can be used for Data Services 4.0, which of the following is bundled with Information Platform Services (mini-BOE)?

23. You have created a file named backup.sql with the following information to run a backup:/c -n -i -u -p BACKUP DATA USING FILE (‘backupDirectory/data/COMPLETE_BK’)

Which of the following commands executes the backup?

24. You installed SAP HANA Database using 51 as your system number.

Which network port is used for Standard SQL communication for client access?

25. SAP Support needs to access a customer’s SAP HANA studio remotely.

Which entry must the client maintain in SAP Service Marketplace?

26. What is the maximum number of master name servers that you can define in a distributed landscape?

27. Which of the following is a result of using SAP HANA as an application platform?

28. What do you have to consider when you design a backup plan? (Choose two.)

29. What must you configure in Data Services 4.0 to establish a connection to SAP ERP?

30. After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.

Which of the following parameter settings allows you to do this?

31. You want to create a role that grants read-only access to the content of the system and monitoring views and to statistics services.

Which of the following privileges should the role contain? (Choose two.)

32. You plan to install an SAP HANA database in an SAP HANA Tailored Datacenter Integration (TDI) scenario.

Which SAP HANA installation tools are required? (Choose two.)

33. Which of the following steps is required for configuring SAP Landscape Transformation (SLT)?

34. Which of the following connections require the highest network bandwidth?

35. Which of the following authentication methods are provided by SAP HANA? (Choose two.)

36. Which of the following are parts of SAP HANA sizing? (Choose three.)

37. In which of the following situations is a recovery of an SAP HANA database applicable? (Choose three.)

38. Which of the following is used to deploy SAP-delivered content in SAP HANA?

39. What is the purpose of the save point process in SAP HANA?

40. Which view displays the current SAP HANA Support Package level?

41. Which of the following views allows an administrator to identify all the authorizations assigned to a user?

42. Which of the following can be imported into and exported from SAP HANA studio? (Choose three.)

43. The SAP LT trigger-based approach uses a log table to record all relevant changes.

Where is this log table stored?

44. You want the user SOLMAN_ADMIN to be able to modify the properties of the SAP HANA instance during system configuration in SAP Solution Manager.

Which role must you assign to the user SOLMAN_ADMIN to achieve this?

45. Which of the following is an SQL privilege?

46. Which of the following can decrease the startup time of an SAP HANA system after a reboot?

47. Which of the following is most relevant for CPU sizing of a SAP HANA appliance?

48. What must you do in SAP LT to establish a connection between a non-SAP source system database and SAP HANA? (Choose three.)

49. Which of the following do you add when you ”scale out” SAP HANA?

50. You create an analytic view and want to restrict access to departments with specific values using analytic privileges.

Which tasks do you have to perform to accomplish this? (Choose three.)