Appsron Technologies Azure Developer Interview Questions and Answers

Q1. Case study for logic apps
Add your answer
Q2. Types of triggers
Ans. 
Triggers are events that initiate the execution of a function in Azure.
• There are several types of triggers in Azure, including HTTP, Blob, Queue, Timer, and Event Grid triggers.

• HTTP triggers are initiated by an HTTP request.

• Blob triggers are initiated when a new or updated blob is detected in Azure Blob Storage.

• Queue triggers are initiated when a new message is added to an Azure Storage queue.

• Timer triggers are initiat...read more
Answered by AI
Add your answer

Q1. About salary and how many years of experience.
Add your answer

Q1. SQL, pyspark, python
Add your answer
Q2. Medallion arctiicture
Add your answer

Q1. Basics scenario based questions
Add your answer

Q1. Sallery discussion.
Add your answer

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. Azure architecture
Add your answer
Q2. Azure security/ azure logic apps/data engineering
Add your answer

Q1. Azure migration
Add your answer
Q2. Azure devops / azure data engineering
Add your answer

Architecture roadmap 3 tier

Q1. Culture of firm
Ans. 
The culture of the firm is collaborative, innovative, and customer-focused.
• Encourages teamwork and open communication

• Values creativity and continuous improvement

• Prioritizes customer satisfaction

• Promotes diversity and inclusion

• Emphasizes work-life balance
Answered by AI
Add your answer

Q1. What is polybase?
Ans. 
Polybase is a feature in Azure SQL Data Warehouse that allows users to query data stored in Hadoop or Azure Blob Storage.
• Polybase enables users to access and query external data sources without moving the data into the database.

• It provides a virtualization layer that allows SQL queries to seamlessly integrate with data stored in Hadoop or Azure Blob Storage.

• Polybase can significantly improve query performance by levera...read more
Answered by AI
View 1 more answer
Q2. Explain your current project architecture.
Add your answer

Q1. 2 Python Questions based on Strong and List manipulation.
Add your answer
Q2. 2 Sql Questions
Add your answer
Q3. 1 Pyspark Question
Add your answer
Q4. What is service principal, ADF questions...
Add your answer

Q1. Introduction. Question on last company why left.
Add your answer
Q2. Salary Negotiation.
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

Coding round will consists of SQL and pyspark questions, it's a medium level