SnowflakeProfessional levelADA-C01Page 3 of 6

ADA-C01 exam dumps: questions 201 to 300 of 565

Page 3 of the free ADA-C01 question bank for the SnowPro® Advanced: Administrator exam. Questions 201 to 300 are listed below, the first 5 in full with answers and explanations. Back to page 1 for the exam overview and FAQ.

Question bank last updated April 2026

Free ADA-C01 practice questions

Questions 201 to 205 of 565

Pick an answer before you open the explanation. Each question also has its own page with a permalink.

ADA-C01 Question 201

Single answer2.3 Given a scenario, manage account identifiers.

A company has separate Snowflake accounts for development, test, and production. The security team is standardizing all automation scripts and private connectivity configurations so they continue to work even if an account is renamed. An administrator must identify which account identifier should be used in URLs and connection definitions when a stable, system-generated identifier is required across the organization. Which identifier should the administrator use?

  1. A

    The account name defined by the organization, because it is unique and intended for long-term use in all endpoints

  2. B

    The locator, because it is the system-assigned account identifier used as the basis for account URLs and remains stable even if the account name changes

  3. C

    The username of the ACCOUNTADMIN role holder, because account URLs are resolved through the primary administrative user

  4. D

    The region name, because Snowflake combines the region with the organization name to create a stable account-specific endpoint

Show answer and explanation

Correct answer: B

Explanation

Snowflake account identifiers can be represented in different ways, including organization-account names and account locators. For operational scenarios where a stable, system-generated identifier is required, such as certain connection definitions or endpoint-related configurations that must continue to work after an account rename, the account locator is the appropriate identifier. By contrast, account names are more human-friendly and can change. Region information is only one component of account location and is not a unique account identifier. This question tests the practical distinction between friendly naming and durable account identity, which is important when managing account identifiers in enterprise automation and connectivity scenarios.

  • A. Incorrect.

    Incorrect. The account name is human-readable and commonly used with the organization name in modern Snowflake identifiers, but it is not the best choice when the requirement is a stable, system-generated identifier that is not affected by account renaming. This option reflects the misconception that friendly account names are immutable infrastructure identifiers.

  • B. Correct.

    Correct. The account locator is a system-assigned identifier for the Snowflake account and is used as the basis for account URLs. It is the right choice when scripts, integrations, or private connectivity configurations need a stable identifier that persists even if the account name is changed. This aligns with Snowflake guidance for scenarios where the administrator must rely on a durable account identifier rather than a display-oriented name.

  • C. Incorrect.

    Incorrect. Usernames and roles are used for authentication and authorization, not for identifying the Snowflake account in URLs or connection endpoints. This distractor targets a common misunderstanding between account-level identifiers and administrative access within the account.

  • D. Incorrect.

    Incorrect. The region helps determine where the account is hosted, but it does not uniquely identify an account by itself. Multiple accounts can exist in the same region, so region information alone cannot serve as the required stable account identifier for endpoints or connection definitions.

ADA-C01 Question 202

Single answerDifferentiate between account names and account locators

A global Snowflake administrator is troubleshooting a connectivity issue after their company renamed a production account from PROD_EAST to FINANCE_PROD for branding consistency. Some legacy automation still references the account using an identifier captured years ago, while newer user documentation tells employees to sign in with the updated account URL. The administrator needs to explain to the operations team why some references still work after the rename and others changed. Which statement best describes the difference between the Snowflake account name and the account locator in this scenario?

  1. A

    The account name is the human-readable identifier that can be changed and is commonly reflected in user-facing sign-in URLs, while the account locator is a system-generated identifier for the account that remains stable even if the account name changes.

  2. B

    The account locator is the friendly name chosen by administrators for login and billing purposes, while the account name is an internal Snowflake-generated value used only in replication.

  3. C

    The account name and account locator are interchangeable identifiers; renaming the account updates both values automatically, so legacy references should not continue to work.

  4. D

    The account locator is assigned per warehouse within an account, while the account name uniquely identifies the whole Snowflake organization across all regions and clouds.

Show answer and explanation

Correct answer: A

Explanation

