HANA Administration Flashcards by Rauno Veberson

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.

A. SAP HANA database explorer
B. SAP HANA Cloud Central
C. SQL trace analyzer
D. Full system information dump

A
D

How well did you know this?

Not at all

Perfectly

Which SAP HANA cockpit application can you use to investigate a system offline situation?

A. Alert Monitor
B. Full System Information Dumps
C. Troubleshoot Unresponsive System
D. Performance Monitor

How well did you know this?

Not at all

Perfectly

Which SAP HANA trace must you activate to analyze performance issues with systems where thirdparty software cannot be installed?

A. End-to-end
B. Kernel profiler
C. SQL
D. Performance trace

How well did you know this?

Not at all

Perfectly

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.

A. HTML file
B. XML file
C. TXT file
D. JSON file
E. CSV file

A
C
E

How well did you know this?

Not at all

Perfectly

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

A. The executed statements trace
B. Your personal stored procedures
C. Your personal SQL scripts
D. The SAP SQL statement collection

C
D

How well did you know this?

Not at all

Perfectly

From which system views can you export content when using the Performance Monitor app? Note:
There are 3 correct answers to this question.

A. SYS.M_WORKLOAD
B. SYS.M_SERVICE_STATISTICS
C. SYS.M_LOAD_HISTORY_HOST
D. SYS.M_SERVICES
E. SYS.M DATABASE

C
D
E

How well did you know this?

Not at all

Perfectly

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

A. To execute scripts from the SQL statement collection for SAP HANA
B. To collect all the executed SQL statements and generate a searchable library list
C. To share custom SQL scripts with the whole administration team
D. To determine special database information not available in the SAP HANA cockpit

A
D

How well did you know this?

Not at all

Perfectly

Which properties can you change in the Alert Definitions app? Note: There are 3 correct answers to
this question.

A. The interval settings
B. The proposed solution
C. The category
D. The schedule
E. The thresholds

A
D
E

How well did you know this?

Not at all

Perfectly

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.

A. Slack
B. Microsoft Teams
C. WhatsApp
D. Signal

A
B

How well did you know this?

Not at all

Perfectly

What tools can you use to view the expensive statement trace file? Note: There are 2 correct answers
to this question.

A. SAP HANA Cloud Central
B. SAP BTP cockpit
C. SAP HANA cockpit
D. SAP HANA database explorer

C
D

How well did you know this?

Not at all

Perfectly

Which services are shared in the Manage Services app in the SAP HANA Cloud database? Note: There
are 2 correct answers to this question.

A. Compile server
B. Name server
C. DP server
D. DI server

A
B

How well did you know this?

Not at all

Perfectly

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

A. Linux kernel information
B. Cloud connector status
C. CPU states
D. NUMA memory bandwidth test

C
D

How well did you know this?

Not at all

Perfectly

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

A. Service Plan Assignment editor
B. Start Recovery wizard
C. Manage Configuration editor
D. Cloud Foundry CLI

B
C

How well did you know this?

Not at all

Perfectly

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

A. Workload classes
B. Workload analysis
C. Admission control
D. Load unit configuration

How well did you know this?

Not at all

Perfectly

What is the maximum number of replicas you can configure for SAP HANA Cloud?

A. 1
B. 3
C. 2
D. 4

How well did you know this?

Not at all

Perfectly

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.

A. The user in the source system must have sufficient privileges in the target database.
B. The cross-tenant database communication must be explicitly activated.
C. The user in the source system must be associated with a user in the target database.
D. The bidirectional communication channel must be allowed.

B
C

How well did you know this?

Not at all

Perfectly

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

A. Using the expensive statements trace in the SAP HANA cockpit
B. Using the Auditing card in the SAP HANA cockpit
C. Using the SQL Console in the SAP HANA database explorer
D. Using the kernel profiler trace in the SAP HANA database explorer

B
C

How well did you know this?

Not at all

Perfectly

Which options for Audited Action Status are available in the SAP HANA Cloud, SAP HANA database?
Note: There are 2 correct answers to this question.

A. Critical
B. Enabled
C. All
D. Unsuccessful

C
D

How well did you know this?

Not at all

Perfectly

Which audit trail target is used by default in the SAP HANA Cloud, SAP HANA database?

A. Database table
B. Kernel trace
C. Linux syslog
D. CSV text file

How well did you know this?

