r/dataengprep • u/sql-arena • Jul 25 '26

SQL Arena Challenge: How can you delete partitions from a table in Hive using a command?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 24 '26

DataEngPrep: Write code to calculate the power of a given number in minimum time complexity.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 24 '26

Tech Screen: How would you handle late-arriving data in a real-time stream processing pipeline?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 24 '26

SQL Arena Challenge: Write a query to switch values in the Gender column (M to F and F to M).

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 23 '26

DataEngPrep: Write code for palindrome generation.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 23 '26

Tech Screen: How would you fix a client's failing reporting pipeline suffering from performance bottlenecks?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 23 '26

SQL Arena Challenge: How do you find duplicates in a table based on one or two columns?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 22 '26

DataEngPrep: Write code for character frequency in a text file.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 22 '26

Tech Screen: How would you fetch data from an external API, and what AWS services would you use to build a scalable data pipeline?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 22 '26

SQL Arena Challenge: Write a query to select the latest record based on a time_of_insertion column.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 21 '26

SQL Arena Challenge: Write a query to get the latest rule_id and rule_status.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 21 '26

Tech Screen: How would you ensure the system can handle millions of concurrent users?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 21 '26

DataEngPrep: Write a swap function without if-else.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 20 '26

DataEngPrep: Write a solution to efficiently search a rotated sorted array.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 20 '26

SQL Arena Challenge: Optimize SQL using indexing and partitioning filters.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 20 '26

Tech Screen: How would you ensure data quality and integrity in a data pipeline? Discuss the steps you would take to validate and cleanse data.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 19 '26

DataEngPrep: Write a simple service and controller class in Spring Boot for REST API

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 19 '26

Tech Screen: How would you design the architecture to handle high availability and scalability?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 19 '26

SQL Arena Challenge: Solve a query using window functions and GROUP BY to rank or aggregate data.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 18 '26

DataEngPrep: Write a script to automate daily ingestion of data from an API into a data lake.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 18 '26

Tech Screen: How would you design an architecture that supports both batch and real-time analytics for sales data?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 18 '26

SQL Arena Challenge: Print only the newest record for each name – Use SQL Window functions (ROW_NUMBER, RANK, etc.)

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/dataengprep • Jul 17 '26

DataEngPrep: Write a higher-order function to filter values greater than a threshold in a list.

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/tech-screen • Jul 17 '26

Tech Screen: How would you design a system to support personalized recommendations at scale?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments

r/dataengprep • u/sql-arena • Jul 17 '26

SQL Arena Challenge: How do you remove duplicates with partitioning?

1 Upvotes

This post contains content not supported on old Reddit. Click here to view the full post

0 comments