SAP Certified Technology Associate - SAP HANA (Edition SPS10)

Question 1

Which of the following are parts of SAP HANA sizing?
There are 3 correct answers to this question.
Response:

A. Memory sizing

B. Disk sizing

C. CPU sizing

D. Network bandwidth sizing

E. Data and log file sizing

Correct Answer: A,B,C

Question 2

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. Corruption of kernel binary files

C. Reset of the system to a specific point in time

D. Disk crash of the data area

E. Crash of the SLT server

Correct Answer: A,C,D

Question 3

You set up a data transfer architecture that replicates data to SAP HANA from an SAP source system using SAP
Landscape Transformation (SLT).
Which of the following SLT configuration parameter changes can improve the replication performance?
There are 3 correct answers to this question.
Response:

A. Change initial load mode

B. Increase the number of calculation jobs

C. Set data class of tablespace

D. Select Allow Multiple Usage in Connection to Source System

E. Increase the number of data transfer jobs

Correct Answer: A,B,E

Question 4

Which of the following traces provides information about past SQL query runtime performance including the values of
parameters?
Please choose the correct answer.
Response:

A. Performance trace

B. Expensive statements trace

C. SQL trace

D. User-specific trace

Correct Answer: B

Question 5

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 double-click on the table CUST_DATA

B. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Content

C. Content node SALES schema node Tables folder simple on the table CUST_DATA Open Definition

D. Content node SALES schema node Tables folder right-click on the table CUST_DATA Open Definition

Correct Answer: A,D

Question 6

Which view in SAP HANA studio do you use to add additional users?
Please choose the correct answer.
Response:

A. Quick Launch view

B. Navigator view

C. Console view

D. Properties view

Correct Answer: B

Question 7

You want the user SOLMAN_ADMIN to be able to modify the properties of the SAP HANA instance during system
configuration in SAP Solution Manager.
Which role must you assign to the user SOLMAN_ADMIN to achieve this?
Please choose the correct answer.
Response:

A. SAP_SYSTEM_REPOSITORY_ALL

B. SAP_SOLAR02_ALL

C. SAP_SM_ADMIN_COMPONENT_ALL

D. SAP_SYSREC_ALL

Correct Answer: A

Question 8

Which of the following can you use to analyze an expensive SQL statement?
There are 2 correct answers to this question.
Response:

A. Open the Plan Visualizer.

B. Open the Plan Explanation.

C. Open the hdbcons tool.

D. Open the SQL Plan Cache.

Correct Answer: A,B

Question 9

How can you make space available inside the log volume in a productive SAP HANA system?
Please choose the correct answer.
Response:

A. Delete log backups at the operating system level.

B. Compress the log backups at file system level.

C. Perform log backups.

D. Set the log mode to Overwrite.

Correct Answer: C

Question 10

Which of the following tools can you use to create and manage SAP HANA database users?
There are 2 correct answers to this question.
Response:

A. Microsoft Active Directory

B. hdbsql

C. SAP Netweaver Identity Management

D. SAP Solution Manager

Correct Answer: B,C

Question 11

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. Synchronous system replication with continuous memory loading

B. Asynchronous system replication with shadow processes

C. Asynchronous system replication with continuous memory loading

D. Synchronous storage replication with shadow processes

Correct Answer: B

Question 12

Which of the following is used to deploy SAP-delivered content in SAP HANA?
Please choose the correct answer.
Response:

A. Java Support Package Management (JSPM)

B. SAP Transport Management System (STMS)

C. SAP NetWeaver Development Infrastructure (NWDI)

D. Server-side export/import

Correct Answer: D

Question 13

Which of the following users allow you to install SAP HANA studio on a Windows client platform?
There are 2 correct answers to this question.
Response:

A. Local users with administrator privileges

B. Local users without administrator privileges

C. Domain users with administrator privileges

D. <SID>ADM users without administrator privileges

Correct Answer: A,C

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

Latest Update

Useful Links

Contact Us