SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 1196


Which command will change the name of shared database role r1 to r4?

Show Answer
Correct Answer:

Discussion

1 comment
Sign in to comment
37ceea2Option: D
Jan 31, 2025

https://docs.snowflake.com/en/sql-reference/sql/alter-database. "ALTER DATABASE [ IF EXISTS ] <name> RENAME TO <new_db_name>" "ALTER DATABASE [ IF EXISTS ] <name> SWAP WITH <target_db_name>" The question does not mention anything about the source database and shared (target) database. If shared database is "d1.r1" and there is about changing its name, only, it seems that the answer is D (like in the first syntax from above).