DP-900 Describe core data concepts — All Questions With Answers

{
  "type": "Microsoft.Sql/servers/databases",
  "apiVersion": "2023-08-01-preview",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "maxSizeBytes": 268435456000,
    "requestedBackupStorageRedundancy": "Geo",
    "edition": "GeneralPurpose",
    "requestedServiceObjectiveName": "GP_Gen5_4"
  }
}

{
  "consumerGroup": "$Default",
  "partitionId": "0",
  "sequenceNumber": 12345,
  "offset": "123456789",
  "enqueuedTimeUtc": "2025-03-25T10:30:00.000Z",
  "properties": {
    "systemProperties": {
      "iothub-connection-device-id": "device-01",
      "iothub-connection-auth-method": "{\"scope\":\"device\",\"type\":\"sas\",\"issuer\":\"iothub\"}",
      "iothub-enqueuedtime": "2025-03-25T10:30:00.000Z"
    }
  },
  "body": {"temperature": 25.5, "humidity": 60}
}

{
  "name": "sales",
  "location": "eastus",
  "properties": {
    "isVersioningEnabled": true,
    "publicNetworkAccess": "Enabled",
    "storageAccount": "/subscriptions/.../storageAccounts/salesdatalake",
    "containerSoftDeleteDurationInDays": 7
  },
  "resourceType": "Microsoft.Storage/storageAccounts/blobServices/containers"
}

Refer to the exhibit.
```json
{
  "type": "Microsoft.Storage/storageAccounts/blobServices/containers",
  "apiVersion": "2021-02-01",
  "name": "[concat(variables('storageName'), '/default/data')]",
  "dependsOn": [
    "[resourceId('Microsoft.Storage/storageAccounts', variables('storageName'))]"
  ],
  "properties": {
    "publicAccess": "None"
  }
}
```

Refer to the exhibit.
```sql
SELECT ProductID, SUM(Quantity) AS TotalQuantity
FROM Sales
WHERE OrderDate >= '2023-01-01'
GROUP BY ProductID
HAVING SUM(Quantity) > 100
ORDER BY TotalQuantity DESC;
```

Refer to the exhibit.
```kusto
StormEvents
| where State == "TEXAS"
| summarize TotalDamage = sum(DamageProperty) by EventType
| top 5 by TotalDamage desc
```

{
  "properties": {
    "displayName": "Enforce encryption on Data Lake Storage",
    "policyType": "BuiltIn",
    "mode": "Indexed",
    "description": "This policy ensures encryption is enabled on Azure Data Lake Storage accounts.",
    "parameters": {
      "effect": {
        "type": "String",
        "defaultValue": "AuditIfNotExists",
        "allowedValues": ["AuditIfNotExists", "Deny", "Disabled"]
      }
    },
    "policyRule": {
      "if": {
        "field": "type",
        "equals": "Microsoft.Storage/storageAccounts"
      },
      "then": {
        "effect": "[parameters('effect')]"
      }
    }
  }
}

Storage account: mysalesdata
Container: transactions
Blob: orders.csv
Metadata:
  Content-Type: text/csv
  DateCreated: 2025-01-15

{
  "datasources": [
    {
      "name": "SalesDB",
      "connectionString": "Server=tcp:myserver.database.windows.net;Database=Sales;...",
      "type": "AzureSQL"
    },
    {
      "name": "SalesLake",
      "connectionString": "https://mystorage.blob.core.windows.net/sales",
      "type": "AzureBlobStorage"
    }
  ],
  "datasets": [
    {
      "name": "SalesOrders",
      "source": "SalesDB",
      "table": "Orders"
    },
    {
      "name": "SalesFiles",
      "source": "SalesLake",
      "folder": "csv"
    }
  ]
}

Refer to the exhibit.
{
  "type": "Microsoft.Storage/storageAccounts",
  "apiVersion": "2023-01-01",
  "name": "[parameters('storageAccountName')]",
  "location": "[parameters('location')]",
  "sku": {
    "name": "Standard_LRS"
  },
  "kind": "StorageV2",
  "properties": {
    "minimumTlsVersion": "1.2",
    "supportsHttpsTrafficOnly": true
  }
}

