Newt Global Azure Data Engineer Interview Questions and Answers

Designing/implementing database solutions in the cloud involves selecting appropriate cloud service, data modeling, security, and scalability.

• Select the appropriate cloud service (e.g. Azure SQL Database, Cosmos DB, etc.) based on the requirements of the application

• Design the data model to optimize for the cloud environment (e.g. denormalization, partitioning, etc.)

• Implement security measures such as encryption, access...read more

Use Azure Data Factory to move data from on-premise Oracle server to Azure cloud.

• Create a linked service to connect to the on-premise Oracle server

• Create a linked service to connect to the Azure cloud storage

• Create a pipeline with a copy activity to move data from on-premise to cloud

• Schedule the pipeline to run daily

• Monitor the pipeline for any errors or issues