DA0-001 Comparing and Contrasting Data Concepts — All Questions With Answers

Refer to the exhibit.

Error log from a data pipeline:

[2025-03-15 10:32:14] ERROR: Duplicate key value violates unique constraint 'order_pkey'
[2025-03-15 10:32:14] Detail: Key (order_id)=(12345) already exists.
[2025-03-15 10:32:15] WARNING: Batch load incomplete. 4999 of 5000 rows inserted.

{"Version":"2012-10-17","Statement":[{"Effect":"Allow","Principal":{"AWS":"arn:aws:iam::123456789012:role/DataAnalyst"},"Action":"s3:GetObject","Resource":"arn:aws:s3:::company-data/prod/*"},{"Effect":"Deny","Principal":"*","Action":"s3:GetObject","Resource":"arn:aws:s3:::company-data/prod/sensitive/*"}]}

CREATE TABLE Orders (
  OrderID INT PRIMARY KEY,
  CustomerID INT,
  OrderDate DATE,
  TotalAmount DECIMAL(10,2),
  INDEX idx_cust (CustomerID),
  INDEX idx_date (OrderDate)
);

2023-08-15 14:23:45, ERROR: Invalid JSON: {"user": "John", "age": 30 "country": "USA"}

{
  "report": "Analytics",
  "filters": [
    {"field": "transaction_date", "operator": ">=", "value": "2023-01-01"},
    {"field": "region", "operator": "=", "value": "West"}
  ],
  "metrics": ["revenue", "units_sold"]
}

Column: Age
Null Count: 50
Unique Values: 23
Min: 0
Max: 150
Mean: 45.2
Median: 42

ID, Name, Salary, Department
1, Alice, 60000, Sales
2, Bob, 70000, IT
3, Charlie, , IT

{
  "policy": {
    "effect": "Allow",
    "action": ["s3:GetObject"],
    "resource": "arn:aws:s3:::data-bucket/*",
    "condition": {
      "StringEquals": {"s3:prefix": "incoming/"}
    }
  }
}

{
  "schema": {
    "type": "struct",
    "fields": [
      { "name": "id", "type": "int", "nullable": false },
      { "name": "name", "type": "string", "nullable": true },
      { "name": "email", "type": "string", "nullable": true }
    ]
  }
}

Refer to the exhibit.
Exhibit:
ID,Name,Age,Salary
1,John,32,50000
2,Jane,28,60000
3,Bob,45,55000

Refer to the exhibit.
Exhibit:
{
  "type": "object",
  "properties": {
    "customerId": { "type": "integer" },
    "name": { "type": "string" },
    "orders": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "orderId": { "type": "integer" },
          "total": { "type": "number" }
        }
      }
    }
  }
}

Refer to the exhibit.
Exhibit:
Table: Customer_Master
Column: Email_Address
Completeness: 92%
Validity: 85%
Uniqueness: 97%
Consistency: 100%

Refer to the exhibit.

{
  "fields": [
    {"name": "customer_id", "type": "integer"},
    {"name": "age", "type": "integer"},
    {"name": "income", "type": "float"},
    {"name": "education", "type": "string"}
  ]
}

{
  "employee": {
    "emp_id": { "type": "integer", "nullable": false, "primary_key": true },
    "name": { "type": "string", "nullable": false },
    "email": { "type": "string", "nullable": true, "unique": true },
    "department": { "type": "string", "nullable": true }
  }
}