DA0-002 Data Governance — All Questions With Answers

Refer to the exhibit.

```
[2024-03-15 14:23:45] ERROR: Connection pool exhausted. Retry attempt 1...
[2024-03-15 14:23:46] ERROR: Connection pool exhausted. Retry attempt 2...
[2024-03-15 14:23:47] ERROR: Connection pool exhausted. Retry attempt 3...
[2024-03-15 14:23:48] ERROR: Connection pool exhausted. Max retries exceeded.
```

Job: sales_aggregation
Input records: 1,000,000
Output records: 500,000
Log: Aggregation on 'region' and 'date' - Sum(sales). Records with null region excluded: 50.

Refer to the exhibit.

```
{
  "policy": {
    "effect": "Deny",
    "action": ["s3:GetObject"],
    "resource": "arn:aws:s3:::data-bucket/*",
    "condition": {
      "IpAddress": {
        "aws:SourceIp": "192.0.2.0/24"
      }
    }
  }
}
```

SELECT COUNT(*) FROM orders WHERE order_date >= '2023-06-01' AND order_date < '2023-07-01';
Result: 12,345

{
  "policy": {
    "Statement": [
      {
        "Effect": "Allow",
        "Action": "SELECT",
        "Resource": "prod_db.customers",
        "Condition": {
          "DateLessThan": {
            "aws:CurrentTime": "2023-10-01T00:00:00Z"
          }
        }
      }
    ]
  }
}

2023-03-15 14:32:10 ERROR: Failed to load data from source: Timeout expired.
2023-03-15 14:32:10 WARN: Retry attempt 1/3...
2023-03-15 14:32:15 ERROR: Retry 1 failed: Connection reset.
2023-03-15 14:32:15 WARN: Retry attempt 2/3...
2023-03-15 14:32:20 ERROR: Retry 2 failed: Server not responding.
2023-03-15 14:32:20 WARN: Retry attempt 3/3...
2023-03-15 14:32:25 ERROR: All retries exhausted. Pipeline failed.

{
  "policy": {
    "access": "restricted",
    "roles": ["analyst", "manager"],
    "conditions": {
      "time": "business_hours",
      "location": "internal_network"
    }
  }
}

2025-03-15 14:32:01 ERROR [TransformJob] Failed to transform row 4521: Missing value for field 'Region'
2025-03-15 14:32:02 WARN [TransformJob] Defaulting missing 'Region' to 'Unknown'

Refer to the exhibit.
ERROR: Duplicate entry '12345' for key 'PRIMARY'
Query: INSERT INTO customers (customer_id, name, email) VALUES (12345, 'John Doe', 'jdoe@example.com');

Refer to the exhibit.
{
  "policy": {
    "data_retention": {
      "customer_transactions": "5 years",
      "employee_records": "7 years",
      "marketing_leads": "2 years"
    },
    "data_sharing": {
      "third_party_vendors": "anonymized only",
      "internal_departments": "as needed"
    },
    "data_quality": {
      "missing_values": "flag and report",
      "outliers": "review quarterly"
    }
  }
}

Error Log:
2024-07-15 08:23:45, ERROR - Query execution failed: ORA-00933: SQL command not properly ended
2024-07-15 08:23:45, ERROR - Stack trace: at com.example.DataService.getData(DataService.java:42)
2024-07-15 08:23:45, WARN - Retry attempt 1 of 3
2024-07-15 08:23:47, ERROR - Retry failed: ORA-00933: SQL command not properly ended
2024-07-15 08:23:47, ERROR - Data refresh job for dashboard 'DailySummary' failed.

{
  "dashboardName": "ExecutiveOverview",
  "refreshSchedule": "daily 06:00",
  "dataSources": ["SalesDB", "CustomerDB"],
  "visualizations": [
    {"type": "bar", "title": "Revenue by Region", "field": "revenue_region"},
    {"type": "line", "title": "Monthly Trend", "field": "monthly_revenue"},
    {"type": "table", "title": "Top Customers", "field": "customer_data"}
  ],
  "alerts": [
    {"metric": "revenue", "condition": "< 1000000", "severity": "high"}
  ]
}

Data Quality Check Report
Table: customer_info
Check: Non-null validation on email field
Result: Failed - 1200 records have null email

Refer to the exhibit.

```
2024-11-20 10:23:45 [ACCESS_DENIED] user: analyst_john, query: SELECT email FROM customers WHERE id=123, reason: insufficient permissions on column 'email'
```