Providence Global Center Interview Questions and Answers

Q1. Azure data engineering basic questions
Add your answer

Q1. Scenario based coding questions
Add your answer

Q1. Azure and it components ADF, Synapse, Pyspark, Databricks
Add your answer
Q2. Diff authentication like sys n user managed identities, service principals
Add your answer

Q1. Azure - adf, databricks, sql
Add your answer
Q2. My experiences from previous proj
Ans. 
I have extensive experience working on various Azure data engineering projects, including data migration, data warehousing, and data analytics.
• Led a team in migrating on-premises data to Azure cloud using Azure Data Factory

• Designed and implemented data warehouse solutions using Azure SQL Data Warehouse

• Developed data pipelines for real-time data processing using Azure Stream Analytics

• Utilized Azure Databricks for big da
Answered by AI
Add your answer

Q1. In binomial distribution what happens when "n" tends to infinity?
Ans. 
As n tends to infinity in binomial distribution, it approaches a normal distribution.
• As n tends to infinity, the shape of the binomial distribution curve becomes more symmetrical.

• The mean and variance of the binomial distribution approach the mean and variance of a normal distribution.

• The central limit theorem states that as n approaches infinity, the distribution of sample means approaches a normal distribution.
Answered by AI
Add your answer
Q2. What does det(A- lamda*I) = 0 represent?
Ans. 
det(A- lamda*I) = 0 represents the characteristic equation of a matrix A.
• It represents finding the eigenvalues of matrix A.

• It is used to solve for the values of lambda that satisfy the equation.

• The equation is used to determine the behavior of the matrix under certain transformations.

• Example: For a 2x2 matrix A, det(A- lamda*I) = 0 gives a quadratic equation to solve for eigenvalues.
Answered by AI
Add your answer
Q3. In a given problem how do you determine which feature is important? (Think about Classification problem)
Add your answer
Q4. SQL query to find Set difference.
Ans. 
SQL query to find Set difference between two tables.
• Use the EXCEPT keyword in SQL to find the set difference between two tables.

• The EXCEPT keyword returns rows from the first table that are not present in the second table.

• Example: SELECT column_name FROM table1 EXCEPT SELECT column_name FROM table2;
Answered by AI
Add your answer
Q5. Explain K2S hypothesis testing
Ans. 
K2S hypothesis testing is a statistical method used to compare two groups or samples.
• K2S hypothesis testing involves comparing the means of two groups to determine if they are significantly different.

• It is commonly used in research studies to test the effectiveness of a new treatment or intervention.

• The test calculates a p-value, which indicates the probability of obtaining the observed results if the null hypothesis i
Answered by AI
Add your answer

It covered basics of Medical devices, general aptitude, and Network related aptitude with 2 coding questions

Q1. Tell about yourself.
Add your answer
Q2. What are your strengths
Add your answer

Q1. Data structures in python
Ans. 
Data structures in Python are used to store and organize data efficiently.
• Python has built-in data structures like lists, tuples, dictionaries, and sets.

• Lists are ordered and mutable, tuples are ordered and immutable, dictionaries are unordered key-value pairs, and sets are unordered unique elements.

• Data structures can be nested within each other to create complex data structures.

• Python also has libraries like NumPy an...read more
Answered by AI
Add your answer
Q2. How much I know Python
Ans. 
I have intermediate knowledge of Python and have used it for scripting, automation, and data analysis.
• I have experience writing Python scripts for automating tasks in my previous roles.

• I have used Python for data analysis and visualization using libraries like Pandas and Matplotlib.

• I am familiar with Python's syntax, data structures, and object-oriented programming concepts.
Answered by AI
Add your answer

Q1. Solving disputes in a team
Add your answer
Q2. Solving an hypothetical scenario
Add your answer