Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

C_HANATEC_17 Questions and Answers

Question # 6

What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose

A.

Metadata Manager and Transaction Manager

B.

Page Management and logge

C.

Column Store and Row Store

D.

Session Management and log Volumes

Full Access
Question # 7

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

Full Access
Question # 8

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

A.

File Export SAP HANA Landscape

B.

File archive SAP HANA Landscape

C.

File archive SAP HANA Export

D.

File Export Landscape SAP HANA

Full Access
Question # 9

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

A.

OPTIMIZER ADMIN

B.

DATA ADMIN

C.

WORKLOAD ADMIN

D.

RESOURCE ADMIN

Full Access
Question # 10

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.

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.

Full Access
Question # 11

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

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

Full Access
Question # 12

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

A.

DBA cockpit

B.

SAP HANA application life cycle management (HDBLCM)

C.

HDB command

D.

SAP HANA cockpit

E.

Sapcontrol

Full Access
Question # 13

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?

A.

$(DIR_INSTANCE)//trace

B.

$(DIR_INSTANCE)/backup/data

C.

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

D.

$(DIR_INSTANCE)/backup/log

Full Access
Question # 14

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

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

Full Access
Question # 15

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.

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.

Full Access
Question # 16

Which system privileges are required for administrating tenant databases when being connected to the system database? There are 2 correct answers to this question.

A.

MONITOR ADMIN

B.

DATA ADMIN

C.

BACKUP ADMIN

D.

DATABASE ADMIN

Full Access
Question # 17

Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.

A.

Set the password for the system database user.

B.

Create an operating system user for the converted tenant database.

C.

Trigger the conversion in the SAP HANA cockpit 2.0.

D.

Generate the system database before the conversion.

Full Access
Question # 18

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

A.

Modeling

B.

Monitoring

C.

Repository

D.

Runtime

Full Access
Question # 19

Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? There are 3 correct answers to this question.

A.

The DBACOCKPIT user of the tenant database

B.

The S-user for the SAP Support Portal connection

C.

The SYSTEM user of the system database

D.

The DDIC user in client 000 of the A BAP system

E.

The SAP user in client 000 of the ABAP system

Full Access
Question # 20

What is XS?

A.

A native, lightweight application server

B.

A data cleansing engine

C.

An optional engine to handle excessive data loads

D.

A user interface

Full Access
Question # 21

After confirming Lock now, which actions are still possible? Choose the correct Answer:.

A.

Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS)

B.

88Creating and changing application data (e.g. VA01) and user master records SU01)

C.

Developing via ABAP workbench (SE80)

D.

Applying SAP notes via Note Assistant (SNOTE)

Full Access
Question # 22

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

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

Full Access
Question # 23

What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.

A.

OS/DB certified consultant

B.

Migration check Services

C.

Migration key

D.

Stack.xml file

Full Access
Question # 24

Which information can you analyze using the Troubleshoot Unresponsive System application?

A.

System availability

B.

Alerts count

C.

Thread status

D.

CPU utilization

Full Access
Question # 25

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

A.

By a database soft shutdown.

B.

By issuing a transactional commit.

C.

By performing a delta merge.

D.

By performing a database backup.

Full Access
Question # 26

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

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

Full Access
Question # 27

What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?

A.

The primary system waits until the secondary system confirms receiving the log

B.

The primary system waits until the secondary system confirms the log was persisted

C.

The primary system does NOT wait for confirmation of the secondary system

D.

The primary system suspends transactions processing until the connection to the secondary system is established

Full Access
Question # 28

Which programming languages are supported when you develop an application on SAP HANA extended application services? Note: There are 2 correct answers.

A.

Node.js

B.

C++

C.

Lisp.js

D.

ABAP

Full Access
Question # 29

Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system? Please choose the correct answer.

A.

On

B.

0

C.

Off

D.

1

Full Access
Question # 30

You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT_MONITOR technical user?

There are 2 correct answers to this question.

A.

DATABSE ADMIN

B.

CATALOG READ

C.

SELECT on the SYS_TELEMETRY schema

D.

SELECT on the SYS_STATISTICS schema

Full Access
Question # 31

Which actions take place during a database migration option (DMO) procedure when performing an in-place migration?

There are 2 correct answers to this question.

A.

One table is migrated per R3load pair.

B.

TABART is considered for the creation of R3load control files.

C.

SAP up decides which tables to split.

D.

De-pooling of tables is done during the procedure.

Full Access
Question # 32

The recovery of your productive SAP HANA database fails during log replay. What is the fastest solution to complete the recovery.

A.

Restart the database and resume the interrupted recovery

B.

Resume the recovery from beginning

C.

Resume the interrupted recovery

D.

Replay the delta backups and log backups

Full Access
Question # 33

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.

A.

SYNCMEM

B.

FULL SYNC

C.

SYNC

D.

ASYNC

Full Access
Question # 34

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.

A.

Near Zero Downtime

B.

Database migration options of SUM

C.

Export/import using SAP Provisioning Manager

D.

Phases update

Full Access
Question # 35

Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? There are 3 correct answers to this question.

A.

Add dedicated tenant OS users to the shm group.

B.

Create dedicated tenant OS users for each tenant.

C.

Remove the adm OS user from the sapsys group.

D.

Add dedicated tenant OS users to the sapsys group.

E.

Lock the adm OS user.

Full Access
Question # 36

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

A.

Preprocessor

B.

XS Engine

C.

Index server

D.

Compile server

Full Access
Question # 37

Which tasks can you perform using the SAP HANA database lifecycle manager (HDBLCM) on installation media? There are 2 correct answers to this question.

A.

Rename the SAP HANA database system.

B.

Uninstall SAP HANA database components.

C.

Update SAP HANA and its components.

D.

Extract components.

Full Access
Question # 38

Which information is recorded in the database trace of the SAP HANA database?

A.

Executed SQL statements on database level

B.

Performance indicators on a query level

C.

Database activities with the trace level ERROR

D.

Query execution plans on an application level

Full Access
Question # 39

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?

A.

hdbuserstore

B.

xuser

C.

Secure store in file system (SSFS)

D.

ABAP secure store file system (SSFS)

Full Access
Question # 40

Which of the following tools can be used for User Administration? There are 3 correct Answers to this question.

A.

SAP NetWeaver Identity Management

B.

hdbsql

C.

Resident hdblcm

D.

SAP HANA Cockpit

Full Access