DP-700 Implement and Manage an Analytics Solution — All Questions With Answers

{
  "sparkProperties": {
    "spark.executor.instances": "4",
    "spark.dynamicAllocation.enabled": "false",
    "spark.driver.memory": "4g",
    "spark.executor.memory": "8g"
  },
  "pool": {
    "name": "Custom_Pool",
    "type": "Workspace"
  }
}

{
  "Policy": {
    "Effect": "Deny",
    "Action": "Fabric:Write",
    "Resource": "/workspaces/*/items/lakehouse/*",
    "Condition": {
      "StringEquals": {
        "Fabric:UserType": "Guest"
      }
    }
  }
}

{
  "name": "DailyIngestionJob",
  "type": "SparkJobDefinition",
  "properties": {
    "executableFile": "main.py",
    "defaultLakehouse": {
      "name": "RawDataLH",
      "id": "a1b2c3d4-e5f6-7890-abcd-ef1234567890"
    },
    "retryPolicy": {
      "event": "FAILED",
      "maxRetryCount": 3
    },
    "compute": {
      "runtimeVersion": "1.2",
      "driverSize": "Small",
      "executorSize": "Small",
      "numExecutors": 2
    }
  }
}

GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items
{
  "value": [
    {
      "id": "f12345",
      "type": "Lakehouse",
      "displayName": "Sales_Data",
      "properties": {
        "hasManagedPrivateEndpoint": true
      }
    }
  ]
}

{
  "status": "Throttled",
  "rejectedRequests": 450,
  "smoothingWindow": "24 hours",
  "currentUtilization": 1.15,
  "operationType": "Background"
}

{"error": "403 Forbidden", "message": "User does not have required permissions to access workspace", "policy": "WorkspaceAccessControl"}

CREATE TABLE SalesData (ID int, Amount decimal, TransDate date) USING DELTA; INSERT INTO SalesData VALUES (1, 100.0, '2023-01-01');

%%configure -f
{
  "conf": {
    "spark.sql.parquet.vorder.enabled": "true",
    "spark.microsoft.delta.optimizeWrite.enabled": "true"
  }
}

{
  "capacityName": "fabric_cap_01",
  "metrics": [
    { "time": "2023-10-01T12:00:00Z", "baseCU": 64, "percentUtilization": 125, "throttlingStatus": "Throttled" },
    { "time": "2023-10-01T12:05:00Z", "baseCU": 64, "percentUtilization": 110, "throttlingStatus": "Throttled" }
  ]
}