In the Aggregate Health Monitor application, you are viewing the overall status of all tenants assigned to your SAP HANA cockpit user Which user retrieves this database status information? A named user with monitor permissions The system user The cockpit_admin user A technical user with limited permissions.
Which of the following options are valid SAP HANA backup strategies?
There are 2 correct answers to this question. A storage snapshot followed by incremental backups and differential backups An offline backup followed by incremental backups and differential backups A full data backup followed by incremental backups and differential backups A data snapshot followed by incremental backups and differential backups.
Which connection type can a standard restricted user use to connect to the SAP HANA database? ODBC TCP/IP JDBC HTTP(S).
Which of the following traces has the default configuration status of "Active"? Performance trace Database trace SQL trace Kernel profiler.
You need to enable single sign-on for SAP HANA with Microsoft Active Directory. Which authentication method allows you to use the Active Directory groups? X.509 client certificates Security Assertion Markup Language (SAML) SAP Logon and assertion tickets Kerberos.
Which package of SAP HANA cloud platform provides a vast set of platform services for the most common pattern in software engineering, such as persistence, connectivity, identity and document management? SAP HANA Infrastructure Services SAP HANA DBServices SAP HANA AppServices SAP HANA Enterprise Cloud.
Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values? System Privileges Object Privileges Analytic Privileges Package Privileges.
How is a savepoint triggered in SAP HANA? By performing a soft shutdown By committing a transaction By starting a log backup By executing a delta merge.
You are applying SAP Support Packages during an SUM DMO run to SAP HANA Which options are possible to select in the main dialog Tool Configuration?
There are 3 correct answers to this question.
Single System Standard Advanced Expert Mode.
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 is 9 hours old and an incremental backup that is 4 hours old. To which point in time can you recover to minimize the data loss? The latest log backup The latest incremental backup The last commited transaction The last full data backup.
Your customer wants to know when the productive SAP HANA system was updated and to
which version. Where do you find this information?
There are 2 correct answers to this question In the General Information app of SAP HANA cockpit 2.0 In the administration editor of the SAP HANA studio In the catalog view of the SAP HANA Web-based Development Workbench In the SAP HANA database explorer for SAP HANA cockpit 2.0.
Which R3load mode is used during a database migration option procedure? Pipe File Network Socket.
Which encryption service can you activate in HANA
There are 3 correct answers to this question. Pages-in memory Data storage snapshot backup log.
Out of complete SAP HANA platform, which from the following components are not part of SAP HANA Database?
There are 3 correct answers to this question. HWCCT Database Services Smart Data Access INA file loader EPM Services.
What is the order specified for registering resources and creating resource groups and cockpit users with the Cockpit Manager? Resources, Resource Groups, Cockpit Users Resource Groups, Resources, Cockpit Users Cockpit Users, Resources, Resource Groups There is no order to follow.
Which partitioning type must you use to produce an equal distribution of rows in the SAP HANA database? Round-robin Aging Hash-range Range.
You implement a multi-host SAP HANA system with auto-failover capabilities. What are the requirements for the disk storage?
There are 2 correct answers to this question. The slave node is set to backup standby. The failed worker host gets fenced during failover. The standby host has file access. The master node is fully clustered.
What are prerequisites for changing the SSFS Master Keys?
There are 2 correct answers to this question. You have the server root privilege INIFILE ADMIN You have the system privilege INIFILE ADMIN You have the credentials of the Operating system user <sid>adm that was created when the
system was installed. You have the credentials of the SYSTEM user.
Which command can re-encrypt the system PKI SSFS with a new key? RSEC_SSFS_DATAPATH=/usr/sap/<SID>/SYS/security/global/rsecssfs/data
RSEC_SSFS_KEYPATH=/usr/sap/.
Which customer-specific configuration files are created during the installation of an SAP HANA database?
There are 2 correct answers to this question. global.ini daemon.ini indexserver.ini nameserver.ini.
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. Generate the system database before the conversion. Create an operating system user for the converted tenant database.
SAP HANA uses SSFS to protect the root encryption keys. These root keys protect all encryption keys used in the SAP HANA database from unauthorized access.
What other two main functions of the root encryption keys?
There are 2 correct answers to this question. The root key used for the internal data encryption service of the database The root key used for data volume encryption The root key used for users log encryption The root key used for transactions volume encryption.
What is a prerequisite before you can install SAP HANA cockpit 2.0 as a central monitoring tool for productive SAP HANA databases? 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 SAP Solution Manager 7.2 on SAP HANA 2.0 with SAP HANA extended application services, advanced model (XS Advanced) A dedicated server with at least 16GB of RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL).
To maintain good read performance in a constantly changing database, which two components are used?
There are 2 correct answers to this question. Column store Memory store Delta storage Main storage.
In SAP HANA Cockpit 2.0, how can you register Cockpit Users, Resource Groups, and Resources with the Cockpit Manager? Start the Cockpit Manager with the following URL: https://<port-number>: Start the Resource Manager with the following URL: https://<cockpit-host>:.
Which activities are required when you execute an SAP HANA Near Zero Downtime upgrade?
There are 2 correct answers to this question. Perform a takeover3. Upgrade the secondary system with the command line tool. Stop the secondary system. Restart the primary and secondary system.
you register a new resource in SAP HANA cocpit 2.0 what prerequiste does the resource require? A user with data Admin privilage and select on _sys_telemetry schema A multienant configuration with SYSTEMDB A user with CATALOG Read privilege and Select on _SYS_STATSITIC Schema Teh target database on SAP HANA 2.0 SPS00 or Higher.
how can you shorten the delta merge runtime of a table
There are 2 correct answers to this question Partition the table Merge per column fully load the delta store into memory perform memory-only delta merges.
Your customer asks you to set up alert monitoring in SAP HANA cockpit 2.0. Which alert properties can you configure?
There are 2 correct answers to this question. Threshold values Check interval Schedule activation Proposed solution.
You need to assign an authentication method for an SAP HANA database user. Which system privilege is required? SSL ADMIN LDAP ADMIN USER ADMIN ROLE ADMIN.
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 Snapshot Data Backup.
SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log?
There are 2 correct answers to this question. max_queue_size queue_timeout record_limit queue_wait_time_threshold.
What is scale-out?
There are 2 correct answers to this question. Use of standby servers in the event of hardware failure. Use of remote servers to store archived data that is rarely used. Use of commodity servers that are used in high volume steaming applications. Use of multiple servers to spread processing and improve performance.
In SAP HANA Studio, what would you find in a Package?
There are 3 correct answers to this question. Calculation Views Analytic Privileges Procedures Tables.
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. SYSTEM user ADM user ROOT user.
When connected to the SAP HANA database, which hdbsql command displays general information about the database? \di \s \c \a.
In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role? Sapprofile.ini Indexserve.ini Nameserver.ini Multidb.ini.
In the context of the SAP HANA maintenance strategy, which of the following terms is connected to bundle new features and functions to the SAP HANA Platform? SAP HANA standard revisions SAP HANA maintenance revisions Support package stack (SPS) Support packages (SP).
Which information can you collect by running the fullSystemInfoDump.py script when the SQL connection is available? A selection of .log files A selection of rows of schema SAP<SID> A selection of rows of schema _SYS_XS A selection of .trc files.
After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode? It rolls back changes of committed transactions that were NOT written to the data area. It reloads a savepoint with the restored consistent state of the database. It rolls back write transactions that were open when the database was stopped. It determines and rolls forward aborted transactions.
Which connection is used when you view or edit alerts in the Configure Alerts app using SAP HANA cockpit 2.0? The https connection with the <sid>adm user The https connection with the system user The SQL connection with a technical user The SQL connection with a named user.
When creating a system connection in SAP HANA Studio, which of these is essential information?
There are 3 correct answers to this question. A valid user and password Host URL Instance.
Which scale-out roles can you assign to the hosts in the nameserver.ini file?
There are 2 correct answers to this question. MASTER 1 SLAVE STANDBY WORKER.
Which productive deployment option is valid when you combine SAP ERP and SAP SCM in one SAP HANA system? SAP HANA AppServices Multitenant database containers Technical co-deployment SAP HANA One.
You are using USER01 and modelling a calculation view that combines existing calculation views with tables belonging to SCHEMA02. You want to activate the new calculation view, but you get a User is NOT Authorized error. What is the cause of the error? User _SYS_REPO is missing object privileges for SCHEMA02. The calculation view was created in the sap package. USER01 is missing object privileges for SCHEMA02. The calculation view was created in the system-local package.
Which activity is always recorded when auditing is active? Enable or disable policies Grant or revoke roles Change system configuration Delete database objects.
Assume your current partitioning plan of SAP HANA is NOT optimal. Which option of the Manage Table Distribution tool do you use to evaluate if a partitioned table needs to be repartitioned? Balance table distribution Check the correct location of tables and partitions Check the number of partitions Redistribute tables after adding host(s).
An SAP HANA scale-out system (2 worker nodes and 1 standby node) has two running tenants: Tenant1 and Tenant2. How can you prevent Tenant1 from starting after the next full database restart?
There are 2 correct answers to this question. Shut down the tenant before the database restart. Move the tenant to the standby node. Set the tenant Autostart parameter to 0. Set the tenant restart mode to No Auto-restart.
What are advantages of column store tables?
There are 3 correct answers to this question. Data footprint is automatically reduced through compression Only the columns required are actually loaded to memory Columns can be partitioned They are optimized for high-volume read / write transactional processing.
Which fault recovery features can you implement to make your SAP HANA 2.0 production system more resilient against local hardware errors and software faults?
There are 2 correct answers to this question. Host auto-failover Service auto-restart Auto log backups Storage replication.
Which database administration tasks can you perform in SAP HANA cockpit 2.0? Monitor table usage Create a data snapshot of a tenant Perform backup check Troubleshoot an unresponsive system.
Which tool do you use to back up the root encryption keys? hdbuserstore dbacockpit hdbnsutil rsecssfx.
Your SAP HANA system CANNOT be reached by SQL. You need to check all connections, transactions, and blocked transactions to understand the root cause.
Which system service do you use to collect the information? daemon sapstartsrv preprocessor nameserver.
you installed an SAP Netweaver based application on an SAP HANA database what is the default secure user store to store the password of the sap <schema-ID> user Please choose the Xuser hdbuserstore ABAP secure store file system (SFFS) instance secure store file system (SSFS).
You can change the SSFS master keys using the command line tool RSECSSFX, where it is available? /sap/usr/<SID>/HDB.
What are the three main steps of Sizing an SAP HANA tailored data center integration setup?
There are 3 correct answers to this question. RAM sizing for static and dynamic data Disk sizing for the persistence storage CPU sizing for the queries and calculations CPU sizing for the smart data access RAM sizing for HWCCT.
technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system or object privilege do you assign to the technical user account on the target system? SELECT on _SYS_TASK SELECT on _SYS_REPO CATALOG READ USER ADMIN.
Which of the following elements are valid rules for the location of the backup files?
There are 3 correct answers to this question. The Volume ID is automatically added to a specified file name. The backup files should never be in the same directory and on the same file system as the data. The backup ID is unique for each persistence only. The backup folder will be created automatically when the backup process is started.
What is included with the Predictive Analysis Library (PAL)?
There are 2 correct answers to this question. Data preparation functions Text mining functions Predictive algorithms Flowgraphs.
which action do you perform when SAP HANA Database is running out of space Please choose the correct answer. Create a new tenant database extend the file system size on the operating system level create a new databse volume extend the size of database volume.
When was the first release of SAP HANA Cockpit? SAP HANA 1.0 SPS09 SAP HANA 1.0 SPS11 SAP HANA 1.0 SPS12 SAP HANA 2.0.
A user is complaining about missing privileges when executing a query. How do you configure the indexserver trace to obtain the missing privileges? Select trace level Error for the auditing component. Select trace level Warning for the authentication component. Select trace level Info for the authorization component. Select trace level Debug for the authenticationcodec component.
You are installing SAP HANA for productive usage, but the installation stops because the hardware check failed. How do you resolve this issue? Use a hardware configuration listed in the Product Availability Matrix. Add an additional scale-out node to your hardware configuration. Run the HanaHwCheck.py script before resuming the installation. Disable the hardware check before starting the installation.
How many tiers do you usually find in an SAP HANA application?
There are 2 correct answers to this question. 1 2 3 4.
Where can you check the trace and log files when your SAP HANA database is NOT available? In the Trace app of the SAP HANA Web-based Development Workbench in the $DIR_INSTANCE/exe/python_support directory in the troubleshoot of unresponsive system app of HANA cockpit 2.0 in the troubleshoot of unresponsive system app of hana cockpit for offline administration.
Which kinds of patches are available in the SAP HANA 2.0 revision strategy?
There are 2 correct answers to this question Maintenance Package Datacenter Service Point Support Package Support Package Stack.
Your customer sets up an SAP HANA system as tailored datacenter integration (TDI) deployment. What are the enterprise network requirements?
There are 2 correct answers to this question. 8 GbE storage area 4 GbE fiber channel 15 GbE internode 10 GbE backup.
You need to check the new monitoring option in SAP HANA cockpit 2.0. Which SAP HANA cockpit 2.0 app do you use? Monitor Performance Configure Alerts Manage Database Backups Configure System Properties.
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. CATALOG READ DATA ADMIN MONITOR ADMIN USER ADMIN.
A developer at your customer starts a badly designed query. How do you stop this query? Use the Threads app to cancel the thread. Use the Monitor Statements app to interrupt the statement. Use the Expensive Statements Trace app to stop the statement. Use the Sessions app to end the session.
Which of the following traces is active after the SAP HANA installation is completed? SQL Plan Performance Database.
In the Monitoring Expensive Statements trace, which additional trace option needs to be set to "false" to write the trace data directly to file. Threshold memory Use in-memory tracing Trace flush interval In-memory tracing records.
Which of the following events occur while the merge operation is running?
There are 2 correct answers to this question. Uncommitted changes in the first delta storage are rolled back. The content of the complete main storage is persisted to disk. The content of the first main storage and the committed entries in the first delta storage are merged into the new second main storage. All write operations go to the second delta storage.
Which information is stored in the SYSTEMDB of SAP HANA multitenant database container system There are 2 correct answers to this question. Landscape topology data on the system as a whole topology data on the location of tables and table partitions users and authorization of the SYSTEMDB and all tenant databases Monitoring data on the SYSTEMDB and all tenant databases.
You created data and log backups on the file system. Due to a hardware failure, you use the Recover Database app in SAP HANA cockpit 2.0 to recover the crashed SAP HANA database. From which location does the Recover Database app read the recovery information by default? $(DIR_INSTANCE)/../global/hdb/custom/config $(DIR_INSTANCE)/backup/log $(DIR_INSTANCE)/<hostname>/trace $(DIR_INSTANCE)/backup/data.
How can you minimize the database migration option (DMO) downtime? 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. 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.
Why should you use variables in SQLScript?
There are 2 correct answers to this question. To implement flow control logic To support processing push-down To increase parallelization opportunities To improve code readability.
Which of the following Technical Deployment Option has single application runs in a single schema, and in a single SAP HANA database as part of an SAP HANA system? Single Application on One System (SCOS) Multiple Components on one Database (MCOD) SAP HANA with Virtualization Technical Co-Deployment.
You install an SAP HANA database and SAP NetWeaver AS ABAP 7.5 on one server. This system will be your customer's productive system. Which of the following installation requirements are mandatory?
There are 2 correct answers to this question. The system ID (SID) for the SAP NetWeaver AS ABAP system and the SAP HANA database must be different. The instance number for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same. The memory resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be added. The disk resources for the SAP NetWeaver AS ABAP system and the SAP HANA database must be the same.
Which security settings can you monitor in SAP HANA cockpit 2.0?
There are 2 correct answers to this question. Data Storage Security Password Policy Manage Database Backups Manage Users.
During Installation 3 users are created automatically, which of the following statement is wrong regarding default users description? The password of the <sid>adm user is set during installation with the password parameter SYSTEM is the SAP Host Agent administrator SYSTEM is the database superuser The password of the SYSTEM user is set during installation with the system_user_password parameter.
You are setting up a disaster recovery system using system replication. You want the transaction processing of the primary system to be suspended if the network to the secondary system fails.
What log replication mode must you use? async full sync syncmem sync.
Which of the following SAP HANA Scenario enable the acceleration of standard ABAP reports? Operational Data Marts SAP HANA Accelerators Agile Data Marts SAP BW/4HANA.
To ensures that the database can be restored to the most recent committed state after a restart which of the following Indexserver components make sure such consistency and maintain durable changes? Storage Engine Relational Engines Disk Storage Request Processing.
In the General Licensing Process you can install and reinstall a new permanent license. If the current permanent license expires, a temporary license is installed automatically, what is the validity of this temporary license following a permanent license? 30 days 28 days 32 days 90 days.
The design-time version of a security role can contain which of the following information?
There are 2 correct answers to this question. The users assigned to the role The role name The privileges assigned to the role The users assigned by default to this role.
In a calculation view, what should you consider when you create an input parameter that derives its value from a user-defined function?
There are 2 correct answers to this question. The input parameter must be set to mandatory. The generated value can be overwritten at runtime. The function can return multiple values. The function must be of the type scalar.
Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system?
There are 2 correct answers to this question. Performing an SAP software update Migrating to a target database, e.g. SAP HANA Performing a Unicode conversion Performing a database upgrade of the source database.
Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive SAP HANA system.
Which tools can you use to monitor the system alerts of the SAP HANA database from your PC?
There are 2 correct answers to this question. SAP HANA studio HDBSQL command line tool SAP NANA cockpit 2.0 DBA Cockpit.
What is a multistore table? A table that can hold data in row and column orientation A table that can distribute its partitions across memory and extended storage tiers A table that can be shared across multiple instances of HANA A table that can be shared across multiple instances of SAP HABA Cockpit.
In which of the following SAP HANA scenarios is it recommended to encrypt communication between the client software and SAP HANA?
There are 2 correct answers to this question. SAP HANA as a data mart for reporting and analytics. SAP HANA as a classic three-tier architecture as the primary database (for example. SAP NetWeaver Business Warehouse, SAP Business Suite Installation). SAP HANA as a platform for providing database and application services to native SAP HANA-based applications.
What is XS? A native, lightweight application server An optional engine to handle excessive data loads A data cleansing engine A user interface.
For scale-out SAP HANA systems, the recommended disk space for hana/shared/<SID> depends on the number of worker nodes.
A disk space of 1x RAM of one worker is recommended for every four worker nodes of a given scaleout system. Size [installation(scale-out)] = 1 x RAM_of_worker per 3 worker nodes Size [installation(scale-out)] = 1 x RAM_of_worker per 8 worker nodes Size [installation(scale-out)] = 1 x RAM_of_worker per 4 worker nodes Size [installation(scale-out)] = 1 x RAM_of_worker per 2 worker nodes.
Due to a hardware failure, you are using a different host to recover a crashed SAP HANA database. Which of the following configuration files must you use for the recovery?
There are 2 correct answers to this question. sapprofile.ini xsengine.ini nameserver.ini Indexserver.ini.
Which of the following elements are required for implementing a database copy?
There are 2 correct answers to this question. The target database must have a the same or higher version than the source database. You don't have to be concerned about disk space and memory of the target database. Source and target databases can have different number and types of services. A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available.
The data storage of your productinve SAP HANA instance crashed and you need to recover the database. The log storage is still intact. You have a full data backup that is 9 hours old and an incremental backup that is 4 hours old To which point in time you can recover to minimize the data. the last commited transaction the latest incremental backup the last full data backup the latest log backup.
Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system? 1 off on 0.
Which of the following statement is not true regarding SAP HANA Server Components? The index server contains the actual data stores and the engines for processing the data Index server is access by SAP HANA Cockpit with SQL queries Web based tools can access the index server with simple HTTP request XS Engine process the client application with HTTP request.
Which table partitioning types does SAP HANA support?
There are 3 correct answers to this question. Hash Composite Round-robin Cluster Range.
In which circumstances do you create a column store table?
There are 3 correct answers to this question. When the calculations are based on a small number of columns When accessing complete records When aggregations or fast search is required When the table has a large number of columns.
What happens when an SAP HANA system is restarted?
There are 2 correct answers to this question The list of open transactions is left open. All row tables are loaded into the memory except the row tables that are configured to be loaded on demand. All row tables and row table attributes are loaded into the memory. The Redo log is replayed from the last savepoint.
You need to periodically monitor if the SAP HANA primary system is online which tools do you use. landscapeHostconfiguration systemreplicationstatus hanasitter HDBAdmin.
Which option do you choose to protect your SAP HANA scale-out system using host autofailover? System replication Standby node Storage replication Automatic savepoint.
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 question. Communication channel whitelist Bi-directional communication channels User mapping User sharing.
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 source database needs to be available. The SUM folder needs to exist. The before-downtime backup needs to be available. The cleanup procedure needs to be performed.
Which of the following statements are true about SAP HANA Live?
There are 2 correct answers to this question. SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite. SAP HANA Live for SAP Business Suite is an accelerator. SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases. and not on live operational reporting. SAP HANA Live for SAP Business Suite comprises of an Analytical Model. SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution.
Why do you create a time dimension calculation view? To support temporal joins in a cube calculation view with star schema To enhance a calculation view with a drilldown on a time hierarchy To provide date-based help values for a DIRECT type input parameter To enable time dependency on parent-child hierarchies.
From an architectural standpoint, which of the following components belong to the SAP HANA Indexserver?
There are 2 correct answers to this question External Interfaces Preprocessor Relational Engines SAP Web Dispatcher.
Which authorizations are assigned to users of type Standard Users by default?
There are 2 correct answers to this question Create objects in schema _SYS_STATISTICS Read data in system views Grant roles to other users Create objects in own schema.
SAP HANA, in the context of user management, allows you to do which of the following?
There are 3 correct answers to this question. Create and delete users Lock and unlock users Assign a user to a user group Create a restricted user.
Which of the following tools can be used for User Administration?
There are 3 correct answers to this question. SAP HANA Cockpit hdbsql Resident hdblcm SAP NetWeaver Identity Management.
Which operation mode can you use to configure SAP HANA system replication? Delta data file shipping Continuous log replay Log file shipping Log mirroring.
Which backup scenarios are allowed in multitenant database containers?
There are 2 correct answers to this question. A backup of a tenant database can be recovered to an SAP HANA single-container system. A tenant database can initiate its own backup unless this is prohibited by the system configuration A tenant database can initiate its own backup and the backup of the other tenant databases. The system database can initiate its own backup and the backup of tenant databases.
You need to secure client-server communication using transport layer security. Which objects must you set up on the server side?
There are 2 correct answers to this question. User certificate Private key Root certificate Server certificate.
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.
How can troubleshoot HANA installer when its crashes
There are 2 correct answers to this question. set the environment variable HDB_INSTALLER_TRACE_FILE to the trace filename activate the debug mode for the database trace create the dirctory containing the trace file run hdblcm with the check_installation action.
You receive a new system from your hardware partner with SAP HANA 2.0 multitenant database containers preinstalled.
What is a prerequisite to guarantee secure encryption of the data volumes? Change the generated SSFS master key for the whole database instance. Change the generated password of the SYSTEM user. Update the connection information stored in the hdbuserstore. Regenerate the encryption root keys for the internal application encryption.
You need to install multiple identically configured SAP HANA systems in batch mode. Which installation parameter is mandatory when you use a configuration file? sid system_usage components number.
Which of the following display authorizations for DBA Cockpit is not enabled for SAP_BC_S_DBCON_USER? S_DBCON ACTVT=03 S_RZL_ADM ACTVT=01.
What do you have to ensure during the downtime phases of SUM?
There are 3 correct answers to this question. The source database must be stopped End users can not log on to the SAP system Batch jobs from daily business can not start Interfaces from other SAP systems can not log on to the SAP system.
What is a prerequisite for a system replication when the development (DEV) system and the quality (QA) system are installed on the secondary site? The DEV and QA systems must be online during system takeover. The preload of tables must be switched off. The global allocation limit must be identical. The SIDs and instance numbers must be identical.
Which of the following actions are audited by default in SAP HANA?
There are 2 correct answers to this question. Changes to system configuration 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 of the following are characteristics of SAP HANA Smart Data Streaming? It uses databases queries. It is a standalone product for use with any target system. It acts based on combinations of events. It provides reports and analysis on the received data.
Why would you implement the SAP HANA Data Warehousing Foundation? To add OLAP data warehousing capabilities to SAP HANA To implement a SQL-driven approach to data warehousing To improve the loading and reporting performance of SAP Business Warehouse To enable reporting on SAP HANA data using the full suite of SAP BusinessObjects.
The administration console is pre-delivered by SAP. You can access the administration console in one of the following ways.
There are 3 correct answers to this question. Choose the Administration button in the upper left corner Choose the Administration button in the upper right corner Double-click the system in the system monitor Double-click the system monitor in the Navigator view Double-click the system in the Navigator view.
What are the prerequisites for configuring audit logging?
There are 2 correct answers to this question. AUDIT ADMIN system privilege INIFILE ADMIN system privilege AUDIT OPERATOR system privilege INIFILE OPERATOR system privilege.
Where is SDI used?
There are 2 correct answers to this question. Data cleansing Data transformation Data streaming For data loading.
Which identity provider is used by default by SAP HANA extended application services, advanced model (XS Advanced)? SAP HANA user store SAP Identity Management SAP ID service SAP Cloud Identity.
Why does SAP HANA have a persistence storage layer that is disk-based?
There are 2 correct answers to this question. To generate indexes for the column store To allow row store operations To persist in-memory data To enable data recovery if the power fails.
During the Installation, the following users are created automatically. Which of them is the SAP Host Agent administrator? adm user sapadm user SYSTEM user.
You need to test an ABAP report, which uses SAP HANA objects, in the quality assurance (QA) system.
Which tool do you use to import all objects to the QA system? SAP HANA Application Lifecycle Manager SAP HANA Quality Gate Maintenance SAP HANA Change Request Management SAP HANA Transport Containers.
Which are tuning methods for the database migration, using DMO of SUM?
There are 3 correct answers to this question. Adapt the number of parallel R3load processes Using the Near Zero Downtime Maintenance capabilities of SUM (NZDM) Using the table migration duration files from a previous run Performing a benchmark using the benchmarking options of SUM.
Why might you want to reference a user-provided service in a project? To access data from another container To access data from a classic database schema To access data from your project container.
Which SAP HANA features ensure that committed data is NOT lost if there is a power failure?
There are 2 correct answers to this question. Automatic savepoints Persisted redo logs Delta merge Undo logs.
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.
Who can access the runtime object generated from a repository object immediately after the activation? The user who started the activation The SYSTEM user The _SYS_REPO user The user who created the repository object.
You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require? A multitenant configuration with SystemDB A usage type of production, test, or development The target database on SAP HANA 2.0 SPS00 or higher A technical user with limited authorizations.
USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards.
What happens if you drop USER B from the HANA database? The privilege is revoked from both USER A and USER C. The privilege is revoked from USER C, but not USER A. The privilege remains assigned to both USER A and USER C. The privilege is revoked from USER A, but not USER C.
What are the advantages of the DMO procedure?
There are 3 correct answers to this question. DMO combines several steps into one procedure. DMO allows a lower target release on SAP HANA database. DMO allows an easy reset during the procedure. DMO is an inplace procedure by default, keeping the application server host.
Which combination of source and target systems is allowed when you perform a database copy in a scale-out scenario? The source system can have 4 hosts.
The target system can have 2 hosts. The source system can have 4 index servers.
The target system can have 2 index servers. The source system can have 2 hosts.
The target system can have 4 hosts. The source system can have 2 index servers.
The target system can have 4 index servers.
you can establish SAP Solution Manager connectivity and configure a Remote Service Connection (via SAP Router) as part of the initial setup. Since Solution Manager 7.1 SP04, the SAP HANA databases can be integrated into SAP Solution Manager.
What are these components can be integrated into SAP HANA database?
There are 3 correct answers to this question. Performance Warehouse SAP HANA Database Alerting Infrastructure The transaction DBACockpit.
Which of the following elements are contained by the SAP HANA Studio System Navigator?
There are 3 correct answers to this question. Backup Content Configuration Security.
Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)?
There are 3 correct answers to this question. Remove host roles Rename the SAP HANA database system Import delivery units Transport application changes Convert to multitenant database containers.
Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview page. This page displays the detailed status of the selected SAP HANA system.
Which of the following options are listed?
There are 3 correct answers to this question. Monitoring and Administration Performance Management Resource Management Security Memory Management.
Which information is provided by the backup catalog Backup ID Backup configuration Progress of a backup Backup destination.
A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer. recover the affected tenant with the initialize log area option recover the system database and the affected tenant with the initialize log area option restore the database and recover the affected tenant upto moment of the problem recover the affected tenant upto moment of the problem.
In the General Licensing Process which of the following statements are true regarding Temporary license keys?
There are 2 correct answers to this question. Temporary license keys are manually installed by the SAP HANA system Temporary license keys are automatically installed by the SAP HANA system After 90 days, the temporary license expires and the system is locked down After 28 days, the temporary license expires and the system is locked down.
Which security infrastructures can you integrate with SAP HANA?
There are 2 correct answers to this question. Linux syslog Radius server Identity management Intrusion detection.
You imported the following objects. Which of them always require an activity from you before they can be built?
There are 2 correct answers to this question. Synonyms definition Multi-target application Logical schema definition SAP HANA database module.
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? 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 false Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false.
What software innovations did SAP deliver with SAP HANA?
There are 2 correct answers to this question. Row and Delta store. Compression and Decompression. Partitioning. Insert only on Column store.
What can you do to shorten the startup time of an SAP HANA system after a reboot? Set the preload column value in the Tables system table to FULL. Flag all columnar tables for preload. Set the savepoint interval to a lower value. Partition the row store across nodes.
What is the minimum space requirement for the Data Volume?
There are 2 correct answers to this question. 1.2 * RAM (TDI) Min. 1 * RAM Min. 0.5 * RAM 3 * RAM (Appliance).
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? An upgrade of the primary system A restart of the primary system An upgrade of the secondary system A restart of the secondary system.
In SAP HANA Architecture which of the following component can easily enhance the functionality of Multiple-Container System. OS & Hardware Storage Tenant Database System Database.
You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and user management.
Which deployment scenario do you use? Multitenant database containers (MDC) Technical co-deployment (TCD) Multiple Components on One Database (MCOD) Multiple Components on One System (MCOS).
The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the SAP HANA database request additional memory? Virtual memory Physical memory Standby memory Resident memory.
Which information is provided via the SUM UI?
There are 3 correct answers to this question. A progress bar for the overall procedure The active roadmap step The memory consumption of SUM The content of log files via the log viewer.
Your business users are complaining about longer-than-usual query runtimes and you want to get an overview of long-running queries.
Where do you activate the expensive statements trace?
There are 2 correct answers to this question SAP HANA studio diagnosis mode SAP HANA cockpit 2.0 SAP HANA database explorer for SAP HANA cockpit SAP HANA Web-based Development Workbench.
Which statement is wrong regarding Operational Data Marts? Views calculate results for reports in real time on the actual operational data No transformation during load step (only selection of relevant data if applicable) Real-time replication of time critical data (SLT/SRS) Typically contains no time critical data and therefore utilize traditional ETL.
Which components for an In-Memory Appliance do you need to consider for sizing? Storage Memory CPU.
Which of the following configuration files are created if customer-specific changes are made after or during installation of SAP HANA database?
There are 3 correct answers to this question. sapprofile.ini hanaconfig.ini daemon.ini nameserver.ini.
What tool must you use to add an additional host to an SAP HANA scale-out system? hdbnsutil hdbinst hdblcm hdbparam.
Which software components do you download to prepare the database migration option?
There are 2 correct answers to this question. SPAM/SAINT SAP Host Agent SAPUI5 SAP GUI.
You are implementing system replication for an SAP HANA system. How is the secondary SAP HANA database synchronized with the primary SAP HANA database?
There are 2 correct answers to this question. Each service on the secondary database establishes a connection with the primary database. The primary database persists the log information to the log volumes of the primary database and the secondary database. Every commit is written to a shared subdirectory between the primary database and secondary database. An initial snapshot and the redo log information are transferred from the primary database to the secondary database.
In an SAP NetWeaver AS for ABAP system, the hdbuserstore program is located in which directory? /usr/<SID>/sap/hdbclient /sap/usr/<SID>/hdbuser /usr/sap/<SID>/hdbclient /usr/sap/<SID>/hdbuser.
For which communication channel do you need to set up encryption manually? Between SAP HANA systems in system replication scenarios Between hosts in an SAP HANA scale-out system Between the SAP HANA server and clients Between databases in an SAP HANA multitenant database container system.
According to SAP Best Practices, what should you do with the SYSTEM user? Delete the user. Exempt the user from locking. Revoke granted roles. Deactivate the user.
What are the prerequisites for using the Web user interface for HDBLCM?
There are 2 correct answers to this question. The SAP HANA database is revision 90 or higher The communication port 1329 is open Internet Explorer - Version 8 or higher The communication port 1129 is open.
You are monitoring the application server of an SAP S/4 HANA system. You need to investigate on the SAP HANA database, but someone locked your personal SAP HANA user.
Which tools can you use to execute an SQL query?
There are 2 correct answers to this question. SQL Command Editor of the DBA Cockpit on the application server SAP HANA studio on the SAP HANA server HDBSQL command line tool on the SAP HANA server SAP HANA cockpit 2.0 on a central server.
You created a restricted user in the DB1 database. Which commands must you use to convert the restricted SAP HANA user to a standard SAP HANA user?
There are 3 correct answers to this question. ALTER USER <USERNAME> ACTIVATE USER NOW ALTER USER <USERNAME> ADD REMOTE IDENTITY ALTER USER <USERNAME> ENABLE CLIENT CONNECT ALTER USER <USERNAME> GRANT ROLE PUBLIC ALTER USER GRANT CREATE ANY ON OWN SCHEMA.
Which of the following actions are possible when managing roles?
There are 3 correct answers to this question. A role can be nested to multiple other roles. A role can contain multiple other roles. A role can contain other roles and privileges at the same time. A role can contain either other roles or privileges but not both together.
What are some of the characteristics of the design-time role?
There are 3 correct answers to this question The role is granted through the execution of stored procedures. The role is revoked if the grantee user is deleted. The role is created by technical user _SYS_REPO. The role can be transported between systems. The role is granted and revoked directly by the database user.
Which of the following statements are true regarding In-Memory computing security?
There are 2 correct answers to this question. Data and undo log information (part of data) are automatically saved to disk at regular savepoints The log is also saved to disk continuously and synchronously after each COMMIT of a database transaction The redo log captures last 5 minutes changes by database transactions After a power failure the system returns to its last consistent state by replaying the undo log since the last savepoint.
Due to a hardware failure of your persistence area, your multitenant database needs to be restored.
Which tasks do you perform to recover the complete system?
There are 2 correct answers to this question. Recover the system database before recovering all tenant databases. Recover all tenant databases before recovering the system database. Start the recovery from the system database using the SAP HANA studio. Start the recovery from the tenant databases using the SAP HANA studio.
Where is the name server running in a multitenant database container system? Master node SYSTEMDB Standby node Each tenant.
You create a new user by copying an existing user. Which predelivered role of the existing user is automatically granted to the new user? Modeling Runtime Monitoring Repository.
Where do you investigate a failed uninstall of an SAP HANA scale-out system? /hana/shared/log /hana/log/<SID> /var/tmp/hdblcm.log /usr/sap//hostctrl/work.
At the end of the SAP HANA Cockpit 2.0 installations, how can you obtain the URL of the SAP HANA cockpit and the SAP HANA cockpit manager? Installation config screen Installation log file Installation logs screen COCKPIT_ADMIN user logs.
Which files are created after unpacking the SAP HANA Cockpit .SAR File?
There are 2 correct answers to this question. Configuration File Signature File hdblcm.sh File.
Which of the following actions can be audited by SAP HANA?
There are 2 correct answers to this question. Changes to system configuration. Upgrade of an SAP HANA database instance. Create or drop user, and create or drop role.
Which of the following elements are SAP HANA system components
There are 2 correct answers to this question. SAP HANA Database SAP HANA Dynamic Tiering SAP HANA Advanced Data Processing SAP HANA Remote Data Sync.
What are the two storage components used to restore the database in case of power failure?
There are 2 correct answers to this question. Log area Data volume Memory Delta store.
Which of the following statements is true for the SAP HANA preinstalled role (SAP_INTERNAL_HANA_SUPPORT) for support cases? It can be granted to the SYSTEM user. It can be granted to another role. It can only be granted further system privileges. It can only be granted further object privileges.
What are the native tools for SAP HANA Database administrators?
There are 2 correct answers to this question. SAP HANA Cockpit SAP Solution Manager SAP Landscape Management SAP HANA Studio.
Which of the following tasks requires the BACKUP ADMIN authorization?
There are 2 correct answers to this question. Backing up the database without a user interface. Recovering the database without a user interface Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location. Administration tasks executed on a tenant database through the system database.
You perform backups using a third-party backup tool (BACKINT SDK for SAP HANA). Which service supports configuration of several parallel streams? preprocessor xsengine indexserver name server.
Where is the name server running in an SAP HANA 2.0 SPS02 cockpit All tenants standby node Master node SYSTEMDB.
You install SAP HANA for productive usage, but the installation stops because the hardware check failed. Use SAP HANA database lifecycle manager (HDBLCM) to edit the configuration. Use a hardware configuration listed in the Product Availability Matrix. Run the HanaHwCheck.py script before resuming the installation. Use the hdbinst command to install the SAP HANA database directly.
Which administration tool can you use to start and stop the SAP HANA database system? SAP HANA HDBSQL DBA Cockpit SAP Solution Manager SAP Landscape Management.
logical error occurred in one tenant of your SAP HANA database. What action do you perform to make the tenant consistent again? Recover the system database. The affected tenant is recovered automatically. Recover the system database first and then recover the affected tenant. Recover the affected tenant. The system database is NOT recovered. Recover the affected tenant first and then recover the system database.
A SAP HANA system is a database management system (DBMS); that is, it is a server component that manages a database model. Which of the following is the wrong statement regarding DBMS functions Please choose the correct answer. Maintains relationships between data Recovers data automatically to the most recent consistent status after a system failure Provides secure access to data using only <sid>adm authorization Delivers high performance for processing data requests.
For which scenarios is it mandatory to define the authorizations at HANA Level?
There are 2 correct answers to this question. SAP HANA Live for SAP Business Suite Business Suite on HANA SAP S/4HANA Web-based native applications based on XS.
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. Process Bucket monitor Log Tail Viewer monitor Table Depooling monitor Table Splitting monitor.
Your source SAP system is running on Windows with an SAP MaxDB database. You want to use the DMO procedure to migrate to SAP HANA database, using the inplace migration.
Which up to date SAP kernel is needed for the DMO procedure?
There are 2 correct answers to this question. Linux, SAP MaxDB Windows, SAP MaxDB Linux, SAP HANA Windows, SAP HANA.
Your SAP HANA database is running in log mode "normal" and automatic log backups "enabled". With this configuration, In which situations are the log segments backed up automatically?
There are 3 correct answers to this question. The log segment is full. The database is started. The log segment is closed after exceeding the configured time threshold. The database is stopped.
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. R3trans processes TP processes SQL processes SAPup processes.
During uptime migration, which information can you receive in the Charts Control Center, via the Utilities of the SUM UI?
There are 3 correct answers to this question. The configured maximum number of parallel R3load processes The actual number of running R3load processes The memory consumption of the target database The process buckets being processed.
You plan to implement SAP HANA multitenant database containers using a scale-out scenario with high availability.
What rules can be applied when you implement such an SAP HANA system?
Note: There are 2 correct answers to this question. Single tenant databases can be failed over to the standby host. Tenant databases can be automatically distributed across all the available hosts. An instance of the system database can run on all the nodes, including the standby host. An instance of the system database can run on all the nodes, except the standby host.
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 its 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.
How to open Web user interface for HDBLCM from SAP HANA Studio from the context menu? HDBLCM ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle Management HDBLCM ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle Management Lifecycle ManagementPlatform Lifecycle ManagementSAP HANA Platform Lifecycle Management Lifecycle ManagementPlatform Lifecycle ManagementOpen HDBLCM.
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. Input/output operations per second (IOPS) SAP Application Performance Standard (SAPS) Main memory Persistent storage Network throughput.
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).
Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor?
There are 3 correct answers to this question. The time at which the database was started. Disk consumption from the SAP HANA database. Connection statistics about open connections. Memory and CPU consumption from the SAP HANA database.
What is a characteristic of the synchronous in-memory system replication mode in SAP HANA? The primary systems suspends transaction processing until the connection to the secondary system is re-established. The primary system waits until the secondary system confirms the log was persisted. The primary system does NOT wait for the confirmation of the secondary system. The primary system waits until the secondary system confirms receiving the log.
Which prerequisites apply when you perform an SAP HANA database copy of a single tenant system?
There are 2 correct answers to this question. The number and type of services on the target database can be different from the source database. The restore point in time (PIT) of the target database is the same as or earlier than the source database. The number of nodes on the target database is the same as or lower than the source database. The version of the target database is the same as or higher than the source database.
you need to integrate an existing SAP HANA 2.0 SPS02 database system into SAP HANA cockpit monitor infrastructure where do you create the technical user created for the resource registration in the first tenant in the SYSTEMDB and the first tenant in the SYSTEMDB and the all tenant in the SYSTEMDB.
You suspect an authorization issue while executing SAP HANA reports that contain calculation views. How do you configure the authorization trace?
There are 2 correct answers to this question. Select INFO from the System Trace Level for the Indexserver component and then select AUTHORIZATION. Specify the name of the table/view. Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION. Specify the user as the database user.
What tenant information can you monitor in the Overall Tenant Statuses app of SAP HANA cockpit 2.0? Security status Used memory Isolation status Instance number.
Which of the following authentication methods are available in SAP HANA?
There are 3 correct answers to this question. Login with user and password Use of SAML identity provider assertion tickets Reuse the Kerberos ticket issued by the Active Directory Use the SAP Logon ticket issued by another SAP ABAP system.
Which of the following actions triggers the replication of SAP BW authorizations in SAP HANA?
There are 3 correct answers to this question. System restart InfoProvider activation Execution of "Replicate BW user authorizations to HANA database" process chain Execution of report "RS2HANA_AUTH_RUN".
Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database? Request Processing and Execution Control External Interfaces Relational Engines Storage Engine and Disk Storage.
Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database?
There are 2 correct answers to this question. Cross-node joins must be avoided. Table partitions can be distributed over all nodes. The row store can be distributed over all nodes. The columns of a table can be distributed over all nodes.
You define the parameters for password policy of an SAP HANA tenant database where the parameters are stored? indexserver.ini multidb.ini nameserver.ini global.ini.
Which prerequisites must be met to set up high availability for a distributed SAP HANA system?
There are 2 correct answers to this question. The column tables were assigned to an index server manually. The name server is started on all nodes. The synchronized backup savepoint is set. The shared storage is connected to every host.
Which certificates can you manage in SAP HANA cockpit 2.0?
There are 2 correct answers to this question. SAML PKCS #12 Kerberos X.509.
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 deleted SAP BusinessObjects Business Intelligence data on the non-SAP database The SAP ABAP kernel on the application server The DBACOCKPIT user on the SAP HANA database The shadow schema on the non-SAP database The updated BRTOOLS on the non-SAP database.
Which of the following SAP HANA license key types locks down the system when the current memory consumption of SAP HANA exceeds the licensed amount of memory? Temporary license keys Unenforced license keys Enforced license keys.
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. The standby host has file access SYSTEM users replaced by standby host The failed worker host no longer has access to write to files The standby host has access to write to files.
Why do we still need a persistent layer?
There are 2 correct answers to this question. To store data that has been unloaded from memory To hold the delta store for newly arrived records To enable full database recovery if we have a power failure To store data that is frequently used.
Which tool do you use to create a new tenant when you install SAP HANA multitenant database containers? Manage Databases app of SAP HANA cockpit 2.0 Administration Console of the SAP HANA studio HDBSQL command line and the CREATE SCHEMA statement System Configuration tab of the DBA Cockpit.
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 Landscape SAP HANA File archive SAP HANA Landscape File Export SAP HANA Landscape File archive SAP HANA Export.
|
