30+ TekLink International Interview Questions and Answers

Types of instances and their costs

• On-demand instances: pay as you go, no upfront cost

• Reserved instances: upfront payment for a discounted rate

• Spot instances: bid for unused capacity, can be cheapest but not guaranteed

• Lowest cost instance varies depending on usage and availability

• Consider usage patterns and budget when choosing instance type

Yes, an AWS keypair can be recovered if lost.

• To recover a lost AWS keypair, you can create a new keypair and associate it with the existing EC2 instances.

• First, create a new keypair in the AWS Management Console or using the AWS CLI.

• Then, stop the EC2 instances associated with the lost keypair.

• Detach the root volume from each instance and create a new temporary instance.

• Attach the root volume to the temporary instance and mount it.

• Modify the authorized_keys file on the mounte...read more

There are several ways to access AWS cloud without using the console.

• AWS Command Line Interface (CLI)

• AWS SDKs (Software Development Kits)

• AWS Management Console API

• AWS CloudFormation

• AWS CloudWatch

• AWS Systems Manager

• AWS Lambda

• AWS Elastic Beanstalk

The interview questions cover topics such as columnstore index, Power BI report performance, complex dashboard creation, data modeling, and RLS.

• For columnstore index in SSAS, I have experience in creating and optimizing them for better query performance.

• To ensure Power BI report performance, I use techniques such as data compression, query optimization, and caching.

• I have created complex dashboards with multiple visuals, drill-down capabilities, and custom visuals.

• I have work...read more

I have used CloudFormation to automate infrastructure deployment. I have written templates in JSON and YAML.

• I have used CloudFormation to create and manage AWS resources.

• I have written templates in JSON and YAML.

• I have used intrinsic functions and parameters to make templates dynamic.

• I have used CloudFormation Designer to create templates visually.

• I have used CloudFormation StackSets to deploy templates across multiple accounts and regions.

Stopping a server halts its processes while terminating a server completely shuts it down.

• Stopping a server is a temporary measure while terminating is permanent

• Stopping a server can be done to perform maintenance or updates while terminating is done when the server is no longer needed

• Stopping a server can be done gracefully to allow processes to finish while terminating is abrupt and may result in data loss

• Examples of stopping a server include using the 'stop' command in the...read more

Infrastructure monitoring and alert generation for crises

• Implement a monitoring system that tracks key metrics such as CPU usage, memory usage, network traffic, and disk space

• Set up alerts for when these metrics exceed certain thresholds or when there are anomalies in the data

• Use a centralized dashboard to view the status of all infrastructure components and quickly identify any issues

• Ensure that the alert system is reliable and can send notifications via multiple channels su...read more

To troubleshoot a Jenkins pipeline if aborted, check logs, identify the cause, and fix the issue.

• Check the Jenkins console output for error messages

• Identify the stage or step where the pipeline was aborted

• Check the logs for any relevant information

• Fix the issue and rerun the pipeline

Coach view life cycle events are events triggered during the life cycle of a coach view in a software application.

• Initialization event - triggered when the coach view is initialized

• Render event - triggered when the coach view is rendered on the screen

• Update event - triggered when the coach view is updated with new data

• Destroy event - triggered when the coach view is removed from the screen

External CSS can be implemented in IBM BAW by linking the CSS file in the HTML code of the coach view.

• Create a CSS file with the desired styles

• Upload the CSS file to a location accessible by IBM BAW

• In the coach view, add a link to the external CSS file using the tag

To convert rows to columns, use the PIVOT function in SQL.

• Identify the column that will become the new row headers.

• Use the PIVOT function to transform the data.

• Specify the values to be aggregated in the new columns.

• Example: SELECT * FROM table_name PIVOT (SUM(value_column) FOR row_header_column IN (column1, column2, column3))

• Example: Use the UNPIVOT function to convert columns to rows.

I will manage delivery independently by setting clear goals, delegating tasks effectively, monitoring progress, and adjusting plans as needed.

• Set clear goals and expectations for the team

