Skip to Content
Technical Articles

Get Certified: C_HANATEC_17 | Sample Questions

DISCLAIMER

Sample questions are .,. SAMPLE QUESTIONS!

Yes, that’s right. Just sample questions, folks.

Not real exam questions. Just sample questions.

SAP Certified Technology Associate – SAP HANA 2.0 SPS05

In this post, you will find some personal suggestions about how to get certified as SAP Certified Technology Associate – SAP HANA 2.0 SPS 05. This exam is available as of December 2020.

For the posts about the SAP HANA 2.0 SPS 05 exams, see

For the post about the previous edition, see

For the posts about the SAP Cloud Platform exams, see

About braindumps and cheat sheets, see

Questions? Post as comment.

Useful? Give us a like and share on social media.

Thanks!

/wp-content/uploads/2016/02/sapnwabline_885687.png

Sample Questions

On the exam page, there is a View more link to the sample questions. This opens a sample exam, similar to the real thing.

SPOILER ALERT!!!!

Before proceeding, first try the sample questions yourself.

As the saying goes, we learn most from our own mistakes!

>>> Take the Sample Exam <<<<

What’s New

Compared to the SPS04 sample exam, five questions are new and listed first, followed by the SPS04 questions, marked with a little star * (asterisk).

No Explanation

The sample exam has 10 questions. When you submit the exam you will get feedback about how many questions you got right. For the ones you got wrong, the right answer is provided.

The sample exam does not provide information about WHY an answer is right or wrong. In this post we will comment upon the sample questions (and answers).

Of course, no point memorising the material as the questions below are not included in the real exam. What does help is to know where you can find this documented and to assess how familiar you are with the material.

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question

Which services are located in a tenant database?

  1. Name server
  2. Compile server
  3. Index server
  4. Web Dispatcher

=====

Correct answer: C

Explanation

The index server, which runs in every tenant database (but not the system database), contains the actual data stores and the engines for processing the data.

The name server, which runs in the system database only, owns the information about the topology of the SAP HANA system, including knowledge of the tenant databases that exist in the system.

The compile server performs the compilation of stored procedures and programs, for example, SQLScript procedures. It runs on every host and does not persist data. It runs in the system database and serves all tenant databases.

The Web Dispatcher processes inbound HTTP and HTTPS connections to XS classic services.

As documented

Commentary

Topic Area: SAP HANA Architecture and Deployment Options (< 8%).

This question tests your understanding of the SAP HANA architecture. This should be an easy question to answer.

With the introduction of tenant databases in SAP HANA 1.0 SPS 09 (at the time known as multi-tenant database container or MDC systems), the role of the name server component changed to include the system database. Service management for several shared services like the webdispatcher, compileserver, and preprocessor is performed when connected to the system database.

Note that the Stop|Start Service button in the Action column is disabled for the services labeled (shared). Only the indexserver and xsengine service (when not running embedded) can be managed when connect to a tenant database.

Note the format of question: a short statement, short question, short answers. This is typical for the exam questions. You will not be tested for your command of the English language. The questions are phrased as simple as possible.

As illustrated, this is a radio button question. If only a single answer is correct, you can only provide a single answer. The format of the questions and answers is not intended to trick you.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question

In which cases can you load and unload individual tables and table columns manually in an SAP HANA tenant database?

Note: There are 2 correct answers to this question.

  1. To optimize the standby node memory
  2. To extend the scale-out memory
  3. To actively free up memory
  4. To measure total table memory

====

Correct answers: C, D

Explanation

As the SAP HANA database automatically manages the loading and unloading of tables it is not normally necessary to manually load and unload individual tables and table columns. However, this may be necessary for example:

  • To precisely measure the total or “worst case” amount of memory used by a particular table (load)
  • To actively free up memory (unload)

As documented

Commentary

Topic Area: SAP HANA Database Administration (8% – 12%).

Question tests your understanding of SAP HANA memory and table management. As documented, there are some scenarios where you might want to manually load and unload tables.

We can configure a multiple host system (also known as distributed or scale-out system) for high availability (HA) by adding a standby host. To reduce the time needed to take over the role of a failed worker host, all data is loaded but the system does not accept any connections (idle). To reduce the total cost of ownership (TCO) of this solution, SAP HANA supports running the instance without any data loaded to free up memory to run additional non-productive SAP HANA systems for training, test, or development purposes. This comes at the expense of a longer takeover time. Loading and unloading tables does not optimise or extent the memory configuration of scale-out systems.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question

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?

Note: There are 2 correct answers to this question.

  1. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
  2. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
  3. The System ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.
  4. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.

===

Correct answers: C, D

Explanation

SAP HANA and SAP NetWeaver AS ABAP on one server is generally available for all productive and non-productive single-node installations (…). Requirements:

  • Additive sizing – Additional memory resources for the SAP NetWeaver AS ABAP system needs to be available on the SAP HANA server. For more information on memory sizing, see the documents attached.
  • Separate SID‘s for both systems required.
  • SAP HANA software installation – Only software installed by certified hardware partners, or any person holding certification, is recommended for use on the SAP HANA system.

As documented

Commentary

Topic Area: SAP HANA Architecture and Deployment Options (< 8%).

Question tests your general understanding of SAP HANA system architecture. This should be an easy question to answer.

Persistence for the database (SAP HANA) and the application server (SAP NetWeaver AS ABAP) can be shared for non-productive system to simplify configuration. For production systems, however, separate storage subsystems will be typical due to the different throughput (IOPS) and backup requirements.

When running SAP HANA as multiple-host system, the instance number and SID on all hosts must be the same. This also applies to SAP NetWeaver AS ABAP, as it shares the concept and architecture (more precisely, SAP HANA inherited the architecture via SAP NetWeaver TREX).

As the database (SAP HANA) and the application server (SAP NetWeaver AS ABAP) are different products, they cannot use the same SID and/or instance number on the same host.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question

What are the supported operating systems for SAP HANA on IBM Power Servers?

Note: There are 2 correct answers to this question.

  1. For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.3 and 8.x
  2. For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP2
  3. For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 7.2
  4. For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15

====

Correct answers: A, D

Explanation

Supported Operating Systems for SAP HANA 2.0 on IBM Power Systems are documented in an SAP Support Note.

SAP HANA 1.0 on IBM Power Systems requires SLES 11 SP4 and does not support RHEL.

As documented

Commentary

The Master Guide provides generic guidelines about hardware and software requirements, which should be familiar.

For detailed information, we need to consult the note where we find exactly which SLES/RHEL operating system and SP is supported with corresponding SAP HANA SPS release.

For SAP HANA 2.0 SPS 05 these are

  • Red Hat Enterprise Linux (RHEL) 7.6 and later; 8.1 and later
  • SUSE Linux Enterprise Server (SLES) 12 SP4 and later; 15 (GA) and later

We may expect that an SAP HANA administrator knows where to find this information but not to memorise it. This might be the reason this question was pulled from the actual exam.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question

Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)?

Note: There are 3 correct answers to this question.

  1. Measurement of data throughput between SAP HANA nodes and storage
  2. Measurement of data throughput between the Linux kernel and CPU
  3. Validation of the LPAR configuration settings on IBM Power servers
  4. Measurement of the data throughput between CPU and DRAM
  5. Validation of the operating system configuration settings for the Linux kernel

====

Correct answers: A, C, E

Explanation

HWCCT provides the following checks:

  • Validation of hardware setup such as memory configuration (DIMM population rules) or core/memory ratio
  • Validation of operating system settings such as Linux kernel settings (e.g. transparent huge pages configuration) and supported Linux distributions
  • Measurement of data throughput rates and latency times between the SAP HANA computing nodes and the external storage system
  • Measurement of the minimum bandwidth of the intra-node network i.e. the bandwidth available between the SAP HANA computing nodes which comprise a multi-node system
  • Check of LPAR settings on IBM Power servers

As documented,

Commentary

For SAP HANA 2.0, SAP recommends to use SAP HANA hardware and cloud measurement tools (HCMT) and not the older Hardware Configuration Check Tool (HWCCT).

A new section about HCMT was added to the HA200 manual and we might expect a question about this tool on the exam.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question*

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?

Note: There are 2 correct answers to this question.

  1. TP
  2. SQL
  3. SAPup
  4. R3trans

===

Correct answers: B, D

Explanation

Dialog Parallel Processes Configuration: Configure the number of parallel SQL and R3load processes.

As documented

The illustration shows that the ABAP, SQL, R3rans and R3load processes are configurable.

SAPup is the executable (process) that performs the SUM tasks but it is not adjustable in advanced mode to speed up the migration.

TP is a calculated value and not configurable.

Commentary

To answer this question correctly you need to be familiar with the Data Migration Option (DMO) of the Software Update Manager (SUM). This is one of the topic areas of the C_HANATEC exam and covered in the 2-days training course HA250 Database Migration using DMO – SAP HANA 2.0. This is where the SAP HANA and the SAP NetWeaver learning journeys cross and for SAP HANA administrator without any SAP Basis background probably one of the most challenging parts of the exam.

Recommended Reading

The DMO Guide covers the topic in detail (most material beyond the scope of the exam) with references to relevant and informative SAP Community blog posts.

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question*

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?

Note: There are 2 correct answers to this question.

  1. queue_wait_time_threshold
  2. record_limit
  3. queue_timeout
  4. max_queue_size

Correct answers: A, B