Refer to the exhibit.
-- Kusto Query
StormEvents
| where State == "FLORIDA"
| summarize TotalDamage = sum(DamageProperty) by EventType
| top 5 by TotalDamage desc

Refer to the exhibit.
{
  "name": "SalesFact",
  "columns": [
    {"name": "OrderDate", "dataType": "datetime"},
    {"name": "SalesAmount", "dataType": "decimal"},
    {"name": "ProductKey", "dataType": "int"},
    {"name": "CustomerKey", "dataType": "int"}
  ]
}

Refer to the exhibit.
```json
{
  "variables": {
    "storageAccountName": "[format('st{0}', uniqueString(resourceGroup().id))]"
  },
  "resources": [
    {
      "type": "Microsoft.Storage/storageAccounts",
      "apiVersion": "2023-01-01",
      "name": "[variables('storageAccountName')]",
      "location": "[resourceGroup().location]",
      "kind": "StorageV2",
      "sku": {
        "name": "Standard_LRS"
      },
      "properties": {
        "accessTier": "Hot",
        "supportsHttpsTrafficOnly": true
      }
    }
  ]
}
```

Refer to the exhibit.
```sql
SELECT ProductID, SUM(SalesAmount) AS TotalSales
FROM Sales
WHERE OrderDate >= '2024-01-01'
GROUP BY ProductID
HAVING SUM(SalesAmount) > 10000
ORDER BY TotalSales DESC;
```

Refer to the exhibit.
```kusto
StormEvents
| where StartTime > datetime(2024-01-01)
| summarize TotalDamage = sum(DamageProperty) by State
| top 5 by TotalDamage desc
```

Refer to the exhibit.

```json
{
  "properties": {
    "folder": "transform",
    "type": "MappingDataFlow",
    "typeProperties": {
      "sources": [
        {
          "name": "source1",
          "dataset": {
            "referenceName": "SalesCSV",
            "type": "DatasetReference"
          },
          "sourceSettings": {
            "format": "DelimitedText",
            "delimiter": ","
          }
        }
      ],
      "sinks": [
        {
          "name": "sink1",
          "dataset": {
            "referenceName": "SalesParquet",
            "type": "DatasetReference"
          },
          "sinkSettings": {
            "format": "Parquet"
          }
        }
      ],
      "transformations": [
        {
          "name": "RemoveDuplicates",
          "type": "Aggregate",
          "inputs": ["source1"],
          "aggregates": [
            {"column": "OrderID", "operation": "count", "output": "Count"}
          ]
        }
      ]
    }
  }
}
```

Refer to the exhibit.

```kql
StormEvents
| where EventType == "Flood"
| summarize TotalDamage = sum(DamageProperty) by State
| top 5 by TotalDamage desc
```

Refer to the exhibit.

```json
{
  "type": "Microsoft.Sql/servers/databases",
  "apiVersion": "2021-02-01-preview",
  "name": "[concat(parameters('serverName'), '/', parameters('databaseName'))]",
  "location": "[parameters('location')]",
  "kind": "v12.0,user",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "maxSizeBytes": 5368709120,
    "sku": {
      "name": "S0",
      "tier": "Standard"
    },
    "zoneRedundant": false
  }
}

{
  "role": "MyRole",
  "permissions": ["Read", "List"],
  "dataActions": ["Microsoft.Storage/storageAccounts/blobServices/containers/blobs/read"]
}

{
  "query": "StormEvents | where State == 'TEXAS' | summarize Count = count() by EventType | order by Count desc | take 5"
}

{
  "properties": {
    "description": "This policy ensures that only approved SKUs are used.",
    "policyRule": {
      "if": {
        "allOf": [
          {
            "field": "type",
            "equals": "Microsoft.Compute/virtualMachines"
          },
          {
            "field": "Microsoft.Compute/virtualMachines/sku.name",
            "notIn": ["Standard_D2s_v3", "Standard_D4s_v3"]
          }
        ]
      },
      "then": {
        "effect": "deny"
      }
    }
  }
}