• Delegate tasks based on team members' strengths and workload

• Monitor progress regularly and address any issues promptly

• Adjust plans as needed to ensure timely delivery

• Communicate effectively with team members and stakeholders

The product was built using a microservices architecture.

• The architecture was designed to be scalable and flexible.

• Each microservice was responsible for a specific function.

• Communication between microservices was done through APIs.

• Examples of microservices include user authentication, payment processing, and order management.

Server side pagination can be implemented by fetching a subset of data from the server based on page number and page size.

• Implement pagination logic on the server side to limit the amount of data returned per request.

• Use query parameters like 'page' and 'pageSize' to specify the page number and number of items per page.

• Adjust the query to fetch the appropriate subset of data based on the page number and page size.

• Return the paginated data to the client for display.

Roles and modules are key components of Ansible automation tool.

• Roles are a way to organize and group tasks, variables, and files in a structured manner.

• Modules are pre-written scripts that perform specific tasks on remote hosts.

• Roles can contain multiple modules and can be reused across different playbooks.

• Modules can be used independently or as part of a role.

• Examples of modules include file, copy, service, and package.

• Examples of roles include webserver, database, and load...read more

Yes, a proxy PO can be appointed to act on behalf of the Product Owner.

• A proxy PO is someone who is appointed to act on behalf of the Product Owner when they are unavailable or unable to perform their duties.

• The proxy PO should have a good understanding of the product and the requirements of the stakeholders.

• The proxy PO should be able to make decisions and prioritize the product backlog in the absence of the Product Owner.

• However, it is important to note that the proxy PO sh...read more

Promises are commitments to deliver, while observable differences are tangible outcomes that can be seen or measured.

• Promises are verbal or written commitments made by an individual or organization.

• Observable differences are the actual results or changes that occur as a result of fulfilling a promise.

• For example, a company promising to improve customer service may see an observable difference in customer satisfaction ratings.

• Another example could be a manager promising to inc...read more

Log management can be configured by defining log sources, setting log levels, and selecting a log management tool.

• Identify all the log sources such as servers, applications, and network devices

• Define log levels for each source to prioritize important logs

• Select a log management tool such as ELK stack, Splunk, or Graylog

• Configure the tool to collect and analyze logs from all sources

• Set up alerts and notifications for critical logs

• Regularly review and analyze logs to identify a...read more

Project workflow is the sequence of steps and tasks involved in completing a project from start to finish.

• Project workflow outlines the order in which tasks need to be completed

• It helps in organizing and managing resources effectively

• It includes defining project scope, setting deadlines, assigning tasks, monitoring progress, and delivering the final product

• Example: In software development, project workflow may involve stages like requirements gathering, design, development, t...read more

VPC stands for Virtual Private Cloud, which is a virtual network dedicated to a user's AWS account.

• VPC allows users to launch AWS resources into a virtual network that they define.

• Users can configure their VPC with their own IP address range, subnets, and route tables.

• VPC provides a secure and isolated environment for users to run their resources.

• Users can also connect their VPC to their on-premises data center using a VPN connection.

• Examples of resources that can be launched...read more

BW4HANA is a separate product designed for HANA database, while BW on HANA is the traditional BW system running on HANA database.

• BW4HANA is a completely new product built on the HANA database, offering enhanced performance and flexibility.

• BW on HANA is the traditional BW system that has been optimized to run on the HANA database.

• BW4HANA allows for more agile data modeling and integration with modern technologies like machine learning and IoT.

• BW on HANA is more suitable for or...read more

To cost optimize AWS infra, use reserved instances, auto scaling, and right-sizing.

• Use reserved instances for predictable workloads

• Implement auto scaling to adjust resources based on demand

• Right-size instances to match workload requirements

• Use cost explorer to identify cost-saving opportunities

• Consider using spot instances for non-critical workloads

• Use AWS Trusted Advisor to identify cost optimization opportunities

Reconciliation is the process of comparing two sets of records to ensure they are in agreement.

• Reconciliation involves matching transactions, balances, or statements to identify discrepancies.