This question tests the practical distinction between two Snowflake account identifiers that administrators encounter during renames, migrations, and troubleshooting. The account name is the human-readable identifier typically used in user-facing account URLs and administrative references. The account locator is a Snowflake-generated identifier for the account and is designed to remain stable. Because of that stability, locator-based references may continue to work even after an account name changes, while references tied to the account name may need to be updated. Snowflake documentation on account identifiers and account URLs distinguishes these values and explains their roles in connection endpoints and account identification. From an operational best-practice perspective, administrators should know which integrations, URLs, or automation scripts depend on the account name versus the account locator before performing account renames or updating end-user documentation.

  • A. Correct.

    Correct. In Snowflake, the account name is the more human-readable account identifier and is commonly seen in account URLs and user-facing references. By contrast, the account locator is a Snowflake-assigned identifier for the account. A key operational distinction is that the account locator is stable, so older integrations or references that use it can continue to work even if the account name is changed. This is why a rename can affect some connection patterns or URLs while locator-based references remain valid.

  • B. Incorrect.

    Incorrect. This reverses the concepts. The account locator is not a friendly administrator-chosen label; it is a Snowflake-generated identifier. The account name is the administrator-defined, human-readable identifier associated with the account. Also, the locator is not limited to replication-related use.

  • C. Incorrect.

    Incorrect. Although both identify the same account in different contexts, they are not interchangeable in behavior. Renaming the account does not mean the account locator changes as well. This option reflects a common misconception that all account identifiers are mutable together. In practice, the distinction matters specifically because legacy references based on the locator may continue to function after an account rename.

  • D. Incorrect.

    Incorrect. The account locator is assigned to the Snowflake account, not to individual warehouses. Warehouses are compute resources inside an account and have their own names, but they do not determine account identity. The account name also does not uniquely identify an organization across all regions and clouds in the way this option suggests.

ADA-C01 Question 203

Single answerDifferentiate between account names and account locators

A Snowflake administrator is documenting connection details for a newly onboarded operations team. The team must use Snowsight and several Snowflake SQL clients to access the same account. During testing, some users try to sign in with the organization's display-style account name, while others use a value copied from an older worksheet that looks like a short system-generated identifier. To reduce login issues, the administrator wants to explain when each identifier should be used. Which statement correctly differentiates the Snowflake account name from the account locator in this scenario?

  1. A

    The account name is the customer-defined identifier typically used in the account URL, while the account locator is a Snowflake-assigned identifier often used in fully qualified references and system-level identification.

  2. B

    The account locator is the only identifier that can be used to access Snowsight, and the account name is used only for replication and failover configuration.

  3. C

    The account name and account locator are interchangeable in all contexts, including login URLs, organization URLs, and object references.

  4. D

    The account name is generated by Snowflake and cannot be customized, while the account locator is chosen by the customer when the account is created.

Show answer and explanation

Correct answer: A

Explanation

Snowflake distinguishes between an account name and an account locator. The account name is the customer-defined identifier for the account and is commonly used with the organization name in modern account identifiers and URLs, such as those used for Snowsight and client connections. The account locator is a Snowflake-generated identifier that uniquely identifies the account and may appear in legacy-style account URLs or technical references. For administrators, the practical takeaway is to document the account identifier format required by the client or workflow rather than assuming all account-related identifiers are equivalent. Snowflake documentation on account identifiers, account URLs, and organization/account naming conventions supports this distinction and is the best reference when standardizing connection instructions.

  • A. Correct.

    Correct. In Snowflake, the account name is the customer-visible name associated with the account and commonly appears in account URLs, especially in organization-account URL formats. The account locator is a Snowflake-assigned identifier that uniquely identifies the account within a region/cloud context and appears in some legacy URL patterns and cross-account/system-level references. This distinction is important when documenting how users should sign in versus how administrators may identify accounts in technical operations.

  • B. Incorrect.

    Incorrect. This reverses the typical usage. Snowsight and modern connection guidance commonly use account identifiers based on organization name and account name, not only the account locator. Replication and failover configurations are not the sole purpose of the account name. The option reflects a common misconception that the locator is the primary end-user sign-in identifier in all cases.

  • C. Incorrect.

    Incorrect. Although both identifiers relate to the same Snowflake account, they are not interchangeable in every context. Snowflake distinguishes between organization/account-based identifiers used in account URLs and the account locator used in other contexts. Assuming they can be swapped everywhere can lead to failed connections or incorrect documentation.

  • D. Incorrect.

    Incorrect. This option swaps the definitions. The account name is customer-defined, whereas the account locator is system-assigned by Snowflake. Administrators often confuse these because both can appear in connection information, but they serve different roles.

