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

SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Question and Answers

SAP Certified Technology Associate - SAP HANA 2.0 SPS05

Last Update May 4, 2024
Total Questions : 270

We are offering FREE C_HANATEC_17 SAP exam questions. All you do is to just go and sign up. Give your details, prepare C_HANATEC_17 free exam questions and then go for complete pool of SAP Certified Technology Associate - SAP HANA 2.0 SPS05 test questions that will help you more.

C_HANATEC_17 pdf

C_HANATEC_17 PDF

$35  $99.99
 Add to Cart
C_HANATEC_17 Engine

C_HANATEC_17 Testing Engine

$42  $119.99
 Add to Cart
C_HANATEC_17 PDF + Engine

C_HANATEC_17 PDF + Testing Engine

$56  $159.99
 Add to Cart
Questions 1

Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

Options:

A.  

SLAVE

B.  

STANDBY

C.  

WORKER

D.  

MASTER 1

Discussion 0
Questions 2

What is the additional disk space factor required during delta merge operations? Please choose the correct answer.

Options:

A.  

1.2

B.  

1.6

C.  

4.0

D.  

3.0

Discussion 0
Questions 3

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

Discussion 0
Questions 4

Which information is provided by the backup catalog. Please choose the correct Answer:.

Options:

A.  

Backup destination

B.  

Progress of a backup

C.  

Backup configuration

D.  

Backup ID

Discussion 0
Questions 5

The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?

Options:

A.  

Standby memory

B.  

Physical memory

C.  

Resident memory

D.  

Virtual memory

Discussion 0
Questions 6

Which diagnostic file can you use to monitor the status of database recovery?

Options:

A.  

backint.log

B.  

backup.log

C.  

sapstartsrv.log

D.  

available.log

Discussion 0
Questions 7

Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer.

Options:

A.  

DATABASE ADMIN

B.  

WORKLOAD ADMIN

C.  

INIFILE ADMIN

D.  

RESOURCEADMIN

Discussion 0
Questions 8

The SAP HANA database is NOT reachable, and the root cause is unclear. Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

Options:

A.  

Troubleshoot unresponsive system

B.  

Overall database status

C.  

Manage full system information dumps

D.  

Open blocked transactions

Discussion 0
Questions 9

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

Options:

A.  

_SYS_WORKLOAD_REPLAY

B.  

_SYS_STATISTICS

C.  

_SYS_SQL_ANALYZER

D.  

_SYS_TELEMETRY

Discussion 0
Questions 10

Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.

Options:

A.  

Service auto-restart

B.  

Storage replication

C.  

Host auto-failover

D.  

Auto log backups

Discussion 0
Questions 11

Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.

Options:

A.  

The source and target database system are of the same type

B.  

The Primary Application Server can be moved to a target system Landscape

C.  

The target database is SAP Adaptive Server Enterprise (ASE)

D.  

The source system is Application Server (AS) Java-base

Discussion 0
Questions 12

Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.

Options:

A.  

Near Zero Downtime

B.  

Database migration options of SUM

C.  

Export/import using SAP Provisioning Manager

D.  

Phases update

Discussion 0
Questions 13

How do you ensure that Web-based applications send HTTPS requests to specific databases in an SAP HANA multiple-container system? Note: There are 2 correct answers.

Options:

A.  

Check the hostnames mapping to internal HTTPS ports

B.  

Configure an SAP Web Dispatcher for every tenant databases

C.  

Configure an alias hostname for every tenant database

D.  

Check that all requests with physical hostnames are forwarded to tenant databases

Discussion 0
Questions 14

What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool for productive SAP HANA databases?

Options:

A.  

A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL)

B.  

A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed

C.  

A central SAP HANA database 2.0 SPS05 multitenant database system with at least 16 GB of RAM

D.  

SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed

Discussion 0
Questions 15

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

Discussion 0
Questions 16

Which partitioning option distributes rows equally for load balancing in the SAP HANA database?

Options:

A.  

RoundRobin

B.  

Hash

C.  

Range-Range

D.  

Range

Discussion 0
Questions 17

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.

Discussion 0
Questions 18

You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default?

Options:

A.  

$(DIR_INSTANCE)//trace

B.  

$(DIR_INSTANCE)/backup/data

C.  

$(DIR_INSTANCE)/../global/hdb/custom/config

D.  

$(DIR_INSTANCE)/backup/log

Discussion 0
Questions 19

Which of the following are characteristics of SAP HANA Smart Data Streaming?

Options:

A.  

It provides reports and analysis on the received data.

B.  

It is a standalone product for use with any target system.

C.  

It acts based on combinations of events.

D.  

It uses databases queries.

Discussion 0
Questions 20

Which system privilege must you have to redistribute tables across the hosts in your scale-out system?

Options:

A.  

OPTIMIZER ADMIN

B.  

DATA ADMIN

C.  

WORKLOAD ADMIN

D.  

RESOURCE ADMIN

Discussion 0
Questions 21

What are the prerequisites for using the Web user interface for HDBLCM? There are 2 correct answers to this question.

