Persistent Systems Azure Developer Interview Questions and Answers

Sql queries and knowledge of different syntaxes

Q1. Find the student with marks greater than 80 in all subjects
Ans. 
Filter students with marks greater than 80 in all subjects
• Iterate through each student's marks in all subjects

• Check if all marks are greater than 80 for a student

• Return the student if all marks are greater than 80
Answered by AI
Add your answer
Q2. Write the syntax to define the schema of a file for loading.
Ans. 
Syntax to define schema of a file for loading
• Use CREATE EXTERNAL TABLE statement in SQL

• Specify column names and data types in the schema definition

• Example: CREATE EXTERNAL TABLE MyTable (col1 INT, col2 STRING) USING CSV
Answered by AI
Add your answer

Q1. Can you describe your project?
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

Q1. Brief about your projects Be much prompt with your roles and responsibilities. Good to know SQL better
Add your answer

Q1. Salary negotiation and about relocation
Add your answer

Q1. Give an overall introduction
Add your answer

Q1. Technical questions based on skills
Add your answer

Q1. Azure App Gateway configuration
Add your answer
Q2. Azure Monitoring and update management
Add your answer

Q1. How to do performance tuning in adf
Ans. 
Performance tuning in Azure Data Factory involves optimizing data flows and activities to improve efficiency and reduce processing time.
• Identify bottlenecks in data flows and activities

• Optimize data partitioning and distribution

• Use appropriate data integration patterns

• Leverage caching and parallel processing

• Monitor and analyze performance metrics
Answered by AI
Add your answer

Q1. Explain the CI CD Flow
Ans. 
CI/CD flow is the process of automating the build, test, and deployment of code changes.
• Continuous Integration (CI) involves automatically building and testing code changes as they are committed to the repository.

• Continuous Deployment (CD) involves automatically deploying code changes to production after passing tests.

• CI/CD pipelines use tools like Jenkins, Azure DevOps, or GitLab to automate the process.

• Automated test...read more
Answered by AI
Add your answer
Q2. Power shell Commands
Add your answer