1~60

1 What is the only assignable privilege for the Privileges on Users type?. ATTACH DEBUGGER. STRUCTUREDPRIVILEGE ADMIN. CATALOG READ. AUDIT OPERATOR.

2 Which tool do you use to execute SQL queries on the SAP HANA Cloud database?. SQLScript. SQL Console. HDBSQL. SQL Editor.

3 Which audit trail target is used by default in the SAP HANA Cloud, SAP HANA database?. Database table. Kernel trace. Linux syslog. CSV text file.

4 Which types of SAP HANA Cloud instance can you provision in an SAP BTP account? Note: There are 2 correct answers to this question. SAP HANA database. SAP SQL Anywhere. SAP IQ. Data lake.

5 Which feature do you use to dynamically control SAP HANA database workloads per client session?. Workload classes. Workload analysis. Admission control. Load unit configuration.

6 Which tools can you use to disable teriant database functionalities? Note: There are 2 correct answers to this question. resident hdblcm. Manage Database Configuration. hdbuserstore. Manage Restricted Features.

7 In SAP HANA Cloud, which tasks are handled by the cloud provider? Note: There are 3 correct answers to this question. Tuning the database to run optimally on the underlying operating system and hardware. Backing up the operating system and the database software. Installing, configuring, and upgrading the operating system. Sizing, provisioning, and monitoring the database. Managing users, roles, and permissions in the database.

8 Which properties can you change in the Alert Definitions app? Note: There are 3 correct answers to this question. The interval settings. The proposed solution. The category. The schedule. The thresholds.

9 What tools can you use to view the expensive statement trace file? Note: There are 2 correct answers to this question. SAP HANA Cloud Central. SAP BTP cockpit. SAP HANA cockpit. SAP HANA database explorer.

10 What is the default single sign-on method when using hdbsql?. Token based. SAML based. Kerberos based. Certificate based.

11 To diagnose and analyze errors in database trace files, which tools would you typically use? Note: There are 2 correct answers to this question. SAP HANA Cloud Central. SQL trace analyzer. Full system information dump. SAP HANA database explorer.

12 What is the primary use of the SQL Trace tool in SAP HANA?. User authentication. Performance tuning. Backup operations. Data modeling.

13 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. HTML file. XML file. TXT file. JSON file. CSV file.

14 Which prerequisites must be fulfilled when recovering a tenant database? Note: There are 2 correct answers to this question. The tenant database must be stopped before the recovery starts. The logon credentials of the system database user must be available. The logon credentials of the SIDadm user must be available. The whole system must be shut down before the recovery starts.

15 What attributes can you control when creating an SAP HANA Cloud, data lake instance? Note: There are 3 correct answers to this question. Automatic backup creation. Availability zone. Number of coordinators. Compatibility with SAP IQ. Compatibility with Apache Hadoop.

16 From which sources can you import catalog objects when using the SAP HANA database explorer? Note: There are 3 correct answers to this question. Data lake files. Local computer. Google Cloud Storage. HPE GreenLake. IBM public cloud.

17 How are savepoints triggered? Note: There are 2 correct answers to this question. By performing a delta merge. By issuing a transactional commit. By a database soft shutdown. By performing a database backup.

18 A new version of SAP HANA Cloud, SAP HANA database is available as of today. If you do NOT perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next version?. 2 weeks. 3 months. 1 year. 7 months.

19 Which tool do you use to reinitialize a non-recoverable system database?. hdbrecovercheck. recoverSys.py. hdbmdcutil. RecoverUtil.py.

20 Which SAP HANA feature is responsible for managing multiple containers within the same database?. XS Advanced. SAP Landscape Transformation. Multitenant Database Containers (MDC). Lifecycle Manager.

21 You are using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media. Which tasks can you perform from the command line? Note: There are 2 correct answers to this question. Update the SAP HANA database system and its components. Rename the SAP HANA database system. Uninstall the SAP HANA database system and its components. Extract the SAP HANA database system components.

22 How do you initiate a recovery of your SAP HANA Cloud, SAP HANA database instance?. In an SQL Console, execute the RECOVER DATABASE statement with the timestamp. In SAP HANA Cloud Central, select the Start Recovery option and set the timestamp. In an SAP BTP CLI, execute the RECOVER DATABASE command with the timestamp. In the SAP HANA cockpit, select the Start Recovery option and set the timestamp.

23 Which actions can you only choose when using the resident HDBLCM tool as root user? Note: There are 2 correct answers to this question. rename_system. unregister_system. update_host. configure_internal_network.

24 Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit?. INIFILE ADMIN. RESOURCE ADMIN. SERVICE ADMIN. DATABASE ADMIN.

25 Which actions can you perform on an SAP HANA Cloud, SAP HANA database using the Cloud Foundry CLI? Note: There are 2 correct answers to this question. Recover instance. Change instance backup schedule. Decrease data volume size. Create instance.

26 Which storage tier is used to manage rarely changing, persistent data?. Replica. Data lake. Native storage extension. WORM device.

27 Which SAP HANA trace must you activate to analyze performance issues with systems where third- party software cannot be installed?. End-to-end. Kernel profiler. SQL. Performance trace.

28 You want to implement a 28-day backup cycle. Which scenario uses the least storage?. Full back up, differential backup, log backup. Incremental backup, log backup. Full back up, log backup. Full back up, incremental backup, log backup.

29 Which SAP HANA Cloud tools would you use to diagnose and analyze errors in database trace files? Note: There are 2 correct answers to this question. SAP HANA database explorer. SAP HANA Cloud Central. SQL trace analyzer. Full system information dump.

