SAP SAP Certifications C_HANATEC_10 Questions & Answers

• Question 61:

  Which tasks do you have to perform if you want to use SAP BW with SAP HANA as the underlying

  database?

  Please choose the correct answer.

  Response:

  A. Do a homogeneous system copy from your current DB to SAP HANA DB.

  B. Ensure that you have at least SAP NetWeaver Business Warehouse 7.02 installed.

  C. Do a heterogeneous system copy from your current DB to SAP HANA DB.

  D. Recreate SAP BW indexes after SAP HANA database migration.

  Correct Answer: C

• Question 62:

  Which of the following is an SQL privilege? Please choose the correct answer. Response:

  A. DEVELOPMENT

  B. DROP

  C. SAVEPOINT ADMIN

  D. EXPORT

  Correct Answer: B

• Question 63:

  In addition to the in-memory database, which of the following technologies are part of SAP HANA? There are 2 correct answers to this question.

  Response:

  A. Columnar store

  B. Asymmetric multi-processing

  C. Diskless data storage

  D. Massive parallel processing

  Correct Answer: AD

• Question 64:

  Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit?

  There are 3 correct answers to this question.

  Response:

  A. Execute system recovery.

  B. Implement backup scheduling.

  C. Monitor an SQLDBC trace.

  D. Display the statuses of database resources.

  E. View the tables in the _SYS_STATISTICS schema.

  Correct Answer: CDE

• Question 65:

  Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts?

  There are 2 correct answers to this question.

  Response:

  A. CCMS agent

  B. Collection script

  C. Host agent

  D. SMD agent

  Correct Answer: BC

• Question 66:

  You need to recover an SAP HANA database. What is a prerequisite?

  Please choose the correct answer

  Response:

  A. Use the SAP DBA Cockpit to perform a database recovery.

  B. An offline SAP HANA database

  C. Use the SAP HANA cockpit to perform a database recovery.

  D. An online SAP HANA database

  Correct Answer: B

• Question 67:

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

  Please choose the correct answer.

  Response:

  A. SQL trace

  B. Performance trace

  C. Database trace

  D. Expensive statements trace

  Correct Answer: C

• Question 68:

  Which of the following are required to enable SAP HANA high availability?

  There are 2 correct answers to this question.

  Response:

  A. SAP HANA distributed systems

  B. SUSE Linux Enterprise High Availability Extension

  C. Redundant storage and network

  D. High-performance computing clustering for Linux

  Correct Answer: AC

• Question 69:

  In which of the following situations is a recovery of an SAP HANA database applicable?

  There are 3 correct answers to this question.

  Response:

  A. Corruption of kernel binary files

  B. Crash of the SLT server

  C. Reset of the system to a specific point in time

  D. Disk crash of the log area

  E. Disk crash of the data area

  Correct Answer: CDE

• Question 70:

  Your SAP HANA usage scenario does not require SAP HANA XS.

  What do you have to consider before you remove the SAP HANA XS service from the configuration?

  There are 3 correct answers to this question.

  Response:

  A. All applications using the SAP HANA instance must be stopped.

  B. User adm is required to remove the SAP HANA XS service.

  C. A data backup must be taken after the SAP HANA XS service has been removed.

  D. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance.

  E. The user privileges for accessing SAP HANA XS must be revoked.

  Correct Answer: ACD