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 Referral and was interviewed before Aug 2021. There were 2 interview rounds.
posted on 5 Apr 2021
posted on 1 Aug 2022
I applied via Recruitment Consulltant and was interviewed before Aug 2021. There was 1 interview round.
I applied via Referral and was interviewed before Mar 2021. There were 2 interview rounds.
I applied via LinkedIn and was interviewed in Oct 2021. There were 3 interview rounds.
Current Ratio formula is Current Assets divided by Current Liabilities.
Current Ratio = Current Assets / Current Liabilities
It measures a company's ability to pay off its short-term liabilities with its short-term assets
A higher current ratio indicates a better ability to meet short-term obligations
Example: If a company has current assets of $100,000 and current liabilities of $50,000, the current ratio would be 2:1
Quick Ratio is a financial metric used to measure a company's ability to pay off its current liabilities with its most liquid assets.
Quick Ratio is also known as Acid Test Ratio
It is calculated by dividing the sum of cash, marketable securities, and accounts receivable by current liabilities
A higher Quick Ratio indicates a company's better liquidity position
A Quick Ratio of 1:1 is considered good
Example: If a company h...
posted on 6 Mar 2024
I applied via Naukri.com and was interviewed before Mar 2023. There was 1 interview round.
Most case kind of question, end to end data flow
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
Sutherland Global Services
Optum Global Solutions
Hexaware Technologies