DA0-001 Mining and Acquiring Data — All Questions With Answers

Refer to the exhibit.

```
SELECT customer_id, COUNT(order_id) AS order_count
FROM orders
GROUP BY customer_id
HAVING COUNT(order_id) > 5
ORDER BY order_count DESC;
```

Refer to the exhibit.

Error log:

```
2025-03-15 10:23:45 ERROR: ORA-12034: materialized view log on "SCHEMA"."SALES" is newer than last refresh
2025-03-15 10:23:45 INFO: Refresh of materialized view "SALES_MV" failed
```

Refer to the exhibit.

```
{
  "policy": {
    "Statement": [
      {
        "Effect": "Allow",
        "Action": ["s3:GetObject"],
        "Resource": "arn:aws:s3:::data-bucket/*"
      }
    ]
  }
}
```

Refer to the exhibit.

Data Import Log:
[2024-03-15 10:22:34] INFO: Starting import from source 'sales_raw.csv'
[2024-03-15 10:22:35] WARN: Row 1502: 'price' field contains non-numeric value '12.5A'. Skipping row.
[2024-03-15 10:22:36] ERROR: Row 3450: 'date' field value '2024-02-30' is invalid. Import halted.
[2024-03-15 10:22:36] INFO: Import process terminated with errors.

Refer to the exhibit.
```json
{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Action": "s3:GetObject",
      "Resource": "arn:aws:s3:::data-bucket/*",
      "Condition": {
        "IpAddress": {"aws:SourceIp": "10.0.0.0/8"}
      }
    }
  ]
}
```

Refer to the exhibit.
```
INFO: Starting extraction from source 'SalesDB'
INFO: Connected successfully.
WARN: Data type mismatch in column 'Price': expected NUMERIC, found VARCHAR
ERROR: Row 1523: failed to parse date '2024-02-30'
INFO: Extraction completed with 1 warning and 1 error.
```

SELECT customer_id, COUNT(*) as order_count FROM orders GROUP BY customer_id HAVING COUNT(*) > 5;

2023-08-15 14:32:10 ERROR: Data conversion failed for column 'salary' in row 45: value 'N/A' cannot be converted to numeric.

SELECT * FROM sales WHERE date BETWEEN '2023-01-01' AND '2023-12-31';

Refer to the exhibit.
{
  "customers": [
    {"id": 1, "name": "John Doe", "email": "john@example.com"},
    {"id": 2, "name": "Jane Smith", "email": "jane@example.com"}
  ],
  "status": "success"
}

Refer to the exhibit.
SELECT customer_id, COUNT(order_id) AS order_count
FROM orders
WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31'
GROUP BY customer_id
HAVING COUNT(order_id) > 5;

Refer to the exhibit.
ERROR: Data type mismatch for column 'transaction_amount' at row 342. Expected DECIMAL(10,2), received VARCHAR.
The source system sends transaction_amount as a string with a currency symbol (e.g., '$123.45').

SELECT COUNT(*) FROM customers WHERE signup_date > '2023-01-01';
Result: 15000
The analyst notices that the result seems low because they expected more signups from that period.

2023-05-01 14:32:01 INFO: Starting extraction from source 'SalesDB'
2023-05-01 14:32:05 ERROR: Connection timeout after 30s
2023-05-01 14:32:06 WARN: Retry attempt 1
2023-05-01 14:32:36 ERROR: Connection timeout after 30s
2023-05-01 14:32:37 WARN: Retry attempt 2
2023-05-01 14:33:07 ERROR: Connection timeout after 30s
2023-05-01 14:33:08 WARN: Retry attempt 3
2023-05-01 14:33:38 ERROR: Maximum retries exceeded

Error: 2024-03-15 10:32:45 ERROR [DataExtractor] Failed to connect to source database 'SalesDB' on server 10.0.0.50:1433. Error: Login failed for user 'dataminer'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only.