exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core 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 🗳️

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
37ceea2
3 weeks, 1 day 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago