DP-900 Describe an analytics workload on Azure Practice Question
Exhibit
Refer to the exhibit.
{
"type": "Microsoft.Synapse/workspaces",
"apiVersion": "2021-06-01-preview",
"properties": {
"defaultDataLakeStorage": {
"accountUrl": "https://datalake123.dfs.core.windows.net",
"filesystem": "synapse-workspace"
},
"sqlAdministratorLogin": "adminuser",
"sqlAdministratorLoginPassword": "P@ssw0rd123!"
}
}Refer to the exhibit. A developer is creating an ARM template for an Azure Synapse workspace. What is the purpose of the 'defaultDataLakeStorage' property?
⚠ Common exam trap
Test-takers frequently confuse the 'defaultDataLakeStorage' property with a configuration for specific features like Spark logs or backups, when in fact it is the foundational storage account that the entire workspace relies on for its primary data lake operations.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Defines the primary storage account for the workspace
The 'defaultDataLakeStorage' property in an ARM template for Azure Synapse Analytics defines the primary Azure Data Lake Storage Gen2 account that the workspace uses as its default storage. This storage account is where the workspace stores its data, including the data lake files and the metadata for the SQL and Spark engines. It is essential for the workspace to function, as it provides the underlying storage for tables, pipelines, and other workspace assets.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Sets the location for pipeline execution history
Why it's wrong here
The storageAccount property does not designate a separate location for pipeline execution history. Run history, metrics, and logs for pipelines are persisted by the Azure Machine Learning run history service (stored in the workspace database), not by an independent storage setting in the ARM template. The property only identifies the workspace's primary storage account, so it cannot be responsible for routing pipeline history.
- ✓
Defines the primary storage account for the workspace
Why this is correct
This property, required in the ARM template for Microsoft.MachineLearningServices/workspaces, accepts the resource ID of an Azure Storage account that becomes the workspace's default datastore. The workspace then uses that account for storing datasets, model artifacts, and run outputs. It serves as the primary storage backing the workspace's file and artifact persistency, which is why it is called the primary storage account.
- ✗
Specifies the storage account for Apache Spark logs
Why it's wrong here
Apache Spark logs from managed Spark pools are written to a dedicated Spark event log store or the workspace's built-in datastore during job execution, not to a location specified by the storageAccount property. The storageAccount property has no logic to act as a Spark-specific log sink; that would require a separate configuration, such as an external Hive metastore or a custom Spark event log directory. Calling it a Spark log store incorrectly narrows the account's role to telemetry rather than the default datastore.
- ✗
Configures the storage for SQL pool backups
Why it's wrong here
SQL pool backups are a feature of dedicated SQL pools in Azure Synapse Analytics, which use automatic geo-redundant Azure storage managed by the Synapse service, completely independent of the Azure Machine Learning workspace. The storageAccount property in an AML workspace ARM template has no capability to configure backup storage for any SQL pool or database. This option conflates two separate Azure services and their storage responsibilities.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based data integration, warehousing, and analytics service that brings together big data and data warehouse capabilities under one platform.
Key term
Data Lake Storage Gen2
Data Lake Storage Gen2 is a cloud-based storage service that combines a scalable data lake with enterprise-grade file system capabilities for big data analytics.
About these practice questions
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.