Providence Global Center Interview Questions, Process, and Tips

Coding plus aptitude test
Dsa and sql questions

Q1. Dbms and sql questions
Add your answer
Q2. Difference between data warehouse and database
Ans. 
Data warehouse is used for analysis and reporting, while database is used for transactional processing.
• Data warehouse stores historical data for analysis, while database stores current data for transactional processing.

• Data warehouse is optimized for read-heavy workloads, while database is optimized for write-heavy workloads.

• Data warehouse typically involves data from multiple sources and is denormalized, while databas...read more
Answered by AI
Add your answer

Q1. Project based questions
Add your answer

Q1. How to resolve issues in workplace
Ans. 
Resolve workplace issues through open communication, collaboration, and problem-solving
• Encourage open communication between team members

• Address conflicts promptly and professionally

• Seek input from all parties involved in the issue

• Collaborate on finding solutions that benefit everyone

• Implement clear policies and procedures for resolving conflicts

• Provide training on conflict resolution and communication skills
Answered by AI
Add your answer
Q2. What did working in team teach you
Add your answer

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