SAP Certified Technology Associate - SAP HANA 2.0 (SPS03) - C-HANATEC-15 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which information is provided by the backup catalog
Please choose the correct answer.
Response:

A. Backup ID B. Progress of a backup C. Backup configuration D. Backup destination

Discussion 0

Correct Answer: C Vote an answer

Question 2

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 users assigned by default to this role C. The privileges assigned to the role D. The role name

Discussion 0

Correct Answer: C,D Vote an answer

Question 3

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 provides reports and analysis on the received data. C. It acts based on combinations of events. D. It is a standalone product for use with any target system.

Discussion 0

Correct Answer: C Vote an answer

Question 4

logical error occurred in one tenant of your SAP HANA database. What action do you perform to make the tenant consistent again?
Please choose the correct answer
Response:

A. Recover the system database first and then recover the affected tenant. B. Recover the affected tenant. The system database is NOT recovered. C. Recover the affected tenant first and then recover the system database. D. Recover the system database. The affected tenant is recovered automatically.

Discussion 0

Correct Answer: B Vote an answer

Question 5

You need to reset the database migration option (DMO) procedure due to a hardware failure. What are the prerequisites if you want to use the DMO reset procedure?
There are 2 correct answers to this question
Response:

A. The SUM folder needs to exist. B. The before-downtime backup needs to be available. C. The cleanup procedure needs to be performed. D. The source database needs to be available.

Discussion 0

Correct Answer: A,D Vote an answer

Question 6

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 in the Navigator view B. Double-click the system in the system monitor C. Choose the Administration button in the upper left corner D. Choose the Administration button in the upper right corner E. Double-click the system monitor in the Navigator view

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 7

you register a new resource in SAP HANA cocpit 2.0 what prerequiste does the resource require?
Please choose the correct answer.
Response:

A. A multienant configuration with SYSTEMDB B. Teh target database on SAP HANA 2.0 SPS00 or Higher C. A user with CATALOG Read privilege and Select on _SYS_STATSITIC Schema D. A user with data Admin privilage and select on _sys_telemetry schema

Discussion 0

Correct Answer: C Vote an answer

Question 8

Which of the following actions are possible when managing roles?
There are 3 correct answers to this question.
Response:

A. A role can contain other roles and privileges at the same time. B. A role can be nested to multiple other roles. C. A role can contain multiple other roles. D. A role can contain either other roles or privileges but not both together

Discussion 0

Correct Answer: A,B,C Vote an answer

Question 9

Which of the following elements are required for implementing a database copy?
There are 2 correct answers to this question.
Response:

A. Source and target databases can have different number and types of services. B. A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available. C. You don't have to be concerned about disk space and memory of the target database. D. The target database must have a the same or higher version than the source database.

Discussion 0

Correct Answer: B,D Vote an answer

Question 10

When creating a system connection in SAP HANA Studio, which of these is essential information?
There are 3 correct answers to this question.
Response:

A. Instance B. URL C. Host D. A valid user and password

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 11

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. SAP HANA cockpit 2.0 on a central server B. HDBSQL command line tool on the SAP HANA server C. SQL Command Editor of the DBA Cockpit on the application server D. SAP HANA studio on the SAP HANA server

Discussion 0

Correct Answer: A,C Vote an answer

Question 12

Where can you check the trace and log files when your SAP HANA database is NOT available?
Please choose the correct answer.
Response:

A. in the $DIR_INSTANCE/exe/python_support directory B. In the Trace app of the SAP HANA Web-based Development Workbench C. in the troubleshoot of unresponsive system app of hana cockpit for offline administration D. in the troubleshoot of unresponsive system app of HANA cockpit 2.0

Discussion 0

Correct Answer: B Vote an answer

Question 13

Which information is stored in the SYSTEMDB of SAP HANA multitenant database container system
There are 2 correct answers to this question.
Response:

A. Monitoring data on the SYSTEMDB and all tenant databases B. topology data on the location of tables and table partitions C. users and authorization of the SYSTEMDB and all tenant databases D. Landscape topology data on the system as a whole

Discussion 0

Correct Answer: A,D Vote an answer

Question 14

Out of complete SAP HANA platform, which from the following components are not part of SAP HANA Database?
There are 3 correct answers to this question.
Response:

A. Database Services B. HWCCT C. Smart Data Access D. EPM Services E. INA file loader

Discussion 0

Correct Answer: C,D,E Vote an answer

Question 15

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

A. By committing a transaction B. By performing a soft shutdown C. By executing a delta merge D. By starting a log backup

Discussion 0

Correct Answer: B Vote an answer