Winter Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Examstrust Logo
examstrust mcafee
  1. Home
  2. SAP
  3. SAP Certified Technology Associate
  4. C_HANATEC_17 - SAP Certified Technology Associate - SAP HANA 2.0 SPS05

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

Page: 1 / 27
Total 270 questions
Get C_HANATEC_17 Full Access Download C_HANATEC_17 PDF

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

Testing Engine

  • Product Type: Testing Engine
$42  $119.99
Add to Cart

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$59.5  $169.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Add to Cart
Question 1

In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs).

However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions?

There are 2 correct answers to this question.

Options:

A.

SYSTEM users replaced by standby host

B.

The failed worker host no longer has access to write to files

C.

The standby host has file access

D.

The standby host has access to write to files

Question 2

Which R3load mode is used during an inplace SUM database migration option procedure?

Options:

A.

Socket

B.

File

C.

Network

D.

Pipe

Question 3

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

Question 4

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

Question 5

What must you do to convert an SAP HANA 1.0 single database system to an SAP HANA 2.0 multitenant database system?

Options:

A.

Export/import application and customer data

B.

Upgrade the SAP HANA database system

C.

Execute the SUM database migration option with system move

D.

Create the system database manually

Question 6

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?

Options:

A.

100 GB

B.

90 GB

C.

35 GB

D.

25 GB

Question 7

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 8

Where is SDI used? There are 2 correct answers to this question.

Options:

A.

Data transformation

B.

Data cleansing

C.

Data streaming

D.

For data loading

Question 9

Which of the following SAP HANA capability allows you to load and replicate data in real time from ABAP source systems and non-ABAP source systems to an SAP HANA environment? Please choose the correct

answer.

Options:

A.

SAP HANA landscape transformation replication server

B.

SAP HANA dynamic tearing

C.

SAP HANA remote data sync

D.

SAP HANA smart data streaming

Question 10

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

Question 11

Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question

Options:

A.

Preprocessor

B.

XS Engine

C.

Index server

D.

Compile server

Question 12

Which information can you collect by running the fullSystemlnfoDump.py script when the SQL connection is available? Please choose the correct Answer:.

Options:

A.

A selection of rows of schema _SYS_XS

B.

A selection of .log files

C.

A selection of .trc files

D.

A selection of rows of schema SAP

Question 13

What can a user do when the backup operator system privileges is assigned?

Options:

A.

Perform data recovery

B.

Schedule backups

C.

Delete backups

D.

Configure backup settings

Question 14

Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers.

Options:

A.

Backup

B.

Data

C.

Log

D.

Pages in-memory

E.

Storage snapshot

Question 15

Which certificates can you manage in SAP HANA cockpit 2.0? There are 2 correct answers to this question.

Options:

A.

Kerberos

B.

SAML

C.

PKCS #12

D.

X.509

Question 16

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.

Question 17

Which of the following actions are possible when managing roles? There are 3 correct answers to this question.

Options:

A.

A role can contain either other roles or privileges but not both together

B.

A role can contain other roles and privileges at the same time

C.

A role can be nested to multiple other roles

D.

A role can contain multiple other roles

Question 18

What is XS?

Options:

A.

A native, lightweight application server

B.

A data cleansing engine

C.

An optional engine to handle excessive data loads

D.

A user interface

Question 19

SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.

Options:

A.

A restart of the primary system

B.

A restart of the secondary system

C.

An upgrade of the secondary system

D.

An upgrade of the primary system

Question 20

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

Options:

A.

rsecssfx

B.

hdbuserstore

C.

dbacockpit

D.

hdbnsutil

Question 21

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 22

Which of the following actions are audited by default in SAP HANA? There are 2 correct answers to this question.

Options:

A.

Deletion of audit entries from the audit trail

B.

Installation of SAP HANA license

C.

Changes to system configuration

D.

Changes to system configuration

E.

Creation, modification or deletion of audit policies

Question 23

How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question.

Options:

A.

run hdblcm with the check_installation action

B.

set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename

C.

create the dirctory containing the trace file

D.

activate the debug mode for the database trace

Question 24

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

Question 25

Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There

are 2 correct answers to this question.

Options:

A.

User mapping

B.

User sharing

C.

Communication channel whitelist

D.

Bi-directional communication channels

Question 26

Where can you check the trace and log files when your SAP HANA database is NOT available? There are 2 correct answers to this question.

Options:

A.

In the /usr/sap//HDB//trace path on the operating system

B.

In the Trace app of the SAP HANA Web-based Development Workbench

C.

In the Diagnosis Files app of the SAP HANA cockpit for offline administration

D.

In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0

Question 27

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 28

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 29

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 30

You are installing several SAP HANA systems with a standard setup. How can you automate this activity?

Options:

A.

Export and import the standard configurations from SAP HANA cocpit

B.

Copy the ini files to all systems

C.

Copy the complete install folders to all hosts

D.

Generate a configuration template using hdblcm

Question 31

How can you use the results from a comparable the run to optimize the database migration option (DMO) procedure downtime for a production system?

There are 2 correct answers to this question.

Options:

A.

Use the Test Cycle option to determine the optimal number of R3load processes.

B.

Use the UPGANA.XML analysis file to optimize the number of R3load processes.

C.

Use the MIGRATE_DT_DUR.XML file to optimize table splitting and migration sequence.

D.

Use the MIGRATE_SOT_DUR.XML file to manually optimize table splitting of large tables.

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

Question 33

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

Options:

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

Question 34

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

Question 35

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

Question 36

Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.

Options:

A.

To persist in-memory data

B.

To ensure maximum performance

C.

To enable database scale-up

D.

To allow a restart if the power fails

Question 37

In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.

Options:

A.

When the log buffer is full.

B.

When the time threshold is exceeded.

C.

When the log segment is full.

D.

When a commit occurs.

Question 38

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 39

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 40

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

Load More C_HANATEC_17 Questions
Page: 1 / 27
Total 270 questions
Get C_HANATEC_17 Full Access Download C_HANATEC_17 PDF