SAP SAP Certifications C_HANATEC_14 Questions & Answers

• Question 81:

  How is a savepoint triggered in SAP HANA? Please choose the correct answer. Response:

  A. By performing a soft shutdown

  B. By committing a transaction

  C. By starting a log backup

  D. By executing a delta merge

  Correct Answer: A

• Question 82:

  The design-time version of a security role can contain which of the following information?

  There are 2 correct answers to this question.

  Response:

  A. The users assigned to the role

  B. The role name

  C. The privileges assigned to the role

  D. The users assigned by default to this role

  Correct Answer: BC

• Question 83:

  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 84:

  Why does SAP HANA have a persistence storage layer that is disk-based?

  There are 2 correct answers to this question.

  Response:

  A. To generate indexes for the column store

  B. To allow row store operations

  C. To persist in-memory data

  D. To enable data recovery if the power fails

  Correct Answer: CD

• Question 85:

  In the context of the SAP HANA maintenance strategy, which of the following terms is connected to bundle

  new features and functions to the SAP HANA Platform?

  Choose the correct answer.

  Response:

  A. SAP HANA standard revisions

  B. SAP HANA maintenance revisions

  C. Support package stack (SPS)

  D. Support packages (SP)

  Correct Answer: C

• Question 86:

  Which of the following privileges allow read access to data in SAP HANA information models depending

  on certain values or combination of values?

  Choose the correct answer.

  Response:

  A. System Privileges

  B. Object Privileges

  C. Analytic Privileges

  D. Package Privileges

  Correct Answer: C

• Question 87:

  You install an SAP HANA system with multitenant database containers and monitor the SYSTEMDB from

  SAP HANA cockpit 2.0.

  Which services are part of the Manage Services app?

  There are 3 correct answers to this question

  Response:

  A. xsengine

  B. compileserver

  C. indexserver

  D. nameserver

  E. preprocessor

  Correct Answer: BDE

• Question 88:

  Which of the following tasks requires the BACKUP ADMIN authorization?

  There are 2 correct answers to this question.

  Response:

  A. Backing up the database without a user interface.

  B. Recovering the database without a user interface

  C. Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location.

  D. Administration tasks executed on a tenant database through the system database.

  Correct Answer: AC

• Question 89:

  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 90:

  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: D