When you resume a database: SQL Data Warehouse acquires compute and memory resources for your DWU setting. Compute charges for your DWUs resume. Your data will be available. You will need to restart your workload queries.