C-HANATEC-17 Exam Training Practice Tests (SAP Certified Technology Associate

Question 1

You plan to set up an SAP HANA2.0 system on intel-based hardware platform. Which of the following operating systems can you use Note: There are 2 correct answers.

A. Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5 B. Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2 C. SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1 D. SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1

Correct Answer: B,C

Question 2

What are the supported operating systems for SAP HANA on IBM Power Servers? There are 2 correct answers to this question.

A. For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15 B. For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6. 10 C. For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4 D. For SAP HANA 2.0, Red Hat Enterprise Linux (RHEL) 7.2

Correct Answer: A,C

Question 3

Which prerequisites are necessary for productively using SAP HANA cockpit 2.0?
There are 2 correct answers to this question.

A. 10 GBit/s network bandwidth B. An IBM Power System with operating system SUSE Linux Enterprise Server (SLES) C. 16 GB RAM on a dedicated server D. An intel-based system with operating system Microsoft Windows

Correct Answer: B,C

Question 4

Which action do you perform when the data area in an SAP HANA database is running out of space?

A. Extend the size of the database volume B. Extend the file system size in the operating system level C. Create a new tenant database D. Create a new database volume

Correct Answer: D

Question 5

In which circumstances do you create a column store table? There are 3 correct answers to this question.

A. When the table has a large number of columns B. When the calculations are based on a small number of columns C. When accessing complete records D. When aggregations or fast search is required

Correct Answer: A,B,D

Question 6

Which of the following elements are valid rules for the location of the backup files? There are 3 correct answers to this question.

A. The backup ID is unique for each persistence only. B. The Volume ID is automatically added to a specified file name. C. The backup files should never be in the same directory and on the same file system as u data. D. The backup folder will be created automatically when the backup process is started.

Correct Answer: A,B,C

Question 7

Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.

A. To allow a restart if the power fails B. To enable database scale-up C. To persist in-memory data D. To ensure maximum performance

Correct Answer: A,C

Question 8

Which backup and recovery scenario is allowed in multitenant database containers?

A. A backup of a tenant database can be recovered to the system database. B. A tenant database can initiate its own backup, but the system database executes the recovery. C. The system database should be recovered first in order to recover the tenant databases. D. After the recovery of a tenant database, the system database needs a backup.

Correct Answer: B

Question 9

Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are 2 correct answers.

A. Automatic savepoints B. Persisted redo logs C. Delta merge D. Memory allocation limit

Correct Answer: A,B

Question 10

What are advantages of column store tables? There are 3 correct answers to this question.

A. Data footprint is automatically reduced through compression B. Columns can be partitioned C. They are optimized for high-volume read /write transactional processing D. Only the columns required are actually loaded to memory

Correct Answer: A,B,D

Question 11

Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?

A. Manage Databases B. Performance Monitor C. Resource Directory D. Manage Services

Correct Answer: D

Question 12

You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?

A. multidb.ini B. global.ini C. nameserver.ini D. indexserver.ini

Correct Answer: D

Question 13

You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration. Which steps take place during downtime?
There are 2 correct answers to this question.

A. Migration of application tables in phase EU_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

Correct Answer: A,D

Question 14

you can establish SAP Solution Manager connectivity and configure a Remote Service Connection (via SAP Router) as part of the initial setup. Since Solution Manager 7.1 SP04, the SAP HANA databases can be integrated into SAP Solution Manager.
What are these components can be integrated into SAP HANA database?
There are 3 correct answers to this question.

A. Alerting Infrastructure B. The transaction DBACockpit C. Performance Warehouse D. SAP HANA Database

Correct Answer: A,B,C

SAP Certified Technology Associate - SAP HANA 2.0 SPS05 - C-HANATEC-17 Exam Practice Test