Options:

A.  

The SAP HANA database is revision 90 or higher

B.  

The communication port 1329 is open

C.  

Internet Explorer - Version 8 or higher

D.  

The communication port 1129 is open

Discussion 0
Questions 22

For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

Options:

A.  

Business Suite on HANA

B.  

SAP HANA Live for SAP Business Suite

C.  

SAP S/4HANA

D.  

Web-based native applications based on XS

Discussion 0
Questions 23

Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive SAP HANA system.

Which tools can you use to monitor the system alerts of the SAP HANA database from your PC? There are 2 correct answers to this question.

Options:

A.  

SAP HANA studio

B.  

DBA Cockpit

C.  

SAP NANA cockpit 2.0

D.  

HDBSQL command line tool

Discussion 0
Questions 24

What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.

Options:

A.  

Kernel settings

B.  

Network configuration

C.  

Memory configuration

D.  

Missing OS patches

Discussion 0
Questions 25

In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA? There are 2 correct answers to this question.

Options:

A.  

SAP HANA as a data mart for reporting and analytics.

B.  

SAP HANA as a platform for providing database and application services to native SAP HANA-based applications.

C.  

SAP HANA as a classic three-tier architecture as the primary database (for example. SAP NetWeaver Business Warehouse, SAP Business Suite Installation).

Discussion 0
Questions 26

To ensures that the database can be restored to the most recent committed state after a restart which of the following Indexserver components make sure such consistency and maintain durable

changes?

Options:

A.  

Storage Engine

B.  

Disk Storage

C.  

Relational Engines

D.  

Request Processing

Discussion 0
Questions 27

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.

Options:

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

Discussion 0
Questions 28

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

Discussion 0
Questions 29

Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? There are 3 correct answers to this question.

Options:

A.  

Create credentials for authenticated access to the source system.

B.  

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

C.  

Back up the source tenant database.

D.  

Configure a secure connection from target system to source system.

E.  

Create credentials for authenticated access to the target system.

Discussion 0
Questions 30

Which preparation tasks do you need to perform before starting the Database Migration Option (DMO) procedure? There are 2 correct answers to this question.

Options:

A.  

Move the latest R3trans update archive into the download folder.

B.  

Extract the SAP HANA database software installation archive.

C.  

Check if the latest SPAM/SAINT update is applied.

D.  

Update the SAP Host Agent to the latest version

Discussion 0
Questions 31

Which backup scenarios are allowed in multitenant database containers? Note: There are 2 correct answers.

Options:

A.  

The system database can initiate its own backup and the backup of tenant databases

B.  

A backup of a tenant database can be recovered to an SAP HANA single-container system

C.  

The system database should be recovered first in order to recover the tenant databases

D.  

A tenant database can initiate its own backup unless this is prohibited by the system configuration

Discussion 0
Questions 32

You installed an SAP Netweaver-based application on an SAP HANA database. What is the default secure user store to store the password of the SAP user?

Options:

A.  

hdbuserstore

B.  

xuser

C.  

Secure store in file system (SSFS)

D.  

ABAP secure store file system (SSFS)

Discussion 0
Questions 33

Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?

There are 2 correct answers to this question.

Options:

A.  

Daemon

B.  

Preprocessor

C.  

Index server

D.  

Compile server

Discussion 0
Questions 34

What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.

Options:

A.  

For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4

B.  

For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2

C.  

For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10

D.  

For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15

Discussion 0
Questions 35

Which of the following users are able to start and stop a distributed SAP HANA Database System? There are 2 correct Answers to this question.

Options:

A.  

ROOT user

B.  

ADM user

C.  

SYSTEM user

Discussion 0
Questions 36

You need to recover a tenant database backup from SAP HANA system 1 into SAP HANAsystem2. Which activities do you perform to restore the tenant? Note: There are 2 correct answers.

Options:

A.  

Create the tenant in the target database

B.  

Recover the tenant with the Initialize Log Area option

C.  

Copy the transaction logs to the target database

D.  

Start the recovered tenant database

Discussion 0
Questions 37

Which products do you use for SAP HANA administration? There are 2 correct answers to this question.

Options:

A.  

SAP Solution Manager

B.  

SAP Web IDE for SAP HANA

C.  

SAP HANA cockpit

D.  

SAP Master Data Governance

Discussion 0
Questions 38

Due to a hardware failure of your persistence area, your SAP HANA database needs to be restored. Which tasks do you perform to recover the complete system? Note: There are 2 correct answers.

Options:

A.  

Start the recovery from the tenant database using SAP HANA cockpit 2.0

B.  

Recover all the databases using Initialize Log Area option

C.  

Recover the system database before recovering all tenant databases

D.  

Start the recovery from the system database SAP HANA cockpit 2.0

Discussion 0
Questions 39

Which operating system process takes care of starting the SAP HANA database system services?

Please choose the correct answer.

Options:

A.  

hdbrsutil

B.  

hdbdaemon

C.  

apstartsrv

D.  

sapstart

Discussion 0
Questions 40

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

Discussion 0
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