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

Question 1

If you want to create or drop tables in a schema, which privilege type do you need?
Please choose the correct answer.
Response:

A. Analytic B. SQL C. System D. Package

Correct Answer: B

Question 2

You deleted billions of records from several tables in the SAP HANA database. However, the file system for the data
volumes did not gain any free space.
What is the reason?
Please choose the correct answer.
Response:

A. You did not execute the ALTER SYSTEM RECLAIM LOG. B. You did not execute a full backup and restore to reduce the size of the data volumes. C. SAP HANA did not trigger a delta merge yet. D. SAP HANA keeps the space for later reuse.

Correct Answer: D

Question 3

When you transport objects between SAP HANA systems using the Change and Transport System (CTS), you want to
create and release the transport requests manually.
Which transport strategy should you choose?
Please choose the correct answer.
Response:

A. WBO_GET_REQ_STRATEGY = Create WBO_REL_REQ_STRATEGY = Auto B. WBO_GET_REQ_STRATEGY = Tagged WBO_REL_REQ_STRATEGY = Manual C. WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Auto D. WBO_GET_REQ_STRATEGY = Smart WBO_REL_REQ_STRATEGY = Manual

Correct Answer: B

Question 4

Which of the following steps allow you to create a test system (system A) based on a productive SAP HANA standalone
system (system B)?
There are 2 correct answers to this question.
Response:

A. Copy a snapshot from system B to system A. B. Restore a complete database backup from system B to system A. C. Export the data from system B to a file share and import the data to system D. Copy the data and log volume files from system B to system A.

Correct Answer: B,D

Question 5

You have to size an SAP HANA system for SAP NetWeaver BW. The SAP NetWeaver BW system is currently running on
a non-SAP RDBMS.
Which of the following factors influences the size of the SAP HANA system?
Please choose the correct answer.
Response:

A. The size of aggregates B. The partitioning of tables C. The number of tables in the row store D. The number of indexes

Correct Answer: C

Question 6

What must you do to configure SAP HANA high availability?
Please choose the correct answer.
Response:

A. Run command./hdbaddhost --SID= --password= --role=standby. B. Right click the Navigator panel and choose Add System... C. Call stored procedure SYS.UPDATE_LANDSCAPE_CONFIGURATION. D. Run command./hdbinst --SID=<SID> --password=<password> --autostart=off.

Correct Answer: A

Question 7

You have SAP HANA and ABAP content that is exclusively used by ABAP for SAP HANA, You want to transport this
content together.
Which of the following options can you use for this transport?
There are 2 correct answers to this question
Response:

A. Enhanced Change and Transport System (CTS+) B. Export and Import of the Delivery Unit (DU) C. SAP HANA Application Lifecycle Manager (SAP HALM) D. SAP HANA Transport Container (SAP HTC)

Correct Answer: A,D

Question 8

What can you use to transform data from SAP Business Warehouse (BW) into SAP HANA?
Please choose the correct answer.
Response:

A. SAP Landscape Transformation (SLT) B. SAP BW extractors C. SAP BusinessObjects Data Services D. SAP Legacy System Migration Workbench (LSMW)

Correct Answer: C

Question 9

You have to implement disaster recovery for an SAP HANA production system. You also want to use the secondary SAP
HANA appliance for development and testing.
The data centers are more than 100km (60 miles) apart; the network capacity between them is restricted.
Which disaster recovery option would you implement?
Please choose the correct answer.
Response:

A. Asynchronous system replication with continuous memory loading B. Synchronous storage replication with shadow processes C. Asynchronous system replication with shadow processes D. Synchronous system replication with continuous memory loading

Correct Answer: C

Question 10

Which of the following traces is active by default in SAP HANA?
Please choose the correct answer.
Response:

A. Performance trace B. Database trace C. Expensive statements trace D. SQL trace

Correct Answer: B

Question 11

Which of the following are recovery types in SAP HANA database?
There are 2 correct answers to this question.
Response:

A. Point in time recovery B. Recovery until cancel C. Full recovery D. Recovery with incremental backup

Correct Answer: A,C

Question 12

How can you delete old data and log backups from both the backup catalog and physically from the server?
Please choose the correct answer.
Response:

A. Run "DELETE from m_backup_catalog_files where backup_id = <backup_id>" in the SQL editor B. Delete all files under $(DIR_GLOBAL)/hdb/log C. Delete all files under $(DIR_INSTANCE)/backup/data and $(DIR_INSTANCE)/backup/log D. Go to Backup Editor -> Backup Catalog -> Delete Older Backups ->Catalog and backup location

Correct Answer: D

Question 13

Which of the following sequences of steps is used to implement SAP HANA with SAP ERP?
Please choose the correct answer.
Response:

A. SAP HANA system setup
Data Provisioning
Modeling
Consumption B. SAP HANA system setup
Modeling
Data Provisioning
Consumption C. SAP HANA system setup
Data Provisioning
Consumption
Modeling D. Data Provisioning
SAP HANA system setup
Modeling
Consumption

Correct Answer: A

Question 14

You are using the Change and Transport System (CTS) with SAP HANA.
When is the transport strategy determined?
Please choose the correct answer.
Response:

A. When the objects are attached to a transport request in the SAP HANA studio B. When the connection to CTS is configured in SAP HANA studio C. When the SAP HANA application type is configured in CTS D. When the export system is configured in CTS

Correct Answer: D

SAP Certified Technology Associate - SAP HANA (Edition SPS10) - C-HANATEC-10 Exam Practice Test