Microsoft Azure Solutions Architect Expert AZ-305 Practice Question
Your company aggregates data from several on-premises Oracle databases, multiple SaaS applications, and partner SFTP servers. You must land the data daily in Azure Data Lake Storage Gen2, apply transformations that run on Apache Spark, and load the curated data into an Azure Synapse Analytics dedicated SQL pool. The solution must provide built-in connectors, a low-code visual design interface, and robust scheduling and monitoring. Which Azure service should you choose to implement the end-to-end data integration pipelines?
Azure Data Factory (ADF) is Microsoft's primary cloud-native data integration service. ADF offers more than 90 pre-built connectors for on-premises and SaaS sources, supports visual authoring of data pipelines and Mapping Data Flows that execute on managed Spark clusters, and includes built-in scheduling, monitoring dashboards, and automatic retry capabilities. Azure Databricks Jobs focus on code-driven processing rather than visual, low-code orchestration and require separate services for many connectors and scheduling. Azure Synapse Data Explorer targets log analytics workloads and is not an orchestration service. Azure Logic Apps is optimized for event-driven application workflows and does not provide the scale or Spark-based transformations needed for large-volume data ingestion and preparation.
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 is Azure Data Factory and how does it enable data integration?
Open an interactive chat with Bash
Why is Azure Data Factory preferred over Azure Databricks for this solution?
Open an interactive chat with Bash
What are Mapping Data Flows in Azure Data Factory?
Open an interactive chat with Bash
Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
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 .