DP-700 Monitor and Optimize an Analytics Solution — All Questions With Answers

{
  "rule_id": "policy-001",
  "effect": "Deny",
  "conditions": {
    "max_parallel_jobs": 5,
    "enforce_compute_limit": true
  }
}

{
  "policy": "Deny",
  "scope": "/subscriptions/sub1/resourceGroups/rg1",
  "effect": "Deny",
  "condition": "DataTransferOut > 100GB"
}

{
  "operation": "Optimize",
  "table": "SalesData",
  "action": "ZORDER",
  "columns": ["RegionID", "DateKey"],
  "status": "Failed",
  "errorCode": "InsufficientMemory"
}

{
  "job_id": "98765",
  "status": "Completed",
  "metrics": {
    "input_rows": 100000000,
    "shuffle_write_size": "500GB",
    "peak_memory": "16GB",
    "duration": "45m"
  }
}

{
  "capacityId": "F-SKU-64-PROD",
  "metrics": [
    { "metricName": "CUPercent", "value": 98.5 },
    { "metricName": "BackgroundOverage", "value": 120.0 },
    { "metricName": "InteractiveOverage", "value": 0.0 }
  ],
  "throttling": "Active"
}

{
  "executorMemory": "16g",
  "executorCores": 4,
  "dynamicAllocation": true,
  "maxExecutors": 20,
  "vorderEnabled": true
}

{
  "query": "SELECT * FROM sales WHERE region = 'North'",
  "status": "429",
  "error": "Too Many Requests",
  "workload": "Power BI",
  "timestamp": "2023-10-27T10:00:00Z"
}

{
  "operation": "REFRESH",
  "startTime": "2023-11-01T08:00:00",
  "endTime": "2023-11-01T08:45:00",
  "duration": "2700s",
  "rowsProcessed": 5000000,
  "status": "SUCCESS"
}

{
  "query": "SELECT * FROM large_table",
  "plan": "Table Scan",
  "duration": "500s",
  "tableSize": "1TB",
  "columns": "*"
}

{
  "queryPlan": {
    "operators": [
      { "type": "RemoteScan", "target": "OneLake", "details": "Table1" },
      { "type": "HashJoin", "condition": "Equal", "output": 100000000 },
      { "type": "BroadcastExchange", "details": "SmallTable" }
    ]
  }
}

{
  "spark.driver.memory": "4g",
  "spark.executor.memory": "4g",
  "spark.executor.cores": "2",
  "spark.dynamicAllocation.enabled": "true",
  "spark.dynamicAllocation.maxExecutors": "10"
}

Error: Capacity limit exceeded. Request rejected. Status: 429