top of page
  • Writer's pictureSeema Iyer

Introduction to SAP Certified Technology Associate - SAP HANA 2.0 (SPS03) Exam

HANA Technology (C_HANATEC_15) preparation guide helps you to get focused on exam. This guide also helps you to be on C_HANATEC_15 exam track to get certified with good score in the

final exam.



C_HANATEC_15 HANA Technology Exam Summary

Exam Syllabus: C_HANATEC_15 SAP Certified Technology Associate - SAP HANA 2.0 (SPS03)


1. SAP HANA Installation & Upgrade (8% - 12%)

Describe the installation, update and configuration process for the SAP HANA database and the SAP HANA Cockpit 2.0 Definitions.

Books: HA200, HA201 OR SAP HANA Admin.& Installation LR

2. Users, Authorization and Security (8% - 12%)

Explain the different SAP HANA security and authentication methods, and maintain users, roles and privileges.

Books: A240, HA200 OR SAP HANA Admin.& Installation LR

3. Database Migration to SAP HANA (8% - 12%)

Understand and use the SAP HANA Database Migration Option tool.

Books: HA250 OR SAP HANA Admin.& Installation LR

4. High Availability & Disaster Tolerance (8% - 12%)

Understand, install and configure the SAP HANA High Availability and Disaster Tolerance features.

Books: HA201 OR SAP HANA Admin.& Installation LR

5. Backup & Recovery (8% - 12%)

Describe the SAP HANA backup and recovery concept, and be able to perform backup and recovery tasks.

Books: HA200, HA201 OR SAP HANA Admin.& Installation LR

6. Multitenant Database Containers (8% - 12%)

Understand the concept of SAP HANA Multitenant Database Containers and be able to administrate Multitenant systems.

Books: HA200, HA201, HA215 OR SAP HANA Admin.& Installation LR

7. Monitoring and troubleshooting of SAP HANA (8% - 12%)

Be able to use the SAP HANA monitor tools to trouble shoot the database.

Books: HA200, HA215 OR SAP HANA Admin.& Installation LR

8. Database Administration Tools and Tasks (8% - 12%)

Understand and use the different SAP HANA administration tools.

Books: HA200, HA201 OR SAP HANA Admin.& Installation LR

9. System Architecture (8% - 12%)

Understand the SAP HANA database arcitecture, the SAP HANA Memory Management and the data persistence.

Books: HA200 OR SAP HANA Admin.& Installation LR

10. Performance and System Tuning (8% - 12%)

Books: HA215 OR SAP HANA Admin.& Installation LR

SAP C_HANATEC_15 Certification Sample Questions and Answers

To make you familiar with HANA Technology (C_HANATEC_15) certification exam structure, we have prepared this sample question set. We suggest you to try our Sample Questions for HANA Technology 2.0 (SPS03) C_HANATEC_15Certification to test your understanding of SAP C_HANATEC_15process with real SAP certification exam environment.

C_HANATEC_15HANA Technology Sample Questions:-

01. 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?

a) Balance table distribution

b) Check the correct location of tables and partitions

c) Check the number of partitions

d) Redistribute tables after adding host(s)

02. You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one server. This system will be your customer’s productive system. Which of the following installation requirements are mandatory?

There are 2 correct answers to this question.

a) The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.

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 disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

03. The data storage of your productive SAP HANA instance crashed, and you need to recover the database. The log storage is still intact.

You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss?

a) The latest log backup

b) The latest incremental backup

c) The last commited transaction

d) The last full data backup

04. 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) SAP Application Performance Standard (SAPS)

c) Main memory

d) Persistent storage

e) Network throughput

05. 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?

a) An upgrade of the primary system

b) A restart of the primary system

c) An upgrade of the secondary system

d) A restart of the secondary system

06. You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?

a) Modeling

b) Runtime

c) Monitoring

d) Repository

07. 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) max_queue_size

b) queue_timeout

c) record_limit

d) queue_wait_time_threshold


08. You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which advanced DMO options can you adjust to speed up the migration?

There are 2 correct answers to this question.

a) R3trans processes

b) TP processes

c) SQL processes

d) SAPup processes


09. Where is the name server running in a multitenant database container system?

a) Master node

b) SYSTEMDB

c) Standby node

d) Each tenant


10. Which tools do you use to delete diagnosis files?

There are 2 correct answers to this question.

a) SAP HANA cockpit

b) SAP HANA database explorer

c) SAP HANA cleaner

d) SAP HANA Web-based Development Workbench


Solutions:


QUESTION: 01- Answer: c

QUESTION: 02- Answer: a, c

QUESTION: 03- Answer: c

QUESTION: 04- Answer: b, c, d

QUESTION: 05- Answer: a

QUESTION: 06- Answer: d

QUESTION: 07- Answer: c, d

QUESTION: 08- Answer: a, c

QUESTION: 09- Answer: b

QUESTION: 10- Answer: a, d

150 views0 comments
bottom of page