ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 64 - ADA-C01 discussion

Report
Export

What are benefits of using Snowflake organizations? (Select TWO).

A.
Administrators can change Snowflake account editions on-demand based on need.
Answers
A.
Administrators can change Snowflake account editions on-demand based on need.
B.
Administrators can monitor and understand usage across all accounts in the organization.
Answers
B.
Administrators can monitor and understand usage across all accounts in the organization.
C.
Administrators can simplify data movement across all accounts within the organization.
Answers
C.
Administrators can simplify data movement across all accounts within the organization.
D.
User administration is simplified across all accounts within the organization.
Answers
D.
User administration is simplified across all accounts within the organization.
E.
Administrators have the ability to create accounts in any available cloud provider or region.
Answers
E.
Administrators have the ability to create accounts in any available cloud provider or region.
Suggested answer: B, E

Explanation:

According to the Snowflake documentation1, organizations are a feature that allows linking the accounts owned by a business entity, simplifying account management and billing, replication and failover, data sharing, and other account administration tasks. Some of the benefits of using organizations are:

* Administrators can monitor and understand usage across all accounts in the organization using the ORGANIZATION_USAGE schema, which provides historical usage data for all accounts in the organization via views in a shared database named SNOWFLAKE2. This can help to optimize costs and performance across the organization.

* Administrators have the ability to create accounts in any available cloud provider or region using the CREATE ACCOUNT command, which allows specifying the cloud platform and region for the new account3. This can help to meet the business needs and compliance requirements of the organization.

Option A is incorrect because administrators cannot change Snowflake account editions on-demand based on need, but rather have to contact Snowflake Support to request an edition change4. Option C is incorrect because administrators cannot simplify data movement across all accounts within the organization, but rather have to enable account database replication for both the source and target accounts, and use the ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS command to promote a local database to serve as the primary database and enable replication to the target accounts5. Option D is incorrect because user administration is not simplified across all accounts within the organization, but rather requires creating and managing users, roles, and privileges for each account separately, unless using a federated authentication method such as SSO or SCIM.

asked 23/09/2024
Kingsley Tibs
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first