EMT Practice Test

1. Question Content...

---

Question1: Which tool do you use to execute SQL queries on the SAP HANA Cloud database?

Question2: Who owns all database objects deployed using the SAP HANA Deployment Infrastructure (HDI)?

Question3: What can you store in the statement library? Note: There are 2 correct answers to this question.

Question4: Which resources will be changed when you scale down an SAP HANA Cloud, SAP HANA database instance? Note: There are 2 correct answers to this question.

Question5: Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note:
There are 3 correct answers to this question.

Question6: You want to compare and analyze session-specific data.
In what format can you save data sets from the SAP HANA cockpit sessions app? Note: There are 3 correct answers to this question.

Question7: How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database instance?

Question8: Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit?

Question9: What is the only assignable privilege for the Privileges on Users type?

Question10: What possibilities do you have when upgrading an SAP HANA Cloud, SAP HANA database instance?
Note: There are 2 correct answers to this question.

Question11: Which role do you need in order to assign users to groups in the SAP HANA cockpit?

Question12: What can you assign to a user with the app in the SAP HANA cockpit? Note: There are 2 correct answers to this question.

Question13: How can you start an SAP HANA Cloud database instance using the command line?

Question14: How are savepoints triggered?
Note: There are 2 correct answers to this question.

Question15: When using the SAP HANA cockpit, which user credentials do you need to stop the SAP HANA database system? Note: There are 3 correct answers to this question.

Question16: What is the purpose of the statement library in the SAP HANA database explorer? Note: There are 2 correct answers to this question.

Question17: Which output channels can the SAP Alert Notification service for SAP BTP use for notification actions?
Note: There are 2 correct answers to this question.

Question18: How can you ensure that a consistent database status is saved using data snapshots?

Question19: Which data stores are activated by default when you provision an SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

Question20: Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system? Note: There are 2 correct answers to this question.

Question21: Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol (LDAP) server? Note: There are 2 correct answers to this question.

Question22: When performing a standard SAP HANA database system installation, which users will be created or validated by default during that installation? Note: There are 3 correct answers to this question.

Question23: Which privilege types are available in SAP HANA Cloud? Note: There are 3 correct answers to this question.

Question24: Which options can you use when creating a role in the SAP HANA Cloud, SAP HANA database?
Note: There are 3 correct answers to this question.

Question25: What is the default single sign-on method when using hdbsql?

Question26: Which parameters are mandatory when using the HDBLCM tool in batch mode, to install the SAP HANA database system? Note: There are 2 correct answers to this question.

Question27: How can you view the audit trail in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question.

Question28: Which tools are available in SAP HANA Cloud Central? Note: There are 2 correct answers to this question.

Question29: You want to prevent changes to system properties in tenant databases.
Which configuration file stores the blocklisted properties?

Question30: What can you check with the SAP HANA hardware and cloud measurement tool (HCMT)? Note:
There are 2 correct answers to this question.

Question31: Which feature do you use to dynamically control SAP HANA database workloads per client session?

Question32: Which container types are available in SAP HANA Deployment Infrastructure (HDI)? Note: There are
2 correct answers to this question.

Question33: What do you need in a multitenant database container (MDC) system to run queries across tenant databases? Note: There are 2 correct answers to this question.

Question34: Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question.

Question35: Where can you start/stop an SAP HANA Cloud, SAP HANA database?