ADA-C01 Question 204

Single answerIdentify when a given account identifier needs to be used

A Snowflake administrator is updating internal runbooks for a company that operates in multiple regions and cloud platforms. During a migration project, several teams ask which account identifier they must provide for different tasks. Which task specifically requires using the account locator (or an organization-qualified account name that resolves to the same account identity), rather than relying only on the friendly account name shown in Snowsight?

  1. A

    Constructing a SQL statement to switch to a different virtual warehouse within the same account

  2. B

    Creating a database replication or failover configuration that targets another Snowflake account

  3. C

    Granting a role to a user in the current account using GRANT ROLE

  4. D

    Tagging a warehouse with cost-center metadata for chargeback reporting

Show answer and explanation

Correct answer: B

Explanation

The key concept is that Snowflake uses different account identifiers for different purposes. Many day-to-day SQL operations are scoped to the current session and account, so they only require object names such as warehouse, role, database, schema, user, or tag names. However, when configuring account-to-account features, the target account must be identified unambiguously. A common real-world example is setting up database replication or failover groups, where Snowflake requires an account identifier that uniquely resolves the target account, such as the account locator or the organization-qualified account name. This is especially important in enterprises with multiple accounts across regions and cloud providers, where a friendly account name alone may be ambiguous or insufficient. This aligns with Snowflake guidance for account identifiers and cross-account administration tasks, including replication/failover configuration and account URL/account identity usage.

  • A. Incorrect.

    Incorrect. Switching warehouses uses the warehouse object name within the current account context, for example USE WAREHOUSE . This does not require any account identifier such as an account locator or organization-qualified account name.

  • B. Correct.

    Correct. Cross-account features such as replication and failover/failover groups require an account-level identifier that uniquely identifies the target account. In practice, Snowflake documentation references using identifiers such as the account locator or organization-qualified account name, because a simple friendly display name is not sufficient to uniquely identify the destination account across regions/clouds.

  • C. Incorrect.

    Incorrect. GRANT ROLE operates on security principals inside the current account and uses role and user names defined in that account. No separate account identifier is needed unless a cross-account integration or account-level feature is being configured, which is not the case here.

  • D. Incorrect.

    Incorrect. Applying tags to a warehouse is an object-level metadata operation inside the current account. The administrator needs the warehouse and tag names, not the account locator.

ADA-C01 Question 205

Single answerIdentify when a given account identifier needs to be used

A Snowflake administrator is documenting how different teams should reference the company's production account after a recent organization rename. The account currently has users connecting through Snowsight, a partner application configured with OAuth redirect URIs, and a separate business unit that needs to create a cross-account share to this account from another Snowflake account in the same organization. Which identifier should the administrator tell each team to use so the integrations continue to work correctly?

  1. A

    Tell all teams to use the account name only, because Snowflake resolves the current organization automatically for all account-level operations.

  2. B

    Tell the Snowsight users and the OAuth-integrated application to use the account locator, and tell the data sharing team to use the account URL.

  3. C

    Tell the Snowsight users and OAuth-integrated application to use the organization-account name in the account URL, and tell the data sharing team to use the locator-based account identifier where Snowflake requires an account identifier.

  4. D

    Tell the Snowsight users to use the region name, the OAuth-integrated application to use the account name, and the data sharing team to use the organization name.

Show answer and explanation

Correct answer: C

Explanation

