SAP Certified Technology Associate - SAP HANA (Edition SPS10)

QUESTION NO: 1
The log volume is full and the SAP HANA database does not accept any new requests. How can you solve this problem
and bring the SAP HANA database online?
Please choose the correct answer.
Response:

A. Move the log files to another volume and create a symbolic link to the new folder. B. Set the log_mode parameter to overwrite in global.ini. C. Delete older log files from the log volume before the last successful database backup. D. Run "Delete older backups" in the Backup Catalog.

Correct Answer: A

QUESTION NO: 2
Which of the following are functions of the DB trigger within SAP Landscape Transformation (SLT)?
There are 2 correct answers to this question.
Response:

A. Decluster table classes into a transparent format. B. Ensure that replicated changes are kept within the logging tables. C. Include only relevant tables for DB recording. D. Record relevant changes in logging tables.

Correct Answer: C,D

QUESTION NO: 3
Which of the following are characteristics of SAP NetWeaver Business Warehouse (SAP NetWeaver BW) when it is
migrated to run on the SAP HANA database?
There are 2 correct answers to this question.
Response:

A. The current SAP NetWeaver BW application server hardware can be re-used. B. All SAP NetWeaver BW 7.x application versions can be used. C. The SAP NetWeaver BW application server can be installed on the SAP HANA hardware. D. The sizing of the current SAP NetWeaver BW application server remains valid.

Correct Answer: B,D

QUESTION NO: 4
Which of the following components must be installed in SAP HANA to enable SAP Early Watch Alerts?
There are 2 correct answers to this question.
Response:

A. SMD agent B. Host agent C. CCMS agent D. Collection script

Correct Answer: B,D

QUESTION NO: 5
Which of the following components need a server certificate when you configure the SAP HANA Automated Update
function?
There are 2 correct answers to this question.
Response:

A. SAP HANA studio B. Host agent C. Update Manager D. SAP HANA database

Correct Answer: B,C

QUESTION NO: 6
Which operating system commands show the SAP HANA processes?
There are 2 correct answers to this question.
Response:

A. HDB admin B. HDB version C. HDB proc D. HDB info

Correct Answer: C,D

QUESTION NO: 7
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. User-specific trace D. Expensive statements trace

Correct Answer: D

QUESTION NO: 8
You want to create a role that grants read-only access to the content of the system and monitoring views and to
statistics services.
Which of the following privileges should the role contain?
There are 2 correct answers to this question.
Response:

A. SERVICE ADMIN B. SELECT for SQL schema _SYS_STATISTICS C. DATA ADMIN D. ALTER for SQL schema _SYS_STATISTICS

Correct Answer: B,C

QUESTION NO: 9
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. Select Allow Multiple Usage in Connection to Source System B. Set data class of tablespace C. Increase the number of calculation jobs D. Change initial load mode E. Increase the number of data transfer jobs

Correct Answer: C,D,E

QUESTION NO: 10
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 NO: 11
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 NO: 12
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 the metadata from SAP HANA into SAP BusinessObjects Data Services. C. Import data from the SAP ERP system into SAP HAN D. Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA.

Correct Answer: B

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