One hundred devices write performance data to Azure Blob Storage. You plan to store and analyze that data in an Azure SQL Database and need a continuous process to copy the Blob data into the database. Which service should you recommend?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Data Factory.
Why this is the answer
Azure Data Factory (ADF) is the correct choice because it's a cloud-based ETL (extract, transform, load) and data integration service that can orchestrate and automate data movement and transformation. It can ingest data from various sources, including Azure Blob Storage, and load it into Azure SQL Database on a continuous schedule, fulfilling the requirement for a continuous process. Data Migration Assistant (DMA) is used for assessing SQL Server migrations to Azure SQL Database, not for continuous data ingestion. Azure Data Box is a physical appliance for large-scale offline data transfer, unsuitable for continuous data streaming. Azure Database Migration Service is designed for migrating entire databases with minimal downtime, not for ongoing data synchronization from Blob Storage.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed