ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 1223 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 1223
Topic #: 1
[All SnowPro Core Questions]

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

  • A. ALTER ROLE d1.r1 RENAME TO d1.r4;
  • B. ALTER ROLE d1.r1 RENAME TO d2.r4;
  • C. ALTER DATABASE ROLE d1.r1 RENAME TO d2.r4;
  • D. ALTER DATABASE ROLE d1.r1 RENAME TO d1.r4;
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by MultiCloudIronMan at Jan. 9, 2025, 10:55 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
37ceea2
2 months, 2 weeks ago
Selected Answer: D
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).
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago