March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

SAP C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Exam Practice Test

Demo: 40 questions
Total 270 questions

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

Question 1

In the General Licensing Process which of the following statements are true regarding Temporary license keys?

There are 2 correct answers to this question.

Options:

A.

Temporary license keys are manually installed by the SAP HANA system

B.

Temporary license keys are automatically installed by the SAP HANA system

C.

After 28 days, the temporary license expires and the system is locked down

D.

After 90 days, the temporary license expires and the system is locked down

Question 2

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

Question 3

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).

Question 4

What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer.

Options:

A.

Back up tenant database

B.

Copy tenant database.

C.

Start tenant database.

D.

Restart secondary system.

Question 5

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

Question 6

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

Question 7

The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems.

From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)?

Options:

A.

File Export SAP HANA Landscape

B.

File archive SAP HANA Landscape

C.

File archive SAP HANA Export

D.

File Export Landscape SAP HANA

Question 8

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)

Question 9

Which system privilege must you have to restrict features for tennant databases in the SAP HANA cockpit?

Please choose the correct answer.

Options:

A.

INFILE ADMIN

B.

WORKLOAD ADMIN

C.

DATABASE ADMIN

D.

RESOURCE ADMIN

Question 10

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

Question 11

Which parameters are mandatory when using the hdblcm tool in batch mode? There are 2 correct answers to this question.

Options:

A.

Password of the user sapadm

B.

SAP HANA System ID (SID)

C.

Data and Log path

D.

Installation path

Question 12

You upgrade an SAP HANA 1.0 system to SAP HANA 2.0. Which of the following activities are required to avoid compatibility issues after the upgrade. Note: There are 2 correct answers.

Options:

A.

Export the backup jobs history from SAP HANA 1.0 and import the history after the upgrade

B.

Delete all Backup schedules with the SAP HANA cockpit 1.0

C.

Create new backup schedules after the upgrade

D.

Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules

Question 13

Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.

Options:

A.

Only one user group per user group operator

B.

Only one user group operator per user group

C.

Multiple user groups per user group operator

D.

Multiple user group operators per user group

Question 14

Which target database does the SUM databases migration option provide by default? Note: There are 2 correct answers.

Options:

A.

SAp MaxDB

B.

SAP ASE

C.

SAP IQ

D.

SAP HANA

Question 15

Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? There are 2 correct answers to this question.

Options:

A.

SYNCMEM

B.

FULL SYNC

C.

SYNC

D.

ASYNC

Question 16

Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.

Options:

A.

A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available.

B.

The target database must have a the same or higher version than the source database.

C.

You don't have to be concerned about disk space and memory of the target database.

D.

Source and target databases can have different number and types of services.

Question 17

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

Question 18

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

Question 19

What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? There are 3 correct Answers to this question.

Options:

A.

SAP Application Performance Standard (SAPS)

B.

Network throughput

C.

Input/output operations per second (IOPS)

D.

Main memory

E.

Persistent storage

Question 20

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

Question 21

You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration. Which steps take place during downtime?

There are 2 correct answers to this question.

Options:

A.

Activation of dictionary objects in phase ACT_UPG

B.

XPRaS execution in phase XPRAS_AIMMRG

C.

Migration of application tables in phase EU_CLONE_MIG_DT_RUN

D.

Creation of application tables in the target database in phase EU_CLONE_MIG_DT_CREATE

Question 22

What are some advantages of a system replication with operation mode logreplay compared to delta_datashipping Note: There are 2 correct answers.

Options:

A.

Takeover time is shorter

B.

CPU load is reduced

C.

Network traffic is reduced

D.

Memory consumption is lower

Question 23

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

Options:

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.

Question 24

After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?

Options:

A.

It determines and rolls forward aborted transactions

B.

It rolls back write transactions that were open when the database was stopped

C.

It reloads a savepoint with the restored consistent state of the database

D.

It rolls back changes of committed transactions that were NOT written to the data area

Question 25

Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? There are 2 correct answers to this question.

Options:

A.

User mapping

B.

User creation

C.

Password policy configuration

D.

Role assignment

Question 26

How are savepoints triggered? There are 2 correct answers to this question

Options:

A.

By a database soft shutdown.

B.

By issuing a transactional commit.

C.

By performing a delta merge.

D.

By performing a database backup.

Question 27

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)

Question 28

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

Question 29

One of your systems show the internal Disk Full (Alert 30) alert. What is the root cause of this alert?

Options:

A.

Reading from the /hana/log/ volume is NOT possible

B.

Writing to the /hana/data/ volume is NOT possible

C.

Runing out of free space on the /hana/shared volume

D.

Exceeding system quota on the /usr/sap volume

Question 30

Which technology is used to install the SAP Landscape Management tool?

Please choose the correct answer.

Options:

A.

SAP NetWeaver Application Server for ABAP

B.

SAP Fiori launchpad

C.

SAP NetWeaver Application Server for Java

D.

SAP HANA XS advanced runtime

Question 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

Question 32

Which tools are integrated into the SAP HANA cockpit?

There are 3 correct answers to this question.

Options:

A.

Database Explorer

B.

HANA Sitter

C.

SQL Console

D.

SQL Analyzer

E.

HDB Admin

Question 33

Which tools can you use to monitor the response time of individual SQL queries? Note: There are 2 correct answers.

Options:

A.

SQL Trace

B.

Statement Monitor

C.

SQL plan cache

D.

Thread Monitor

Question 34

What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.

Options:

A.

Delta data shipping takes place in addition to continuous log replay.

B.

Delta data shipping takes place with continuous read-only access to the secondary system.

C.

Delta data shipping takes place in addition to continuous log shipping.

D.

Delta data shipping takes place every 5 minutes.

Question 35

Which file system locations are suggested to install an SAP HANA multi-host system? There are 2 correct answers to this question.

Options:

A.

hana/log/

B.

/hana/

C.

/hana/shared

D.

/hana/

Question 36

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

Question 37

What cryptographic libraries are supported in SAP HANA by default?

There are 2 correct answers to this question.

Options:

A.

LibgCrypt

B.

OpenSSL

C.

Common Cryptolib

D.

WolfCrypt

Question 38

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

Options:

A.

3 * RAM (Appliance)

B.

1.2 * RAM (TDI)

C.

Min. 1 * RAM

D.

Min. 0.5 * RAM

Question 39

Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.

Options:

A.

Restore the source tenant backup into the target tenant

B.

Start the replayer on the source system

C.

Create the replayer user in the control system

D.

Create a secure store key on the control system host

Question 40

You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user?

Options:

A.

Modeling

B.

Monitoring

C.

Repository

D.

Runtime

Demo: 40 questions
Total 270 questions