CHT

Which action do you perform when the data area in an SAP HANA database is running out of space?. Create a new database volume. Extend the file system size on the operating system level. Create a new tenant database. Extend the size of the database volume.

What is a prerequisite before you can install SAP HANA cockpit 2.0 as a central monitoring tool for productive SAP HANA database?. A central SAP HANA 2.0 SPS02 multi-tenant database system with at least 16GB of RAM. SAP NetWeaver 7,5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed. A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed. A dedicated server with at least 16GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL).

When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this questions. The kernel on the SAP primary application server. The shadow schema on the non-SAP database. The upload BRTOOLS on the non-SAP database. The DBACOCKPIT user on the SAP HANA database. The delete SAP Business Object Business Intelligence data on the non-SAP database.

Which backup types can you schedule using SAP HANA cockpit 2.0? There are 2 correct answers to this questions. Backup of configuration files. Data backup. Data snapshot. Delta backup.

Due to a hardware failure of your persistence area, your SAP HANA database needs to be restored. Which task do you perform to recover the complete system? There are 2 correct answers to this questions. Start the recovery from the system database using SAP HANA cockpit 2.0. Recover all the databases using the initialize Log Area option. Recover the system database before recovering all tenant database. Start the recovery from the tenant database using SAP HANA cockpit 2.0,.

Where is the name server running in an SAP HANA 2.0 SPS02 database?. Master node. Standby node. All tenants. SYSTEMDB.

You need to check the new monitoring option in SAP HANA cockpit 2.0. Which SAP HANA cockpit 2.0 app do you use?. Configure System Properties. Configure Alerts. Manage Database Backups. Monitor Performance.

Which command do you execute to bring a distributed SAP HANA database system to a fully operation state?. sapcontrol -nr <instance number> -function Start. sapcontrol -nr <instance number> -function StartSystem. ALTER SYSTEM START DATABASE SYSTEM. ALTER SYSTEM DTART SATABASE All.

What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? There are 3 correct answers to this question. Network throughput. Persistent storage. SAP Application Performance Standard (SAPS). Input / Output operations per second (IOPS). Main memory.

How can you minimize the database migration option (DMO) downtime?. Provide the measured table migration duration for table sequencing during benchmarking. Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3load processes. Adjust the number of R3load processes during benchmarking and the DMO procedure. Use the benchmarking tool for a productive database migration with the DMO procedure.

You need to troubleshoot authorization error and invalid object error of a calculation view in SAP HANA studio. Which system privileges do you need to run the authorization dependency viewer?. MONITOR ADMIN. CATALOG READ. TRACE ADMIN. USER ADMIN.

In the Aggregate Health Monitor application, you are viewing the overall status of all tenant assigned to your SAP HANA cockpit user. The cockpit_admin user. A named user with monitor permissions. The system user. A technical user with limited permissions.

Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question. To enable database schale-out. To ensure maximum performance. To persist in-memory data. To allow a restart if the power fails.

Which SAP HANA features ensure that committed data is not lost if there is a power failure? There are 2 correct answers to this questions. Undo logs. Automatic savepoints. Persisted redo logs. Delta merge.

What is the advantage of partitioning a table?. Optimized column compression. Better load balancing. Improved network load. Restrictable partitioning size.

Which encryption services can you active in SAP HANA? There are 3 correct answers to this question. Data. Backup. Log. Storage snapshot. Pages in-memory.

The recovery of your productive SAP HANA database fails during log replay. What is the fastest solution to complete the recovery?. Repeat the recovery from the beginning. Replay the delta backups and log backups. Resume the interrupted recovery. Restart the database and resume the interrupted recovery.

An application user is complaining about missing privileges when executing a query. Which trace level of the indexserver trace do you select to obtain the missing privileges?. DEBUG for the authentication codec component. INFO for the authorization component. ERROR for the Auditing component. WARNING for the authentication component.

Which processor combinations are allowed for the primary system and secondary system in an Active / Active system replication setup? There are 2 correct answers to this question. Primary Intel-based Secondary IBM Power. Primary IBM Power Secondary Intel-based. Primary Intel-based Secondary Intel-based. Primary IBM Power Secondary IBM Power.

How can you shorten the delta merge runtime of a table? There are 2 correct answers to this question. Merge per column. Perform memory-only delta merges. Fully load the delta store into memory. Partition the table.

Which tool do you use to back up the root encryption keys?. hdbnsutil. rsecssfx. dbacckpit. hdbuserstore.

