Answer: 24 hours

According to Snowflake documentation, temporary tables are automatically dropped at the end of the session in which they are created. The maximum Continuous Data Protection (CDP) charges for a temporary table are incurred for 24 hours because this is the maximum duration a temporary table can exist before being automatically dropped. The community discussion confirms this with multiple users selecting option D and referencing official Snowflake documentation that states 'the maximum total CDP charges incurred for a temporary table are 1 day (or less if the table is explicitly dropped or dropped as a result of terminating the session).' Other options (30 days, 7 days, 48 hours) represent longer time periods that do not apply to temporary tables, making them incorrect.

Author: LeetQuiz Editorial Team