SAP Certified Technology Associate - SAP HANA 2.0 (SPS03) (C_HANATEC_15) Free Practice Test

Question 1

You define the parameters for password policy of an SAP HANA tenant database where the parameters are stored?
Please choose the correct answer.
Response:

A. multidb.ini

B. indexserver.ini

C. nameserver.ini

D. global.ini

Correct Answer: B

Question 2

You receive a new system from your hardware partner with SAP HANA 2.0 multitenant database containers preinstalled.
What is a prerequisite to guarantee secure encryption of the data volumes?
Please choose the correct answer.
Response:

A. Change the generated password of the SYSTEM user.

B. Change the generated SSFS master key for the whole database instance.

C. Update the connection information stored in the hdbuserstore.

D. Regenerate the encryption root keys for the internal application encryption.

Correct Answer: B

Question 3

You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers.
Which rules apply?
There are 2 correct answers to this question.
Response:

A. The tenant databases must run on the worker hosts.

B. The system database instance must run on all hosts (worker and standby).

C. The system database must run on the standby host.

D. The tenant databases must be able to be scaled out to all hosts (worker and standby).

Correct Answer: A,B

Question 4

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 5

You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database.
From which location does the Recover Database app read the recovery information by default?
Please choose the correct answer.
Response:

A. $(DIR_INSTANCE)/backup/log

B. $(DIR_INSTANCE)/<hostname>/trace

C. $(DIR_INSTANCE)/../global/hdb/custom/config

D. $(DIR_INSTANCE)/backup/data

Correct Answer: A

Question 6

What are the prerequisites for using the Web user interface for HDBLCM?
There are 2 correct answers to this question.
Response:

A. The SAP HANA database is revision 90 or higher

B. The communication port 1129 is open

C. The communication port 1329 is open

D. Internet Explorer - Version 8 or higher

Correct Answer: A,B

Question 7

Which of the following are characteristics of SAP HANA Smart Data Streaming?
Please choose the correct answer.
Response:

A. It uses databases queries.

B. It is a standalone product for use with any target system.

C. It provides reports and analysis on the received data.

D. It acts based on combinations of events.

Correct Answer: D

Question 8

Which of the following actions triggers the replication of SAP BW authorizations in SAP HANA?
There are 3 correct answers to this question.
Response:

A. InfoProvider activation

B. Execution of report "RS2HANA_AUTH_RUN"

C. System restart

D. Execution of "Replicate BW user authorizations to HANA database" process chain

Correct Answer: A,B,D

Question 9

You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace?
There are 2 correct answers to this question.
Response:

A. Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.

B. Specify the user as the database user.

C. Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION.

D. Specify the name of the table/view.

Correct Answer: B,C

Question 10

Which SAP HANA features ensure that committed data is NOT lost if there is a power failure?
There are 2 correct answers to this question.
Response:

A. Undo logs

B. Automatic savepoints

C. Delta merge

D. Persisted redo logs

Correct Answer: B,D

Question 11

Which of the following options are valid SAP HANA backup strategies?
There are 2 correct answers to this question
Response:

A. A full data backup followed by incremental backups and differential backups

B. A data snapshot followed by incremental backups and differential backups

C. A storage snapshot followed by incremental backups and differential backups

D. An offline backup followed by incremental backups and differential backups

Correct Answer: A,C

Question 12

You imported the following objects. Which of them always require an activity from you before they can be built?
There are 2 correct answers to this question.
Response:

A. Multi-target application

B. Logical schema definition

C. SAP HANA database module

D. Synonyms definition

Correct Answer: A,C

Question 13

What are the two storage components used to restore the database in case of power failure?
There are 2 correct answers to this question.
Response:

A. Data volume

B. Delta store

C. Memory

D. Log area

Correct Answer: A,D

Question 14

You are setting up a disaster recovery system using system replication. You want the transaction processing of the primary system to be suspended if the network to the secondary system fails.
What log replication mode must you use?
Please choose the correct answer.
Response:

A. full sync

B. sync

C. syncmem

D. async

Correct Answer: A

Question 15

Which of the following actions are audited by default in SAP HANA?
There are 2 correct answers to this question.
Response:

A. Creation, modification or deletion of audit policies

B. Changes to system configuration

C. Changes to system configuration

D. Deletion of audit entries from the audit trail

E. Installation of SAP HANA license

Correct Answer: A,D

Welcome to TestSimulate

SAP Certified Technology Associate - SAP HANA 2.0 (SPS03) (C_HANATEC_15) Free Practice Test