Courseiva
Describe an analytics workload on AzurehardMultiple ChoiceObjective-mapped

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.

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 →

How Courseiva writes practice questions · Editorial policy

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.