SAP SAP Certifications C_HANATEC_15 Questions & Answers

• Question 101:

  A SAP HANA system is a database management system (DBMS); that is, it is a server component that

  manages a database model. Which of the following is the wrong statement regarding DBMS functions

  Please choose the correct answer.

  Response:

  A. Maintains relationships between data

  B. Recovers data automatically to the most recent consistent status after a system failure

  C. Provides secure access to data using only adm authorization

  D. Delivers high performance for processing data requests

  Correct Answer: C

• Question 102:

  Response:

  A. SAP HANA Cockpit

  B. hdbsql

  C. Resident hdblcm D. SAP NetWeaver Identity Management

  Correct Answer: ABD

• Question 103:

  You are using USER01 and modelling a calculation view that combines existing calculation views with

  tables belonging to SCHEMA02. You want to activate the new calculation view, but you get a User is NOT

  Authorized error.

  What is the cause of the error?

  Please choose the correct answer.

  Response:

  A. User _SYS_REPO is missing object privileges for SCHEMA02.

  B. The calculation view was created in the sap package.

  C. USER01 is missing object privileges for SCHEMA02.

  D. The calculation view was created in the system-local package.

  Correct Answer: C

• Question 104:

  What are the prerequisites for querying the system view EFFECTIVE_PRIVILEGES to get data about

  other users and roles granted privileges?

  There are 2 correct answers to this question.

  Response:

  A. CATALOG READ

  B. DATA ADMIN

  C. MONITOR ADMIN

  D. USER ADMIN

  Correct Answer: AB

• Question 105:

  The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the

  SAP HANA database request additional memory?

  Please choose the correct answer.

  Response:

  A. Virtual memory

  B. Physical memory

  C. Standby memory

  D. Resident memory

  Correct Answer: A

• Question 106:

  Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Response:

  A. Balance table distribution

  B. Check the correct location of tables and partitions

  C. Check the number of partitions D. Redistribute tables after adding host(s)

  Correct Answer: C

• Question 107:

  What do you need to size before you install SAP HANA in a tailored data center integration (TDI)

  scenario?

  There are 3 correct answers to this question.

  Response:

  A. Input/output operations per second (IOPS)

  B. SAP Application Performance Standard (SAPS)

  C. Main memory

  D. Persistent storage

  E. Network throughput

  Correct Answer: BCD

• Question 108:

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

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

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

  C. The role is created by technical user _SYS_REPO.

  D. The role can be transported between systems.

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

  Correct Answer: ACD

• Question 109:

  Which of the following display authorizations for DBA Cockpit is not enabled for

  SAP_BC_S_DBCON_USER?

  Please choose the correct answer.

  Response:

  A. S_DBCON

  B. ACTVT=03

  C. S_RZL_ADM

  D. ACTVT=01

  Correct Answer: D

• Question 110:

  You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the

  SAP HANA database, but someone locked your personal SAP HANA user.

  Which tools can you use to execute an SQL query?

  There are 2 correct answers to this question.

  Response:

  A. SQL Command Editor of the DBA Cockpit on the application server

  B. SAP HANA studio on the SAP HANA server

  C. HDBSQL command line tool on the SAP HANA server

  D. SAP HANA cockpit 2.0 on a central server

  Correct Answer: AD