Not at all

Perfectly

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

A. Token based
B. SAML based
C. Kerberos based
D. Certificate based

How well did you know this?

Not at all

Perfectly

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

A. Docker
B. Kubernetes
C. Runtime
D. Design time

C
D

How well did you know this?

Not at all

Perfectly

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.

A. User group assignment
B. User creation
C. Password policy configuration
D. Role assignment

B
D

How well did you know this?

Not at all

Perfectly

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

A. The user who created the role
B. The DBADMIN user of the tenant database
C. The_SYS_REPO technical user
D. The container-specific technical user

How well did you know this?

Not at all

Perfectly

What cryptographic libraries are supported in SAP HANA? Note: There are 2 correct answers to this
question.

A. CommonCryptoLib
B. Libgcrypt
C. OpenSSL
D. LibreSSL

A
C

How well did you know this?

Not at all

Perfectly

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

C D

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

A B

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

C D

Which database storage technology does native storage extension utilize in SAP HANA Cloud? A. Dynamic tiering B. Disk-based C. In-memory D. Extension node

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

B C

Where does the SAP HANA Cloud, SAP HANA database run in SAP BTP? A. Kubernetes container B. SAP HANA Cloud Central C. Cloud Foundry runtime D. Kyma runtime

Which object types are stored in an SAP HANA catalog? Note: There are 3 correct answers to this question. A. Cubes B. HDI containers C. Agents D. Cockpit roles E. JSON collections

A C E

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

A B C

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. A. Web dispatcher B. Index server C. XS engine D. Compile server

B C

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? A. 2 weeks B. 3 months C. 1 year D. 7 months

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. A. XFS B. Btrfs C. GPFS D. EXT4

A C

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

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

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

A B

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. A. Disable ODBC/JDBC Access must be set to "Yes". B. Authorization method must be set to "LDAP". C. Creation of Objects in Own Schema must be set to "No". D. User Group must be set to "Restricted". E. PUBLIC role must be set to "No".

C D E

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. A. Assign User Groups B. Create Role in Schema C. Assign to Role Group D. Assign LDAP Groups E. Create Group Admin

B C E

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

A B C

Which database objects can you manipulate if you have the object privilege activity ALL PRIVILEGES? Note: There are 2 correct answers to this question. A. Functions B. Views C. Procedures D. Schemas

B D

What can you assign to a user with the User Management app in the SAP HANA cockpit? Note: There are 2 correct answers to this question. A. LDAP identity provider B. Scopes C. LDAP authorization mode D. User group

C D

What can you assign to a user group in the SAP HANA Cloud, SAP HANA database? Note: There are 2 correct answers to this question. A. Password policies B. Users C. Permissions D. Roles

A B

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

C D

Which user is assigned by default when you provision a data lake in SAP HANA Cloud? A. SYSTEM B. DBADMIN C. COCKPIT MONITOR D. HDLADMIN

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

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. A. Recover instance B. Change instance backup schedule C. Decrease data volume size D. Create instance

A D

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. A. hana B. relational data lake C. multi-environment tools D. tools

A D

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

How can you start an SAP HANA Cloud database instance using the command line? A. alter system start database B. cf update-service -c "{ "data": {"service Stopped": false}}" C. sapcontrol -nr -function StartSystem D. of start

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

A B

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

B C

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. A. Cockpit User B. sap C. Database User D. Root E. adm

A C E

Where can you start/stop an SAP HANA Cloud, SAP HANA database? A. SAP HANA HDBSQL B. SAP BTP cockpit C. SAP HANA Cloud Central D. SAP HANA cockpit

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

A B C

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

A C

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

Which user is automatically created when you add a data lake to an SAP HANA Cloud, SAP HANA database? A. HDLADMIN B. SAPSA C. DBA D. DBADMIN

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

A B

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. A. Update the SAP HANA database system and its components. B. Rename the SAP HANA database system. C. Uninstall the SAP HANA database system and its components. D. Extract the SAP HANA database system components.

A D

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

A D

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. A. SAP HANA system ID (SID) B. Password of user sapadm C. Data and log path D. Installation path

A B

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. A. Native storage extension B. In-memory C. Data lake D. Hadoop distributed file system

A B

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

B C D

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. A. Replicas B. vCPUs C. Storage D. Memory

B D