Snowflake uses different account identifiers depending on the task. For user access and web-based integrations, administrators generally use the account URL, which is typically built from the organization name and account name (for example, in Snowsight and OAuth-related endpoint/redirect configurations). For some cross-account features, such as data sharing or commands that explicitly require an account identifier, Snowflake may require the account locator-based identifier rather than the friendly account name. This is why administrators must distinguish between the organization-account name used in URLs and the account locator used where Snowflake documentation specifically calls for an account identifier. Best practice is to check the identifier format required by the specific feature: account URL for login/browser integrations, and locator/account identifier format for account-to-account references where documented.

  • A. Incorrect.

    Incorrect. The account name by itself is not sufficient for all scenarios. User-facing access typically uses the account URL, which in modern Snowflake deployments is based on the organization name and account name. In addition, some cross-account and programmatic operations require a specific account identifier format rather than just the account name alone.

  • B. Incorrect.

    Incorrect. This reverses the common usage. End users and browser-based tools such as Snowsight typically access the account through its account URL, not the raw locator. OAuth redirect URIs also must match the actual account URL being used. By contrast, certain Snowflake features and SQL commands that reference another account can require the locator-style account identifier.

  • C. Correct.

    Correct. Snowsight access and OAuth redirect URIs depend on the account URL, which is commonly expressed using the organization name and account name. For account-to-account operations such as sharing or other features that explicitly ask for an account identifier, Snowflake may require the locator-based form (sometimes with region/cloud context depending on the account and feature). This distinction is important after an organization rename or when validating which identifier a specific integration expects.

  • D. Incorrect.

    Incorrect. None of these identifiers are appropriate as stated. A region name alone does not identify a Snowflake account for user login, an account name alone is often not enough for OAuth endpoint and URL configuration, and an organization name alone does not identify the target account for data sharing or cross-account operations.

Timed practice exam

Take a ADA-C01 practice test under exam conditions

65 questions in 115 minutes, drawn from this bank, with a score report and a per-question review when you finish.

Start timed exam

ADA-C01 practice questions 201 to 300 of 565

