Download SAP C_HANATEC_17 Sample Questions [Aug-2023]
Real C_HANATEC_17 Exam Questions and Answers FREE
NEW QUESTION # 66
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.
- A. When the log buffer is full
- B. When the log segment is full
- C. After the configured time threshold has been exceeded
- D. When a savepoint occurs
Answer: B,C
NEW QUESTION # 67
Which partitioning option distributes rows equally for load balancing in the SAP HANA database?
- A. Hash
- B. RoundRobin
- C. Range
- D. Range-Range
Answer: B
NEW QUESTION # 68
What can you do to shorten the startup time of an SAP HANA system after a reboot?
- A. Set the savepoint interval to a lower value.
- B. Flag all columnar tables for preload.
- C. Set the preload column value in the Tables system table to FULL.
- D. Partition the row store across nodes.
Answer: A
NEW QUESTION # 69
What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers.
- A. Network traffic is reduced
- B. Takeover time is shorter
- C. Memory consumption is lower
- D. CPU load is reduced
Answer: A,B
NEW QUESTION # 70
Due to a hardware failure of your persistence area, your SAP HANA database needs to be restored. Which tasks do you perform to recover the complete system? Note: There are 2 correct answers.
- A. Recover all the databases using Initialize Log Area option
- B. Recover the system database before recovering all tenant databases
- C. Start the recovery from the system database SAP HANA cockpit 2.0
- D. Start the recovery from the tenant database using SAP HANA cockpit 2.0
Answer: B,C
NEW QUESTION # 71
How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.
- A. Provide the measured table migration duration data for optimal table sequencing during benchmarking.
- B. Set the optimal number of R31oad processes during benchmarking and the DMO procedure
- C. Use the benchmarking option to find the optimal throughput during the DMO procedure.
- D. Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.
Answer: A,B
NEW QUESTION # 72
Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor?
There are 3 correct answers to this question.
- A. Disk consumption from the SAP HANA database.
- B. Memory and CPU consumption from the SAP HANA database.
- C. The time at which the database was started.
- D. Connection statistics about open connections.
Answer: A,B,C
NEW QUESTION # 73
How are savepoints triggered? There are 2 correct answers to this question
- A. By performing a database backup.
- B. By performing a delta merge.
- C. By issuing a transactional commit.
- D. By a database soft shutdown.
Answer: A,D
NEW QUESTION # 74
How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system?
There are 2 correct answers to this question.
- A. Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence.
- B. Use the UPGANA.XML analysis file to optimize the number of R3load processes.
- C. Use the Test Cycle option to determine the optimal number of R3load processes.
- D. Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables.
Answer: A,C
NEW QUESTION # 75
In which situations can you resume the failed recovery of your productive SAP HANA tenant database?
There are 2 correct answers to this question.
- A. An aborted recovery of a log backup
- B. An aborted recovery of delta data backup
- C. An aborted recovery of a complete data backup
- D. An aborted recovery of the configuration files
Answer: A,B
NEW QUESTION # 76
You need to periodically monitor if the SAP HANA primary system is online. Which tool do you use?
- A. landscapeHostConfiguration
- B. systemreplicationStatus
- C. hanasitter
- D. HDBAdmin
Answer: A
NEW QUESTION # 77
Which system usage types are automatically assigned to ties in the SAP HANA cockpit?
There are 3 correct answers to this question.
- A. Development
- B. Production
- C. Custom
- D. Quality assurance
- E. Test
Answer: A,B,E
NEW QUESTION # 78
Which SUM database migration option utility do you use to check and monitor table splitting?
- A. R3load utilization
- B. R3ta
- C. Table comparison
- D. Log tail Viewer
Answer: C
NEW QUESTION # 79
Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Please choose the correct answer.
- A. Balance table distribution
- B. Redistribute tables after adding host(s)
- C. Check the number of partitions
- D. Check the correct location of tables and partitions
Answer: C
NEW QUESTION # 80
Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.
- A. Thread throttling
- B. Workload classes
- C. Capture and replay
- D. Admission control
Answer: B,D
NEW QUESTION # 81
Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.
- A. Multiple user group operators per user group
- B. Only one user group operator per user group
- C. Multiple user groups per user group operator
- D. Only one user group per user group operator
Answer: B,C
NEW QUESTION # 82
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?
Please choose the correct answer.
- A. Kernel profiler
- B. User-Specific
- C. SQL
- D. End-to-End
Answer: A
NEW QUESTION # 83
How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.
- A. Backup the complete storage system.
- B. Back up the system database and all tenant databases individually.
- C. Back up the complete database system.
- D. Back up the system database and all tenant databases in one step.
Answer: B
NEW QUESTION # 84
One of your systems show the internal Disk Full (Alert 30) alert. What is the root cause of this alert?
- A. Reading from the /hana/log/<sid> volume is NOT possible
- B. Writing to the /hana/data/<sid> volume is NOT possible
- C. Runing out of free space on the /hana/shared volume
- D. Exceeding system quota on the /usr/sap volume
Answer: C
NEW QUESTION # 85
Which of the following recovery types is not supported for delta backups?
- A. Recover the database to a specific data backup.
- B. Recover the database to a specific point in time.
- C. Recover the database to its most recent state.
Answer: A
NEW QUESTION # 86
Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question
- A. Compile server
- B. Preprocessor
- C. XS Engine
- D. Index server
Answer: A,B
NEW QUESTION # 87
Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server?
There are 2 correct answers to this question.
- A. User creation
- B. User mapping
- C. Password policy configuration
- D. Role assignment
Answer: A,D
NEW QUESTION # 88
......
To ensure that candidates are adequately prepared for the exam, SAP recommends that they have a minimum of one year of practical experience working with SAP HANA systems. They should also have a thorough understanding of SAP HANA architecture, data modeling, security, and performance optimization. This knowledge will be tested through a series of multiple-choice questions and practical exercises during the exam.
Truly Beneficial For Your SAP Exam: https://whizlabs.actual4dump.com/SAP/C_HANATEC_17-actualtests-dumps.html