Hanatec

A detailed infographic depicting SAP HANA architecture, database management, and performance optimization concepts, with icons representing various components like data, security, and performance metrics, vibrant colors and modern design

SAP HANA Database Mastery Quiz

Test your knowledge of SAP HANA with this comprehensive quiz designed for database professionals and enthusiasts alike. With 119 challenging questions, you will explore various aspects of SAP HANA installation, configuration, and management.

  • Multiple choice questions with detailed scenarios
  • Covering topics from security roles to database isolation
  • Perfect for those looking to enhance their SAP HANA expertise
119 Questions30 MinutesCreated by TestingTurtle927
Which default users will be created during the installation of the SAP HANA database system? There are 2 correct answers to this question.
<sid>crypt
sap<sid>
Idapadm
Sapadm
Which is the relationship between the user group administrator and the user groups? There are 2 correct answers to this question.
Only one user group per user group administrator
Only one user group administrator per user group
Multiple user groups per user group administrator
Multiple user group administrator per user group
Which parameters are mandatory when using the hdblcm tool in batch mode? There are 2 correct answers to this question.
Password of the user sapadm
SAP HANA System ID (SID)
Data and Log path
Installation path
During the delta merge process, to which memory areas is data inserted? There are 2 correct Answers to this question.
Delta 2
Main 2
Delta 1
Main 1
The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.
The role name
The privileges assigned to the role
The users assigned to the role
The users assigned by default to this role
Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database?
Request Processing and Execution Control
Relational Engines
External Interfaces
Storage Engine and Disk Storage
Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer.
SAP Adaptive Server Enterprise
SAP Business Intelligence
SAP Intelligent Query
SAP Analytics Cloud
Your customer has purchased a 3 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 2TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.
375 GB
1.5 TB
512 GB
1.0 TB
How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?
Set up cross-database access control
Set database isolation levels to high
Edit the configuration change blacklist
Assign internal communication ports
Which user credentials are requested during the initial run of the configuration phase when performing the Database Migration Option (DMO) procedure to an SAP HANA 2.0 database tenant? There are 3 correct answers to this question.
The DBACOCKPIT user of the tenant database
The S-user for the SAP Support Portal connection
The SYSTEM user of the system database
The DDIC user in client 000 of the ABAP system
The SAP user in client 000 of the ABAP system
What are advantages of column store tables? There are 3 correct answers to this question.
Columns can be partitioned
Only the columns required are actually loaded to memory
They are optimized for high-volume read /write transactional processing
Data footprint is automatically reduced through compression
Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? There are 3 correct answers to this question.
Add dedicated tenant OS users to the sapsys group.
Lock the adm OS user / O Add dedicated tenant
users to the <sid>shm group.
Remove the adm OS user from the sapsys group.
Create dedicated tenant OS users for each tenant.
Which information is provided via the SUM UI? There are 3 correct answers to this question.
The content of log files via the log viewer
The memory consumption of SUM
A progress bar for the overall procedure
The active roadmap step
Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correct answers to this question.
Delta Backup
Backup of Configuration files
Data Backup
Data Snapshot
The SAP HANA database is NOT reachable, and the root cause is unclear. Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.
Troubleshoot unresponsive system
Overall database status
Manage full system information dumps
Open blocked transactions
Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.
_SYS_WORKLOAD_REPLAY
_SYS_STATISTICS
_SYS_SQL_ANALYZER
_SYS_TELEMETRY
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases? There are 2 correct answers to this question.
The cross-tenant database communication must be explicitly activate
The bidirectional communication channel must be whitelisted
The user in the source system must have sufficient privileges in the target database
The user in the source system must be associated with a user in the target database
What can you Directly assign to a user with the Manage Users App in SAP HANA Cockpit? Note: There are 2 correct answers.
Scopes
Privileges
Roles
Role collections
How are savepoints triggered? There are 2 correct answers to this question
By a database soft shutdown.
By issuing a transactional commit.
By performing a delta merge.
By performing a database backup.
How are hosts assigned to the shared storage in an SAP HANA scale-out system? There are 2 correct answers to this question.
The master name server is assigned to its master data volume.
The master server is assigned to all data volumes.
The slave servers are assigned to their own data volumes.
The standby server is assigned to the master data volume.
Which SAP HANA feature ensure that committed data is NOT lost if there is a power failure? Note: There are 2 correct answers.
Persisted redo logs
Automatic savepoints
Memory allocation limit
Delta merge
You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers. Which rules apply? There are 2 correct answers to this question.
The system database must run on the standby host.
The system database instance must run on all hosts (worker and standby).
The tenant databases must be able to be scaled out to all hosts (worker and standby).
The tenant databases must run on the worker hosts.
Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? There are 3 correct answers to this question.
Create credentials for authenticated access to the source system.
Create a tenant on the target system identical to the source system.
Back up the source tenant database.
Configure a secure connection from target system to source system.
Create credentials for authenticated access to the target system
SAP HANA system replication is configured and active between two SAP HANA systems. After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.
A restart of the primary system
A restart of the secondary system
An upgrade of the secondary system
An upgrade of the primary system
Which privileges are assigned automatically when you create a technical user during the register resource procedure in SAP HANA cockpit? There are 2 correct answers to this question.
SELECT on the _SYS_TELEMETRY schema
RESOURCE ADMIN
SELECT on the _SYS_STATISTICS schema
CATALOG READ
What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question.
Having the data and log volumes on the different disks.
Obtaining the hardware certification from SAP for the existing hardware you are going to use.
Obtaining C_HANATEC_XX Certification.
Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity
How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.
Trigger a save point.
Create a fullback snapshot.
Create an internal database snapshot.
Execute the hdbbackupdiag tool.
You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?
Indexserver.ini
Multidb.ini
Global.ini
Nameserver.ini
Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server? There are 2 correct answers to this question.
User mapping
User creation
Password policy configuration
Role assignment
Which of the following users are able to start and stop a distributed SAP HANA Database System? There are 2 correct Answers to this question.
ROOT user
ADM user
SYSTEM user
What is the correct sequence of the following four steps in the restart of the SAP HANA database system? Please choose the correct answer.
1. Aborted transactions are rolled back. 2. Open transactions are recovered. 3. Row tables are loaded into memory. 4. Column tables are loaded.
Aborted transactions are rolled back.
Row tables are loaded into memory. 3. Open transactions are recovered. 4. Column tables are loaded.
Row tables are loaded into memory. 2. Column tables are loaded. 3. Open transactions are recovered. 4. Aborted transactions are rolled back.
Row tables are loaded into memory. 2. Open transactions are recovered. 3. Aborted transactions are rolled back. 4. Column tables are loaded.
Who owns an SAP HANA Deployment Infrastructure (HDI) role? Please choose the correct answer.
The SYSTEM user of the tenant database
The user who created the role
The _SYS_REPO technical user
The container-specific technical user
What is a prerequisite when you install the SAP Landscape Management tool? Please choose the correct answer.
SAP HANA XS Advanced
SAP NetWeaver Application Server Java
SAP Fiori launchpad
SAP NetWeaver Application Server ABAP
What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.
Kernel settings
Network configuration
Memory configuration
Missing OS Patches
Which of the following events occur while the merge operation is running? There are 2 correct answers to this question.
The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage.
The content of the complete main storage is persisted to disk.
Uncommitted changes in the first delta storage are rolled back.
All write operations go to the second delta storage.
Which SQL privileges can you grant to another user?
CREATE SCHEMA
ATTACH DEBUGGER
DATA ADMIN
CATALOG READ
In single-host SAP HANA systems, you can use plain attached storage devices, such as Small Computers System Interface hard drives, solid-state drives (SSDs), or storage area networks (SANs). However, to build a multi-host system with failover capabilities, the storage must ensure which of the following conditions? There are 2 correct answers to this question.
SYSTEM users replaced by standby host
The failed worker host no longer has access to write to files
The standby host has file access
The standby host has access to write to files
Why are repository roles preferred over catalog roles? Note: There are 2 correct answers.
They are created by the technical user
They are revoked if the database user that granted them is deleted.
They are transportable runtime objects
They are transportable design-time objects
What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system? Please choose the correct answer.
For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB
For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB
For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB
For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB
What can you use the Secure User Store (hdbuserstore) for? There are 2 correct answers to this question.
To store connection information on the SAP HANA XS Advanced engine
To configure failover supporting a 3-tier scenario
To configure an SAP HANA Auto-Restart Fault Recovery Support
To store connection information on the SAP HANA database client
Where are the R3load processes located when performing Database Migration Option (DMO) procedure using in-place migration?
On the Additional Application Server (AAS) host
On the host and target host
On the remote target database host
On the Primary Application Server (PAS) host
The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory?
Standby memory
Physical memory
Resident memory
Virtual memory
What are the advantages of the DMO procedure? There are 3 correct answers to this question.
DMO is an inplace procedure by default, keeping the application server host.
DMO allows an easy reset during the procedure.
DMO allows a lower target release on SAP HANA database.
DMO combines several steps into one procedure.
Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.
CREATE ANY
EXPORT
EXECUTE
CREATE SCHEMA
DEVELOPMENT
Which parameters do you need to change before you can analyse the memory usage of running SQL statements? There are 2 correct answers to this question.
Memory_tracking
Statement_memory_limit
Enable_tracking
Use_in_memory_tracing
Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.
The same number of active hosts and standby hosts must be installed
Both must have the same SAP HANA version
An explicit read-only connection between both systems must be available
The CPU architecture must be identical
Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to
Keep all partitions on different hosts
Keep the number of partitions per table high.
Keep the number of partitioned tables low.
Keep the number of key columns low.
Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question
Preprocessor
XS Engine
Index server
Compile server
A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0. Which system privileges do you assign to the technical user account on the target system?
CATALOG READ
DATA ADMIN
MONITOR ADMIN
USER ADMIN
How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.
Back up the system database and all tenant databases individually.
Back up the system database and all tenant databases in one step.
Back up the complete database system.
Backup the complete storage system.
Which file systems are supported for the SAP HANA database system? There are 3 correct answers to this question.
GPFS
NFS
MPFS
Dxfs
XFS
Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.
Cockpit User Administrator
Cockpit User
Cockpit Resource Administrator
Cockpit Administrator
Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.
The source and target database system are of the same type
The Primary Application Server can be moved to a target system Landscape
The target database is SAP Adaptive Server Enterprise (ASE)
The source system is Application Server (AS) Java-base
You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?
A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema
A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema
A multitenant configuration with SYSTEMDB
The target database on SAP HANA 2.0 SPS00 or higher
What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer.
Back up tenant database
Copy tenant database.
Start tenant database.
Restart secondary system.
The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems. From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)?
File Export SAP HANA Landscape
File archive SAP HANA Landscape
File archive SAP HANA Export
File Export Landscape SAP HANA
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 question.
The SAP ABAP kernel on the application server
The DBACOCKPIT user on the SAP HANA database
The updated BRTOOLS on the non-SAP database
The deleted SAP BusinessObjects Business Intelligence data on the non SAP database
The shadow schema on the non-SAP database
Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with secondary time travel? There are 2 correct answers to this question.
The CPU architecture must be identical.
An explicit read-only connect on between both systems must be available
Both must have the same SAP HANA version.
Both systems are located in the same data center.
You install a productive multi-host system with failover capabilities. Which storage condition prerequisites must be ensured? Note: There are 2 correct answers.
The standby host has file access
The standby host has NO file access
The failed worker host has access to write files
The failed worker host no lonqer has access to write to files
Which of the following actions are audited by default in SAP HANA? There are 2 correct answers to this question.
Deletion of audit entries from the audit trail
Installation of SAP HANA license
Changes to system configuration
Creation, modification or deletion of audit policies
Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.
CPU threshold for rejecting requests
Maximum request queue size
Maximum parallel 10 requests
Memory limit for queuing requests
SQL statement request memory limit
After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?
It determines and rolls forward aborted transactions
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 rolls back changes of committed transactions that were NOT written to the data area
How can troubleshoot HANA installer when its crashes There are 2 correct answers to this question.
Run hdblcm with the check_installation action
Set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename
Create the dirctory containing the trace file
Activate the debug mode for the database trace
In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.
When the log buffer is full.
When the time threshold is exceeded.
When the log segment is full.
When a commit occurs.
Which of the following recovery types is not supported for delta backups?
Recover the database to its most recent state.
Recover the database to a specific point in time.
Recover the database to a specific data backup.
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.
SAP Application Performance Standard (SAPS)
Network throughput
Input/output operations per second (IOPS)
Main memory
Persistent storage
Which R3load mode is used during an inplace SUM database migration option procedure?
Socket
File
Network
Pipe
Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? There are 2 correct answers to this question.
SYNCMEM
FULL SYNC
SYNC
ASYNC
In which scenario do you need SAP expert sizing? There are 2 correct answers to this question.
Costumers are new to SAP application and SAP HANA
Carving out ERP functionality from the source system to the ERP on SAP HANA system
Costumers want to migrate their existing ERP
Consolidating multiple ERP source systems into one ERP system on SAP HANA
Which prerequisites must you consider to rename a tenant database in the sap HANA cockpit? There are 2 correct answers to this question.
The tenant database must be unloaded from memory.
The on-disk tenant directory should be a mount point
The tenant database is stopped
The Database that is not in move operation
What is the merge methods that are triggered by the SAP HANA system process? There are 2 correct answers to this question.
Auto
Smart
Hard
Critical
In a Multiple Database Container (MDC) system, which priviledge do you need to perform database-specific backups on all tenant databases?
Database Admin
Backup Admin
Tenant Admin
Backup Operator
What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for productive SAP HANA database system? There are 2 correct answers to this question.
Obtaining the hardware certification from the SAP for the existing hardware you are going to use.
Obtaining C_HANATEC_XX Certification
Having 10 GBit/s for the internal zone for network connectivity.
Having the data and log volumes on the different disk
The recovery of of your Productive SAP HANA Tenant database fails, In which cases can you resume the incomplete recovery. There are 2 correct answers to this question.
Aborted recovery of a delta data backup
Aborted recovery of the configuration file
Aborted recovery of a log backup
Aborted recovery of a complete data backup
How can the database administrator disable tenant database functionalities?
Using hdbuserstore tool
Using the Manage blacklisted parameter app
Using the resident hdblcm tool
Using the Manage Restricted Features app
Which System priviledge must you have to redistribute tables across the hosts in the scale-out system?
RESOURCE ADMIN
DATA ADMIN
OPTIMIZER ADMIN
WORKLOAD ADMIN
Which SAP HANA cockpit can you use to investigate a system offline situation? There are 2 correct answers to this question.
Troubleshoot unresponsive system
Full system information dump
Out-of-memory event monitor
CPU usage monitor
Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers.
Development
Quality assurance
Production
Custom
Sandbox
What is the additional disk space factor required during delta merge operations?
1.2
4.0
1.6
3.0
Which characteristics describe an SAP HANA Multiple Database Container (MDC) system? There are 3 correct answers to this question.
The database Isolation increases the isolation between tenant databases on the operating system level.
The name server provides index server functionality for the system database.
A Multiple Database Container system is identified by a single System ID (SID)
The name server owns information about the location of the tables and table partition in databases.
You are checking and monitoring SAP HANA System replication. Which status indicates a temporary connection loss of the secondary system?
Error
Syncing
Initializing
Unknown
What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.
Delta data shipping takes place with continuous read-only access to the secondary system.
Delta data shipping takes place every 5 minutes.
Delta data shipping takes place in addition to continuous log shipping.
Delta data shipping takes place in addition to continuous log replay.
Your application runs with technical user in a database of an SAP HANA mutitenant 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 question
Communication channel whitelist
Bi-directional communication channel
User mapping
User sharing
Which connection type can a standard restricted user can use to connect to the SAP HANA Database?
ODBC
TCP/IP
JDBC
HTTP(S)
Which of the following are part of the software logistics (SL) toolset? There are 3 correct answers to this question
Software Update Manager (SUM)
Transport Management System (TMS)
Software Provisioning Manager (SWPM)
Support Package Manager (SPAM)
What kind of query language statements can be used in the SAP HANA Database Explorer
SQL
MDX
XML
TCL
Which protocol is used by the statistic service to collects statistical and performance information
JSON
MDX
SNMP
SQL
Service in charge of starting sap HANA database
Sapstartsrv
Sapcontrol
Hdbdaemon
Which file system location are suggested to install an SAP HANA multi-host system
/hana/shared
/hana/log/
/hana/
/hana/
Which connection do you need to enable explicitly for the restricted user? There are 2 correct answers to this question.
JDBC
OLEDB
ADO.NET
ODBC
Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL? There are 2 correct answers to this question.
HANASitter
Hdbcons
HDBAdmin
Sapcontrol
Which parameter do you set to protect an SAP HANA database system against uncontrolled quiries that consume excessive memory? There are 2 correct answers to this question.
Total_statement_memory_limit
Reject_memory_threshold
Statement_memory_limit
Memory tracking
What is the first node limit for planning an SAP HANA scale-out system
>=8CPU
>=6TB
>=8TB
>=12CPU
Which SAP HANA features are secured by certificates saved in the SAP HANA certificate store?
Client-server communication over JDBC
SAP HANA tenant database replication
Internal communication channels with the system PKI
HTTPS client access using the SAP HANA Web Dispatcher
Which tasks can you perform using SAP HANA database lifecycle manager (HDBLCM) on installation media?
Uninstall SAP HANA database components
Update SAP HANA and its component
Rename the SAP HANA database system
Extract components
What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable Changes?
Page management and logger
Session Management and log volumes
Column store and row store
Metadata manager and transaction manager
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?
Kernel Profiler
End-to-End
User-Specific
SQL
You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which advanced DMO options can you adjust to speed up the migration? There are 2 correct answers to this question.
SQL
R3trans
SAPup
TP
How can you optimize the Database Migration Option (DMO) procedure downtime for a production system? There are 2 correct answers to this question.
Provide the measured table migration duration data for optimal table sequencing during benchmarking.
Set the optimal number of R3load processes during benchmarking and the DMO procedure
Use the test cycle option on to find the optimal number of R3load process in a test run
Use benchmarking option to find the optimal throughput during the DMO procedure
Which Prerequisites are necessary for productively using SAP HANA Cockpit 2.0?
A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL)
A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed
A central SAP HANA database 2.0 SPS05 multitenant database system with at least 16 GB of RAM
SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed
Which checks are executed when you run the Hardware Configuration Check Tool (HWCCTL)?
Validation of the operating systems configurations setting for the Linux Kernel
Measurement of the data throughput between SAP HANA nodes and storage
Validation of the LPAR configuration settings on IBM Power Servers
Measurement of data throughput between the linux kernel and CPU
Measurement of data throughput between the linux kernel and CPU
Measurement of the data throughput between CPU and DRAM
Your customer ask you to set up alert monitoring in saP hana cockpit 2.0 . Which alert properties can you configure in hana cockpit
Alert Threshold value
Email alert notification
Alert checker category
Schedule period
Schedule activation
Check interval
What are the supported operating systems for SAP HANA on IBM Power System?
For SAP HANA 1.0, SUSE Linux Enterprise Server (SLES) 11 SP4
For SAP HANA 2.0, SUSE Linux Enterprise Server (SLES) 12 and 15
For SAP HANA 1.0, Red Hat Enterprise Linux (RHEL) 6.10
For SAP HANA 2.0, Red Hat Enerprise Linux (RHEL) 7.2
Which parameters do you set to protect an SAP HANA Database System against uncontrolled queries that consume excessive memory?
Total_statement_memory_limit
Statement_memory_limit
Memory_tracking
Reject_memory_threshold
What you must do to configure the data backup on scale out hana system
Verify that data and log backup destinations are valid through the system
Ensure the availability of shared backup storage
Has own backup directory and storage
If you need to integrate an existing hana 2 sps 3 db into the hana cockpit monitor infrastructure, where do you create the technical user for the resource registration
In the system database and all tenants
In the system database and first tenants
In the tenant database
In the system database only
Which tools do you use to delete diagnosis files? There are 2 correct answers to this question.
SAP HANA Web-based Development Workbench
SAP HANA cockpit
SAP HANA cleaner
SAP HANA database explorer
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting? Please choose the correct answer.
The R3LDCTL
The Process Bucket monitor
The Log viewer
The Observer Monitor
What kind of query language statements can be used in the SAP HANA database explorer
SQL
MDX
SNMP
JSON
Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.
CPU threshold for rejecting requests
Maximum request queue size
Memory limit for queuing requests
Maximum parallel 10 requests
SQL statement request memory limit
How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.
Back up the system database and all tenant databases individually.
Backup the complete storage system
Backup the complete database
Backup the system and all tenant database in one step
Which sap recommendations do you follow to create an optimal table partitioning plan for sap business suite powered by sap
Have a high number of partitions per table
Have partitions of a table on the same host
Have a low number of keys
Have a high number of partitioned tables
How can you perform a complete back up of an SAP HANA database system? Please choose the correct answer.
Back up the system database and all tenant databases individually
Backup the complete storage system
Backup the complete database
Backup the system and all tenant database in one step
In which replication mode is the primary system blocked until the secondary system is available?
Full sync
Async
Mem-sync
Sync
Who do you ensure that web-based application send https requests to specific databases in an sap hana multiple container system?
Configure an sap web dispatcher for every tenant databases
Configure an alias hostname for every tenant database
Check the hostname mapping to internal HTTPS ports
Check that all requests with physical hostnames are forwarded to tenant database
What is included with the Predictive Analysis Library (PAL)? There are 2 correct answers to this question.
Data preparation functions
Text mining functions
Flowgraphs
Predictive algorithms
After confirming Lock now, which actions are still possible?
Applying SAP notes via Note Assistance (SNOTE)
Creating and changing application data (e.g. VA01) and user master records SU01)
Developing via ABAP workbench
Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management system (STMS)
Reloading column tables in this way restores the database to a fully operational state more quickly. However, it does create performance overhead, and may not be necessary in nonproductive systems, how can you deactivate the the reload feature? Please choose the correct answer.
Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false
Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true
Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to true
Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false
Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.
Set the password for the system database user.
Trigger the conversion in the SAP HANA cockpit 2.0.
Create an tenant user for operating system
Create target
{"name":"Hanatec", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of SAP HANA with this comprehensive quiz designed for database professionals and enthusiasts alike. With 119 challenging questions, you will explore various aspects of SAP HANA installation, configuration, and management.Multiple choice questions with detailed scenariosCovering topics from security roles to database isolationPerfect for those looking to enhance their SAP HANA expertise","img":"https:/images/course8.png"}
Powered by: Quiz Maker