• It is important for financial accuracy and fraud prevention.

• Examples include bank reconciliation, inventory reconciliation, and account reconciliation.

A multi instance loop is a loop that iterates over multiple instances of the same process or activity.

• A multi instance loop is used in BPMN (Business Process Model and Notation) to model a repetitive task that needs to be performed multiple times.

• Each iteration of the loop represents a separate instance of the process or activity.

• The loop can be sequential, parallel, or mixed depending on the requirements of the process.

• Example: In a workflow for approving expense reports, a ...read more

EBS is block storage for EC2 instances while S3 is object storage for files and data.

• EBS is used for storing data that needs to be accessed frequently and requires low latency.

• S3 is used for storing large amounts of data that may not be accessed frequently.

• EBS volumes are attached to EC2 instances while S3 is accessed through APIs.

• EBS provides higher performance and lower latency compared to S3.

• EBS is more expensive than S3.

• Examples of EBS use cases include running databases ...read more

A composite provider is a type of data provider in SAP BW that combines data from multiple InfoProviders into a single virtual InfoProvider.

• Combines data from multiple InfoProviders

• Acts as a virtual InfoProvider

• Allows for complex reporting and analysis by combining data sources

The question was not provided.

• No question provided.

• Cannot answer without the question.

• Please provide the question.

A virtual method is a method in object-oriented programming that is declared in a base class and can be overridden in derived classes.

• Virtual methods allow for polymorphism, where a method can be called on an object and the specific implementation is determined at runtime based on the actual type of the object.

• In C++, virtual methods are declared using the 'virtual' keyword in the base class and can be overridden in derived classes using the 'override' keyword.

• In C#, virtual ...read more

I am available for client discussions during regular business hours and can schedule meetings as needed.

• Available for client discussions during regular business hours

• Can schedule meetings as needed

• Responsive to client inquiries and requests

Waterfall is a linear sequential approach to software development.

• Divided into distinct phases

• Each phase must be completed before moving to the next

• Emphasis on planning and documentation

• Limited customer involvement until the end

• Difficult to make changes once a phase is completed

I cannot disclose the salary of any employee due to confidentiality policies.

• As per company policy, employee salaries are confidential information.

• Disclosing salary information of any employee is a breach of trust and confidentiality.

• It is important to respect the privacy of employees and maintain confidentiality.

• Instead of discussing specific salaries, we can focus on discussing the salary range for the position and negotiate based on qualifications and experience.

Jenkins is a popular open-source automation server used for Continuous Integration and Continuous Delivery/Deployment (CI/CD).

• Jenkins automates the build, test, and deployment process of software applications.

• It integrates with various tools and technologies to provide a seamless CI/CD pipeline.

• Jenkins uses plugins to extend its functionality and support various languages and frameworks.

• It provides a web-based interface for easy configuration and management of jobs and pipeli...read more

A stage in IBM InfoSphere DataStage used to generate rows based on specified criteria.

• Used to create new rows in a data set based on certain conditions

• Can be used to generate test data or to fill in missing data

• Can be configured to generate a specific number of rows or to continue generating rows until a certain condition is met

To find duplicates, use indexing and rank calculations.

• Create an index on the column(s) where duplicates are expected.

• Use rank calculations to identify rows with duplicate values.

• For example, use the RANK() function in SQL to assign a unique rank to each row based on the values in the duplicate column(s).

• Then, select the rows with a rank greater than 1 to identify the duplicates.

Interfaces define contracts for classes to implement, while abstract classes can provide partial implementations.

• Interfaces allow multiple inheritance, abstract classes do not

• Abstract classes can have constructor, interfaces cannot

• Interfaces are used for defining types, abstract classes are used for code reusability

• Example: Interface - Comparable, Abstract class - Animal

The output of the NVL function when 'Job.id' is null or empty

• NVL function returns the first non-null value from the list of arguments

• If 'Job.id' is not null, the output will be 'Job.id'

• If 'Job.id' is null or empty, the output will be an empty string