Does database view occupy the disk space.
Data Engineer Interview Questions
20,163 data engineer interview questions shared by candidates
Null +1 = ? Union and Union Alll which one is faster
Already covered in other reviews
SQL - I was given 4 tables Sales, Product, Promotion and something else (Never had to use it). 1. Which product had the highest sales with promotions and sales ( basically a where clause on 2 flags) 2. What % of sales happened on the first and last day of promotion. I don't remember the rest.. I'd say your ability to translate regular english statements into SQL is tested very well
basic sql and python problem
You have this table - orders (order_id, customer_id, order_datetime, order_amt): 1)select top 10 paying customers for given month
Tell me about your self? What is Data Warehousing?
The interview was highly focused SQL questions such as finding the third high, finding the newest one.
Based on my experience in different projects and analytical functions in SQL
queries, R,Python, data warehouses
Viewing 141 - 150 interview questions
See Interview Questions for Similar Jobs
Analytics EngineerPerl DeveloperModeling EngineerOracle Data IntegratorEtl TesterEtl DeveloperDatastage DeveloperData ModelerDatabase AdministratorData Warehouse DeveloperData MinerBusiness Intelligence SpecialistData ScientistData Warehouse ArchitectDatawarehouse DeveloperData AnalystBusiness Objects DeveloperData Warehouse ManagerMachine Learning Scientist