Certified Technology Associate - SAP HANA 2.0 SPS07

Question 1

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.

A. The SAP system can be AS Java-based if the release is 7.50 or higher

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

C. A database migration from SAP HANA to SAP ASE can be performed

D. A database migration from Oracle to SAP MaxDB can be performed.

Correct Answer: B,D

Question 2

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.

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

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

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

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

Correct Answer: A,C

Question 3

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.

A. Remove the <sid>adm OS user from the sapsys group.

B. Create dedicated tenant OS users for each tenant

C. Lock the <sid>adm OS user.

D. Add dedicated tenant OS users to the sapsys group.

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

Correct Answer: B,D,E

Question 4

Where are the preinstalled SAP HANA mini-checks stored?

A. M_SYSTEM_INFORMATION_STATEMENTS

B. CHECK_PLATFORM

C. M_PREPARED_STATEMENTS

D. CHECK_CATALOG

Correct Answer: A

Question 5

Which SAP HANA cockpit application can you use to investigate a system offline situation?

A. Out-of-memory event monitor

B. Full system information dumps

C. CPU usage monitor

D. Troubleshoot unresponsive system

Correct Answer: B

Question 6

Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option?
Note: There are 2 correct answers to this question

A. The content comparison is performed for repository tables.

B. The clustered tables are declustered.

C. A check sum is generated every 10000 rows

D. A row count is executed for the migrated tables

Correct Answer: B,D

Question 7

Which part of the SAP HANA database memory holds the application data being stored to disk?

A. In-memory store

B. Page cache

C. Delta store

D. Log buffer

Correct Answer: D

Question 8

Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question.

A. Uninstall the SAP HANA database system and its components

B. Extract the SAP HANA database system components.

C. Rename the SAP HANA database system.

D. Update the SAP HANA database system and its components.

Correct Answer: B,D

Question 9

Which database objects can manipulate if you have the Object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question.

A. Schemas

B. Views

C. Procedures

D. Functions

Correct Answer: A,B

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

Latest Update

Useful Links

Contact Us