SAP SAP Certifications C_HANATEC_17 Questions & Answers

• Question 151:

  Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.

  A. To generate indexes for the column store

  B. To persist in-memory data

  C. To enable data recovery if the power fails

  D. To allow row store operations

  Correct Answer: BC

• Question 152:

  What are some of the characteristics of the design-time role? There are 3 correct answers to this question.

  A. The role can be transported between systems.

  B. The role is revoked if the grantee user is deleted.

  C. The role is granted and revoked directly by the database user.

  D. The role is created by technical user _SYS_REPO.

  E. The role is granted through the execution of stored procedures.

  Correct Answer: ADE

• Question 153:

  Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.

  A. _SYS_WORKLOAD_REPLAY

  B. _SYS_STATISTICS

  C. _SYS_SQL_ANALYZER

  D. _SYS_TELEMETRY

  Correct Answer: B

• Question 154:

  You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

  A. Provide the sum observer URL to SAP support

  B. Provide the SUM URL to SAP support

  C. Create the OS user obs on the application server

  D. Create the database user obs on the application server

  Correct Answer: AC

• Question 155:

  What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? There are 2 correct answers to this question.

  A. Role collections

  B. Scopes

  C. Roles

  D. Privileges

  Correct Answer: CD

• Question 156:

  Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? There are 2 correct answers to this question.

  A. User mapping

  B. User creation

  C. Password policy configuration

  D. Role assignment

  Correct Answer: BD

• Question 157:

  Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers to this question.

  A. Production

  B. Custom

  C. Test

  D. Sandbox

  E. Development

  Correct Answer: ACE

• Question 158:

  Which of the following actions are possible when managing roles? There are 3 correct answers to this question.

  A. A role can contain either other roles or privileges but not both together

  B. A role can contain other roles and privileges at the same time

  C. A role can be nested to multiple other roles

  D. A role can contain multiple other roles

  Correct Answer: BCD

• Question 159:

  Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.

  A. CREATE ANY

  B. EXPORT

  C. EXECUTE

  D. CREATE SCHEMA

  E. DEVELOPMENT

  Correct Answer: ABD

• Question 160:

  Which tools can you use to monitor the response time of individual SQL queries?

  Note: There are 2 correct answers.

  A. SQL Trace

  B. Statement Monitor

  C. SQL plan cache

  D. Thread Monitor

  Correct Answer: AC