Free SAP C_HANATEC_11 Exam Dumps Questions & Answers

Which of the following can you use to analyze an expensive SQL statement?
There are 2 correct answers to this question.
Response:

• A.  The plan visualizer
• B.  The hdbcons tool
• C.  The plan explanation
• D.  The performance trace view

Which collects information about all executed sql statement and saves it as an executable python program and recording a scenario?
Please choose the correct answer.
Response:

• A.  User-specific trace
• B.  Expensive statements trace
• C.  Performance trace
• D.  SQL trace

SAP Hana database is recovered from a backup but the database is locked after recovery
Why is a database locked?
Please choose the correct answer.
Response:

• A.  the database backup was corrupt
• B.  the license amount of disc space was exceeded
• C.  the license key has expired
• D.  the database recovery failed

Which of the following is influenced by the audit level?
Response:

• A.  The order of the audit log entries in the audit log
• B.  The information that is printed with the audit log entry
• C.  The amount of data transferred to SAP Solution Manager
• D.  The messages that are sent to the security administrator

What do you have to consider when you design a backup plan?
There are 2 correct answers to this question
Response:

• A.  the database backup must be stored outside the database host
• B.  the column table data needs to be compressed before a backup
• C.  the newest data must be backed up most often
• D.  the log backup mode needs to be checked