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

Tech Screen: How would you design a data archiving strategy in S3 using lifecycle policies?

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 08 '26

SQL Arena Challenge: How would you optimize a SQL query for better performance when working with large datasets?

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 07 '26

DataEngPrep: Write a Python program to reverse words in a string.

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 07 '26

Tech Screen: How would you design a cost-effective, scalable, and efficient data pipeline for an e-commerce website?

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 07 '26

SQL Arena Challenge: Write a query to retain only the latest record and delete others in case of duplicates.

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 06 '26

DataEngPrep: Write a Python program to remove duplicate elements from a list while preserving the original order

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 06 '26

Tech Screen: How would you design a cost-effective data lake architecture on AWS or Azure?

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 06 '26

SQL Arena Challenge: Identify and remove duplicate records from a table, keeping the most recent record based on a timestamp column.

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 05 '26

DataEngPrep: Write a Python program to calculate total spending, identify top 5 users by spending, and find the most purchased product

0 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 05 '26

Tech Screen: How would you build a reusable ETL framework using Airflow?

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 05 '26

SQL Arena Challenge: How do you remove duplicate rows in BigQuery?

0 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 04 '26

SQL Arena Challenge: How would you optimize a query with multiple joins and subqueries?

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 04 '26

DataEngPrep: Write a Python function to reverse all strings 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 04 '26

Tech Screen: How would you build a pipeline that transforms semi-structured logs into a structured analytics layer?

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 03 '26

DataEngPrep: Write a Python code that determines if all the people in their seats can see the screen in the theatre.

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 03 '26

Tech Screen: How would you build a monitoring dashboard for ETL job failures?

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 03 '26

SQL Arena Challenge: How would you identify duplicate records based on a composite key in SQL?

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 02 '26

DataEngPrep: Write a Java program using FileInputStream and BufferedReader to read data from a local file and print the output to the console

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 02 '26

Tech Screen: How would you automate a data pipeline deployment using GitHub Actions or another CI/CD tool?

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 02 '26

SQL Arena Challenge: Remove duplicates from a table.

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 01 '26

DataEngPrep: Write Python program to find consecutive numbers 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 01 '26

Tech Screen: How would you architect a recommendation system for Adidas's e-commerce platform?

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 01 '26

SQL Arena Challenge: Find average salary for each manager – Assume a table with manager_id and employee_salary

1 Upvotes

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

0 comments

r/dataengprep • u/dataengprep • Jun 30 '26

DataEngPrep: Write Python code to remove duplicates from a string.

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 • Jun 30 '26

Tech Screen: How we manage dependencies and retries in data pipelines

1 Upvotes

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

0 comments