SAP C_HANATEC_19 Exam Questions Instant Access

Question 1

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

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

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

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

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

Answer : B

Question 2

You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT MONITOR technical user? Note: There are 2 correct answers to this question.

ADATABASE ADMIN

BSELECT on the SYS TELEMETRY schema

CCATALOG RAED

DSELECT on the SYS STATISTICS schema

Answer : C, D

Question 3

How can you use the results from a comparable test run to optimize the database migration option (DMO) procedure downtime for a production system?

Note: There are 2 correct answers to this question.

AUse the MIGRATE DT DUR.XML file to optimize table splitting and migration sequence

BUse the Test Cycle option to determine the optimal number of R310ad processes.

CUse the UPGANA.XML analysis file to optimize the number of R310ad processes

DUse the MIGRATE SOT DUR.XML file to manually optimize table splitting of large tables.

Answer : A, B

Question 4

Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol (LDAP) server? Note: There are 2 correct answers to this question.

AUser creation

BUser group assignment

CPassword policy configuration

DRole assignment

Answer : B, D

Question 5

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.

ALDAP authorization mode

BScopes

CUser group

DLDAP identity provider

Answer : A, C

Question 6

How can you ensure that a consistent database status is saved using data snapshots?

ATrigger a savepoint.

BCreate a fallback snapshot

CExecute the hdbbackupdiag tool

DCreate an internal database snapshot

Answer : D

Question 7

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/hana/log/<SID>

D/usr/sap/<SID>

Answer : A, C

SAP Certified Technology Associate - SAP HANA 2.0 SPS07 C_HANATEC_19 Exam Questions