Which target databases are supported when you use the Database Migration Option (DMO) of Software Update Manager (SUM)? There are 2 correct answers to this question. IBM DB6. Micrsoft SQL Server. MySQL. IBM DB2.

You need to reset the Database Migration Option (DMO) procedure due to a hardware failure. What are the prerequisites if you want to use the DMO reset procedure? There are 2 correct answers to this question. The cleanup procedure needs to be performed. The SUM folder needs to exist. The before-downtime backup needs to be available. The source database needs to be available.

You plan to migrate a non-SAP database to SAP HANA using the Database Migration Option (DMO) of the Software Update Manager (SUM). Which processes can you adjust in the advanced mode to speed up the migration? There are 2 correct answers to this questions. SAPup. R3trans. SQL. TP.

What are the prerequisites for querying the system view EFFECTIVE_PRIVILEGES to get data about other users and roles granted privileges? There are 2 correct answers to this question. DATA ADMIN. MONITOR ADMIN. CATALOG READ. USER ADMIN.

Which backup scenarios are allowed in multitenant database containers? There are 2 correct answers to this questions. A tenant database can initiate it's own backup unless this is prohibited by the system configuration. A tenant database con initiate it's own backup and the backup of the other tenant databases. A backup of a tenant database can be recovered to an SAP HANA single-container system. The system database can initiate it's own backup and the backup of tenant databases.

Your application runs with a technical user in a database of an SAP HANA multitenant database container. You want to execute a query across tenant databases. Which of the following prerequisites are required? There are 2 correct answers to this questions. User mapping. BI-directional communication channels. User sharing. Communication channel whitelist.

Which of the following options are valid SAP HANA backup strategies? There are 2 correct answers to this question. A data snapshot followed by incremental backups and differential backups. A storage snapshot followed by incremental backups and differential backups. A full data backup followed by incremental backup and differential backups. An offline backup followed by incremental backups and differential backup.

Which advantages of a system replication with operation mode log replay compared to delta_datashiping? There are 2 correct answers to this question. Memory consumption is lower. CPU load is reduce. Network traffic is reduced. Take over time is shorter.

You need to assign an authentication method for an SAP HANA database user. Which system privilege is required?. LDAP ADMIN. SSL ADMIN. ROLE ADMIN. USER ADMIN.

What are some of the characteristics of the repository role? There are 3 correct answers to this question. The role is granted and revoked directly by the database user. The role can be transported between systems. The role is created by technical user _SYS_REPO. The role is granted through the execution of stored procedures. The role is revoked if the grantee user is deleted.

Which kinds of patches are available in the SAP HANA 2.0 revision strategy? There are 2 correct answers to this question. Support Package Stack. Feature Package Stack. Datacenter Service Point. Support Package.

You create a new user by copying and existing user. Which predelivered role of the existing user is automatically granted to the new user?. Repository. Runtime. Monitoring. Modelling.

In which replication mode is the primary system blocked until the secondary system is available?. full sync. sync. async. syncmem.

You need to periodically monitor if the SAP HANA primary system in online. Which tool do you use?. LandscapeHostConfiguration. hanasitter. HDBAdmin. SistemReplicationStatus.

After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?. It rolls back write transactions that were open when the database was stopped. It reloads a savepoint with the restored consistent state of the database. It determines and rolls forward aborted transactions. It rolls back changes of committed transactions that were NOT written to the data area.

Which transport system do you use to transport SAP HANA content that is exclusively used by an SAP ABAP system?. Enhanced Correction and Transport System (CTS+). SAP HANA application lifecycle management (HALM). SAP HANA table export / import. SAP HANA Transport Containers (HTC).

Which of the following task can you perform using the resident SAP HANA database lifecycle management (HDBLCM)? There are 3 correct answers to this question. Import delivery units. Remove host roles. Rename the SAP HANA database system. Transport application changes. Convert to multitenant database containers.

What tenant information can you monitor in the Overall Tenant Statuses app of SAP HANA cockpit 2.0?. Security status. Isolation status. Instance number. Used memory.

How can you troubleshoot the SAP HANA installer when it crashes? There are 2 correct answers to this question. Activate the debug mode for the database trace. Run hdblcm with the check_installation action. Create the directory containing the trace file. Set the environment variables HDB_INSTALLER_TRACE_FILE to the trace file name.

A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system privilege do you assign to the technical user account on the target system?. CATALOG READ. MONITOR ADMIN. USER ADMIN. DATA ADMIN.

