Nielsen interview question

Types of join in SQL, How will you connect Spark with different databases write syntax for it. How will you connect AWS S3 with spark. How will you remove/ show the duplicates from a table (spark, sql) UDF in spark and its syntax. Spark-submit syntax How to create table in hive