SAP C_HANATEC_17 SAP Certified Technology Associate – SAP HANA 2.0 SPS05 Online Training
SAP C_HANATEC_17 Online Training
The questions for C_HANATEC_17 were last updated at Nov 01,2025.
- Exam Code: C_HANATEC_17
 - Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
 - Certification Provider: SAP
 - Latest update: Nov 01,2025
 
You installed an SAP Netweaver-based application on an SAP HANA database .
What is the default secure user store to store the password of the SAP<schema-id> user?
- A . hdbuserstore
 - B . xuser
 - C . Secure store in file system (SSFS)
 - D . ABAP secure store file system (SSFS)
 
In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.
- A . Customers want to migrate their existing SAP NetWeaver-based systems to run on SAP HANA
 - B . Consolidating multiple ERP source systems into one ERP system on SAP HANA
 - C . Carving out ERP functionality from the source system to the ERP on SAP HANA system.
 - D . Customers are new to SAP applications and SAP HANA
 
You need to update the location where a copy of the persistent data is saved .
Which of the following parameters do you change? Note: There are 2 correct answers.
- A . basepathjogmirror
 - B . basespath_export
 - C . basepathjogbackup
 - D . basepath_databackup
 
When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question.
- A . When you need to extend the scale-out memory
 - B . When you need to optimize the standby node memory.
 - C . When you need to measure total memory
 - D . When you need to actively free up memory.
 
Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question.
- A . <sid>crypt
 - B . sap<sid>
 - C . Idapadm
 - D . sapadm
 
Why do we still need a persistent layer? There are 2 correct answers to this question.
- A . To store data that has been unloaded from memory
 - B . To enable full database recovery if we have a power failure
 - C . To hold the delta store for newly arrived records
 - D . To store data that is frequently used
 
Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question
- A . Preprocessor
 - B . XS Engine
 - C . Index server
 - D . Compile server
 
What are advantages of column store tables? There are 3 correct answers to this question.
- A . Columns can be partitioned
 - B . Only the columns required are actually loaded to memory
 - C . They are optimized for high-volume read /write transactional processing
 - D . Data footprint is automatically reduced through compression
 
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 Test Cycle opt on to find the optimal number of R31oad processes in a test run.
 - D . Use the benchmarking option to find the optimal throughput during the DMO procedure.
 
A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.
- A . recover the system database and the affected tenant with the initialize log area option
 - B . restore the database and recover the affected tenant upto moment of the problem
 - C . recover the affected tenant upto moment of the problem
 - D . recover the affected tenant with the initialize log area option