SAP C_HANATEC_19 Exam Practice Test Instant Access

Question 1

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.

AWhen the log segment is full

BWhen a commit occurs

CWhen the time threshold is exceeded

DWhen the log buffer is full

Answer : A, C

Question 2

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 a complete data backup

DAn aborted recovery of the configuration files

Answer : A, B

Question 3

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 4

Which migration features are supported when using the database migration option (DMO) of Software Update Manager (SUM)? Note: There are 2 correct answers to this question.

AThe primary application server (PAS) can be moved to a target system landscape.

BA database migration from Oracle to SAP MaxDB can be performed.

CA database migration from SAP HANA to SAP ASE can be performed

DThe SAP system can be AS Java-based if the release is 7.50 or higher

Answer : A, B

Question 5

Which user credentials do you need to stop the SAP HANA database system using the SAP HANA cockpit? Note: There are 3 correct answers to this question.

A<sid>adm

Bsap<sid>

CDatabase User

DCockpit user

ERoot

Answer : A, C, D

Question 6

Which activities do you have to carry out to configure your multitenant database container (MDC) system to a higher database isolation level between tenant databases on the operating system (OS)? Note: There are 3 correct answers to this question.

AAdd dedicated tenant OS users to the <sid>shm group.

BLock the <sid>adm OS user.

CRemove the <sid>adm OS user from the sapsys group.

DAdd dedicated tenant OS users to the sapsys group.

ECreate dedicated tenant OS users for each tenant

Answer : A, D, E

Question 7

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

AA multitenant database container system is identified by a single system ID (SID).

BDatabase isolation increases the isolation between tenant databases on operating system level

CEach tenant database runs its own compile server and the preprocessor server.

DThe name server owns information about the location of tables and table partitions in databases.

EThe name server provides index server functionality for the system database.

Answer : A, B, E

SAP Certified Technology Associate - SAP HANA 2.0 SPS07 C_HANATEC_19 Exam Practice Test