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?
Please choose the correct answer. syncmem async sync full sync.
Which statement is wrong regarding Operational Data Marts?
Please choose the correct answer. 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 Views calculate results for reports in real time on the actual operational data.
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 processes R3trans processes TP processes SAPup processes.
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 a Unicode conversion Performing an SAP software update Performing a database upgrade of the source database Migrating to a target database, g. SAP HANA.
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. Double-click the system in the system monitor Choose the Administration button in the upper left corner Choose the Administration button in the upper right corner Double-click the system monitor in the Navigator view Double-click the system in the Navigator view.
The application data of the SAP NetWeaver-based applications are stored in the schema SAP<Schema-ID> of the SAP HANA system, Which of the following statement is biased to perform if you change the SAP<Schema-ID> password of a NetWeaver based system?
There are 2 correct answers to this question. Update the ABAP SSFS of the <sapsid>adm (Linux) You must update the relevant DEFAULT connection entries in the hdbuserstore Use the old password when establishing the connection No need to update the ABAP SSFS of the Domain\SAPService<SAPSID> (Windows).
When can you load and unload individual tables and table columns manually in an SAP HANA tenant database?
There are 2 correct answers to this question. When you need to measure total memory. When you need to optimize the standby node memory. When you need to extend the scale-out memory. When you need to actively free up memory.
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.
Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag 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 Security Memory Management Resource Management Performance Management.
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 recovere
3. Row tables are loaded into memory.
4. Column tables are loade 1.Aborted transactions are rolled back.
2. Row tables are loaded into memory.
3. Open transactions are recovere
4. Column tables are loade 1.Row tables are loaded into memory.
2. Open transactions are recovere
3. Aborted transactions are rolled back.
4. Column tables are loade 1. Row tables are loaded into memory.
2. Column tables are loade
3. Open transactions are recovere
4. Aborted transactions are rolled back.
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 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 The bidirectional communication channel must be whiteliste The cross-tenant database communication must be explicitly activate.
Which SAP HANA cockpit application can you use to investigate a system offline situation?
Please choose the correct answer. CPU usage monitor Troubleshoot unresponsive system Out-of-memory event monitor Full system information dump.
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 STANDBY WORKER SLAVE.
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. Alerting Infrastructure Diagnostics agent SAP HANA Database The transaction DBACockpit Performance Warehouse.
Where can you check the trace and log files when your SAP HANA database is NOT available?
There are 2 correct answers to this question In the Diagnosis Files app of the SAP HANA cockpit for offline administration In the Trace app of the SAP HANA Web-based Development Workbench In the Troubleshoot Unresponsive System app of SAP HANA cockpit 2.0 In the /usr/sap/<SID>/HDB<instance number>/<host>/trace path on the operating system.
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. Table Depooling monitor Table Splitting monitor Process Bucket monitor Log Tail Viewer monitor.
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. FULL SYNC ASYNC SYNC SYNCMEM.
Which role do you need in order to assign users to groups in SAP HANA cockpit?
Please choose the correct answer. Cockpit User Cockpit User Administrator Cockpit Administrator Cockpit Resource Administrator.
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. User sharing Communication channel whitelist User mapping Bi-directional communication channels.
SAP HANA, in the context of user management, allows you to do which of the following?
There are 3 correct answers to this question. Assign a user to a user group Lock and unlock users Create a restricted user Create and delete users.
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? A restart of the primary system An upgrade of the secondary system An upgrade of the primary system A restart of the secondary system.
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 false 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.
What do you do to prepare the database migration option of a Software Update Manager procedure?
There are 3 correct answers to this question Move the SPAM update archive into the download folder. Extract the SAP HANA client installation archive. Move the stack.xml update file into the download folder. Extract the SAP HANA database installation archive. Move the R3trans update archive into the download folder.
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?
Please choose the correct answer. Installation logs screen Installation config screen COCKPIT_ADMIN user logs Installation log file.
Which is the relationship between the user group operators and the user groups?
There are 2 correct answers to this question. Only one user group per user group operator Only one user group operator per user group Multiple user groups per user group operator Multiple user group operators per user group.
Which value for the Autostart parameter do you use to control the automatic start of an SAP HANA system?
Please choose the correct answer. 0 On 1 Off.
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?
Response: Balance table distribution Check the number of partitions Redistribute tables after adding host(s) Check the correct location of tables and partitions.
What are the prerequisites for configuring audit logging?
There are 2 correct answers to this question. INIFILE OPERATOR system privilege INIFILE ADMIN system privilege AUDIT OPERATOR system privilege AUDIT ADMIN system privilege.
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 of nodes on the target database is the same as or lower than the source database 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 version of the target database is the same as or higher than the source database.
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 target database is SAP Adaptive Server Enterprise (ASE). The Primary Application Server can be moved to a target system Landscape The source system is Application Server (AS) Java-base.
Which preparation steps do you need to perform before replaying a captured workload using the SAP HA NA capture and replay tool?
There are 3 correct answers to this question. Create a replayer user account in the target database system. Store the logon credentials of the replayer user in the secure store Create a replayer user account on the target operating system. Preprocess the captured workload on the source system. Restore the source system tenant backup to the target tenant.
Which tools do you use to delete diagnosis files?
There are 2 correct answers to this question. SAP HANA cleaner SAP HANA database explorer SAP HANA Web-based Development Workbench SAP HANA cockpit.
Which information is provided via the SUM UI?
There are 3 correct answers to this question. The active roadmap step The memory consumption of SUM A progress bar for the overall procedure The content of log files via the log viewer.
Which of the following SAP HANA capability allows you to load and replicate data in real time from ABAP source systems and non-ABAP source systems to an SAP HANA environment?
Please choose the correct answer. SAP HANA dynamic tearing SAP HANA smart data streaming SAP HANA remote data sync SAP HANA landscape transformation replication server.
What is included with the Predictive Analysis Library (PAL)?
There are 2 correct answers to this question. Data preparation functions Flowgraphs Text mining functions Predictive algorithms.
Which of the following actions are possible when managing roles?
There are 3 correct answers to this question. A role can contain either other roles or privileges but not both together A role can contain other roles and privileges at the same time A role can contain multiple other roles. A role can be nested to multiple other roles.
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting?
Please choose the correct answer. The Log viewer The R3LDCTL The Observer Monitor The Process Bucket monito.
Which of the following system privileges can you assign to an SAP HANA database user?
There are 3 correct answers to this question. CREATE SCHEMA EXPORT DEVELOPMENT EXECUTE CREATE ANY.
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. An explicit read-only connect on between both systems must be available The CPU architecture must be identical. Both systems are located in the same data center. Both must have the same SAP HANA version.
What is XS? A user interface An optional engine to handle excessive data loads A native, lightweight application server A data cleansing engine.
Which connection types are allowed when you use system replication with the Active/Active option?
There are 2 correct answers to this question. Explicit read only on the secondary system Explicit read and write on the secondary system Automatic round-robin statement routing Implicit hint-based statement routing.
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 by default to this role The users assigned to the role.
Why might you want to reference a user-provided service in a project?
Please choose the correct answer. To access data from another container To access data from a classic database schema To access data from your project container.
You administer a single-host system with 100gb physical memory. The global allocation limit and the individual service allocation are set to 90%. Three services are running. Service 1 has 25GB of memory allocated and service 2 has 40gb allocated.
What is the effective allocation of service 3?
Please choose the correct Answer:. 25 GB 90 GB 35 GB 100 GB.
Why would you implement the SAP HANA Data Warehousing Foundation?
Please choose the correct Answer:. To enable reporting on SAP HANA data using the full suite of SAP BusinessObjectse To implement a SQL-driven approach to data warehousing To add OLAP data warehousing capabilities to SAP HANA To improve the loading and reporting performance of SAP Business Warehouse.
logical error occurred in one tenant of your SAP HANA database. What action do you perform to make the tenant consistent again?
Please choose the correct Answer: Recover the affected tenant first and then recover the system database. Recover the affected tenant. The system database is NOT recovered. Recover the system database. The affected tenant is recovered automatically. Recover the system database first and then recover the affected tenant.
Which option do you choose to protect your SAP HANA scale-out system using host auto-failover?
Please choose the correct Answer. Standby node Storage replication System replication Automatic savepoint.
Which administration tool can you use to start and stop the SAP HANA database system?
Please choose the correct Answer:. DBA Cockpit SAP Solution Manager SAP HANA HDBSQL SAP Landscape Management.
What do you need to size before you install SAP HANA in a tailored data center integration (TDI) scenario?
There are 3 correct Answer:s to this question. Persistent storage Network throughput Main memory Input/output operations per second (IOPS) SAP Application Performance Standard (SAPS).
Which of the following tools can be used for User Administration?
There are 3 correct Answer:s to this question. Resident hdblcm SAP HANA Cockpit hdbsql SAP NetWeaver Identity Management.
Which authorization assignments are possible when you set up an authorization concept in the SAP HANA database?
There are 2 correct Answer:s to this question. A role can be granted to a catalog object. A privilege can be granted to a user. A user can be granted to a role. A role can be granted to a role.
Which of the following actions are audited by default in SAP HANA?
There are 2 correct Answer:s 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 Changes to system configuration.
What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)?
There are 2 correct Answer:s to this question. Kernel settings Missing OS patches Memory configuration Network configuration.
During the delta merge process, to which memory areas is data inserted?
There are 2 correct Answer:s to this question. Main 2 Delta 1 Delta 2 Main 1.
Which of the following tasks requires the BACKUP ADMIN authorization?
There are 2 correct Answer:s to this question. Recovering the database without a user interface Physically deleting data and log backups and obsolete versions of the backup catalog from the backup location. Backing up the database without a user interface. Administration tasks executed on a tenant database through the system database.
A user is complaining about missing privileges when executing a query. How do you configure the indexserver trace to obtain the missing privileges?
Please choose the correct Answer:. Select trace level Info for the authorization component. Select trace level Warning for the authentication component. Select trace level Debug for the authenticationcodec component. Select trace level Error for the auditing component.
What is the the recommended disk space for /hana/shared/<SID> for single-node SAP HANA systems
Please choose the correct Answer:. Size [installation(single-node)] = MIN (2 x RAM; 2 TB) Size [installation(single-node)] = MIN (1 x RAM; 1 TB) Size [installation(single-node)] = MAX (2 x RAM; 1 TB) Size [installation(single-node)] = MIN (2 x RAM; 1 TB).
Which information is provided by the backup catalog
Please choose the correct Answer:. Backup destination Backup configuration Progress of a backup Backup ID.
After confirming Lock now, which actions are still possible?
Choose the correct Answer:. 88Creating and changing application data (e.g. VA01) and user master records SU01) Developing via ABAP workbench (SE80) Releasing and importing transport requests via the Transport Manager (SE09) and Transport Management System (STMS) Applying SAP notes via Note Assistant (SNOTE).
Which connections do you need to enable explicitly for a Restricted User?
There are 2 correct Answer:s to this question. JDBC ADO.NET ODBC OLEDB.
Which of the following are characteristics of SAP HANA Smart Data Streaming?
Please choose the correct Answer:. It uses databases queries. It provides reports and analysis on the received data. It acts based on combinations of events. It is a standalone product for use with any target system.
You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup?
There are 2 correct Answer:s to this question. When a savepoint occurs When the log buffer is full After the configured time threshold has been exceeded When the log segment is full.
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 Answer:s to this question. SQL Command Editor of the DBA Cockpit on the application server HDBSQL command line tool on the SAP HANA server SAP HANA cockpit 2.0 on a central server SAP HANA studio on the SAP HANA server.
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
Please choose the correct Answer: in the SYSTEMDB in the first tenant in the SYSTEMDB and the first tenant in the SYSTEMDB and the all tenant.
Which information can you collect by running the fullSystemInfoDump.py script when the SQL connection is available?
Please choose the correct Answer:. A selection of rows of schema SAP<SID> A selection of rows of schema _SYS_XS A selection of .trc files A selection of .log files.
What are the merge methods that are triggered by the SAP HANA system processes?
There are 2 correct Answer:s to this question. Critical Hard Smart Auto.
Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database?
Please choose the correct Answer:. Request Processing and Execution Control External Interfaces Storage Engine and Disk Storage Relational Engines.
Which of the following actions can be audited by SAP HANA?
Changes to system configuration. Upgrade of an SAP HANA database instance. Create or drop user, and create or drop role.
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 Answer:s to this question. The log segment is closed after exceeding the configured time threshold. The database is started. The database is stopped. The log segment is full.
Which of the following users are able to start and stop a distributed SAP HANA Database System
There are 2 correct Answer:s to this question. ADM user SYSTEM user ROOT user.
Which tools shows the differences of tables and indexes between your abap dictionary and your SAP HANA Database?
Please choose the correct Answer:. HDBLCM SAP HANA cockpit HDBSQL DBAcockpit.
During the Installation, the following users are created automatically. Which of them is the SAP Host Agent administrator? adm user sapadm user SYSTEM user.
What are advantages of column store tables?
There are 3 correct answers to this question. Only the columns required are actually loaded to memory Columns can be partitioned They are optimized for high-volume read / write transactional processing Data footprint is automatically reduced through compression.
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 catalog view of the SAP HANA Web-based Development Workbench In the administration editor of the SAP HANA studio In the SAP HANA database explorer for SAP HANA cockpit 2.0.
Why do you create a time dimension calculation view?
Please choose the correct answer. To provide date-based help values for a DIRECT type input parameter To enhance a calculation view with a drilldown on a time hierarchy To support temporal joins in a cube calculation view with star schema To enable time dependency on parent-child hierarchies.
Which diagnostic file can you use to monitor the status of database recovery
Please choose the correct answer. Sapstartsrv.log Backinit.log Available.log Backup.log.
How do you ensure that web-based applications send https requests to specific db in an sap Hana multiple-container system?
There are 2 correct answers to this question. Check the hostname mappings to internal https ports Configure an alias hostname for every tenant db Check that all requests with physical hostname are forwarded to tenant databases Configure an sap web dispatcher for every tenant database.
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. Configure a secure connection from target system to source system Back up the source tenant database. Create credentials for authenticated access to the target system. Create a tenant on the target system identical to the source system. Create credentials for authenticated access to the source system.
You plan to setup a sap hana 2.0 system on intel-based platforms. Which of the following Operating system can you use?
There are 2 correct answers for this questions Suse linux enterprise server (SLES for sap application 11 sp1) Suse linux enterprise server (SLES for sap application 12 sp1) Radhat enterprise linux for sap hana (RHEL for SAP HANA) 6.5 Radhat enterprise linux for sap hana (RHEL for SAP HANA) 7.2.
Which processor combinations are allowed for the primary system and secondary system in an Active/Active system replication setup?
There are 2 correct Answer:s to this question.
Primary Intel-based
Secondary Intel-based Primary Intel-Based
Secondary IBM Power Primary IBM Power
Secondary IBM Power Primary IBM Power
Secondary Intel-based.
|
