Telstra Interview Questions and Answers

Leetcode easy and medium questions. It was easy to clear

Q1. Dry run bubble and insertion sort
Add your answer
Q2. One SQL query easy level
Ans. 
This SQL query retrieves data from a database based on specific conditions.
• Use SELECT to specify columns: e.g., SELECT name, age FROM users;

• Use WHERE to filter results: e.g., WHERE age > 18;

• Combine conditions with AND/OR: e.g., WHERE age > 18 AND city = 'New York';

• Sort results with ORDER BY: e.g., ORDER BY age DESC;

• Limit results with LIMIT: e.g., LIMIT 10;
Answered by AI
Add your answer

Q1. Discussion about projects
Add your answer
Q2. Do you have any questions
Add your answer

Python and SQL Questions (Easy to Medium)

Q1. Project Work Discussion
Add your answer
Q2. SQL Coding (Can be with an online compiler)
Ans. 
This SQL coding question tests your ability to manipulate and query data effectively.
• Understand the requirements: Clarify what data is needed and how it should be structured.

• Use SELECT statements: Retrieve specific columns from tables, e.g., SELECT name, age FROM users;

• Join tables: Combine data from multiple tables using JOIN, e.g., SELECT * FROM orders JOIN customers ON orders.customer_id = customers.id;

• Filter results...read more
Answered by AI
Add your answer
Q3. Python Coding (Can be with an online compiler)
Ans. 
This question tests your ability to write Python code for data engineering tasks.
• Understand data types: Lists, dictionaries, sets, and tuples are essential in Python.

• Use libraries: Familiarize yourself with Pandas and NumPy for data manipulation.

• Practice SQL: Data engineers often work with databases, so SQL knowledge is crucial.

• Data pipelines: Learn how to create ETL (Extract, Transform, Load) processes.

• Cloud services:...read more
Answered by AI
Add your answer
Q4. PySpark Coding (All the coding answers have to be submitted to the interviewer)
Add your answer
Q5. PySpark Joins, and Databricks, and Vanilla Spark difference
Add your answer

Q1. SQL 2 Questions (Easy to Medium) (Maybe on the compiler)
Add your answer
Q2. Python (Easy) (Maybe on compiler)
Add your answer
Q3. Scenario-based questions on the project
Add your answer

Easy-medium level and it included two coding questions and some technical questions

Q1. How are structures and classes stored?
Ans. 
Structures and classes are stored in memory as a combination of data members and member functions.
• Structures and classes are stored in memory as a combination of data members and member functions.

• Data members of a structure or class are stored in contiguous memory locations.

• Member functions of a class are stored separately in memory and are shared among all instances of the class.

• Pointers to member functions are used t...read more
Answered by AI
Add your answer
Q2. What is final and finalize?
Ans. 
final is a keyword in Java used to restrict inheritance, overriding, and modification. finalize is a method used for cleanup operations before an object is garbage collected.
• final keyword is used to declare constants, prevent inheritance by marking a class as final, and prevent method overriding by marking a method as final

• finalize method is called by the garbage collector before an object is destroyed

• Example: final in...read more
Answered by AI
Add your answer

Q1. If your manager assigned you a task that needs to be done in certain manner with strict timeline and you have better approach for the same but It might take a lot of time. What will you do in that case?
Ans. 
I would communicate with my manager to discuss the benefits of my approach while respecting the timeline constraints.
• Assess the current task requirements and timeline to understand the constraints.

• Prepare a detailed comparison of both approaches, highlighting the long-term benefits of my method.

• Schedule a meeting with my manager to present my findings and discuss the potential trade-offs.

• Be open to feedback and willing...read more
Answered by AI
Add your answer
Q2. Discussions on projects and current job
Add your answer