Explanation

As documented

System parameters max_queue_size and queue_timeout configure queue management.

Commentary

To answer this question correctly you need to be quite familiar with the configuration of the Admission Control feature of Workload Management.

We can use the SAP HANA cockpit Workload Admission Control Settings app, section Admission control log management, to configure the threshold and log records but for the corresponding system parameters we would need to consult the Administration Guide.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question*

What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario?

Note: There are 3 correct answers to this question.

  1. Input/output operations per second (IOPS)
  2. Main memory
  3. Network throughput
  4. Persistent storage
  5. SAP Application Performance Standard (SAPS)

====

Correct answers: B, D, E

Explanation

Sizing is documented in the SAP HANA Master Guide which contains a section about Memory Sizing and CPU Sizing. In addition, the guide mentions:

With TDI phase 5, which was introduced in 2017, the SAPS requirements for the specific customer workload are used to determine the type and number of the processors required.

Commentary

This question may have been retired from the exam because of ambiguity:

  • What do you need to size? Memory, CPU, Disk.
  • How do we perform sizing? By comparing SAPS, IOPS, etc.

The Quicksizer contains a tab for Disk I/O referencing IOPS.

You need to be familiar with the sizing topic for the exam. The link to the Master Guide references a number of SAP Notes you might want to take a look at.

Recommended Reading

SAP Quicksizer for SAP HANA

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question*

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?

  1. Check the number of partitions
  2. Balance table distribution
  3. Redistribute tables after adding host(s)
  4. Check the correct location of tables and partitions

===

Correct answer: A

Explanation

Check the number of partitions: This option evaluates whether or not partitioned tables need to be repartitioned.

As documented

Commentary

Note the uppercase NOT. As a rule, all statements are positive. To avoid any misreading, negative statements are highlighted with uppercase.

This question may have been retired from the exam because the Manage Table Distribution app was renamed in SPS 04 to Table Redistribution Plan Generator. The redistribution plan goals are similar, however so the question is still a good one. It is also a difficult one actually, as all the answers are valid options.

To answer this question correctly, you will need to be familiar with multiple host SAP HANA systems, table partitions and table placement.

Because the question does not specify that host(s) were just added, answer Redistribute tables after adding host(s) is the least likely.

Both Balance table distribution and Check the correct location of tables and partitions concern table placement (as specified in the TABLE_PLACEMENT table) and not partitioning per se. This leaves Check the number of partitions as best remaining candidate.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Question*

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?

  1. A restart of the primary system
  2. A restart of the secondary system
  3. An upgrade of the secondary system
  4. An upgrade of the primary system

====

Correct Answer: D

Explanation

One of the general prerequisites for system replication configuration is that during an upgrade of the system replication landscape, the software version of the current secondary system must be equal or newer to the version of the current primary system. This makes sense logically. New releases are often backwards compatible (to some extent). In our scenario, after upgrading the secondary system, system replication automatically resumes.

As documented

If for some reason you have to stop and restart the primary or the secondary, once the systems are available they will automatically try to get in sync again. There are no manual steps necessary.
Only in case of Near Zero Downtime Upgrades, we need to manually register the original primary as secondary after the upgrade. For this, see Use SAP HANA System Replication for Near Zero Downtime Upgrades

Commentary

Note how the answers are constructed: you have to chose between either restart and upgrade, and between primary and secondary. A good strategy often is to eliminate less plausible answers. With system replication, the secondary system receives its updates from the primary system. This is minimal knowledge about system replication you are expected to know. Hence, one might assume that most operations on the secondary are processed automatically. Both restart and upgrade concern planned maintenance but the first one would be more common. By elimination alone, answer (4) would be the most plausible one.

Recommended Reading

/wp-content/uploads/2016/02/sapnwabline_885687.png

Share and Connect

Questions? Post as comment.
Useful? Give a like and share on social media. Thanks!
If you would like to receive updates, connect with me on

For the author page of SAP Press, visit

2 Comments
You must be Logged on to comment or reply to a post.
  • Hello Denys,

    from my perspective the question “Which checks are executed when you run the Hardware Configuration Check Tool (HWCCT)?” is not a good one. It is a typical theory meets practice question.

    The last time I have used the landscape check in the HWCCT it was very buggy and outdated. At the moment the tool refuses to run because of a missing lib ;-(

    But regarding to the operating system configuration I had a discussion in the summer in the DSAG forum about the HWCT and the checks. Because at this time (maybe it is better now) no parameters or other operating system configuration have been verified by the tool.

    And according to the SAP colleague (unfortunately dsagnet.de seems to be down at the moment) it is not the goal of the tool to verify operating system parameters because it is too dynamic.

    And so I don’t think that answer E is 100% correct at least in the real world 😉

    Kind Regards
    Achim