SAP C_HANATEC_18 Exam Practice Test Instant Access

Question 1

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.

ACompile server

BIndex server

CXS engine

DWeb dispatcher

Answer : A, B

Question 2

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

AThe bidirectional communication channel must be allowed.

BThe cross-tenant database communication must be explicitly activated.

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

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

Answer : B, C

Question 3

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.

APerfTrace.py

BManage full system information dumps

CTroubleshoot unresponsive systems

DemergencyInfo.py

Answer : B, C

Question 4

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

APerformance trace

BCapture and replay

CWorkload classes

DAdmission control

Answer : C, D

Question 5

You are running a database migration option (DMO) procedure using in-place migration. Where are the reading and writing R3load processes located during the actual migration?

AAll of the reading and writing processes run on the primary application server (PAS) host.

BThe reading processes run on the primary application server (PAS) host; the writing processes run on the target database host.

CAll of the reading and writing processes run on the target database host.

DThe reading processes run on the source database host; the writing processes run on the target database host.

Answer : A

Question 6

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.

AAn aborted recovery of a delta data backup

BAn aborted recovery of a log backup

CAn aborted recovery of the catalog backup

DAn aborted recovery of a complete data backup

Answer : A, B

Question 7

Which file system locations do you 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/<SID>

C/hana/<SID>

D/hana/log/<SID>

Answer : A, D

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