Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: cramtreat

C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Questions and Answers

Questions 4

Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start?

Please choose the correct answer.

Options:

A.

hdbcons

B.

RecoverStateCheckerpy

C.

sap control

D.

HDBAdmin

Buy Now
Questions 5

Which prerequisites must be fulfilled when recovering a tenant database? There are 2 correct answers to this question.

Options:

A.

Before the recovery starts, the tenant database must be stopped.

B.

The whole system is shut down, including all tenant databases

C.

You need the logon credentials of the adm user.

D.

You need the logon credentials of the system database user.

Buy Now
Questions 6

What are the merge methods that are triggered by the SAP HANA system processes? There are 2 correct answers to this question.

Options:

A.

Critical

B.

Auto

C.

Hard

D.

Smart

Buy Now
Questions 7

Which prerequisites are necessary for productively using SAP HANA cockpit 2.0?

There are 2 correct answers to this question.

Options:

A.

10 GBit/s network bandwidth

B.

16 GB RAM on a dedicated server

C.

An intel-based system with operating system Microsoft Windows

D.

An IBM Power System with operating system SUSE Linux Enterprise Server (SLES)

Buy Now
Questions 8

A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.

Options:

A.

recover the system database and the affected tenant with the initialize log area option

B.

restore the database and recover the affected tenant upto moment of the problem

C.

recover the affected tenant upto moment of the problem

D.

recover the affected tenant with the initialize log area option

Buy Now
Questions 9

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

Options:

A.

The R3LDCTL

B.

The Process Bucket monitor

C.

The Log viewer

D.

The Observer Monitor

Buy Now
Questions 10

Which operations are performed by SAP Landscape Management? Note: There are 2 correct answers.

Options:

A.

It de-centralizes landscape operations and provides local landscape view

B.

It automizes repetitive, time-intensive administration tasks

C.

It simplifies the management of SAP hybrid landscapes and standardizes SAP operations

D.

It replicates the storage in SAP landscape

Buy Now
Questions 11

How do you trigger a savepoint in an SAP HANA database?

Options:

A.

Execute a delta merge

B.

Commit a transaction

C.

Start a log backup

D.

Perform a soft shutdown

Buy Now
Questions 12

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.

Options:

A.

HANASitter

B.

hdbcons

C.

HDBAdmin

D.

Sapcontrol

Buy Now
Questions 13

Which tool do you use to backup the root encryption keys?

Options:

A.

rsecssfx

B.

hdbuserstore

C.

dbacockpit

D.

hdbnsutil

Buy Now
Questions 14

You created a restricted user in the DB1 database. Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user? There are 3 correct answers to this question.

Options:

A.

ALTER USER GRANT ROLE PUBLIC

B.

ALTER USER ENABLE CLIENT CONNECT

C.

ALTER USER ACTIVATE USER NOW

D.

ALTER USER GRANT CREATE ANY ON OWN SCHEMA

E.

ALTER USER ADD REMOTE IDENTITY

Buy Now
Questions 15

What is the recommended disk space for /hana/shared/ for single-node SAP HANA systems? Please choose the correct Answer:.

Options:

A.

Size [installation(single-node)] = MIN (2 x RAM; 2 TB)

B.

Size [installation(single-node)] = MIN (1 x RAM; 1 TB)

C.

Size [installation(single-node)] = MIN (2 x RAM; 1 TB)

D.

Size [installation(single-node)] = MAX (2 x RAM; 1 TB)

Buy Now
Questions 16

The network security policies of your project restrict direct SQL connections to the SAP HANA databases. Which tools can you use to monitor the SAP HANA database? Note: There are 2 correct answers.

Options:

A.

SAP Landscape Management

B.

SAP HANA Cockpit

C.

SAP HANA Data Management Suite

D.

SAP Solution Manager

Buy Now
Questions 17

Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

Options:

A.

Cockpit User Administrator

B.

Cockpit User

C.

Cockpit Resource Administrator

D.

Cockpit Administrator

Buy Now
Questions 18

Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers.

Options:

A.

SAP HANA cockpit 2.0 - Manage Databases

B.

hdbsql

C.

SAP HANA Studio - System view

D.

sapcontrol

Buy Now
Questions 19

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

Options:

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

Buy Now
Questions 20

What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.

Options:

A.

Row and Delta store.

B.

Insert only on Column store.

C.

Partitioning.

D.

Compression and Decompression.

Buy Now
Questions 21

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? Please choose the correct answer.

Options:

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

Buy Now
Questions 22

Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?

Please choose the correct answer.

Options:

A.

SQL

B.

User-Specific

C.

End-to-End

D.

Kernel profiler

Buy Now
Questions 23

Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

Options:

A.

DBA Cockpit

B.

hdblcm

C.

hdbsql

D.

SAP HANA cockpit

Buy Now
Questions 24

