Which trace do you use to create a graphical representation of an individual SQL Statement?

Which trace do you use to create a graphical representation of an individual SQL Statement?A . Performance traceB . Expensive statements traceC . SQL traceD . Plan traceView AnswerAnswer: A

January 13, 2021 No Comments READ MORE +

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

Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.A . SLAVEB . STANDBYC . WORKERD . MASTER 1View AnswerAnswer: B,C

January 13, 2021 No Comments READ MORE +

What is the root cause of this alert?

One of your systems show the internal Disk Full (Alert 30) alert. What is the root cause of this alert?A . Reading from the /hana/log/<sid> volume is NOT possibleB . Writing to the /hana/data/<sid> volume is NOT possibleC . Runing out of free space on the /hana/shared volumeD . Exceeding...

January 12, 2021 No Comments READ MORE +

What prerequisite does the resource require?

You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?A . A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schemaB . A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schemaC . A multitenant configuration with SYSTEMDBD . The target database...

January 12, 2021 No Comments READ MORE +

What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.A . The database is renamedB . The directories are renamedC . The backups are renamedD . The logs are renamedView AnswerAnswer: A,B

January 10, 2021 No Comments READ MORE +

Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.A . Cockpit User AdministratorB . Cockpit UserC . Cockpit Resource AdministratorD . Cockpit AdministratorView AnswerAnswer: D

January 10, 2021 No Comments READ MORE +

Which of the following activities are required to avoid compatibility issues after the upgrade?

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.A . Export the backup jobs history from SAP HANA 1.0 and import the history after the upgradeB . Delete...

January 9, 2021 No Comments READ MORE +

Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?A . DBA CockpitB . hdblcmC . hdbsqlD . SAP HANA cockpitView AnswerAnswer: A

January 9, 2021 No Comments READ MORE +

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

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 DatabasesB . hdbsqlC . SAP HANA Studio - System viewD . sapcontrolView AnswerAnswer: A,B

January 9, 2021 No Comments READ MORE +

Which action can you still perform?

Your SAP HANA database is locked down. Which action can you still perform?A . Check database licenseB . Check overall database statusC . Check session memoryD . Configure system propertiesView AnswerAnswer: A

January 9, 2021 No Comments READ MORE +