ADA-C01 Question 146
Single answerIdentify which regions are available for a given organizationA global company uses Snowflake Organizations to centrally manage multiple accounts. The lead administrator has been asked to create a new account for a business unit, but it must be created only in a region that is available to the company’s organization. The administrator wants to verify the list of valid regions before attempting account creation from the organization account. Which action should the administrator take?
- A
Run SHOW REGIONS in the organization account and use the returned list as the regions available to that organization
- B
Query ORGANIZATION_USAGE views to find all commercial Snowflake regions and select one from that list
- C
Use SHOW REPLICATION ACCOUNTS in an existing account to determine which regions the organization can create accounts in
- D
Open Snowsight in any account and review the warehouses page to infer the available regions for the organization
Show answer and explanation
Correct answer: A
Explanation
To identify which regions are available for a given Snowflake organization, the administrator should use the organization account and run SHOW REGIONS. This aligns with Snowflake best practice of performing organization-level account management tasks from the organization account rather than from a regular member account. In real-world administration, verifying region availability before creating an account helps avoid failed provisioning attempts and ensures compliance with geographic or residency requirements. Snowflake documentation for organizations and account management distinguishes organization-level commands from account-level monitoring or replication features, making SHOW REGIONS the correct administrative method for this task.
- A. Correct.
Correct. In the organization account, SHOW REGIONS is the appropriate command to list the regions available to the organization for account creation. This is the practical administrative step when validating where new accounts can be provisioned under the organization.
- B. Incorrect.
Incorrect. ORGANIZATION_USAGE views provide organization-level usage and billing metadata, but they are not the mechanism for determining which regions are available for account creation. A common misconception is that usage metadata exposes all provisioning options, but region availability for an organization is checked directly with the relevant SHOW command.
- C. Incorrect.
Incorrect. SHOW REPLICATION ACCOUNTS relates to replication and failover configuration visibility, not the set of regions available for creating new accounts in the organization. Administrators may confuse replication topology with account provisioning scope, but these are different capabilities.
- D. Incorrect.
Incorrect. The warehouses page in Snowsight shows compute resources for the current account and does not identify the regions available to the organization for new account creation. This distractor reflects the mistaken assumption that account-level UI pages expose organization-level provisioning metadata.