Free SAP C-HANATEC141 Exam Dumps Questions & Answers

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

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

Which of the following views allows an administrator to identify all the authorizations assigned to a user?

• A.  GRANTED_ROLES
• B.  USERS
• C.  EFFECTIVE_PRIVILEGES
• D.  GRANTED_PRIVILEGES

Diagram:

Which component in the attached diagram is used when you query an SAP HANA information model to populate a pivot table in Microsoft Excel?

• A.  The SQL Interface
• B.  The Transaction Manager
• C.  The Log Volumes
• D.  The Calculation Engine

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 <user_name> ACCOUNT UNLOCK
• D.  ALTER USER <username> FORCE PASSWORD CHANGE AFTER ATTEMPTS

Which of the following traces provides information about past SQL query runtime performance including the values of parameters?

• A.  SQL trace
• B.  Expensive statements trace
• C.  User-specific trace
• D.  Performance trace