Câu 24: DP-750: Implementing Data Engineering Solutions Using Azure Databricks

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a managed Delta table named Sales. Sales stores transaction data and contains the following columns: transaction_id (string) transaction_date (date) amount (decimal)You need to implement the following data quality requirements by using table-level data quality enforcement: amount must be greater than 0. transaction_id must never be null. Invalid records must be rejected when data is written to the Sales table. What should you do?

1. A. Use a SELECT statement with WHERE conditions to validate the data before querying.
2. B. Create a view that filters out rows where transaction_id is null or amount is less than or equal to 0.
3. C. Add a NOT NULL constraint to transaction_id and a CHECK constraint to amount. — đáp án hiện tại
4. D. Configure row-level security (RLS) where transaction_id is null or amount is less than or equal to 0.