C_HANATEC_17 Practice Exam Questions with Answers SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Certification

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

To store connection information on the SAP HANA XS Advanced engine

To configure failover supporting a 3-tier scenario

To configure an SAP HANA Auto-Restart Fault Recovery Support

To store connection information on the SAP HANA database client

10 GBit/s network bandwidth

16 GB RAM on a dedicated server

An intel-based system with operating system Microsoft Windows

An IBM Power System with operating system SUSE Linux Enterprise Server (SLES)

memory_tracking

statement_memory_limit

reject_memory_threshold

total_statement_memory_limit

OPTIMIZER ADMIN

DATA ADMIN

WORKLOAD ADMIN

RESOURCE ADMIN

CREATE SCHEMA

ATTACH DEBUGGER

DATA ADM IN

CATALOG READ

Manage Databases

Manage Services

Resource Directory

Performance Monitor

Automatic round-robin statement routing

Explicit read and write on the secondary system

Explicit read only on the secondary system

Implicit hint-based statement routing

Specify the name of the table/view.

Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.

Specify the user as the database user.

Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.

100 GB

90 GB

35 GB

25 GB

On the Additional Application Server (AAS) host

On the source and target host

On the remote target database host

On the Primary Application Server (PAS) host

SAP Adaptive Server Enterprise

SAP Business Intelligence

SAP Intelligent Query

SAP Analytics Cloud

Move the SPAM update archive into the download folder

Extract the SAP HANA Client installation archive

Move the stack.xml update file into the download folder

Extract the SAP HANA database installation archive

Move the R3trans update archive into the download folder

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

indexserver.ini

multidb.ini

global.ini

nameserver.ini

To generate indexes for the column store

To persist in-memory data

To enable data recovery if the power fails

To allow row store operations

Service auto-restart

Storage replication

Host auto-failover

Auto log backups

Object Privileges

Analytic Privileges

System Privileges

Package Privileges

A row count is executed for the migrated tables.

The content comparison is performed for repository tables.

A check sum is generated every 10000 rows.

The clustered tables are decluttered.

The SUM folder needs to exist.

The source database is up and running.

The DMO procedure hasn't reached downtime yet.

A cleanup has already been triggered.

Performance Warehouse

SAP HANA Database

Alerting Infrastructure

The transaction DBACockpit

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.

On

0

Off

1

For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4

For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2

For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10

For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15

By a database soft shutdown.

By issuing a transactional commit.

By performing a delta merge.

By performing a database backup.

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.

Test

Development

Production

Quality assurance

Custom

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.

DBA cockpit

SAP HANA application life cycle management (HDBLCM)

HDB command

SAP HANA cockpit

Sapcontrol

Multiple Components on One Database (MCOD)

Multitenant database containers (MDC)

Technical co-deployment (TCD)

Multiple Components on One System (MCOS)

Temporary license keys are manually installed by the SAP HANA system

Temporary license keys are automatically installed by the SAP HANA system

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

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

Have a high number of partitions per table

Have a low number of keys

Have partitions of a table on the same host

Have a high number of partitioned tables

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

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)

$(DIR_INSTANCE)//trace

$(DIR_INSTANCE)/backup/data

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

$(DIR_INSTANCE)/backup/log

Cockpit User

Database User

sap

adm

Root

A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema

A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema

A multitenant configuration with SYSTEMDB

The target database on SAP HANA 2.0 SPS00 or higher

Full database backup

Data snapshot

Delta database backup

Fallback snapshot

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

3 * RAM (Appliance)

1.2 * RAM (TDI)

Min. 1 * RAM

Min. 0.5 * RAM

Create a restricted user

Assign a user to a user group

Create and delete users

Lock and unlock users

Modeling

Monitoring

Repository

Runtime

Executed SQL statements on database level

Performance indicators on a query level

Database activities with the trace level ERROR

Query execution plans on an application level

hana/log/

/hana/

/hana/shared

/hana/

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

Back up the system database and all tenant databases individually.

Back up the system database and all tenant databases in one step.

Back up the complete database system.

Backup the complete storage system.

ODBC

JDBC

OLEDB

ADO.NET

Socket

File

Network

Pipe

Deletion of audit entries from the audit trail

Installation of SAP HANA license

Changes to system configuration

Changes to system configuration

Creation, modification or deletion of audit policies

Backup

Data

Log

Pages in-memory

Storage snapshot

The role can be transported between systems.

The role is revoked if the grantee user is deleted.

The role is granted and revoked directly by the database user.

The role is created by technical user _SYS_REPO.

The role is granted through the execution of stored procedures.

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.

Diagnosis information

Runtime environment

End-to-end Trace

SAP HANA minichecks

Row and Delta store.

Insert only on Column store.

Partitioning.

Compression and Decompression.

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

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

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

Delta data shipping takes place every 5 minutes.

Check database license

Check overall database status

Check session memory

Configure system properties

Only one user group administrator per user group

Multiple user group administrators per user group

Only one user group per user group administrator

Multiple user groups per user group administrator

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.

basepathjogmirror

basespath_export

basepathjogbackup

basepath_databackup

Delta Backup

Backup of Configuration files

Data Backup

Data Snapshot

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

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

Rename the SAP HANA database system.

Uninstall SAP HANA database components.

Update SAP HANA and its components.

Extract components.

hdbuserstore

xuser

Secure store in file system (SSFS)

ABAP secure store file system (SSFS)

System availability

Alerts count

Thread status

CPU utilization

Migrating to a target database, g. SAP HANA

Performing an SAP software update

Performing a Unicode conversion

Performing a database upgrade of the source database

Disable auditing

Grant or revoke user

Modification of an audit policy

Create or drop user

Indexserve.ini

Nameserver.ini

Multidb.ini

Sapprofile.ini

Kerberos

SAML

PKCS #12

X.509

threshold_cpu_time

cpu_time_measurement_mode

load_monitor_granularity

enable_tracking

The system database can initiate its own backup and the backup of tenant databases

A backup of a tenant database can be recovered to an SAP HANA single-container system

The system database should be recovered first in order to recover the tenant databases

A tenant database can initiate its own backup unless this is prohibited by the system configuration

SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases, and not on live operational reporting.

SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution.

SAP HANA Live for SAP Business Suite is an accelerator.

SAP HANA Live for SAP Business Suite comprises of an Analytical Model.

SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite.

SAP HANA Web-based Development Workbench

SAP HANA cockpit

SAP HANA cleaner

SAP HANA database explorer

CREATE ANY

EXPORT

EXECUTE

CREATE SCHEMA

DEVELOPMENT

When a savepoint occurs

When the log buffer is full

After the configured time threshold has been exceeded

When the log segment is full