SAP C_HANATEC_16 SAP Certified Technology Associate – SAP HANA 2.0 SPS04 Online Training
SAP C_HANATEC_16 Online Training
The questions for C_HANATEC_16 were last updated at Nov 12,2024.
- Exam Code: C_HANATEC_16
- Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS04
- Certification Provider: SAP
- Latest update: Nov 12,2024
Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers.
- A . SAP HANA cockpit 2.0 – Manage Databases
- B . hdbsql
- C . SAP HANA Studio – System view
- D . sapcontrol
What can a user do when the backup operator system privileges is assigned?
- A . Perform data recovery
- B . Schedule backups
- C . Delete backups
- D . Configure backup settings
What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring
tool for productive SAP HANA databases?
- A . A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES)
or Red Hat Enterprise Linux (RHEL) - B . A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed
- C . A central SAP HANA database 2.0 SPS02 multitenant database system with at least 16 GB of RAM
- D . SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed
Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.
- A . The same number of active hosts and standby hosts must be installed
- B . Both must have the same SAP HANA version
- C . An explicit read-only connection between both systems must be available
- D . The CPU architecture must be identical
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 a nswer
- A . Recover the affected tenant. The system database is NOT recovered.
- B . Recover the system database first and then recover the affected tenant.
- C . Recover the affected tenant first and then recover the system database.
- D . Recover the system database. The affected tenant is recovered automatically.
Which diagnostic file can you use to monitor the status of database recovery?
- A . backint.log
- B . backup.log
- C . sapstartsrv.log
- D . available.log
After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?
- A . It determines and rolls forward aborted transactions
- B . It rolls back write transactions that were open when the database was stopped
- C . It reloads a savepoint with the restored consistent state of the database
- D . It rolls back changes of committed transactions that were NOT written to the data area
Which tool do you use to backup the root encryption keys?
- A . rsecssfx
- B . hdbuserstore
- C . dbacockpit
- D . hdbnsutil
Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.
- A . CREATE ANY
- B . EXPORT
- C . EXECUTE
- D . CREATE SCHEMA
- E . DEVELOPMENT
Which trace do you use to create a graphical representation of an individual SQL Statement?
- A . Performance trace
- B . Expensive statements trace
- C . SQL trace
- D . Plan trace