During unplanned maintenance, the SAP HANA database system is NOT accessible. the root cause is unclear. Which SAP HANA cockpit 2.0 option allow you to investigate this situation? There are 2 correct answers to this question. Manage full system information dumps. Open blocked transaction. Troubleshoot unresponsive system. Overall database status.

Where can you check the trace and log files when your SAP HANA database is NOT available?. In the Troubleshoot and Unresponsive System app of the SAP HANA cockpit for online administration. In the Trace app of the SAP HANA Web-based Development Workbench. In the $DIR_INSTANCE/exe/python_support directory. In the Troubleshoot an Unresponsive System app of SAP HANA cockpit 2.0.

Which security infrastructures can you integrate with SAP HANA? There are 2 correct answers to this question. Identity management. Linux syslog. Intrusion detection. Radius server.

You need to integrate an existing SAP HANA 2.0 SPS02 database system into the SAP HANA cockpit monitor infrastructure. Where do you create the technical user needed for the resource registration?. In the SYSTEMDB and the first tenant. In the SYSTEMDB and all tenants. In the SYSTEMDB. In the first tenant.

In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?. Indexserver.ini. Multidb.ini. Nameserver.ini. Sapprofile.ini.

Which certificates can you manage in SAP HANA cockpit 2.0? There are 2 correct answers to this question. X.509. PKCS #12. Kerberos. SAML.

You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?. The target database on SAP HANA 2.0 SPS00 or higher. A multitenant configuration with SYSTEMDB. A user with DATA ADMIN privilege and SELECT on _SYS_TELEMETRY schema. A user with CATALOG READ privilege and SELECT on _SYS_STADISTICS schema.

A logical error occurred in one tenant database of your SAP HANA database. What action do you perform to make the tenant consistent again?. Recover the affected tenant with the Initialize Log Area option. Restore the system database and the affected tenant with the Initialize Log Area option. Restore the database and recover the affected tenant up to the moment of the problem. Recover the affected tenant up to the moment of the problem.

How do you trigger a savepoint in an SAP HANA database?. Execute a delta merge. Start a log backup. Commit a transaction. Perform a soft shutdown.

Which system privilege do you need to change system parameters using SAP HANA cockpit 2.0?. INIFILE ADMIN. MONITOR ADMIN. TRACE ADMIN. OPTIMIZER ADMIN.

You need to recover a tenant database backup from SAP HANA system 1 into SAP HANA system 2. Which activities do you perform to recover the tenant? There are 2 correct answers to this question. Recover the tenant with the Initialize Log Area option. Start the recovered tenant database. Copy the transaction logs to the target database. Create the tenant in the target database.

What happens in the SAP HANA database system when you convert it from single container to multi container? There are 2 correct answers to this question. The name server of the system database will own topology information. The tenant database will have it's own name server. Databases are identified by a system ID (SID) and a database name. The SYSTEM user of the single-container system becomes the SYSTEM user of the tenant database.

Which task can you perform in the Certificate Management application of SAP HANA cockpit if have the TRUST ADMIN system privileges? There are 3 correct answers to this question. Create the required certificate collections. Add SAP HANA server certificates to collections. Set the purpose of individual collections. Add trusted certificates to certificate collections. Import certificates into the certificate store.

What do you do to prepare the Database Migration Option of a Software Update Manager procedure? There are 3 correct answers to this question. Move the R3trans update archive into the download folder. Move the SPAM update archive into the download folder. Extract the SAP HANA client installation archive. Extract the SAP HANA database installation archive. Move the stack.xml update file into the download folder.

What is a characteristic of the synchronous in-memory system replication mode in SAP HANA?. The primary system waits until the secondary system confirms receiving the log. The primary system does NOT wait for the confirmation of the secondary system. The primary system waits until the secondary system confirms the log was persisted. The primary system suspends transaction processing until the connection to the secondary system is re-established.

For which communication channel do you need to set up encryption manually?. Between SAP HANA system in system replication scenarios. Between databases in an SAP HANA multitenant database container system. Between the SAP HANA server and clients. Between hosts in an SAP HANA scale-out system.

What do you need to use the HDBLCM web user interface? There are 2 correct answers to this question. SYSTEM user name and password. Open communication port 1129. SAP Host Agent. Manually started hdblcm web.

You installed an SAP NetWeaver-based application on an SAP HANA database. What is the default secure store to store the password of the SAP<Schema-ID> user?. xuser. ABAP secure store file system (SSFS). instance secure store file system (SSFS). hdbuserstore.

