Your question is Migrate On-Prem to Cloud. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Can you explain how you would migrate an on-premise relational database to a cloud data warehouse?
Cover discovery and source profiling, schema and data-model conversion, full and incremental extraction, validation, security, orchestration, cutover, rollback, and post-migration reconciliation. Assume the target uses Snowflake, ingestion uses AWS Database Migration Service and Amazon S3, and orchestration uses Apache Airflow. Explain how you would minimize downtime, handle type incompatibilities and large tables, preserve lineage, and prove that the migrated data is complete and accurate.
