Introduction to SAP Certified Technology Associate - SAP HANA 2.0 SPS06 Exam
HANA Technology (C_HANATEC_18) preparation guide helps you to get focused on exam. This guide also helps you to be on C_HANATEC_18 exam track to get certified with good score in the final exam.
C_HANATEC_18 HANA Technology Exam Summary
● Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS06
● Exam Code: C_HANATEC_18
● Level: Associate
● Exam Price: $500 (USD)
● Duration: 180 mins
● Number of Questions: 80
● Passing Score: 60%
● Reference Books:
● Schedule Exam: SAP Training
● Sample Questions: SAP HANATEC 18 Certification Sample Question
● Recommended Practice: SAP HANATEC 18 Certification Practice Exam
Exam Syllabus: C_HANATEC_18 SAP Certified Technology Associate - SAP HANA 2.0 SPS06
1. SAP HANA Database Administration
Performing the daily SAP HANA database administration tasks using SAP HANA cockpit.
Books:
● HA200 (SAP HANA 2.0 SPS06)
● HA201 (SAP HANA 2.0 SPS06)
● HA215 (SAP HANA 2.0 SPS06)
● HA250 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
2. SAP HANA High Availability and Disaster Recovery
Install, configure and monitor SAP HANA database systems that are setup in a scale-out or in system replication configuration.
Books:
● HA200 (SAP HANA 2.0 SPS06)
● HA201 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
3. Sizing, Installation, update and post-installation tasks for SAP HANA and SAP HANA cockpit
Performing sizing, installation, update and post-installation tasks for the SAP HANA database and SAP HANA cockpits.
Books:
● HA200 (SAP HANA 2.0 SPS06)
● HA201 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
4. SAP HANA Architecture and Deployment Options
Describing the SAP HANA database system architecture and the different deployment options.
Books:
● HA100 (SAP HANA 2.0 SPS06)
● HA200 (SAP HANA 2.0 SPS06)
● HA201 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
5. SAP HANA Backup and Recovery
Configure and execute SAP HANA database system backups and restores in single host and system replication setups.
Books:
● HA200 (SAP HANA 2.0 SPS06)
● HA201 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
6. SAP HANA Database Security
Understand the SAP HANA database system security concepts, create SAP HANA users and roles and setup audit policies.
Books:
● HA200 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
7. Database Migration Options for SAP HANA
Be able to perform database migrations from AnyDB to SAP HANA using the Database Migration Option (DMO) of SUM.
Books:
● HA100 (SAP HANA 2.0 SPS06)
● HA200 (SAP HANA 2.0 SPS06)
● HA250 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
8. SAP HANA Monitoring and Troubleshooting
Monitor and analyze the performance of SAP HANA systems, and be able to troubleshoot problems and perform Root Cause Analysis using the SAP HANA cockpit and SAP HANA database explorer.
Books:
● HA200 (SAP HANA 2.0 SPS06)
● HA201 (SAP HANA 2.0 SPS06)
● HA215 (SAP HANA 2.0 SPS06) OR
● SAP HANA Admin.& Installation LR
SAP C_HANATEC_18 Certification Sample Questions and Answers
To make you familiar with HANA Technology (C_HANATEC_18) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for HANA Technology 2.0 (SPS06) C_HANATEC_18 Certification to test your understanding of SAP C_HANATEC_18process with real SAP certification exam environment.
C_HANATEC_18HANA Technology Sample Questions:-
01. Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)?
There are 3 correct answers to this question.
a) Validation of the operating system configuration settings for the Linux kernel
b) Measurement of the data throughput between CPU and DRAM
c) Measurement of data throughput between SAP HANA nodes and storage
d) Validation of the LPAR configuration settings on IBM Power servers
e) Measurement of data throughput between the Linux kernel and CPU
Answer: a, c, d
02. In which cases 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) To extend the scale-out memory
b) To actively free up memory
c) To optimize the standby node memory
d) To measure total table memory
Answer: b, d
03. Which services are located in a tenant database?
Please choose the correct answer.
a) Name server
b) Index server
c) Web Dispatcher
d) Compile server
Answer: b
04. SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems?
Please choose the correct answer.
a) A restart of the primary system
b) A restart of the secondary system
c) An upgrade of the secondary system
d) An upgrade of the primary system
Answer: d
05. You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one productive system. Which of the following installation requirements are mandatory?
There are 2 correct answers to this question.
a) The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
b) The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
c) The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.
d) The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
Answer: c, d
06. 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) Check the number of partitions
b) Check the correct location of tables and partitions
c) Redistribute tables after adding host(s)
d) Balance table distribution
Answer: a
07. What are the supported operating systems for SAP HANA on IBM Power Servers?
There are 2 correct answers to this question.
a) For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 7.2
b) For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP2
c) For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.3 and 8.x
d) For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15
Answer: c, d
08. SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log?
There are 2 correct answers to this question.
a) queue_wait_time_threshold
b) record_limit
c) queue_timeout
d) max_queue_size
Answer: a, b
09. What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario?
There are 3 correct answers to this question.
a) Input/output operations per second (IOPS)
b) Network throughput
c) Persistent storage
d) SAP Application Performance Standard (SAPS)
e) Main memory
Answer: c, d, e
10. You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager.
Which processes can you adjust in the advanced mode to speed up the migration?
There are 2 correct answers to this question.
a) TP
b) SQL
c) SAPup
d) R3trans
Answer: b, d