SAP Certified Technology Associate - SAP HANA 2.0 SPS05

Here you have the best SAP C_HANATEC_17 practice exam questions

You have 38 total questions to study from
Each page has 5 questions, making a total of 8 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on May 9, 2025
This site is not affiliated with or endorsed by SAP.

Question 1 of 38

Which schema provides performance data and alert details to review in SAP HANA mini-checks?

SAP_XS_USAGE

COCKPIT_MONITOR

_SYS_SQL_ANALYZER

_SYS_STATISTICS

Correct Answer: D

The _SYS_STATISTICS schema in SAP HANA is responsible for providing performance data and alert details. This schema contains the views generated by the statistics server, which collect historical performance data and system alerts. These statistics are crucial for monitoring the system's health and performance, making it the correct schema for reviewing performance data and alert details in SAP HANA mini-checks.

Question 2 of 38

Which system privilege do you need to redistribute tables across the hosts in a scale-out system?

WORKLOAD ADMIN

RESOURCE ADMIN

DATA ADMIN

OPTIMIZER ADMIN

Correct Answer: B

To redistribute tables across the hosts in a scale-out system, you need the RESOURCE ADMIN privilege. This privilege allows for the management of resources within the system, including the redistribution of tables. Managing resources, such as data distribution, is a critical operation that falls under RESOURCE ADMIN privileges.

Question 3 of 38

Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? (Choose two.)

Create credentials for authenticated access to the source system.

Configure a secure connection from target system to source system.

Back up the source tenant database.

Create a tenant on the target system identical to the source system.

Correct Answer: A, C

Before starting the copy and move process for a tenant database, it is essential to create credentials for authenticated access to the source system to ensure that the transfer can be securely initiated and verified. Additionally, backing up the source tenant database is crucial to prevent data loss and provide a recovery point in case of any issues during the transfer. These tasks help to ensure secure, authenticated, and recoverable data transfer processes.

Question 4 of 38

What cryptographic libraries are supported in SAP HANA by default? (Choose two.)

OpenSSL

Libgcrypt

CommonCryptoLib

wolfCrypt

Correct Answer: A, C

SAP HANA supports the following cryptographic libraries by default: OpenSSL and CommonCryptoLib. CommonCryptoLib (libsapcrypto.so) is installed by default as part of the SAP HANA server installation, and the OpenSSL library is part of the operating system installation. Hence, OpenSSL and CommonCryptoLib are the correct answers.

Question 5 of 38

Which prerequisites of the primary system and the secondary system are mandatory before you can activate SAP HANA system replication with secondary time travel? (Choose two.)

Both systems are located in the same data center.

Both must have the same SAP HANA version.

An explicit read-only connection between both systems must be available.

The CPU architecture must be identical.

Correct Answer: B, D

Both must have the same SAP HANA version because different versions are not compatible with each other for replication purposes. The CPU architecture must be identical to ensure compatibility and proper functioning of the replicated systems. Other prerequisites, such as being located in the same data center or having an explicit read-only connection, are not mandatory for the activation of SAP HANA system replication with secondary time travel.