Certified Technology Associate - SAP HANA 2.0 SPS07 (C_HANATEC_19) Free Practice Test

Question 1

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

A. HANASitter

B. SQL Analyzer

C. HDBAdmin

D. SQL Console

E. Database Explorer

Correct Answer: B,D,E

Question 2

Which properties can you adjust in SAP HANA admission control? Note: There are 3 correct answers to this question.

A. Maximum queue size for requests

B. Memory threshold for queuing new requests

C. Memory limits for new SQL statement requests

D. CPU threshold for rejecting new requests

E. Maximum number of parallel 10 requests

Correct Answer: A,B,D

Question 3

Which types of backups can you use to copy an SAP HANA tenant database? Note: There are 2 correct answers to this question.

A. Full database backup

B. Data snapshot

C. Delta database backup

D. Fallback snapshot

Correct Answer: A,B

Question 4

Which schema provides performance data and alert details to review in SAP HANA mini-checks?

A. SAP XS USAGE

B. COCKPIT MONITOR

C. SYS STATISTICS

D. SYS SQL ANALYZER

Correct Answer: C

Question 5

What cryptographic libraries are supported in SAP HANA by default? Note: There are 2 correct answers to this question.

A. OpenSSL

B. CommonCryptoLib

C. wolfCrypt

D. Libgcrypt

Correct Answer: A,B

Question 6

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

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

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

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

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

Correct Answer: C

Question 7

What are the merge methods that are triggered by the SAP HANA system? Note: There are 2 correct answers to this question.

A. Auto

B. Forced

C. Critical

D. Smart

Correct Answer: A,C

Question 8

Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option?
Note: There are 2 correct answers to this question

A. A check sum is generated every 10000 rows

B. The content comparison is performed for repository tables.

C. The clustered tables are declustered.

D. A row count is executed for the migrated tables

Correct Answer: C,D

Question 9

Which prerequisites must be fulfilled before adding hosts to an SAP HANA scale-out system? Note: There are 2 correct answers to this question.

A. The host has access to the Installation directories

B. The SAP HANA system installation is on a shared file system

C. The additional host is placed in a different data center

D. The SAP HANA database server IS shut down.

Correct Answer: A,B

Welcome to TestSimulate

SAP Certified Technology Associate - SAP HANA 2.0 SPS07 (C_HANATEC_19) Free Practice Test