SQL interview Questions and Answers | Data Engineer Interview

SQL interview Questions and Answers | Data Engineer Interview question

In this Data Engineer Interview Questions and Answers you will learn the latest and top questions asked by companies for Data Engineer interview. This Data Engineer Interview Questions & Answers video covers all kinds of questions starting from basic to advanced questions so that you can get benefited. We can assure you that if you watch this Data Engineer interview preparation video completely you can crack any Data Engineer job interview easily.

[ShashankSharma-kghu]

I am your big fan.. your teaching style

[edigavijay]

In the 3rd question when we use the window function we can't use the where condition. We need to make a subquery for this.

[noreply]

Kindly make a video on
"How to create student account for creating ADF account (without using credit card)"

[gitalijade]

You can use create new_table as and select status..table will create in Oracle db

[ankitapal]

In the query to delete the duplicates the query will also print the record which is duplicate as one of the record is ranked as 1

[ТомРодриго]

you forgot to write DELETE from CTE instead of select to remove dub records

[ChandrakanthSaravanan]

Where can I download the database in the video? It will help with the examples and practice.

[FromBrooklyn]

How can I access the sample data that you are using?

[Anonymous-feep]

Hello, I was asked the following questions for AWS Developer role. Please make a video on this. Thanks.
Q1. We have *sensitive data* coming in from a source and API. Help me design a pipeline to bring in data, clean and transform it and park it.
Q2. So where does pyspark come into play in this?
Q3. Which all libraries will you need to import to run the above glue job?
Q4. What are shared variables in pyspark
Q5. How to optimize glue jobs
Q6. How to protect sensitive data in your data
Q7. How do you identify sensitive information in your data
Q8. How do you provision a S3 bucket?
Q9. How do I check if a file has been changed or deleted?
Q10. How do I protect my file having sensitive data stored in S3
Q11. How does KMS work?
Q12. Do you know S3 glacier?
Q13. Have you worked on S3 glacier?

[KamalSingh-oils]

In Query2 Can we write like : select * into Empl from Employee i.e. without any where condition ?
It also works without where condition right ?

[junnunvishal]

Hi i am getting error for this query select * into EMPL from employee where 1=0 ;
and select * into EMPL from employee where 1 = 0.

It shows as error in sql workbench as undeclared variable: EMPL. can you help regarding this