Every question has a page with the answer and explanation. Numbers are stable, so you can bookmark or share them. The bank is split into 6 pages of up to 100 questions.

  1. 201.A company has separate Snowflake accounts for development, test, and production. The security team is...
  2. 202.A global Snowflake administrator is troubleshooting a connectivity issue after their company renamed a...
  3. 203.A Snowflake administrator is documenting connection details for a newly onboarded operations team. The team...
  4. 204.A Snowflake administrator is updating internal runbooks for a company that operates in multiple regions and...
  5. 205.A Snowflake administrator is documenting how different teams should reference the company's production...
  6. 206.A global company is preparing to replicate data from its Snowflake account in AWS US East (N. Virginia) to a...
  7. 207.A global company is designing a replication and failover strategy for a Snowflake account that currently runs...
  8. 208.A Snowflake administrator is asked to reduce storage costs for a large fact table named SALESFACT in a...
  9. 209.A Snowflake administrator needs to retire a reporting table named SALESMONTHLY in the PROD.REPORTING schema....
  10. 210.A retail company runs hourly ELT jobs and ad hoc analyst queries in the same Snowflake virtual warehouse....
  11. 211.A retail company runs a nightly ELT process in Snowflake that starts at 1:00 AM and must finish by 3:00 AM....
  12. 212.A data engineering team uses a Snowflake X-SMALL standard warehouse to run a nightly COPY INTO job that loads...
  13. 213.A data engineering team loads 2 TB of compressed JSON files into a staging table every night using COPY INTO....
  14. 214.A data engineering team uses a Snowflake virtual warehouse named ETLWH to run hundreds of short ELT jobs...
  15. 215.A Snowflake administrator manages a reporting warehouse used by BI dashboards during business hours and by a...
  16. 216.A Snowflake administrator is troubleshooting inconsistent query performance for a reporting team. Users...
  17. 217.A BI team uses a shared warehouse named BIWH for interactive dashboards. During business hours, users...
  18. 218.A Snowflake administrator manages a virtual warehouse used by a BI tool during weekday business hours. The...
  19. 219.A BI team uses a Snowflake virtual warehouse named BIWH to support hundreds of dashboard queries during...
  20. 220.A global company has several business units using the same Snowflake account. The platform team wants to...
  21. 221.A global analytics team stores highly sensitive customer data in Snowflake and wants to let external auditors...
  22. 222.A Snowflake administrator manages a multi-cluster virtual warehouse named ETLWH that supports a critical ELT...
  23. 223.A Snowflake administrator manages a multi-cluster virtual warehouse used by a BI tool during business hours....
  24. 224.A data engineering team uses a multi-cluster virtual warehouse named ETLWH to support hundreds of concurrent...
  25. 225.A data engineering team uses a multi-cluster virtual warehouse named ETLWH to support highly concurrent ELT...
  26. 226.A Snowflake administrator manages a production database named SALESDB that contains a large permanent table...
  27. 227.A data engineering team maintains a database named PRODDB that contains a large transactional table...
  28. 228.A data engineering team loads a large fact table named SALESFACT every hour using a batch process. Over time,...
  29. 229.A data engineering team loads approximately 500 million rows per day into a large FACTSALES table. Most...
  30. 230.A retail company stores 4 years of sales data in a Snowflake table named SALESFACT with more than 8 billion...
  31. 231.A retail company stores 8 TB of order history in a Snowflake table named ORDERSFACT. The table receives...
  32. 232.A retail company loads clickstream data into a fact table that grows by hundreds of millions of rows per day....
  33. 233.A retail company loads clickstream events into a large fact table in Snowflake. Analysts primarily query the...
  34. 234.A data engineering team stores daily JSON files in an S3 bucket and exposes them to analysts through a...
  35. 235.A data engineering team stores hourly JSON files in an Amazon S3 bucket and exposes them through a Snowflake...
  36. 236.A data platform team wants to expose curated sales data to both Snowflake users and external engines that...
  37. 237.A data engineering team wants to create a Snowflake-managed Apache Iceberg™ table for clickstream data so...
  38. 238.A Snowflake administrator supports a data-sharing use case for external partners. The partners must query a...
  39. 239.A data platform team maintains a SALES table in Snowflake that contains sensitive customer attributes and...
  40. 240.A financial services company needs to validate a schema migration against production data before a weekend...
  41. 241.A retail company needs to let its QA team test a risky schema migration against the current production data...
  42. 242.A data engineering team needs to load daily CSV files from an Amazon S3 bucket into Snowflake. The files...
  43. 243.A retail company receives hourly CSV files from an external partner in Amazon S3. The files must be loaded...
  44. 244.A company wants Snowflake users to load files from a single Amazon S3 bucket into external stages without...
  45. 245.A company stores raw data files in an Amazon S3 bucket and wants multiple Snowflake external stages to use a...
  46. 246.A data engineering team stores daily CSV files in an Amazon S3 bucket and uses a Snowflake external stage...
  47. 247.A company stores daily CSV files in an Amazon S3 bucket and loads them into Snowflake. The security team...
  48. 248.A financial services company stores highly sensitive customer data in Snowflake and must reduce the risk of...
  49. 249.A financial services company stores highly sensitive customer data in Snowflake. The security team must...
  50. 250.A data platform team is enabling Snowflake-managed Apache Iceberg tables for a finance domain. The table data...
  51. 251.A data platform team wants Snowflake-managed Apache Iceberg tables to store their table metadata and data...
  52. 252.A global retail company wants to centralize governance for Apache Iceberg tables that are created in...
  53. 253.A Snowflake administrator is setting up an open data governance solution so multiple analytics engines can...
  54. 254.A data engineering team uses Snowflake tasks to run an hourly ELT pipeline. The root task loads raw files,...
  55. 255.A data engineering team uses a serverless task named LOADDAILYSALES to run every 5 minutes and merge files...
  56. 256.A data engineering team wants to run a daily ETL pipeline in Snowflake using tasks. The pipeline has three...
  57. 257.A data engineering team is building a nightly ELT pipeline in Snowflake. They created three tasks: TASKSTAGE...
  58. 258.A data engineering team has a nightly Snowflake task graph that starts with a root task scheduled at 01:00...
  59. 259.A data platform team uses a Snowflake task graph to orchestrate nightly processing. The root task loads raw...
  60. 260.A data engineering team wants to let developers in the role DEVTASKADMIN create and manage scheduled tasks in...
  61. 261.A data engineering team wants to let analysts manage a scheduled data quality task in the ANALYTICS database...
  62. 262.A Snowflake administrator is investigating why a production task stopped loading data overnight. The task is...
  63. 263.A Snowflake administrator is investigating why a production root task did not execute its downstream task...
  64. 264.A Snowflake administrator supports a business unit that loads customer transaction files from an internal...
  65. 265.A global retail company runs a business-critical Snowflake account in AWS us-east-1. The platform team has...
  66. 266.A data engineering team is redesigning nightly and event-driven processing in Snowflake. They currently run a...
  67. 267.A data engineering team is redesigning its scheduled pipelines in Snowflake. One task runs every 5 minutes to...
  68. 268.A Snowflake administrator is troubleshooting a dashboard query that has become slow and expensive. The query...
  69. 269.A Snowflake administrator is investigating why a reporting query against a 4 TB fact table is slow during...
  70. 270.A data engineering team loads customer records into a Snowflake table from multiple concurrent ingestion...
  71. 271.A data engineering team is loading customer orders into a Snowflake table from several parallel ETL streams....
  72. 272.A BI team runs the same dashboard query every few minutes against a large FACTSALES table. The Snowflake...
  73. 273.A BI team runs the same dashboard query every few minutes against a large SALESFACT table and expects...
  74. 274.A Snowflake administrator receives an alert that several ad hoc queries submitted by analysts in the ANALYST...
  75. 275.A Snowflake administrator is responding to an incident in which several ad hoc queries submitted by a small...
  76. 276.A Snowflake administrator is investigating a spike in warehouse usage between 01:00 and 03:00 UTC. The team...
  77. 277.A Snowflake administrator is investigating a spike in warehouse usage that occurred overnight. They suspect...
  78. 278.A Snowflake administrator is helping a finance team use Snowsight to review monthly warehouse spend. The team...
  79. 279.A data platform administrator is helping finance analysts use Snowsight to review monthly cloud spending. The...
  80. 280.A Snowflake administrator needs to give engineering managers a simple way to monitor whether ETL workloads...
  81. 281.A Snowflake administrator is asked to quickly identify why business users are complaining about slow...
  82. 282.A Snowflake administrator needs to let a group of finance analysts view and collaborate on a Snowsight...
  83. 283.A Snowflake administrator needs to let a finance manager review a Snowsight dashboard and one supporting...
  84. 284.A Snowflake administrator built a Snowsight worksheet that queries monthly revenue by region and created a...
  85. 285.A Snowflake administrator creates a chart in Snowsight from a worksheet query that summarizes daily order...
  86. 286.A Snowflake administrator creates a Snowsight chart from a worksheet that queries a secure view in the PRODDB...
  87. 287.A Snowflake administrator created a Snowsight chart from a worksheet that queries a secure view in the...
  88. 288.A Snowflake administrator is told that a Snowsight dashboard used by finance was accidentally deleted earlier...
  89. 289.A Snowflake administrator receives an urgent request from the analytics team: a Snowsight dashboard used by...
  90. 290.A Snowflake administrator is investigating slow dashboard queries from a BI tool. The queries run every few...
  91. 291.A retail company runs hourly ELT pipelines on a MEDIUM virtual warehouse and has recently seen the end-to-end...
  92. 292.A Snowflake administrator is investigating a dashboard workload that became slower after a recent release....
  93. 293.A Snowflake administrator is investigating complaints that a dashboard query has become much slower during...
  94. 294.A Snowflake administrator is investigating a dashboard query that has become slow after a large historical...
  95. 295.A data engineering team reports that a nightly ETL query has become significantly slower over the last two...
  96. 296.A Snowflake administrator is investigating a dashboard query that became much slower after a new release. In...
  97. 297.A Snowflake administrator is investigating why a dashboard query suddenly takes much longer during peak...
  98. 298.A Snowflake administrator is troubleshooting a task-based ELT pipeline that intermittently fails during one...
  99. 299.A Snowflake administrator is troubleshooting a task that orchestrates a stored procedure and several SQL...
  100. 300.A Snowflake administrator is investigating a dashboard query that suddenly became much slower after a schema...