Certified Technology Associate - SAP HANA 2.0 SPS07 (C-HANATEC-19) Free Practice Test

Question 1

In which situations can you resume the failed recovery of your productive SAP HANA tenant database? Note: There are 2 correct answers to this question.

A. An aborted recovery of the configuration files

B. An aborted recovery of a complete data backup

C. An aborted recovery of a delta data backup

D. An aborted recovery of a log backup

Correct Answer: C,D

Question 2

In a multitenant database container (MDC) system, which privilege do you need to perform database-specific backups on all tenant databases?

A. TENANT ADMIN

B. BACKUP OPERATOR

C. DATABASE ADMIN

D. BACKUP ADMIN

Correct Answer: C

Question 3

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.

A. XPRAS execution in phase XPRAS AIMMRG

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

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

D. Activation of dictionary objects in phase ACT UPG

Correct Answer: A,B

Question 4

The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions, and threads? Note: There are 2 correct answers to this question.

A. Troubleshoot unresponsive systems

B. PerfTrace.py

C. Manage full system information dumps

D. emergencylnfo_py

Correct Answer: C,D

Question 5

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 a commit occurs

B. When the log buffer is full

C. When the time threshold is exceeded

D. When the log segment is full

Correct Answer: C,D

Question 6

How are user group administrators and user groups related? Note: There are 2 correct answers to this question.

A. Only one user group administrator per user

B. Multiple user groups per user group administrator

C. Multiple user group administrators per user group

D. Only one user group per user group administrator

Correct Answer: B,C

Question 7

You want to perform the database migration option (DMO) procedure.
Which components have to be updated if they are not on the right version level?
Note: There are 2 correct answers to this question.

A. ABAP Kernel

B. ST-PI

C. SAP Host Agent

D. SPAM/SAINT

Correct Answer: C,D

Question 8

What is the purpose of the SAP HANA secure user store (hdbuserstore)? Note: There are 2 correct answers to this question.

A. TO configure failover support in a 3-tier scenario

B. TO store connection information on the SAP HANA XS advanced engine

C. TO store connection information on the SAP HANA database client

D. TO configure an SAP HANA auto-restart for fault recovery

Correct Answer: A,C

Question 9

How does SAP HANA encrypt the data persistence layer?

A. By row level

B. By column level

C. By table level

D. By page level

Correct Answer: D

Welcome to TestSimulate

SAP Certified Technology Associate - SAP HANA 2.0 SPS07 (C-HANATEC-19) Free Practice Test