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

Installation log file

COCKPIT_ADMIN user logs

Installation logs screen

Installation config screen

Validation of the operating system configuration settings for the Linux kernel

Measurement of the data throughput between CPU and DRAM

Validation of the LPAR configuration settings on IBM Power servers

Measurement of data throughput between SAP HANA nodes and storage

Measurement of data throughput between the Linux kernel and CPU

It de-centralizes landscape operations and provides local landscape view

It automizes repetitive, time-intensive administration tasks

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

It replicates the storage in SAP landscape

max_queue_size

queue_wait_time_threshold

record_limit

queue_timeout

CPU threshold for rejecting new requests

Memory threshold for queuing new request

Memory limits for new SQL statement requests

Maximum queue size for requests

Maximum number of parallel request

A native, lightweight application server

A data cleansing engine

An optional engine to handle excessive data loads

A user interface

When the log buffer is full.

When the time threshold is exceeded.

When the log segment is full.

When a commit occurs.

CREATE SCHEMA

ATTACH DEBUGGER

DATA ADM IN

CATALOG READ

_SYS_WORKLOAD_REPLAY

_SYS_STATISTICS

_SYS_SQL_ANALYZER

_SYS_TELEMETRY

hdb back int

hdb backup diag

hdb recover check

hdb backup check

run hdblcm with the check_installation action

set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename

create the dirctory containing the trace file

activate the debug mode for the database trace

One table is migrated per R3load pair.

TABART is considered for the creation of R3load control files.

SAP up decides which tables to split.

De-pooling of tables is done during the procedure.

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

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

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

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

The input parameter must be set to mandatory.

The function can return multiple values.

The function must be of the type scalar.

The generated value can be overwritten at runtime.

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

The whole system is shut down, including all tenant databases

You need the logon credentials of the adm user.

You need the logon credentials of the system database user.

CPU usage monitor

Troubleshoot unresponsive system

Full system information dump

Out-of-memory event monitor

Feature Package Stack

Datacenter Service Point

Support Package

Support Package Stack

CATALOG READ

DATA ADMIN

MONITOR ADMIN

USER ADMIN

HanaHwCheck.py

fullSystemlnfoDump.py

hanachecker.py

hanadumpviewer.py

SYSTEM users replaced by standby host

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

The standby host has file access

The standby host has access to write to files

The CPU architecture must be identical.

An explicit read-only connect on between both systems must be available

Both must have the same SAP HANA version.

Both systems are located in the same data center.

Service auto-restart

Storage replication

Host auto-failover

Auto log backups

The content of log files via the log viewer

The memory consumption of SUM

A progress bar for the overall procedure

The active roadmap step

Production

Custom

Test

Sandbox

Development

Password of the user sapadm

SAP HANA System ID (SID)

Data and Log path

Installation path

By a database soft shutdown.

By issuing a transactional commit.

By performing a delta merge.

By performing a database backup.

Metadata Manager and Transaction Manager

Page Management and logge

Column Store and Row Store

Session Management and log Volumes

Set the password for the system database user.

Create an operating system user for the converted tenant database.

Trigger the conversion in the SAP HANA cockpit 2.0.

Generate the system database before the conversion.

The system database must run on the standby host.

The system database instance must run on all hosts (worker and standby).

The tenant databases must be able to be scaled out to all hosts (worker and standby).

The tenant databases must run on the worker hosts.

R3ta

Log tail Viewer

Table comparison

R3load utilization

The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.

The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.

The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

Create the tenant in the target database

Recover the tenant with the Initialize Log Area option

Copy the transaction logs to the target database

Start the recovered tenant database

Kernel settings

Network configuration

Memory configuration

Missing OS patches

Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.

Aborted transactions are rolled back.

Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded.

Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.

Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.

Role collections

Scopes

Roles

Privileges

Create credentials for authenticated access to the source system.

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

Back up the source tenant database.

Configure a secure connection from target system to source system.

Create credentials for authenticated access to the target system.

Rename the SAP HANA Database hostname

Remove host roles

Transport application changes

Rename the SAP HANA database system

Uninstall the individual components