Filter interviews by
I applied via Approached by Company and was interviewed before Mar 2021. There were 2 interview rounds.
Yes, Azure SQL db is a fully managed relational database service provided by Microsoft Azure.
Azure SQL db is a cloud-based database service that allows you to build, scale, and manage applications with ease.
It is based on Microsoft SQL Server engine and offers high availability, security, and performance.
You can use Azure SQL db to store and retrieve structured, semi-structured, and unstructured data.
It supports variou...
Steps to improve SQL query performance
Optimize the query by using appropriate indexes
Minimize the use of functions and calculations in the query
Avoid unnecessary joins and subqueries
Retrieve only the required columns instead of selecting all
Use query hints or optimizer directives if necessary
Analyze and optimize the database schema and table structures
Consider partitioning large tables
Monitor and tune the database serv...
To improve the performance of a data pipeline in Azure Data Factory, you can optimize data flow, use parallel processing, and monitor resource utilization.
Optimize data flow by reducing unnecessary transformations and filtering
Use parallel processing by partitioning data and running multiple activities concurrently
Monitor resource utilization to identify bottlenecks and optimize resource allocation
To send emails on completing a job from SQL Server, you can use SQL Server Agent and Database Mail.
Configure SQL Server Agent to run the job
Enable Database Mail and configure an SMTP server
Create a SQL Server Agent job that sends an email on completion
Use the sp_send_dbmail stored procedure to send the email
Include the necessary details in the email, such as job status and execution duration
Top trending discussions
I applied via Job Portal and was interviewed in Oct 2024. There were 4 interview rounds.
posted on 22 Dec 2024
Create scenario-based questions that challenge you to utilize all of your coding skills.
Security in APIs is crucial for protecting sensitive data and preventing unauthorized access.
Use authentication methods such as OAuth or API keys to verify the identity of users accessing the API.
Implement encryption to secure data transmission between clients and servers.
Set up rate limiting to prevent abuse and protect against denial of service attacks.
Regularly update and patch the API to address security vulnerabil...
posted on 4 Jul 2024
Current technologies are more advanced, efficient, and user-friendly compared to previous technologies.
Current technologies have faster processing speeds and higher storage capacities.
Previous technologies often required manual input and were less intuitive for users.
Current technologies offer more connectivity options and seamless integration with other devices.
Examples: Smartphones vs. flip phones, cloud computing vs
I applied via Naukri.com and was interviewed in Jun 2024. There were 2 interview rounds.
Non functional requirements are criteria that specify how a system should behave, rather than what it should do.
Performance - system should respond within 2 seconds for all user interactions
Scalability - system should be able to handle 1000 concurrent users
Reliability - system should have a 99.99% uptime
Security - system should encrypt all sensitive data
Usability - system should have a user-friendly interface
Improve legacy app performance by optimizing code, implementing caching, and scaling resources.
Optimize code by identifying and removing bottlenecks
Implement caching to reduce database calls and improve response time
Scale resources by using containers or serverless architecture
Use asynchronous processing for long-running tasks
Upgrade hardware or infrastructure if necessary
Security in microservices involves implementing authentication, authorization, encryption, and monitoring to protect data and services.
Implement authentication and authorization mechanisms to control access to microservices.
Use encryption to secure communication between microservices and external clients.
Implement monitoring and logging to detect and respond to security incidents.
Consider using API gateways for central...
Microservices architecture for a wealth management app involves breaking down the application into smaller, independent services.
Each microservice focuses on a specific business function, such as client onboarding, portfolio management, or reporting.
Services communicate through APIs, allowing for flexibility and scalability.
Each microservice can be developed, deployed, and scaled independently, leading to faster develo...
posted on 15 Oct 2024
I was interviewed in Sep 2024.
Message related issues in Kubernetes can be handled by troubleshooting network configurations, checking pod logs, and monitoring resource usage.
Troubleshoot network configurations to ensure proper communication between pods
Check pod logs for any error messages or issues related to message passing
Monitor resource usage to identify any bottlenecks or performance issues affecting message delivery
I was interviewed in Sep 2024.
posted on 20 May 2024
posted on 16 Apr 2024
Solution architecture involves designing and describing the structure, behavior, and views of a system.
Identifying key components and their interactions
Defining data flow and communication protocols
Ensuring scalability, performance, and security
Creating detailed diagrams and documentation
Collaborating with stakeholders to align with business goals
Softwaretest Engineer
9
salaries
| ₹1.5 L/yr - ₹3.5 L/yr |
Software Developer
8
salaries
| ₹2 L/yr - ₹4 L/yr |
Delivery Manager
7
salaries
| ₹11 L/yr - ₹18.2 L/yr |
Business Analyst
6
salaries
| ₹5 L/yr - ₹8.5 L/yr |
IT Technical Recruiter
6
salaries
| ₹2 L/yr - ₹6 L/yr |
Cognizant
NTT Data Information Processing Services
Sutherland Global Services
Hexaware Technologies