30 What happens when you rename a tenant database in the SAP HANA cockpit? Note: There are 2 correct answers to this question. The tenant database is stopped. The tenant database backups are renamed. The tenant database trace directory is renamed. The tenant database is unloaded from memory.

31 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. Cockpit User. sapSID. Database User. Root. SIDadm.

32 Which services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app? Note: There are 2 correct answers to this question. Web dispatcher. Index server. XS engine. Compile server.

33 What feature of SAP HANA allows for the extension of storage capabilities without affecting the performance of in-memory operations?. Dynamic Tiering. Multi-tenant database containers. Persistent memory. SAP HANA Cockpit.

34 What possibilities do you have when upgrading an SAP HANA Cloud, SAP HANA database instance? Note: There are 2 correct answers to this question. Upgrade the replica first. Select the version to. install Upgrade without restart. Revert to a previous version.

35 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. Replicas. vCPUs. Storage. Memory.

36 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. Slack. Microsoft Teams. WhatsApp. Signal.

37 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. DRAM required for the static data memory area. Total disk space required for the log volume. Persistent memory (PMEM) required for backups. Network bandwidth for the storage zone.

38 Where can you start/stop an SAP HANA Cloud, SAP HANA database?. SAP HANA HDBSQL. SAP BTP cockpit. SAP HANA Cloud Central. SAP HANA cockpit.

39 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. Assign User Groups. Create Role in Schema. Assign to Role Group. Assign LDAP Groups. Create Group Admin.

40 Which file systems are supported for the data and log volumes of the SAP HANA 2.0 database system? Note: There are 2 correct answers to this question. XFS. Btrfs. GPFS. EXT4.

41 What does SAP HANA smart data integration primarily facilitate?. Data cleansing. Real-time data replication. Backup and recovery. User authentication.

42 Youch services can you stop in the SAP HANA cockpit from the SYSTEMDB Manage Services app?. Web dispatcher. Index server. XS engine. Compile server.

43 What is one of the backup options provided by the SAP HANA database?. Time travel. Single table backup. Fallback snapshots. Data snapshots.

44Which tools are available in SAP HANA Cloud Central? Note: There are 2 correct answers to this question. Service Plan Assignment editor. Start Recovery wizard. Manage Configuration editor. Cloud Foundry CLI.

45 What is the maximum number of replicas you can configure for SAP HANA Cloud?. 1. 3. 2. 4.

46 How can the SAP HANA database minimize the risk of data loss during a power failure?. Savepoints. Transaction logs. Delta merges. Data snapshots.

47 You want to prevent changes to system properties in tenant databases. Which configuration file stores the blocklisted properties?. multidb.ini. attributes.ini. global.ini. indexserver.ini.

48 Which privilege types are available in SAP HANA Cloud? Note: There are 3 correct answers to this question. Analytic. System. Object. Application. Package.

49 You want to use the multi-environment tools to administer an SAP HANA Cloud, SAP HANA database instance. Which SAP BTP entitlement service plans do you need? Note: There are 2 correct answers to this question. hana. relational data lake. multi-environment tools. tools.

50 You want to change a standard user account into a restricted user account. Which attributes do you need to adjust? Note: There are 3 correct answers to this question. Disable ODBC/JDBC Access must be set to "Yes". Authorization method must be set to "LDAP". Creation of Objects in Own Schema must be set to "No". User Group must be set to "Restricted". PUBLIC role must be set to "No".

51 How long are SAP HANA Cloud, SAP HANA database backups retained by default?. 3 weeks. 2 weeks. 1 week. 4 weeks.

52 Which SAP HANA cockpit application can you use to investigate a system offline situation?. Alert Monitor. Full System Information Dumps. Troubleshoot Unresponsive System. Performance Monitor.

53 What can you check with the SAP HANA hardware and cloud measurement tool (HCMT)? Note: There are 2 correct answers to this question. Linux kernel information. Cloud connector status. CPU states. NUMA memory bandwidth test.

54 In which scenario do you need SAP expert sizing? Note: There are 2 correct answers to this question. Migrating existing SAP ERP systems from AnyDB to run on SAP HANA. Customer is new to SAP ERP applications and the SAP HANA database system. Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA. Carving out SAP ERP functionality from the source system to the SAP ERP system on SAP HANA.

55 Which system privileges are required for administering tenant databases when connected to the system database? Note: There are 2 correct answers to this question. BACKUP ADMIN. DATABASE ADMIN. DATA ADMIN. MONITOR ADMIN.

56 Which privileges are required to create the COCKPIT MONITOR technical user? Note: There are 2 correct answers to this question. MONITOR ADMIN. SELECT on the _SYS_TELEMETRY schema. CATALOG READ. SELECT on the_SYS_STATISTICS schema.

57 Which circumstances will allow SUM to run without the creation of a shadow system? Please choose the correct answer. Response: alter system start database [DATABASE_NAME]. cf update-service [SERVICE_INSTANCE] -c "{ "data": {"service Stopped": false}}". sapcontrol -nr [INSTANCE_NUMBER]-function StartSystem. of start [APPLICATION_NAME].

58 What cryptographic libraries are supported in SAP HANA? Note: There are 2 correct answers to this question. CommonCryptoLib. Libgcrypt. OpenSSL. LibreSSL.

59 Which role do you need in order to assign users to groups in the SAP HANA cockpit?. Cockpit Administrator role. Cockpit Database Administrator role. Cockpit User Administrator rolle. Cockpit User role.

60 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. The user in the source system must have sufficient privileges in the target database. The cross-tenant database communication must be explicitly activated. The user in the source system must be associated with a user in the target database. The bidirectional communication channel must be allowed.