Give Push to your Success with SAP Certified Technology Associate C-HANATEC-19 Exam Questions [Q27-Q51] : Free Exam Dumps Collection : http://free.examcollectionpass.com

QUESTION 27
Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question.

Configure the system landscape directory registration.

Manage the full system information dumps.

Update the SAP HANA database system

Stop and start the SAP HANA database system

QUESTION 28
Which feature do you use to dynamically manage SAP HANA database workloads per client session?

Workload classes

Admission control

Parallel execution of SQL statements

Non-Uniform Memory Access (NUMA)

QUESTION 29
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?

End-to-end

Kernel profiler

SQL

User-specific

QUESTION 30
What is the recommended size for the log volume file system for a 512 GB SAP HANA database system?

614 GB

256 GB

512 GB

427 GB

QUESTION 31
You are running an SAP HANA database in log mode “normal”
Under what circumstances does the database automatically execute a regular log backup?
Note: There are 2 correct answers to this question.

When the log segment is full

When a commit occurs

When the time threshold is exceeded

When the log buffer is full

QUESTION 32
You want to implement a 28-day backup cycle. Which scenario uses the least storage?

Full backup, incremental backup, log backup

Full backup, log backup

Incremental backup, log backup

Full backup, differential backup, log backup

QUESTION 33
You are checking and monitoring SAP HANA system replication
Which status indicates a temporary connection loss of the secondary system?

Unknown

Error

Initializing

Syncing

QUESTION 34
What is the correct sequence of the following four steps when you restart the SAP HANA database system?

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

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

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

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

QUESTION 35
Which prerequisites must be fulfilled to rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question.

The tenant database is stopped

The tenant database must be unloaded from memory

The on-disk tenant directory should be a mount point

The tenant database is not part of a move operation.

QUESTION 36
Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question.

Uninstall the SAP HANA database system and its components

Rename the SAP HANA database system.

Update the SAP HANA database system and its components.

Extract the SAP HANA database system components.

QUESTION 37
What do need in a multitenant database container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question.

The user in the source system must be associated with a user in the target database.

The cross-tenant database communication must be explicitly activated

The bidirectional communication channel must be whitelisted.

The user in the source system must have sufficient privileges in the target database.

QUESTION 38
Which features do you need to activate before you can analyze the memory usage of running SQL statements? Note: There are 2 correct answers to this question.

Tracking

In-memory tracing

Statement memory limit

Memory tracking

QUESTION 39
You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as an in-place migration. Which steps take place during downtime? Note: There are 2 correct answers to this question.

Activation of dictionary objects in phase ACT UPG

XPRAS execution in phase XPRAS AIMMRG

Migration of application tables in phase EL) CLONE MIG DT RUN

Creation of application tables in the target database in phase EU CLONE MIG DT CREATE

QUESTION 40
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? Note: There are 2 correct answers to this question.

DATABASE ADMIN

SELECT on the SYS TELEMETRY schema

CATALOG RAED

SELECT on the SYS STATISTICS schema

QUESTION 41
Which actions take place during a database migration option (DMO) procedure when performing an in-place migration? Note: There are 2 correct answers to this question.

One table is migrated per R3load pair

De-pooling of tables is done during the procedure.

TABART is considered for the creation of R3load control files.

SAPup decides which tables to split.

QUESTION 42
What additional action do you need to perform after you create a new tenant in an SAP HANA system replication configuration?

Copy the tenant database

Restart the secondary system.

Back up the tenant database

Start the tenant database

QUESTION 43
Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app? Note: There are 2 correct answers to this question.

Daemon

Preprocessor

Compile server

Index server

QUESTION 44
Which system usage types are automatically assigned to tiles in the SAP HANA cockpit? Note: There are 3 correct answers to this question.

Quality assurance

Test

Development

Custom

Production

QUESTION 45
Which technology is utilized by the Performance Warehouse option in the transaction DBACOCKPIT?

SAP Business Intelligence

SAP Data Warehouse Cloud

SAP Analytics Cloud

SAP Intelligent Query (SAP 10)

QUESTION 46
Which file system locations do need to specify when installing the SAP HANA multi-host database system using the default settings?
Note: There are 2 correct answers to this question.

/hana/shared

/usr/sap/hostctrl >/

/hana/log/<SID>

/usr/sap/<SID>

QUESTION 47
Which tools are integrated into the SAP HANA cockpit? Note: There are 3 correct answers to this question

SQL Analyzer

HDBAdmin

HANASitter

SQL Console

Database Explorer

QUESTION 48
Which feature do you configure to prevent the whole SAP HANA database system from reaching physical processing limits?

Workload classes

Capture and replay

Performance trace

Admission control

QUESTION 49
Which SAP HANA cockpit application can you use to investigate a system offline situation?

Full system information dumps

CPU usage monitor

Troubleshoot unresponsive system

Out-of-memory event monitor

QUESTION 50
Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system?
Note: There are 2 correct answers to this question.

Network bandwidth for the storage zone

Total disk space required for the log volume

Persistent memory (PMEM) required for backups

DRAM required for the static data memory area

QUESTION 51
How does SAP HANA encrypt the data persistence layer?

By column level

By page level

By table level

By row level

Give Push to your Success with SAP Certified Technology Associate C-HANATEC-19 Exam Questions [Q27-Q51]

SAP C-HANATEC-19 Exam Syllabus Topics: