C-HANATEC-19 by SAP Actual Free Exam Questions And Answers

Question 1

Which system privilege do you need to redistribute tables across the hosts in a scale-out system?

A. optimizer admin

B. resource admin

C. data admin

D. workload admin

Discussion 0

Correct Answer: B Vote an answer

Question 2

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.

A. /hana/shared

B. /usr/sap/hostctrl >/

C. /usr/sap/<SID>

D. /hana/log/<SID>

Discussion 0

Correct Answer: A,D Vote an answer

Question 3

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. Open transactions are recovered
3. Row tables are loaded into memory.
4. Column tables are loaded

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

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

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

Discussion 0

Correct Answer: B Vote an answer

Question 4

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. Migration of application tables in phase EL) CLONE MIG DT RUN

B. Activation of dictionary objects in phase ACT UPG

C. XPRAS execution in phase XPRAS AIMMRG

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

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

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

Discussion 0

Correct Answer: C,D Vote an answer

Question 6

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 time threshold is exceeded

B. When a commit occurs

C. When the log segment is full

D. When the log buffer is full

Discussion 0

Correct Answer: A,C Vote an answer

Question 7

How does SAP HANA encrypt the data persistence layer?

A. By row level

B. By table level

C. By column level

D. By page level

Discussion 0

Correct Answer: D Vote an answer

Question 8

How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question.

A. Using the Manage Restricted Features app

B. Using the resident hdblcm tool

C. Using the hdbuserstore tool

D. Using the Manage Database Configuration app

Discussion 0

Correct Answer: A,C Vote an answer

Question 9

What can you assign to a user with the User Management app in SAP HANA cockpit? Note: There are 2 correct answers to this question.

A. Scopes

B. LDAP identity provider

C. User group

D. LDAP authorization mode

Discussion 0

Correct Answer: C,D Vote an answer

SAP Certified Technology Associate - SAP HANA 2.0 SPS07 - C-HANATEC-19 Exam Practice Test

Contact Us

Useful Links

Latest Updated