DBMS Vs Data warehousing?
Detailed difference available in sql question and answer document
SCD & types?
Detailed information available in sql question and answer document
Schemas in DW?
Answer available in this document (above)
My ETL,Model
Given a table to find Max salary, Max salary of each company?
Detailed information available in sql question and answer document
Project flow?
I will add
SQL queries like joins,2nd highest salary
Detailed information available in sql question and answer document
what type of data you will get generally?
Interviewer asking what type of are you getting daily.
We will get csv,txt and tables
what are the activities you performed?
You can tell some control flow activities
Any idea about DW concepts like SCDs ?
Already covered
Have any relevant experience in Python or Pyspark?
No
Did you do any performance tuning?
NO. But I know how do. this is already covered
Mention one difficult scenario you have faced?
You can any one of the difficult scenario
what are the services used in azure?
Azure Blob, ADLS, Azure SQL, Azure Data factory, Azure Keyvalut and Logic apps
IAAS, PAAS, SAAS examples?
It is covered in the above
Devops,Scaling both Horizantal & vertical,Azure Kubernetes,No-SQL ?
I don’t have idea on this
Data flows ?
Covered in the above
Removing duplicates query?
Detailed information available in sql question and answer document
How to join two tables in data flows? end to end explain?
This will cover in data flows and I will show you
Share with your friends: |
