C-HANATEC151 by SAP Valid Free Exam Practice Test

Question 1

Which of the following template roles allows a user who has been assigned this role to grant the privileges of this role
to other users?

A. MODELING B. PUBLIC C. MONITORING D. CONTENT_ADMIN

Correct Answer: D

Question 2

A company wants to restrict data access to a specific year for certain users. Which privilege type must you define in
SAP HANA to achieve this requirement?

A. System privileges B. Package privileges C. SQL privileges D. Analytic privileges

Correct Answer: D

Question 3

You have created a file named backup.sql with the following information to run a backup:
/c -n <server name> -i <instance number> -u <user> -p <password>
BACKUP DATA USING FILE ('backupDirectory/data/COMPLETE_BK')
Which of the following commands executes the backup?
Please choose the correct answer.

A. hdbsql -I backup.sql B. hdbsql -o backup.sql C. hdbsql -S backup.sql D. hdbsql -c backup.sql

Correct Answer: A

Question 4

Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit?

A. View the tables in the _SYS_STATISTICS schema. B. Display the statuses of database resources. C. Monitor an SQLDBC trace. D. Execute system recovery. E. Implement backup scheduling.

Correct Answer: A,B,C

Question 5

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. SAP HANA Studio Administration Console->Performance LOAD B. DBA Cockpit (DBACOCKPIT) Current Status Alerts C. SAP HANA Studio System Monitor Sessions D. DBA Cockpit (DBACOCKPIT) Performance Expensive Statements

Correct Answer: A

Question 6

Which of the following tools can you use to create and manage SAP HANA database users?

A. SAP Solution Manager B. Microsoft Active Directory C. hdbsql D. SAP Netweaver Identity Management

Correct Answer: C,D

Question 7

Which of the following are valid assignment sequences (assigning from the left to the right) of authorizations?
There are 2 correct answers to this question

A. Role - User - Privilege B. Role - Role - User C. Privilege - Role - User D. Role - Privilege - User

Correct Answer: B,C

Question 8

Which of the following traces is active by default in SAP HANA?

A. Database trace B. SQL trace C. Performance trace D. Expensive statements trace

Correct Answer: A

Question 9

What type of data is transferred between the SAP HANA database and end user clients?

A. Application data B. Data models C. Configuration models D. Configuration data

Correct Answer: A

SAP Certified Technology Associate - SAP HANA (Edition 2015) - C-HANATEC151 Exam Practice Test