Wissen Infotech Interview Questions, Process, and Tips

Branching strategies in GIT are ways to manage code changes and collaboration among team members.

• Gitflow - a popular branching model that uses a master branch for production-ready code and a develop branch for ongoing development

• Trunk-based development - a strategy where all changes are made directly to the main branch, with frequent merges to keep the codebase up-to-date

• Feature branching - a method where each feature ...read more

Terraform is an infrastructure as code tool used to provision and manage cloud resources.

• Automates infrastructure deployment

• Supports multiple cloud providers

• Enables version control for infrastructure

• Allows for modular and reusable code

• Facilitates collaboration between teams

• Examples: provisioning EC2 instances, creating S3 buckets, managing DNS records

A service account is a special account used by a service or application to access resources on a network.

• Service accounts are used to run services or applications with the necessary permissions and access rights.

• Service accounts are often used in database administration to allow the database service to interact with the operating system.

• Service accounts can be configured with specific permissions and restrictions to li...read more

Replication can be configured by setting up a publication, creating a subscription, and initializing the subscription.

• Set up a publication by selecting the database objects to replicate and defining the publication properties.

• Create a subscription by specifying the subscriber server, database, and synchronization schedule.

• Initialize the subscription by generating a snapshot of the publication and applying it to the sub

Truncate is faster and cannot be rolled back, while delete is slower and can be rolled back.

• Truncate is a DDL command, while delete is a DML command.

• Truncate removes all rows from a table, while delete removes specific rows based on a condition.

• Truncate resets identity column values, while delete does not.

• Truncate cannot be used with a WHERE clause, while delete can.

• Truncate is faster than delete as it does not log ind...read more

Team dynamics refer to the interactions and relationships among team members that impact team performance and effectiveness.

• Effective communication is key for successful team dynamics

• Establishing clear roles and responsibilities helps avoid conflicts

• Encouraging collaboration and mutual respect fosters a positive team environment

I faced a major challenge when a critical system outage occurred, impacting multiple users and requiring swift resolution.

• Identified the issue quickly by analyzing system logs and user reports.

• Coordinated with the IT team to implement a temporary workaround while investigating the root cause.

• Communicated regularly with affected users to keep them informed and manage expectations.

• Documented the incident thoroughly for f...read more