Cognizant Azure Cloud Engineer Interview Questions and Answers

Q1. Describe your roles and responsibilities in previous job.
Add your answer
Q2. Describe your technical expertise in cloud.
Add your answer
Q3. Where are your career path in cloud?
Add your answer

Q1. Describe did you manage your work life and personal life while working in 24x7 shift?
Add your answer
Q2. How do you plan to step into leading a team and managing a project?
Add your answer

Mental ability, problem of L.C.M and H.C.F,simplification etc

Q1. How would you create a pipeline for ADLS to SQL data movement?
Add your answer
Q2. How would you create a pipeline from REST API to ADLS? What is there are 8 million rows of records?
Add your answer
Q3. IF data needs filtering, joining and aggregation, how would you do it with ADF?
Add your answer
Q4. Explain medallion architecture.
Add your answer
Q5. Explain medallion with databricks
Add your answer

Q1. Basic questions and salary expectation.
Add your answer

Q1. Lets say you have table 1 with values 1,2,3,5,null,null,0 and table 2 has null,2,4,7,3,5 What would be the output after inner join?
Ans. 
The output after inner join of table 1 and table 2 will be 2,3,5.
• Inner join only includes rows that have matching values in both tables.

• Values 2, 3, and 5 are present in both tables, so they will be included in the output.

• Null values are not considered as matching values in inner join.
Answered by AI
Add your answer
Q2. Lets say you have customers table with customerID and customer name, Orders table with OrderId and CustomerID. write a query to find the customer name who placed the maximum orders. if more than one person...read more
Add your answer
Q3. Spark Architecture, Optimisation techniques
Add your answer
Q4. Some personal questions.
Add your answer

Q1. Explain the entire architecture of a recent project you are working on in your organisation.
Ans. 
The project involves building a data pipeline to ingest, process, and analyze large volumes of data from various sources in Azure.
• Utilizing Azure Data Factory for data ingestion and orchestration

• Implementing Azure Databricks for data processing and transformation

• Storing processed data in Azure Data Lake Storage

• Using Azure Synapse Analytics for data warehousing and analytics

• Leveraging Azure DevOps for CI/CD pipeline aut
Answered by AI
Add your answer
Q2. How do you design an effective ADF pipeline and what all metrics and considerations you should keep in mind while designing?
Ans. 
Designing an effective ADF pipeline involves considering various metrics and factors.
• Understand the data sources and destinations

• Identify the dependencies between activities

• Optimize data movement and processing for performance

• Monitor and track pipeline execution for troubleshooting

• Consider security and compliance requirements

• Use parameterization and dynamic content for flexibility

• Implement error handling and retries fo
Answered by AI
Add your answer
Q3. Lets say you have a very huge data volume and in terms of performance how would you slice and dice the data in such a way that you can boost the performance?
Add your answer
Q4. Lets say you have to reconstruct a table and we have to preserve the historical data ? ( i couldnt answer that but please refer to SCD)
Add your answer
Q5. We have adf and databricks both, i can achieve transformation , fetching the data and loading the dimension layer using adf also but why do we use databricks if both have the similar functionality for few ...read more
Add your answer

Q1. Basic HR questions
Add your answer

Q1. Nothing interviewers interested about your past experience, work you handled in last project , your roles & responsibilities.
Ans. Just prepare everything you mentioned in your resume
Answered Anonymously
Add your answer

Q1. Second round is with project head. Only looking for your problem handling skills & how youn present yourself. Mostly focus on your communication.
Add your answer

Q1. Salty discussion. Be carefully they try to give you only 20% hikes on current package. Negotiate properly.
Add your answer

30 Minutes Round- Easy to moderate level

Q1. Day to day activities?
Ans. 
Day to day activities involve managing Azure DevOps pipelines, monitoring builds, resolving issues, collaborating with teams.
• Managing Azure DevOps pipelines for continuous integration and deployment

• Monitoring builds and deployments for any issues or failures

• Resolving any issues that arise during the development process

• Collaborating with development teams to ensure smooth workflow and communication

• Implementing best prac...read more
Answered by AI
Add your answer
Q2. Quetsions on various devops tools
Add your answer

Q1. Cicd process azure pipeline ?
Add your answer
Q2. Docker file build image?
Ans. 
Docker file is used to build a Docker image by specifying the instructions to create the image.
• Docker file contains instructions for building a Docker image, such as base image, dependencies, commands, etc.

• Each instruction in the Docker file creates a layer in the image, allowing for efficient image building and sharing.

• Example: FROM, RUN, COPY, CMD are common instructions used in a Docker file.
Answered by AI
Add your answer