SAP Certified Technology Associate - SAP HANA 2.0 (C-HANATEC-14) Free Practice Test

Question 1

Which authorizations are assigned to users of type Standard Users by default?
There are 2 correct answers to this question
Response:

A. Create objects in schema _SYS_STATISTICS

B. Grant roles to other users

C. Create objects in own schema

D. Read data in system views

Correct Answer: C,D

Question 2

What are the prerequisites for configuring audit logging?
There are 2 correct answers to this question.
Response:

A. AUDIT OPERATOR system privilege

B. AUDIT ADMIN system privilege

C. INIFILE ADMIN system privilege

D. INIFILE OPERATOR system privilege

Correct Answer: B,C

Question 3

SAP HANA, in the context of user management, allows you to do which of the following?
There are 3 correct answers to this question.
Response:

A. Assign a user to a user group

B. Create a restricted user

C. Lock and unlock users

D. Create and delete users

Correct Answer: B,C,D

Question 4

You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one server. This system will be your customer's productive system.
Which of the following installation requirements are mandatory?
There are 2 correct answers to this question.
Response:

A. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

B. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.

C. The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different.

D. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added.

Correct Answer: C,D

Question 5

Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database?
Please choose the correct answer.
Response:

A. Request Processing and Execution Control

B. Storage Engine and Disk Storage

C. Relational Engines

D. External Interfaces

Correct Answer: D

Question 6

What can you do to shorten the startup time of an SAP HANA system after a reboot?
Please choose the correct answer.
Response:

A. Set the savepoint interval to a lower value

B. Partition the row store across nodes.

C. Flag all columnar tables for preload.

D. Set the preload column value in the Tables system table to FULL.

Correct Answer: A

Question 7

The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems.
From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)?
Please choose the correct answer.
Response:

A. File archive SAP HANA Export

B. File Export Landscape SAP HANA

C. File Export SAP HANA Landscape

D. File archive SAP HANA Landscape

Correct Answer: C

Question 8

Which type of backup can you schedule using SAP HANA cockpit 2.0?
Please choose the correct answer.
Response:

A. Data backup

B. Log backup

C. Backup of configuration files

D. Storage snapshot

Correct Answer: A

Question 9

For which communication channel do you need to set up encryption manually?
Please choose the correct answer.
Response:

A. Between databases in an SAP HANA multitenant database container system

B. Between SAP HANA systems in system replication scenarios

C. Between the SAP HANA server and clients

D. Between hosts in an SAP HANA scale-out system

Correct Answer: C

Question 10

Due to a hardware failure, you are using a different host to recover a crashed SAP HANA database. Which of the following configuration files must you use for the recovery?
There are 2 correct answers to this question.
Response:

A. xsengine.ini

B. nameserver.ini

C. Indexserver.ini

D. sapprofile.ini

Correct Answer: B,C

Question 11

In which circumstances do you create a column store table?
There are 3 correct answers to this question.
Response:

A. When accessing complete records

B. When aggregations or fast search is required

C. When the calculations are based on a small number of columns

D. When the table has a large number of columns

Correct Answer: B,C,D

Question 12

The administration console is pre-delivered by SAP. You can access the administration console in one of the following ways.
There are 3 correct answers to this question.
Response:

A. Double-click the system monitor in the Navigator view

B. Double-click the system in the Navigator view

C. Choose the Administration button in the upper left corner

D. Double-click the system in the system monitor

E. Choose the Administration button in the upper right corner

Correct Answer: B,D,E

Question 13

Your application runs with a technical user in a database of an SAP HANA multitenant database container.
You want to execute a query across tenant databases.
Which of the following prerequisites are required?
There are 2 correct answers to this question.
Response:

A. User sharing

B. User mapping

C. Bi-directional communication channels

D. Communication channel whitelist

Correct Answer: B,D

Question 14

Which of the following SAP HANA capability allows you to load and replicate data in real time from ABAP source systems and non-ABAP source systems to an SAP HANA environment?
Please choose the correct answer.
Response:

A. SAP HANA dynamic tearing

B. SAP HANA remote data sync

C. SAP HANA smart data streaming

D. SAP HANA landscape transformation replication server

Correct Answer: D

Question 15

You can change the SSFS master keys using the command line tool RSECSSFX, where it is available?
Please choose the correct answer.
Response:

A. /sap/usr/<SID>/HDB<instance>/exe

B. /usr/sap/HDB<instance>/<SID>/exe

C. /sap/usr/HDB<instance>/<SID>/exe

D. /usr/sap/<SID>/HDB<instance>/exe

Correct Answer: D

Welcome to TestSimulate

SAP Certified Technology Associate - SAP HANA 2.0 (C-HANATEC-14) Free Practice Test