Quantzig Data Engineer Interview Questions and Answers

Q1. Join, adf related questions
Add your answer
Q2. Databricks basics related questions
Add your answer

It was nice focus on quantitative and logical reasoning in aptitutude section

Interviewer himself did not knew python or any other data analysis language

Excel, questions that were open ended

Q1. How will you work under female manager
Add your answer
Q2. Are you willing to work for lower salary than previous
Add your answer
Q3. Will your accomodation or salary structure needed to be validated in case you got married
Add your answer
Q4. Will you work till 1 am in the morning as bjp politicians client can ask anything anytime
Add your answer

Q1. Why ai and machine learning is only marketing term and not a real technology
Add your answer
Q2. Why python is an awful language and would you be willing to work as a back end developer using spring or Node
Add your answer

Q1. Will you work under bond of 2 yrs ?
Add your answer
Q2. We will give 30% of your salary as Variable pay after completion of 1 yr but we will decide when to give it to you. Would you still be willing to work for us as working for our company is a prestigious opp...read more
Add your answer

Q1. Installation and upgradation steps
Add your answer
Q2. Patching and performance tuning
Add your answer

Q1. Table space is full what action need to take
Ans. 
Free up space by deleting unnecessary data or increasing table space size.
• Identify which table space is full

• Check if there are any unnecessary data that can be deleted

• Increase the size of the table space if necessary

• Consider partitioning the table to distribute data across multiple table spaces
Answered by AI
Add your answer
Q2. Datafile addition to tablespace
Ans. 
Adding a datafile to a tablespace
• Use ALTER TABLESPACE statement to add datafile

• Ensure enough disk space is available

• Monitor tablespace usage regularly

• Example: ALTER TABLESPACE users ADD DATAFILE '/u01/app/oracle/oradata/db1/users02.dbf' SIZE 50M;
Answered by AI
Add your answer
Q3. How to add datafile to tablespace
Ans. 
To add a datafile to a tablespace:
• Identify the tablespace where the datafile needs to be added

• Create a new datafile using the 'CREATE DATAFILE' command

• Add the new datafile to the tablespace using the 'ALTER TABLESPACE' command

• Ensure that the new datafile is of the correct size and location
Answered by AI
Add your answer

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer