C_HANATEC_17 Practice Exam Questions with Answers SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Certification

How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.

Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive SAP HANA system.

Which tools can you use to monitor the system alerts of the SAP HANA database from your PC? There are 2 correct answers to this question.

Which information can you analyze using the Troubleshoot Unresponsive System application?

Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?

Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

What can you use the Secure User Store (hdbuserstore) for? There are 2 correct answers to this question.

What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?

To ensures that the database can be restored to the most recent committed state after a restart which of the following Indexserver components make sure such consistency and maintain durable

changes?

You need to periodically monitor if the SAP HANA primary system is online. Which tool do you use?

How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.

What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool for productive SAP HANA databases?

Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.

Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system. Which of the

following options are listed? There are 3 correct answers to this question.

For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers.

Which operation is executed before a table is repartitioned?

Where is the name server running in a multitenant database container system? Please choose the correct answer.

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

Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape Note: There are 2 correct answers.

You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT_MONITOR technical user?

There are 2 correct answers to this question.

Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.

Which of the following tasks requires the BACKUP ADMIN authorization? There are 2 correct Answers to this question.

Which table partitioning types does SAP HANA support? There are 3 correct answers to this question.

Which tool do you use to backup the root encryption keys?

Which types of backup can you use to copy an SAP HANA tenant database?

There are 2 correct answers to this question.

How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?

The data storage of your productive SAP HANA instance crashed, and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss? Please choose the correct answer.

Which tools can you use to start and stop an SAP HANA database? Note: There are 3 correct answers.

Which prerequisites must be fulfilled when recovering a tenant database? There are 2 correct answers to this question.

Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.

You upgrade an SAP HANA 1.0 system to SAP HANA 2.0. Which of the following activities are required to avoid compatibility issues after the upgrade. Note: There are 2 correct answers.

Which tools do you use to delete diagnosis files? There are 2 correct answers to this question.

A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.

Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults? There are 2 correct answers to this question.