Microsoft Azure Data Fundamentals DP-900 Practice Question
Your organization is delineating responsibilities for a new Azure-based analytics solution. One role must take ownership of bringing data from various operational systems, cleaning it, and loading it into an Azure Synapse Analytics dedicated SQL pool so that analysts can later query it. Which task is most aligned with the responsibilities of a data engineer?
Create interactive dashboards and reports in Power BI for business stakeholders.
Train a machine-learning model in Azure Machine Learning and deploy it as a REST endpoint.
Configure automated backups and monitor index fragmentation for an Azure SQL Database instance.
Design and implement data ingestion pipelines that cleanse and transform raw data before loading it into an Azure Synapse Analytics dedicated SQL pool.
Data engineers focus on the movement and preparation of data. Building and maintaining ingestion pipelines-including extraction from multiple sources, data cleansing, transformation, and loading into analytic stores such as Azure Synapse Analytics-is a core duty of the role. Creating reports is associated with data analysts, managing backups and index health is typical for database administrators, and training machine-learning models is usually the remit of data scientists, not data engineers.
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 Synapse Analytics?
Open an interactive chat with Bash
What is a dedicated SQL pool in Azure Synapse Analytics?
Open an interactive chat with Bash
What does a data ingestion pipeline do?
Open an interactive chat with Bash
Microsoft Azure Data Fundamentals DP-900
Describe core data concepts
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 .