SAP Certified Technology Associate - SAP HANA (Edition 2016)

QUESTION NO: 1
Which of the following are required to enable SAP HANA high availability?
There are 2 correct answers to this question.
Response:

A. SAP HANA distributed systems B. Redundant storage and network C. SUSE Linux Enterprise High Availability Extension D. High-performance computing clustering for Linux

Correct Answer: A,B

QUESTION NO: 2
Which of the following can you do in the SAP HANA studio and also in the DBA Cockpit?
There are 3 correct answers to this question.
Response:

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

Correct Answer: C,D,E

QUESTION NO: 3
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?
Please choose the correct answer.
Response:

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

Correct Answer: C

QUESTION NO: 4
How can you find out which SAP HANA parameters have been changed in your system?
There are 2 correct answers to this question.
Response:

A. By checking the indexserver trace file covering the last system startup. B. By running the SQL query select * from "PUBLIC"."M_CONFIGURATION" where options != 'DEFAULT' C. By checking the configuration tab of the Administration Console in SAP HANA studio D. By running the SQL query select * from "PUBLIC"."M_INIFILE_CONTENTS" where layer_name != 'DEFAULT'

Correct Answer: C,D

QUESTION NO: 5
Which of the following authentication methods does SAP HANA support for http(s) access?
There are 2 correct answers to this question.
Response:

A. LDAP authentication B. X.509 client certificates C. Header-based authentication D. SAP logon tickets

Correct Answer: B,D

QUESTION NO: 6
When you try to create a delivery unit in the SAP Hana studio you receive an error message that the delivery unit CANNOT be created
How do you solve this problem?
Please choose the correct answer.
Response:

A. Grant the REPO. MAINTAIN_DELIVERY_UNITS privilege B. update the content_vendor parameter C. Update the reg_change content parameter D. Grant the REPO. MODIFY_OWN_CONTRIBUTION privilege

Correct Answer: B

QUESTION NO: 7
Which operating system commands show the SAP HANA processes?
There are 2 correct answers to this question.
Response:

A. HDB admin B. HDB version C. HDB proc D. HDB info

Correct Answer: C,D

QUESTION NO: 8
If you want to create or drop tables in a schema, which privilege type do you need?
Please choose the correct answer.
Response:

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

Correct Answer: C

SAP Certified Technology Associate - SAP HANA (Edition 2016) - C_HANATEC_12 Exam Questions