Have you failed a job interview?
Send us your job interview questions and get correct answers.
You need to migrate 10 on-premises databases to Azure SQL Database, but there are also 100 SSIS packages that are configured to use on premise servers as destinations. What will you use for migration?
Experience Level: Senior
Tags: Azure CloudAzure Data Factory
Answer
Use Azure Data Factory.
Provision Azure SSIS -IR in Azure Data Factory to host SSIS package first. Then use SSMS tool to deploy and run SSIS package.
Related Azure Cloud job interview questions
Which Azure service should you use to store Application Insights data for five years? You plan to use continuous export.
Azure Application InsightsAzure CloudAzure Log Analytics WorkspaceAzure Storage SeniorYou need to recommend a data-tier solution for the app. The solution needs to support multiple consistency levels, needs to be able to store at least 1TB of data, must be able to perform read/write operations in the Azure region local to the instance of the app. How will you solve the requirements?
Azure CloudAzure Cosmos DB SeniorYour application runs in Azure and generates log files that must be archived for five years. The log files must be readable by the app but must not be modified. How will you solve this?
Azure CloudAzure Storage SeniorYou plan to move many files from Azure Blob to Azure Data Lake storage. What solution do you recommend?
Azure CloudAzure Data Factory SeniorYou need to encrypt multiple Azure Virtual Machines where operating system disks and data disks will be encrypted. What do you recommend?
Azure CloudAzure Key VaultAzure Virtual Machines Senior
