C-HANATEC-11 by SAP Actual Free Exam Q&As

Question 1

Which technologies use trigger-based replication?
There are 2 correct answers to this question.
Response:

A. TREX engine B. ABAP extractors C. Near Zero Downtime D. Standard SQL database replication E. Test Data Migration Server (TDMS)

Discussion 0

Correct Answer: C,E Vote an answer

Question 2

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?
There are 2 correct answers to this question.
Response:

A. DATA ADMIN B. SELECT for SQL schema _SYS_STATISTICS C. SERVICE ADMIN D. ALTER for SQL schema _SYS_STATISTICS

Discussion 0

Correct Answer: A,B Vote an answer

Question 3

Your customer is performing a full data backup every week and a delta backup daily. You need to implement the shortest recovery method for an SAP HANA database.
Which recovery order is the fastest?
Please choose the correct answer.
Response:

A. 1. Full data backup
2. Log backup
3. Incremental backup B. 1. Full data backup
2. Log backup
3. Differential backup C. 1. Full data backup
2 . Incremental backup
3 . Log backup D. 1. Full data backup
2 . Differential backup
3 . Log backup

Discussion 0

Correct Answer: D Vote an answer

Question 4

You have to size and SAP Hana system How large is a memory area used by objects created during runtime?
Please choose the correct answer.
Response:

A. the same as a size for static data in memory B. half the size of the days earlier for data files C. a maximum of 90% of the physical memory D. the same as the size of the disc area for log files

Discussion 0

Correct Answer: A Vote an answer

Question 5

You want to perform a recovery of an SAP Hana database using the recovery wizard in the
SAP Hana studio Which recovery options do you have?
There are 3 correct answers to this question
Response:

A. recover the database to a specific point in time B. recover the database to its most recent state C. recover the database to a specific savepoint D. recover the database to a specific log shipment E. recover the database to a specific data backup

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 6

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 newest data must be backed up most often C. the log backup mode needs to be checked D. the column table data needs to be compressed before a backup

Discussion 0

Correct Answer: A,C Vote an answer

Question 7

In your SAP Hana database, The Automatic log backup is enabled and the parameter log_backup_timeout_s set to 0.
When a log backups still triggered?
There are 2 correct answers to this question
Response:

A. when the log area is full B. when the log segment is full C. when the services are restarted D. when the Delta storage is full

Discussion 0

Correct Answer: B,C Vote an answer

SAP Certified Technology Associate - SAP HANA (SPS11) - C-HANATEC-11 Exam Practice Test