1. Give me the result rows of left join, right join, full join and cross join for the given two tables?
  2. what is difference between rank, dense rank and average window functions ?
  3. What is indexing in SQL? What are its advantages and disadvantages?
  4. Write a python program to reverse a string without using built in functions?
  5. Write a python program to create a dict from two lists?
  6. What is Enumerate in python?
  7. What are the python libraries you used in your project?
  8. What is Pandas?
  9. How to slice a pandas dataframe?
  10. What is difference between RDD and Dataframe in Pyspark?
  11. How to filter rows and columns in a Pyspark Dataframe?
  12. How to create a s3 trigger in aws lambda?
  13. What are layers in aws lambda? How to create layers?
  14. Is there any other way to use dependencies in aws lambda apart from layers?
  15. What is aws glue catalog?
  16. What are glue crawlers?
  17. What is the difference between aws glue and EMR?
  18. How to copy data from S3 to aws Redshift?
  19. Why copy command is best for moving data to Redshift?
  20. Assume you have data in you local and want to move that to aws. What is the best and cost effective way to do this?