C_HANATEC_10 by SAP Valid Free Exam Practice Test

Question 1

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

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

Correct Answer: A,D

Question 2

In the navigator tree of the SAP HANA studio, how can you find out which indexes are defined for table CUST_DATA
from the SALES schema?
There are 2 correct answers to this question.
Response:

A. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition B. Content node SALES schema node Tables folder double-click on the table CUST_DATA C. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Content D. Content node SALES schema node Tables folder simple on the table CUST_DATA Open Definition

Correct Answer: A,B

Question 3

Which of the following can you use to update SAP HANA?
Please choose the correct answer.
Response:

A. SAP HANA update wizard B. SAP HANA lifecycle manager C. SAP HANA on-site configuration tool D. Software update manager (SUM) for SAP HANA

Correct Answer: B

Question 4

Which tool do you use for complex data transformation of SAP ERP data?
Please choose the correct answer.
Response:

A. Sybase Replication Server B. SAP BusinessObjects Data Services C. SAP Landscape Transformation (SLT) D. SAP BusinessObjects Explorer

Correct Answer: B

Question 5

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. Export the data from system B to a file share and import the data to system B. Copy the data and log volume files from system B to system A. C. Copy a snapshot from system B to system A. D. Restore a complete database backup from system B to system A.

Correct Answer: B,D

Question 6

You are using SAP BusinessObjects Data Services as your ETL tool.
What is the next step required after you have created the datastore and imported the metadata from an SAP ERP
system into SAP HANA?
Please choose the correct answer.
Response:

A. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system. B. Import data from the SAP ERP system into SAP HAN C. Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA. D. Import the metadata from SAP HANA into SAP BusinessObjects Data Services.

Correct Answer: D

Question 7

What information is presented when you check the license key?
Please choose the correct answer.
Response:

A. SAP HANA licensed memory amount B. SAP HANA edition type C. SAP HANA support package number D. SAP HANA build number

Correct Answer: A

Question 8

Your SAP HANA usage scenario does not require SAP HANA XS.
What do you have to consider before you remove the SAP HANA XS service from the configuration?
There are 3 correct answers to this question.
Response:

A. The SAP HANA XS service must be removed from all hosts of the SAP HANA instance. B. A data backup must be taken after the SAP HANA XS service has been removed. C. User <sid>adm is required to remove the SAP HANA XS service. D. All applications using the SAP HANA instance must be stopped. E. The user privileges for accessing SAP HANA XS must be revoked.

Correct Answer: A,B,D

Question 9

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

Correct Answer: B

Question 10

In which of the following situations is a recovery of an SAP HANA database applicable?
There are 3 correct answers to this question.
Response:

A. Disk crash of the log area B. Disk crash of the data area C. Crash of the SLT server D. Reset of the system to a specific point in time E. Corruption of kernel binary files

Correct Answer: A,B,D

Question 11

Which authorization error do you troubleshoot using the Authorization Dependency Viewer?
Please choose the correct answer
Response:

A. Transaction error (128) B. Invalidated procedure (430) C. Invalid user privilege (334) D. SQL processing error (256)

Correct Answer: B

Question 12

You need to combine unstructured data from an Apache Hadoop database with data in your SAP HANA system. What
do you use to achieve this?
Please choose the correct answer.
Response:

A. SAP Sybase IQ B. Virtual tables C. SAP Landscape Transformation D. Full-text search indexes

Correct Answer: B

Question 13

What are the recommended ways to perform a database backup?
There are 2 correct answers to this question.
Response:

A. Use the BRBACKUP command B. Use SQL commands C. Use the./hdbsetup command D. Use SAP HANA Studio

Correct Answer: B,D

Question 14

Which connectivity options can you use to create an SAP BusinessObjects universe on SAP HANA?
There are 2 correct answers to this question.
Response:

A. Relational connection using BICS B. Relational connection using JDBC C. Relational connection using MDX D. Relational connection using ODBC

Correct Answer: B,D

Question 15

Which of the following URLs do you define for Software Update Manager?
Please choose the correct answer.
Response:

A. https://<host>:8444/studio_repository/ B. https://<host>:8443/studio_repository/ C. http://:8443/studio_repository/ D. http://:8444/studio_repository/

Correct Answer: B

SAP Certified Technology Associate - SAP HANA (Edition SPS10) - C_HANATEC_10 Exam Practice Test