Which R3load mode is used during a database migration option procedure?. Pipe. File. Socket. Network.

What happens when you restart an SAP HANA database system? There are 2 correct answers to this question. All row tables and row table attributes are loaded into memory. All row tables are loaded into the memory on demand. The Redo log is replayed from the last savepoint. The list of open transactions is rolled back.

Which database administration tasks can you perform in SAP HANA cockpit 2.0? There are 2 correct answers to this question. Create a data snapshot of a tenant. Perform backup checks. Troubleshoot and unresponsive system. Monitor table usage.

Which authorization assignments are possible when you set up an authorization concept in the SAP HANA database? There are 2 correct answers to this question. A role can be granted to a catalog object. A role can be granted to a role. A user can be granted to a role. A privilege can be granted to a user.

Which activities are required when you execute a SAP HANA Near Zero Downtime upgrade? There are 2 correct answers to this question. Restart the primary and secondary system. Perform a takeover. Upgrade the secondary system with the command line tool. Stop the secondary system.

Which scale-out role can you assign to the host in the nameserver.ini file? There are 2 correct answers to this question. Slave. Worker. Master 1. Standby.

Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system? There are 2 correct answers to this question. Topology data on the location of tables and table partitions. Landscape topology data on the system as a whole. User authorization of the SYSTEDB and all tenant databases. Monitoring data on the SYSTEMDB and all tenant database.

An SAP HANA scale-out system (2worker nodes and 1 standby node) has two running tenants: Tenant 1 and Tenant 2. There are 2 correct answers to this question. Set the tenant Autostart parameter to 0. Set the tenant restart mode to NO Auto-restart. Shut down the tenant before the database restart. Move the tenant to the standby node.

Which activity is always recorded when auditing is active?. Enable or disable policies. Grant or revoke roles. Delete database objects. Change system configuration.

You migrate a database using the Database Migration Option. Which tools are available to monitor the migration? There are 2 correct answers to this question. Log Tail Viewer monitor. Table Depooling monitor. Process Bucket monitor. Table Splitting monitor.

A security restriction prohibits you to create a direct SQL connections to the products SAP HANA system. Which tool can you use to monitor the system alerts of the SAP HANA database? There are 2 correct answers to this question. DBA Cockpit. SAP HANA studio. SAP HANA cockpit 2.0. Perform Lifecycle Management.

Which service is restarted by the SAP HANA startup framework?. daemon. sapstartsrv. scriptserver. indexserver.

You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one server. This system will be the productive system. Which of the following installation requirements are mandatory? There are 2 correct answers to this question. The memory resources for the SAP Netweaver AS ABAP system ande SAP HANA database must be added. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database most be the same. The instance number for the SAP Netweaver as AS system and the and SAP HANA database must be the same. The System ID (SID) fot the SAP NetWeaver AS ABAP system and the SAP HANA databasemust be different.

You configured an automatic log backup. When does the system perform a regular log backup? There are 2 correct answers to this question. The Log buffer is full. The log segment is full. After the configured time threshold has been executed. When a savepoint occurs.

You need tod elete a tenant database and preserve the backup in a SAP HANA 2.0 SPS02 database system. Which action do you perform? There are 2 correct answers to this question. Execute the SQL command: DROP Database <database_name> KEEP BACKUPS. DELETE the tenant in the SAP HANA cockpit 2.0. Delete the tenant with the option to keep the backup directory in the SAP HANA cockpit 2/0. Execute the SQL command: DROP DATABASE <database_name>.

Which value for the Autostart parameter do voy user to control the automatic start of an SAP HANA system?. 1. 0. Off. On.

Which information is provide by the backup catalog?. Backup ID. Process of a backup. Backup destination. Backup configuration.

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 us 9 hours old, and an incremental backup that is 4 hours old. The latest log backup. The last full data backup. The last committed transaction. The latest incremental bakcup.

You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?. nameserver.ini. multidb.id. indexserver.ini. global.ini.

Which prerequisites apply when you copy an SAP HANA multi-tenant database system. There are 2 correct answers to this question. The system database needs to be recovered first. The logon credentials of the operation system user must be available. The restore point in time (PIT) of the target database is the same as or earlier than the source database. The hardware configurations must be identical.

Which authorization are assigned to users of type Standard User by default? There are 2 correct answers to this question. Create objects in schema _SYS_STADISTICS. Read data in system views. Create objects in own schema. Grant roles to other users.