You need to periodically monitor if the SAP HANA primary system is online. Which tool do you use?

Options:

A.

systemreplicationStatus

B.

HDBAdmin

C.

hanasitter

D.

landscapeHostConfiguration

Buy Now
Questions 25

Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers.

Options:

A.

Rename the SAP HANA Database hostname

B.

Remove host roles

C.

Transport application changes

D.

Rename the SAP HANA database system

E.

Uninstall the individual components

Buy Now
Questions 26

Where are the R3load processes located when performing the Database Migration Option (DMO) procedure using the in-place migration? Please choose the correct answer.

Options:

A.

On the Additional Application Server (AAS) host

B.

On the source and target host

C.

On the remote target database host

D.

On the Primary Application Server (PAS) host

Buy Now
Questions 27

Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers to this question.

Options:

A.

Production

B.

Custom

C.

Test

D.

Sandbox

E.

Development

Buy Now
Questions 28

What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question.

Options:

A.

Having the data and log volumes on the different disks.

B.

Obtaining the hardware certification from SAP for the existing hardware you are going to use.

C.

Obtaining C_HANATEC_XX Certification.

D.

Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.

Buy Now
Questions 29

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.

Options:

A.

basepathjogmirror

B.

basespath_export

C.

basepathjogbackup

D.

basepath_databackup

Buy Now
Questions 30

Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers.

Options:

A.

User certificate

B.

Server certificate

C.

X.509 certificate

D.

Root certificate

Buy Now
Questions 31

Which tools can you use to start and stop an SAP HANA database? Note: There are 3 correct answers.

Options:

A.

DBA cockpit

B.

SAP HANA application life cycle management (HDBLCM)

C.

HDB command

D.

SAP HANA cockpit

E.

Sapcontrol

Buy Now
Questions 32

logical error occurred in one tenant of your SAP HANA database. What action do you perform to make the tenant consistent again? Please choose the correct Answer:

Options:

A.

Recover the affected tenant. The system database is NOT recovered.

B.

Recover the system database first and then recover the affected tenant.

C.

Recover the affected tenant first and then recover the system database.

D.

Recover the system database. The affected tenant is recovered automatically.

Buy Now
Questions 33

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.

Options:

A.

max_queue_size

B.

queue_wait_time_threshold

C.

record_limit

D.

queue_timeout

Buy Now
Questions 34

In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?

Options:

A.

Indexserve.ini

B.

Nameserver.ini

C.

Multidb.ini

D.

Sapprofile.ini

Buy Now
Questions 35

Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.

Options:

A.

CPU threshold for rejecting new requests

B.

Memory threshold for queuing new request

C.

Memory limits for new SQL statement requests

D.

Maximum queue size for requests

E.

Maximum number of parallel request

Buy Now
Questions 36

Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question.

Options:

A.

GPFS

B.

EXT3

C.

MPFS

D.

Dxfs

Buy Now
Questions 37

Out of complete SAP HANA platform, which from the following components are not part of SAP HANA Database? There are 3 correct answers to this question.

Options:

A.

HWCCT

B.

Database Services

C.

Smart Data Access

D.

INA file loader

E.

EPM Services

Buy Now
Questions 38

You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?

Options:

A.

After the migration

B.

Before table creation

C.

After table creation

D.

Before the migration

Buy Now
Questions 39

Which role do you need in order to assign users to groups in the SAP HANA cockpit?

Please choose the correct answer.

Options:

A.

Cockpit User Role

B.

Cockpit Administrator Role

C.

Cockpit User Administrator Role

D.

Cockpit Database Administrator Role

Buy Now
Questions 40

Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor?

There are 3 correct answers to this question.

Options:

A.

Memory and CPU consumption from the SAP HANA database.

B.

Disk consumption from the SAP HANA database.

C.

Connection statistics about open connections.

D.

The time at which the database was started.

Buy Now

SAP Certified Technology Associate | C_HANATEC_17 Questions Answers | C_HANATEC_17 Test Prep | SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Questions PDF | C_HANATEC_17 Online Exam | C_HANATEC_17 Practice Test | C_HANATEC_17 PDF | C_HANATEC_17 Test Questions | C_HANATEC_17 Study Material | C_HANATEC_17 Exam Preparation | C_HANATEC_17 Valid Dumps | C_HANATEC_17 Real Questions | SAP Certified Technology Associate C_HANATEC_17 Exam Questions

Exam Code: C_HANATEC_17
Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05
Last Update: May 4, 2024
Questions: 270
C_HANATEC_17 pdf

C_HANATEC_17 PDF

$28  $80
 Add to Cart
C_HANATEC_17 Engine

C_HANATEC_17 Testing Engine

$33.25  $95
 Add to Cart
C_HANATEC_17 PDF + Engine

C_HANATEC_17 PDF + Testing Engine

$45.5  $130
 Add to Cart