Question 55

You are designing the schema for a `silver.finance.transactions` managed table in Unity Catalog. The business has these requirements for three columns: - `amount` — monetary value that must store an **exact** base-10 value with no floating-point rounding error, up to 18 total digits with 2 decimal places. - `event_ts` — the instant an event occurred, which **must be normalized and stored in UTC** and re-rendered in the reader's session local time zone. - `customer_id` — a whole-number surrogate key that can exceed 2,147,483,647 (the 4-byte integer maximum). You must pick the data types that satisfy each requirement with the smallest correct type. Which `CREATE TABLE` column definitions are correct? ```sql CREATE TABLE silver.finance.transactions ( amount <TYPE_1>, event_ts <TYPE_2>, customer_id <TYPE_3> ); ```

• A`amount DOUBLE`, `event_ts TIMESTAMP_NTZ`, `customer_id INT`
• B`amount DECIMAL(18,2)`, `event_ts TIMESTAMP`, `customer_id BIGINT`
• C`amount FLOAT`, `event_ts DATE`, `customer_id BIGINT`
• D`amount DECIMAL(18,2)`, `event_ts TIMESTAMP_NTZ`, `customer_id INT`
• E`amount DECIMAL(2,18)`, `event_ts TIMESTAMP`, `customer_id BIGINT`