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

Question 1

Which tab in SAP HANA studio displays CPU load history data?
Please choose the correct answer.
Response:

A. Overview

B. Landscape

C. Volumes

D. Performance

Correct Answer: D

Question 2

You are investigating a problem with the SAP HANA database. You opened a customer message with SAP support.
SAP support asks you to provide diagnostic information from the SAP HANA instance. How can you gather this
information?
There are 2 correct answers to this question.
Response:

A. Execute Diagnosis Files -> Diagnosis Information -> Collect function in the SAP HANA studio

B. Select and download all files under Diagnosis Files in the SAP HANA studio

C. Run the fullSystemInfoDump.py script on the SAP HANA server as <SID>adm

D. Run the HDB info command on the SAP HANA server as <SID>adm

Correct Answer: A,C

Question 3

Which combination of authorizations is required for this user?
Please choose the correct answer.
Response:

A. USER ADMIN, CREATE STRUCTURED PRIVILEGE, ROLE ADMIN

B. USER ADMIN, CREATE STRUCTURED PRIVILEGE, RESOURCE ADMIN

C. USER ADMIN, SERVICE ADMIN, ROLE ADMIN

D. USER ADMIN, SERVICE ADMIN, DATA ADMIN

Correct Answer: A

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. SQL trace

B. Performance trace

C. Expensive statements trace

D. User-specific trace

Correct Answer: C

Question 5

Which of the following connections require the highest network bandwidth?
Please choose the correct answer.
Response:

A. SAP HANA and SAP NetWeaver Portal

B. SAP HANA and SAP BW

C. SAP HANA and SAP HANA studio

D. SAP HANA and SBO BI

Correct Answer: B

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 an SAP BusinessObjects Data Services job to migrate data to SAP HANA.

B. Import data from the SAP ERP system into SAP HAN

C. Import the metadata from SAP HANA into SAP BusinessObjects Data Services.

D. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system.

Correct Answer: C

Question 7

You installed SAP HANA Database using 51 as your system number. Which network port is used for Standard SQL
communication for client access?
Please choose the correct answer.
Response:

A. 55113

B. 31551

C. 35100

D. 35115

Correct Answer: D

Question 8

Which of the following authentication methods does SAP HANA support for http(s) access?
There are 2 correct answers to this question.
Response:

A. X.509 client certificates

B. LDAP authentication

C. SAP logon tickets

D. Header-based authentication

Correct Answer: A,C

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. Perform log backups.

B. Compress the log backups at file system level.

C. Delete log backups at the operating system level.

D. Set the log mode to Overwrite.

Correct Answer: A

Question 10

You have exported a system landscape from an SAP HANA studio and imported it into a different SAP HANA studio.
What information must you provide to make the imported landscape work?
Please choose the correct answer.
Response:

A. Server instance numbers

B. Passwords for all connections

C. Connection path

D. Server host names

Correct Answer: B

Question 11

After you install an SAP HANA database, you want to ensure that it is automatically started when the host is rebooted.
Which of the following parameter settings allows you to do this?
Please choose the correct answer.
Response:

A. Autostart to "TRUE" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL

B. Autostart to "1" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name>

C. Autostart to "Yes" in the profile file /usr/sap/<SAPSID>/SYS/profile/DEFAULT.PFL

D. Autostart to "Enable" in the profile file /usr/sap/<SAPSID>/SYS/profile/<SID>_HDB<Instance_No>_<host_name>

Correct Answer: B

Welcome to TestSimulate

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