Questions about Snowflake asked by my Students on Udemy (Q11-Q15)

These are real-life questions I’ve been asked by students in the Q&A sections of my Udemy courses about Snowflake. I’ll just keep the anonymity of the sender and I’ll only reformat them a bit, to make them more readable. My previous post in this series: Questions about Snowflake asked by my Students on Udemy (Q6-Q10).

[Q11] In the code below, is this a bug, where the SHOW PARAMETERS on testdb2 is showing 2 instead of 3?

USE ROLE ACCOUNTADMIN;
ALTER ACCOUNT SET DATA_RETENTION_TIME_IN_DAYS = 4;
ALTER ACCOUNT SET MIN_DATA_RETENTION_TIME_IN_DAYS = 3;
 
USE ROLE SYSADMIN;
CREATE DATABASE TESTDB1;
show parameters LIKE 'DATA_RETENTION_TIME_IN_DAYS' in database TESTDB1;
-- DATA_RETENTION_TIME_IN_DAYS 4
 
CREATE DATABASE TESTDB2
    DATA_RETENTION_TIME_IN_DAYS = 2;
    -- Database TESTDB2 successfully created. Data retention for Database
    -- TESTDB2 is 3 days because of the min data retention set on the acct.
show parameters LIKE 'DATA_RETENTION_TIME_IN_DAYS' in database TESTDB2;
-- DATA_RETENTION_TIME_IN_DAYS 2
 
USE DATABASE TESTDB1;
CREATE SCHEMA TEST;
show parameters LIKE 'DATA_RETENTION_TIME_IN_DAYS' in SCHEMA TEST;
-- DATA_RETENTION_TIME_IN_DAYS 4
 
USE DATABASE TESTDB2;
CREATE SCHEMA TEST2;
show parameters LIKE…