What options do you have when deploying an SAP HANA Cloud, SAP HANA database with an integrated data lake? Note: There are 2 correct answers to this question. A. Create an SAP HANA Cloud database with a separate data lake. B. Create an SAP HANA Cloud database with the data lake on premise. C. Create an SAP HANA Cloud database and later add a data lake. D. Create an SAP HANA Cloud database and include a data lake in one step.

C D

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. A. SYSTEM B. syb C. SAP D. sapadm E. crypt

A D E

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

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

How can you ensure that a consistent database status is saved using data snapshots? A. Execute the hdbbackupdiag tool. B. Create a fallback snapshot. C. Create an internal database snapshot. D. Trigger a savepoint.

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

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

C D

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

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

Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note: There are 3 correct answers to this question. A. Data snapshot B. Incremental backup C. Complete backup D. Log backup E. Differential backup

B C E

In which situations can you resume the failed recovery of your productive SAP HANA tenant database? Note: There are 2 correct answers to this question. A. An aborted recovery of a delta data backup B. An aborted recovery of a log backup C. An aborted recovery of a complete data backup D. An aborted recovery of the catalog backup

A B

Which scenarios are supported for a database copy using backup and recovery from a source machine to a target machine? Note: There are 2 correct answers to this question. A. The source system has more nodes than the target system. B. The source system and target system have different SIDS. C. The source system and target system have different CPU architecture. D. The source system release version is higher than the target system.

B C

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

A C

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

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

You are tasked with configuring high availability setup for SAP HANA. Which of the following components are crucial? Note: 3 correct answers A. Statistics server B. Name server C. Preprocessor server D. Index server

A B D

What does SAP HANA smart data integration (SDI) primarily facilitate? A. Backup and recovery B. Data cleansing C. User authentication D. Real-time data replication

Which memory areas are part of the SAP HANA memory pool? Note: There are 3 correct answers to this question. A. Table data B. Code and stack C. Database management D. Database used memory E. Allocated memory pool (free)

A C E

Which storage service type is one of the possible options when adding a data lake to an existing SAP HANA Cloud, SAP HANA database? A. Network file system B. SAP Native storage C. SAP HANA native storage extension D. Logical volume manager

Which service is exclusively available in an SAP HANA database instance of SAP HANA cloud? A. Index server B. Compile server C. Name server D. SAP Web Dispatcher

Which file formats can you use to import data into an SAP HANA cloud database instance when using the SAP HANA database explorer? Note: There are 2 correct answers. A. CSV B. Binary C. Parquet D. YAML

A C

What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario? Note: 3 correct answers. A. Input/output operations per second (IOPS) B. Network throughput C. Persistent storage D. SAP Application Performance Standard (SAPS) E. Main memory

C D E

Which parameters can you change when creating a data lake in SAP HANA cloud? 2 correct answers A. The amount of storage B. The number of replicas C. The amount of memory D. The number of workers

A D

What type of privilege do you need to create a schema using the SQL Console in SAP HANA Cloud? A. Object B. Package C. Application D. System

What are the supported operating systems for SAP HANA on IBM Power Servers? 2 correct answers A. HANA 1.0, RHEL 7.2 B. HANA 2.0, RHEL 9.x C. HANA 1.0, SLES 11 SP2 D. HANA 2.0, SLES 15 SPx

B D

Which actions can you perform in SAP HANA database explorer for SAP HANA Cloud? 2 correct answers A. Navigate the catalog B. Configure trace files C. Examine host diagnostic files D. Show instance overview

A D

You install an SAP HANA database and SAP NetWeaver AS for ABAP on one productive system. Which of the following installation requirements are mandatory for both systems? 2 correct answers A. The instance number must be the same B. The memory resources must be added C. The system IDs (SIDs) must be different D. The disk resources must be the same

B C

You want to perform the database migration option (DMO) procedure. Which components have to be updated if they are not on the right version level? Note: There are 3 correct answers to this question. A. ABAP Kernel B. SPAM/SAINT C. ST-PI D. SAP Host Agent E. Database client software

B D E

The SAP HANA database system is not available through the SQL interface. Which options do you have to collect information to monitor connections, transactions, blocked transactions and threads? Note: 2 correct answers. A. PerTrace.py B. Manage full system information dumps C. Troubleshoot unresponsive systems D. emergencyInfo.py

B C

HANA Administration Flashcards

C_DBADM_2404 (96 cards)