IBM Senior SAP Basis Technology Consultant Interview Questions and Answers

Outlined POC process for migrating SAP On-Premise System to Google Cloud Platform

• Analyzed current system and determined necessary resources for migration

• Created a test environment to ensure compatibility and identify errors

• Used Cloud Migration for SAP tool to migrate data and configurations

• Encountered errors with network connectivity and resolved through troubleshooting

• Monitored system performance and made necessary ad...read more

To enhance performance during system hang or intermittent freezing, we follow these practices:

• Analyze system logs to identify the root cause of the issue

• Check system resources like CPU, memory, disk usage, etc.

• Optimize database performance by tuning parameters and indexes

• Implement SAP recommended notes and patches

• Monitor system performance regularly to identify potential issues

• Implement load balancing and clustering to...read more

SLT Replication offers real-time data replication with minimal system impact.

• SLT Replication allows for real-time data replication from multiple sources to a single target system.

• It offers minimal system impact as it uses trigger-based replication instead of full table scans.

• SLT Replication also provides data transformation capabilities and supports heterogeneous data replication.

• Compared to other replication methods, ...read more

Yes, I have experience in performing HANA database refresh.

• I have performed HANA database refresh for various clients during my tenure as a SAP Basis consultant.

• I am well-versed with the process of taking a backup of the source database and restoring it on the target system.

• I have also worked on post-refresh activities such as updating system configurations and performing system checks to ensure data consistency.

• One of...read more

Implemented HANA table partitioning and index optimization resulting in 50% faster query performance.

• Implemented table partitioning based on frequently accessed data

• Optimized indexes to reduce data retrieval time

• Tuned HANA parameters for better memory allocation

• Reduced data footprint by archiving historical data

• Implemented data compression to reduce storage requirements

HANA Database memory issue identification scenario

• High memory consumption by HANA processes

• Frequent garbage collection

• Slow query performance

• Out of memory errors in HANA logs

• Memory-related alerts in HANA monitoring tools