What is the difference between data in motion and data at rest?
Using the provided tables, classify each data object according to whether it currently has an active transfer. Treat objects without an active transfer as data at rest, including objects with completed, failed, or canceled transfers.
object_id, object_name, data_state, size_bytes, and transfer_id.object_id ascending, and use NULL for transfer_id when no active transfer exists.| Column | Type | Description |
|---|---|---|
| object_idPK | INT | Unique identifier for the data object |
| object_name | VARCHAR(100) | Name of the data object |
| data_classification | VARCHAR(30) | Sensitivity classification of the object |
| size_bytes | BIGINT | Object size in bytes |
| storage_region | VARCHAR(50) | Region where the object is stored |
| Column | Type | Description |
|---|---|---|
| transfer_idPK | INT | Unique identifier for a transfer session |
| object_id | INT | Data object involved in the transfer |
| transfer_status | VARCHAR(20) | Current or final transfer status |
| source_system | VARCHAR(50) | System sending the data |
| destination_system | VARCHAR(50) | System receiving the data |