Microsoft Azure Data Fundamentals DP-900 Practice Question
A company must ingest data from several on-premises SQL Server databases into Azure Data Lake Storage on a nightly schedule. The solution should orchestrate the batch pipeline and allow developers to design data transformations by using a visual, code-free interface. Which Azure service meets these requirements?
Azure Data Factory is Microsoft's cloud-based data integration service. It can connect to on-premises data sources through self-hosted integration runtimes, schedule and orchestrate batch pipelines, and provides Mapping Data Flows so that transformations can be built in a drag-and-drop, code-free designer. Azure Event Hubs is optimized for real-time event streaming, not scheduled batch ETL. Azure Databricks is an analytics platform that requires writing notebooks rather than providing a visual orchestration interface. An Azure Synapse Analytics dedicated SQL pool is an analytical data store, not an ingestion and orchestration service.
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 used for?
Open an interactive chat with Bash
How does Azure Data Factory connect to on-premises data sources?
Open an interactive chat with Bash
What are Mapping Data Flows in Azure Data Factory?
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 .