ADA-C01 Question 145
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 open a new Snowflake account in a region that meets local data residency requirements, but first needs to determine which regions are available to the organization's Snowflake contract. Which action should the administrator take to accurately identify the regions available for that organization before creating the account?
- A
Run SHOW REGIONS from any existing account in the organization to list the regions the organization is entitled to use.
- B
In Snowsight, switch to the organization view and review the available region and cloud platform choices during the Create Account workflow.
- C
Query ACCOUNT_USAGE views in an existing account to see all Snowflake regions available for future accounts in the organization.
- D
Use SHOW ORGANIZATIONS in SQL to return the list of regions where the organization can create additional accounts.
Show answer and explanation
Correct answer: B
Explanation
To identify which regions are available for a given Snowflake organization, the administrator should use the organization-level experience in Snowsight and review the region choices offered when creating a new account. Those presented values reflect the organization's actual enabled cloud platforms and regions. This is more reliable than account-level SQL commands such as SHOW REGIONS or ACCOUNT_USAGE queries, which may expose general metadata but do not confirm organization-specific provisioning eligibility. In practice, account creation and region availability are governed at the organization level, so administrators should validate region options there or work with Snowflake if a required region is not shown. This aligns with Snowflake guidance around Organizations and account management in Snowsight.
- A. Incorrect.
Incorrect. SHOW REGIONS returns Snowflake region metadata visible from the current account context, but it does not definitively identify which regions are available for that specific organization to create new accounts under its contract. A common misconception is to assume visibility of a region means the organization is entitled to provision accounts there.
- B. Correct.
Correct. The organization administrator should use Snowsight's organization-level account creation workflow, where Snowflake presents the valid cloud platform and region options available for that organization. This reflects the organization's actual entitlement and is the practical way to confirm where new accounts can be created.
- C. Incorrect.
Incorrect. ACCOUNT_USAGE views report usage and metadata for the current account and do not provide a supported list of all regions contractually available to the organization for future account creation. This option reflects a common mistake of using account-level telemetry for organization-level provisioning decisions.
- D. Incorrect.
Incorrect. SHOW ORGANIZATIONS provides information about organizations, not a list of regions in which that organization may create new accounts. It does not serve as a region entitlement discovery command.