Question 600
For a university data platform, this issue must not recur: A pipeline architect puts transactional row mutation processing on an ad hoc BI query warehouse with no workload isolation. Which review control fits best?
Explanation
Correct Answer
Benchmark realistic transactional and analytic workloads before warehouse consolidation. This reduces recurrence of: Mixing different execution profiles on one warehouse can create avoidable contention regardless of common storage. The verification should demonstrate: Operational writes and analytic scans maintain their intended service expectations under representative concurrency.
Incorrect Answers
Review solution diagrams for accurate separation of storage, compute and services. That safeguard is aimed at ANOTHER risk: An architecture slide describes Snowflake's services layer as storing every table's raw compressed micro-partitions. It is less targeted than the control for: Mixing different execution profiles on one warehouse can create avoidable contention regardless of common storage.
Document managed-storage responsibilities and supported SQL administration boundaries. That safeguard is aimed at ANOTHER risk: A customer migrates an on-prem database and wants to manage underlying Snowflake storage files directly for normal tables. It is less targeted than the control for: Mixing different execution profiles on one warehouse can create avoidable contention regardless of common storage.
Classify data recoverability before choosing temporary, transient or permanent tables. That safeguard is aimed at ANOTHER risk: A staging team creates transient tables for reproducible data but expects the seven-day Fail-safe recovery of permanent tables. It is less targeted than the control for: Mixing different execution profiles on one warehouse can create avoidable contention regardless of common storage.