Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Free Practice Exam Questions (2025 Updated)

Prepare effectively for your SAP C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Page: 3 / 5
Total 270 questions

In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function? There are 2 correct answers to this question.

A.

The input parameter must be set to mandatory.

B.

The function can return multiple values.

C.

The function must be of the type scalar.

D.

The generated value can be overwritten at runtime.

You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?

A.

A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema

B.

A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema

C.

A multitenant configuration with SYSTEMDB

D.

The target database on SAP HANA 2.0 SPS00 or higher

Which authentication method can you configure for single sign-on in a middleware/application server scenario.

A.

JSON web token

B.

SAML

C.

Kerberos

D.

X.509 certificate

What cryptographic libraries are supported in SAP HANA by default?

There are 2 correct answers to this question.

A.

LibgCrypt

B.

OpenSSL

C.

Common Cryptolib

D.

WolfCrypt

What is the minimum space requirement for the Data Volume? There are 2 correct answers to this question.

A.

3 * RAM (Appliance)

B.

1.2 * RAM (TDI)

C.

Min. 1 * RAM

D.

Min. 0.5 * RAM

You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory

allocated and service 2 has 40 GB allocated. What is the effective allocation limit of service 3?

A.

100 GB

B.

90 GB

C.

35 GB

D.

25 GB

Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.

A.

_SYS_WORKLOAD_REPLAY

B.

_SYS_STATISTICS

C.

_SYS_SQL_ANALYZER

D.

_SYS_TELEMETRY

Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? There are 2 correct answers to this question.

A.

memory_tracking

B.

statement_memory_limit

C.

reject_memory_threshold

D.

total_statement_memory_limit

How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

A.

Set up cross-database access control

B.

Set database isolation levels to high

C.

Edit the configuration change blacklist

D.

Assign internal communication ports

Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.

A.

The same number of active hosts and standby hosts must be installed

B.

Both must have the same SAP HANA version

C.

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

D.

The CPU architecture must be identical

Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure?

There are 2 correct answers in this question.

A.

The SUM folder needs to exist.

B.

The source database is up and running.

C.

The DMO procedure hasn't reached downtime yet.

D.

A cleanup has already been triggered.

What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.

A.

Predictive algorithms

B.

Flowgraphs

C.

Text mining functions

D.

Data preparation functions

What are some of the characteristics of the design-time role? There are 3 correct answers to this question.

A.

The role can be transported between systems.

B.

The role is revoked if the grantee user is deleted.

C.

The role is granted and revoked directly by the database user.

D.

The role is created by technical user _SYS_REPO.

E.

The role is granted through the execution of stored procedures.

Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.

A.

Admission control

B.

Capture and replay

C.

Thread throttling

D.

Workload classes

Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.

A.

The R3LDCTL

B.

The Process Bucket monitor

C.

The Log viewer

D.

The Observer Monitor

Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL? There are 2 correct answers to this question.

A.

HANASitter

B.

hdbcons

C.

HDBAdmin

D.

Sapcontrol

Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question.

A.

Migrating to a target database, g. SAP HANA

B.

Performing an SAP software update

C.

Performing a Unicode conversion

D.

Performing a database upgrade of the source database

Which action do you perform when the data area in an SAP HANA database is running out of space?

A.

Create a new tenant database

B.

Extend the file system size in the operating system level

C.

Extend the size of the database volume

D.

Create a new database volume

Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.

A.

375 GB

B.

1.5 TB

C.

512 GB

D.

1.0 TB

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

Page: 3 / 5
Total 270 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved