exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 638 discussion

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

What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABASE_REPLICATION?

  • A. ACCOUNTADMIN
  • B. SECURITYADMIN
  • C. SYSADMIN
  • D. ORGADMIN
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
Rajivnb
7 months, 1 week ago
Selected Answer: D
https://docs.snowflake.com/en/user-guide/account-replication-config#label-enabling-accounts-for-replication To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account.
upvoted 2 times
...
singhks
9 months ago
D https://docs.snowflake.com/en/user-guide/account-replication-config Enable Replication for Accounts in the Organization The organization administrator (ORGADMIN role) must enable replication for the source and target accounts. To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account. Log into an ORGADMIN account to enable replication for each source and target account in your organization. USE ROLE ORGADMIN; -- View the list of the accounts in your organization -- Note the organization name and account name for each account for which you are enabling replication SHOW ORGANIZATION ACCOUNTS; -- Enable replication by executing this statement for each source and target account in your organization SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('<organization_name>.<account_name>', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true
upvoted 2 times
...
Zaaju
9 months, 1 week ago
Selected Answer: D
Only organization administrators (i.e. users with the ORGADMIN role) can call this SQL function.
upvoted 1 times
...
MultiCloudIronMan
10 months, 1 week ago
Selected Answer: A
The question says minimum role so its A see https://docs.snowflake.com/en/sql-reference/sql/alter-database
upvoted 2 times
MultiCloudIronMan
10 months, 1 week ago
https://docs.snowflake.com/en/user-guide/database-replication-config
upvoted 2 times
...
...
rokr87
1 year ago
Selected Answer: D
https://docs.snowflake.com/en/sql-reference/functions/system_global_account_set_parameter
upvoted 2 times
...
rokr87
1 year ago
its ORG AdMIN
upvoted 3 times
...
isolated_sniper
1 year ago
The organization administrator (ORGADMIN role) must enable replication for the source and target accounts before replicating a database https://docs.snowflake.com/en/user-guide/database-replication-config#
upvoted 2 times
...
bee5k
1 year ago
Selected Answer: D
To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account.
upvoted 3 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 ...