Microsoft Azure Data Fundamentals DP-900 Practice Question
Your organization needs to copy 4 TB of on-premises SQL Server data into Azure every night for historical reporting. The process must include a schedule, built-in retry logic, and the ability to add data transformation steps, but sub-second latency is not required. Which Azure service should you choose for the ingestion layer?
Azure Data Factory (ADF) is Microsoft's fully managed data integration service. It is designed for orchestrating and automating batch data movement and transformation. ADF pipelines support scheduling, built-in retry and monitoring features, and can run mapping or code-based transformations as part of the load.
Azure Event Hubs is optimized for streaming millions of events per second and is unnecessary overhead for nightly batch loads. Azure Stream Analytics processes streaming data but does not move bulk data from on-premises sources. Azure Databricks provides a big-data compute environment; while it can read from many sources, it is not an orchestration service for scheduled data ingestion. Therefore, Azure Data Factory is the most appropriate choice.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What are the key features of Azure Data Factory pipelines?
Open an interactive chat with Bash
Why isn't Azure Event Hubs suitable for batch data ingestion in this scenario?
Open an interactive chat with Bash
How does Azure Data Factory differ from Azure Databricks for data ingestion?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Describe an analytics workload
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .