C_HANATEC_18 by SAP Valid Free Exam Practice Test

Question 1

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

A. Parallel execution of SQL statements B. Admission control C. Workload classes D. Non-Uniform Memory Access (NUMA)

Correct Answer: C

Question 2

How are savepoints triggered?
Note: There are 2 correct answers to this question.

A. By issuing a transactional commit B. By performing a delta merge C. By a database soft shutdown D. By performing a database backup

Correct Answer: C,D

Question 3

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

A. SAP Data Warehouse Cloud B. SAP Business Intelligence C. SAP Analytics Cloud D. SAP Intelligent Query (SAP 10)

Correct Answer: B

Question 4

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

A. COCKPIT MONITOR B. SYS SQL ANALYZER C. SAP XS USAGE D. SYS STATISTICS

Correct Answer: D

Question 5

Which tool do you use to check that the actual size of the backup file is the same as the size recorded in the backup file header?

A. hdbrecovercheck B. hdbbackint C. hdbbackupcheck D. hdbbackupdiag

Correct Answer: D

Question 6

Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question.

A. A multitenant database container system is identified by a single system ID (SID). B. Database isolation increases the isolation between tenant databases on operating system level C. The name server owns information about the location of tables and table partitions in databases. D. The name server provides index server functionality for the system database. E. Each tenant database runs its own compile server and the preprocessor server.

Correct Answer: A,B,D

Question 7

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.

A. When the log segment is full B. When a commit occurs C. When the log buffer is full D. When the time threshold is exceeded

Correct Answer: A,D

Question 8

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

A. Unknown B. Initializing C. Syncing D. Error

Correct Answer: C

Question 9

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.

A. TABART is considered for the creation of R3load control files. B. SAPup decides which tables to split. C. De-pooling of tables is done during the procedure. D. One table is migrated per R3load pair

Correct Answer: B,D

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C_HANATEC_18 Exam Practice Test