C-HANATEC131 Exam Training Practice Tests (SAP Certified Technology Associate (Edition 2013)

Question 1

A user is locked due to too many failed logon attempts.
Which SQL command can solve this problem?

A. ALTER USER <username> RESET CONNECT ATTEMPTS B. ALTER USER <user_name> DROP CONNECT ATTEMPTS C. ALTER USER <username> FORCE PASSWORD CHANGE AFTER ATTEMPTS D. ALTER USER <user_name> ACCOUNT UNLOCK

Correct Answer: A

Question 2

Application users report that a query sometimes runs much slower than usual. You suspect that high system load is causing the slower query execution.
Which of the following can you use to review overall system resource utilization at the time of query execution?

A. DBA Cockpit (DBACOCKPIT) Current Status Alerts B. SAP HANA Studio System Monitor Sessions C. DBA Cockpit (DBACOCKPIT) Performance Expensive Statements D. SAP HANA Studio Administration Console->Performance LOAD

Correct Answer: D

Question 3

The statistics server was stopped during an upgrade by the system administrator.
Which of the following parameters in statisticsserver.ini do you modify to restart the statistics server?

A. statsconnect in the trace section B. active in the statisticsserver_general section C. statsserv in the trace section D. editing in the statisticsserver_general section

Correct Answer: B

Question 4

In the SAP HANA studio, to which of the following does the loading status "partially" refer?

A. To a row store table of which only some rows are loaded B. To a column store table that is loaded in delta storage C. To a row store table that is loaded in delta storage D. To a column store table of which only some columns are loaded

Correct Answer: D

Question 5

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? (Choose two)

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

Correct Answer: B,D

Question 6

How can you delete old data and log backups from both the backup catalog and physically from the server?

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. Go to Backup Editor -> Backup Catalog -> Delete Older Backups -> Catalog and backup location D. Delete all files under $(DIR_INSTANCE)/backup/data and $(DIR_INSTANCE)/backup/log

Correct Answer: C

Question 7

A long-running SQL query issued by an SAP NetWeaver work process also seems to use a lot of system resources.
How can you find out which ABAP module and which SAP NetWeaver user called the query?

A. Open Transaction Process Overview (SM50) in the SAP NetWeaver system
Sort the list by CPU time
Select the top entry
Check the User and Report columns B. In SAP HANA studio, check the session overview
Identify the logical CONNECTION ID for the SAP NetWeaver work process
Check the columns APPLICATIONSOURCE and APPLICATIONUSER C. Go to the Performance tab of SAP HANA studio
Check the System load diagram D. Open Transaction Global Work Process Overview (SM66) in the SAP NetWeaver system
Sort the list by CPU time
Select the top entry

Correct Answer: B

Question 8

You are using the Change and Transport System (CTS) with SAP HANA.
When is the transport strategy determined?

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 (Edition 2013) - SAP HANA - C-HANATEC131 Exam Practice Test