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

The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage.

The content of the complete main storage is persisted to disk.

Uncommitted changes in the first delta storage are rolled back.

All write operations go to the second delta storage.

Modeling

Monitoring

Repository

Runtime

the latest incremental backup

the latest log backup

the last full data backup

the last commited transaction

Verify that data and log backup destinations are valid throughout the system

Change the backup configuration for each node

Specify the individual backup destination on each node

Ensure the availability of shared backup storage

Export/import application and customer data

Upgrade the SAP HANA database system

Execute the SUM database migration option with system move

Create the system database manually

R3ta

Log tail Viewer

Table comparison

R3load utilization

systemreplicationStatus

HDBAdmin

hanasitter

landscapeHostConfiguration

3 * RAM (Appliance)

1.2 * RAM (TDI)

Min. 1 * RAM

Min. 0.5 * RAM

Cockpit User

Database User

sap

adm

Root

Role collections

Scopes

Roles

Privileges

User mapping

User creation

Password policy configuration

Role assignment

For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB

For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB

For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

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

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

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

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

Standby memory

Physical memory

Resident memory

Virtual memory

DMO is an inplace procedure by default, keeping the application server host.

DMO allows an easy reset during the procedure.

DMO allows a lower target release on SAP HANA database.

DMO combines several steps into one procedure.

Check the hostnames mapping to internal HTTPS ports

Configure an SAP Web Dispatcher for every tenant databases

Configure an alias hostname for every tenant database

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

memory_tracking

statement_memory_limit

enable_tracking

use_in_memory_tracing

When the log buffer is full.

When the time threshold is exceeded.

When the log segment is full.

When a commit occurs.

The role name

The privileges assigned to the role

The users assigned to the role

The users assigned by default to this role

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.

Database Explorer

HANA Sitter

SQL Console

SQL Analyzer

HDB Admin

$(DIR_INSTANCE)//trace

$(DIR_INSTANCE)/backup/data

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

$(DIR_INSTANCE)/backup/log

Trigger a save point.

Create a fullback snapshot.

Create an internal database snapshot.

Execute the hdbbackupdiag tool.

Procedures

Sequences

Tables

Views

Data transformation

Data cleansing

Data streaming

For data loading

Size [installation(single-node)] = MIN (2 x RAM; 2 TB)

Size [installation(single-node)] = MIN (1 x RAM; 1 TB)

Size [installation(single-node)] = MIN (2 x RAM; 1 TB)

Size [installation(single-node)] = MAX (2 x RAM; 1 TB)

Move the latest R3trans update archive into the download folder.

Extract the SAP HANA database software installation archive.

Check if the latest SPAM/SAINT update is applied.

Update the SAP Host Agent to the latest version

DRAM required for the static data memory area

Persistent memory (PMEM) required for backups

Total disk space required for the log volume

Network bandwidth for the storage zone

Multiple Components on One Database (MCOD)

Multitenant database containers (MDC)

Technical co-deployment (TCD)

Multiple Components on One System (MCOS)

Execute a delta merge

Commit a transaction

Start a log backup

Perform a soft shutdown

recover the system database and the affected tenant with the initialize log area option

restore the database and recover the affected tenant upto moment of the problem

recover the affected tenant upto moment of the problem

recover the affected tenant with the initialize log area option

When a savepoint occurs

When the log buffer is full

After the configured time threshold has been exceeded

When the log segment is full

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

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

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

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

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

Memory and CPU consumption from the SAP HANA database.

Disk consumption from the SAP HANA database.

Connection statistics about open connections.

The time at which the database was started.

Table partitions can be distributed over all nodes.

The row store can be distributed over all nodes.

Cross-node joins must be avoided.

The columns of a table can be distributed over all nodes.

HanaHwCheck.py

fullSystemlnfoDump.py

hanachecker.py

hanadumpviewer.py