Refer to the Exhibit Practice Questions

{
  "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"
  }
}

{
  "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')]"
      }
    }
  }
}

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.
{
  "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
  }
}

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

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

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/12345/resourceGroups/rg1/providers/Microsoft.ManagedIdentity/userAssignedIdentities/id1": {}
    }
  },
  "properties": {
    "isHnsEnabled": true,
    "encryption": {
      "keySource": "Microsoft.Storage"
    }
  }
}

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

Refer to the exhibit.

Power BI DAX expression:
```
Total Sales = 
CALCULATE(
    SUM(Sales[Amount]),
    Sales[Channel] = "Online"
)
```

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.

```json
{
  "type": "Microsoft.StreamAnalytics/streamingjobs",
  "apiVersion": "2020-03-01",
  "properties": {
    "sku": {
      "name": "StandardV2"
    },
    "inputs": [
      {
        "name": "input",
        "properties": {
          "type": "Stream",
          "datasource": {
            "type": "Microsoft.EventHub/EventHub",
            "properties": {
              "eventHubName": "telemetry-events",
              "consumerGroupName": "$Default"
            }
          }
        }
      }
    ],
    "outputs": [
      {
        "name": "output",
        "properties": {
          "datasource": {
            "type": "Microsoft.Sql/Server/Database",
            "properties": {
              "server": "sqlserver123.database.windows.net",
              "database": "sqldb",
              "table": "SensorData"
            }
          }
        }
      }
    ],
    "transformation": {
      "name": "TransformTelemetry",
      "properties": {
        "streamingUnits": 6,
        "query": "SELECT SensorId, AVG(Temperature) AS AvgTemp INTO output FROM input GROUP BY SensorId, TumblingWindow(minute, 5)"
      }
    }
  }
}
```

{
  "policyRule": {
    "if": {
      "allOf": [
        {
          "field": "type",
          "equals": "Microsoft.Storage/storageAccounts"
        },
        {
          "field": "Microsoft.Storage/storageAccounts/kind",
          "equals": "StorageV2"
        },
        {
          "field": "Microsoft.Storage/storageAccounts/encryption.keySource",
          "notEquals": "Microsoft.Keyvault"
        }
      ]
    },
    "then": {
      "effect": "deny"
    }
  }
}

Refer to the exhibit.

```json
{
  "name": "CopyFromOnPrem",
  "properties": {
    "activities": [
      {
        "name": "CopyData",
        "type": "Copy",
        "inputs": [
          {
            "referenceName": "OnPremSqlServerDataset",
            "type": "DatasetReference"
          }
        ],
        "outputs": [
          {
            "referenceName": "AzureSqlDatabaseDataset",
            "type": "DatasetReference"
          }
        ],
        "typeProperties": {
          "source": {
            "type": "SqlSource",
            "sqlReaderQuery": "SELECT * FROM Sales.Orders WHERE OrderDate > '2025-01-01'"
          },
          "sink": {
            "type": "SqlSink",
            "writeBatchSize": 10000
          }
        }
      }
    ],
    "integrationRuntime": {
      "referenceName": "SelfHostedIR",
      "type": "IntegrationRuntimeReference"
    }
  }
}
```

Refer to the exhibit.

```json
{
  "properties": {
    "databaseName": "SalesDB",
    "requestedServiceObjectiveName": "S2",
    "edition": "Standard",
    "maxSizeBytes": 268435456000
  }
}
```