New (2026) Download free ADA-C02 PDF for Snowflake Practice Tests
100% Free ADA-C02 Files For passing the exam Quickly
NEW QUESTION # 25
Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?
- A. alter user user1 set TEMPORARY_MFA_BYPASS=1440;
- B. alter user user1 set DISABLE_MFA=1440;
- C. alter user user1 set HOURS_TO_BYPASS_MFA=24;
- D. alter user user1 set MINS_TO_BYPASS_MFA=1440;
Answer: D
Explanation:
The parameter MINS_TO_BYPASS_MFA controls how long MFA is bypassed for a user. Setting it to 1440 minutes (24 hours) temporarily disables MFA for that duration without revoking the user's MFA enrollment.
NEW QUESTION # 26
A user with the proper role issues the following commands when setting up and activating network policies:
CREATE OR REPLACE NETWORK POLICY foo_policy
ALLOWED_IP_LIST = ('1.1.1.0/24', '2.2.2.0/24', '3.3.3.0/24')
BLOCKED_IP_LIST = ('1.1.1.1')
COMMENT = 'Account level policy';
ALTER ACCOUNT SET NETWORK_POLICY=foo_policy;
CREATE OR REPLACE NETWORK POLICY bar_policy
ALLOWED_IP_LIST = ('3.3.3.0/24')
BLOCKED_IP_LIST = ('3.3.3.10')
COMMENT = 'user level policy';
ALTER USER user1 SET NETWORK_POLICY=BAR_POLICY;
Afterwards, user1 attempts to log in to Snowflake from IP address 3.3.3.10.
Will the login be successful?
- A. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
- B. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
- C. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
- D. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
Answer: A
Explanation:
Although 3.3.3.10 is in the ALLOWED_IP_LIST, it is also explicitly listed in the BLOCKED_IP_LIST of the user-level policy (bar_policy). Blocked IPs always take precedence over allowed IPs in Snowflake network policies, so the login attempt will fail.
NEW QUESTION # 27
A Snowflake Administrator needs to persist all virtual warehouse configurations for auditing and backups. Given a table already exists with the following schema:
Table Name: VWH_META
Column 1: SNAPSHOT_TIME TIMESTAMP_NTZ
Column 2: CONFIG VARIANT
Which commands should be executed to persist the warehouse data at the time of execution in JSON format in the table VWH_META?
- A. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID())); - B. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
OBJECT_CONSTRUCT(*)
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID())); - C. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1))); - D. SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(SELECT LAST_QUERY_ID(-1)));
Answer: B
Explanation:
To persist warehouse configurations in JSON format, the result set from SHOW WAREHOUSES must be captured and converted into a variant object. Using OBJECT_CONSTRUCT(*) with RESULT_SCAN(LAST_QUERY_ID()) stores the full warehouse configuration snapshot as JSON in the CONFIG VARIANT column, along with the timestamp.
NEW QUESTION # 28
A company has many users in the role ANALYST who routinely query Snowflake through a reporting tool. The Administrator has noticed that the ANALYST users keep two small clusters busy all of the time, and occasionally they need three or four clusters of that size.
Based on this scenario, how should the Administrator set up a virtual warehouse to MOST efficiently support this group of users?
- A. Create a multi-cluster warehouse with MIN_CLUSTERS set to 1. Give MANAGE privileges to the ANALYST role so this group can start and stop the warehouse, and increase the number of clusters as needed.
- B. Create four virtual warehouses (sized Small through XL) and set them to auto-suspend and auto-resume. Have users in the ANALYST role select the appropriate warehouse based on how many queries are being run.
- C. Create a standard X-Large warehouse, which is equivalent to four small clusters. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role.
- D. Create a multi-cluster warehouse with MIN_CLUSTERS set to 2. Set the warehouse to auto-resume and auto-suspend, and give USAGE privileges to the ANALYST role. Allow the warehouse to auto-scale.
Answer: D
Explanation:
A multi-cluster warehouse with MIN_CLUSTERS = 2 matches typical usage, while auto-suspend and auto-resume ensure resources are only used when needed. Allowing auto-scaling handles peak periods efficiently, and giving USAGE (not MANAGE) to ANALYST users is secure and appropriate.
NEW QUESTION # 29
An Administrator needs to create a sample of the table LINEITEM. The sample should not be repeatable and the sampling function should take the data by blocks of rows.
What select command will generate a sample of 20% of the table?
- A. select * from LINEITEM sample system (20);
- B. select * from LINEITEM tablesample system (20) seed (1);
- C. select * from LINEITEM sample bernoulli (20);
- D. select * from LINEITEM tablesample block (20 rows);
Answer: A
Explanation:
SYSTEM sampling performs block sampling, meaning Snowflake selects entire blocks of rows rather than evaluating each row individually. This satisfies the requirement that the sampling function take data by blocks of rows. Using SYSTEM (20) returns approximately 20% of the table and, since no seed value is specified, the result is not repeatable.
NEW QUESTION # 30
What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?
- A. SIMULATED DATA SHARING CONSUMER
- B. PRODUCER TEST ACCT
- C. TEST ACCOUNT ID
- D. MIMIC CONSUMER ACCOUNT
Answer: D
Explanation:
The session parameter MIMIC_CONSUMER_ACCOUNT allows a data provider to test how secure views will appear to a specific consumer account. This ensures the integrity and correctness of secure views before they are shared.
NEW QUESTION # 31
An Administrator needs to configure a virtual warehouse in Snowflake for a new use case with these details:
1. There will be 50-100 concurrent users running reports
2. Minimize costs based on the number of active users at a given time
3. The virtual warehouse should suspend and resume automatically based on user activity
Which configuration will meet these requirements?
- A. create or replace warehouse reporting_wh
warehouse_size = medium
auto_suspend = 600
auto_resume = true; - B. create or replace warehouse reporting_wh
warehouse_size = xxxlarge
auto_suspend = 60
auto_resume = true; - C. create or replace warehouse reporting_wh
warehouse_size = xxxlarge
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = false; - D. create or replace warehouse reporting_wh
warehouse_size = medium
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = true;
Answer: D
Explanation:
Supporting 50-100 concurrent users requires a multi-cluster warehouse so compute resources can scale to handle high concurrency. Setting a maximum cluster count allows Snowflake to automatically add clusters when query demand increases and reduce them when demand drops, which helps minimize cost based on active users. Enabling auto_suspend and auto_resume ensures the warehouse automatically stops when idle and restarts when queries arrive, further optimizing cost and operational efficiency.
NEW QUESTION # 32
MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is '8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Choose three.)
- A. SELECT * FROM my_table AT(OFFSET => -60*30);
- B. SELECT * FROM my_table BEFORE(STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
- C. SELECT * FROM TIME_TRAVEL('MY_TABLE', 2021-01-01 07:00:00);
- D. SELECT * FROM my_table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';
- E. SELECT * FROM my_table AT(TIMESTAMP => '2021-01-01 07:00:00'::timestamp);
- F. SELECT * FROM my_table WITH TIME TRAVEL(OFFSET => -60*30);
Answer: A,B,E
Explanation:
Use Time Travel to view past table versions: (B) selects the table "as of" 07:00 via AT(TIMESTAMP => ...); (E) selects "as of" 30 minutes earlier via AT(OFFSET => -60*30); (F) selects the state before the specified statement via BEFORE(STATEMENT => '<query_id>').
NEW QUESTION # 33
Which Snowflake objects can be managed using SCIM integration? (Choose two.)
- A. Shares
- B. Stages
- C. Roles
- D. Warehouses
- E. Users
Answer: C,E
Explanation:
SCIM integration in Snowflake is used to manage users and roles for automated provisioning and de-provisioning from external identity providers.
NEW QUESTION # 34
For Snowflake network policies, what will occur when the account level and user level network policies are both defined?
- A. The user_level policy will override the account_level policy.
- B. The user_level network policies will not be supported.
- C. A network policy error will be generated with no definitions provided.
- D. The account_level policy will override the user_level policy.
Answer: A
Explanation:
When both account-level and user-level network policies are defined in Snowflake, the user-level policy overrides the account-level policy for that specific user.
NEW QUESTION # 35
Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)
- A. GRANT ROLE ORGADMIN TO USER <username>;
- B. SHOW USERS;
- C. SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('ACCOUNT_LOCATOR','ENABLE_ACCOUNT_DATABASE_REPLICATION','true');
- D. SHOW REGIONS;
- E. SHOW ORGANIZATION ACCOUNTS;
Answer: D,E
Explanation:
Only the ORGADMIN role can run SHOW REGIONS and SHOW ORGANIZATION ACCOUNTS, which provide organization-wide information. These commands are not available to the ACCOUNTADMIN role.
NEW QUESTION # 36
What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?
- A. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false; - B. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = false; - C. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = true;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = true;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true; - D. ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_CREATION = false;
ALTER ACCOUNT my_account SET
REQUIRE_STORAGE_INTEGRATION_FOR_STAGE_OPERATION = false;
ALTER ACCOUNT my_account SET
PREVENT_UNLOAD_TO_INLINE_URL = true;
Answer: C
Explanation:
To prevent data exfiltration, Snowflake requires storage integrations for both stage creation and stage operations, ensuring that unmanaged external locations cannot be used. Additionally, setting PREVENT_UNLOAD_TO_INLINE_URL = true blocks unloading directly to unsecured inline URLs. This configuration enforces secure stage usage tied to storage integrations.
NEW QUESTION # 37
What SCIM integration types are supported in Snowflake? (Choose three.)
- A. Custom
- B. Google Cloud Platform (GCP)
- C. Okta
- D. Azure Active Directory (Azure AD)
- E. Amazon Web Services (AWS)
- F. Duo Security Provisioning Connector
Answer: A,C,D
Explanation:
Snowflake supports SCIM integrations with Okta, Azure Active Directory (Azure AD), and custom SCIM integrations. These allow automated provisioning and de-provisioning of users and roles. SCIM is not provided directly through AWS, GCP, or Duo.
NEW QUESTION # 38
A Snowflake organization MYORG consists of two Snowflake accounts:
Account Name Snowflake Region Snowflake Edition
ACCOUNT1 AWS_EU_WEST_2 ENTERPRISE
ACCOUNT2 AZURE_WESTEUROPE STANDARD
The ACCOUNT1 has a database PROD_DB and the ORGADMIN role enabled.
Management wants to have the PROD_DB database replicated to ACCOUNT2.
Are there any necessary configuration steps in ACCOUNT1 before the database replication can be configured and initiated in ACCOUNT2?
- A. USE ROLE ORGADMIN;
SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT1','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
USE ROLE ACCOUNTADMIN;
ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2 IGNORE EDITION CHECK; - B. USE ROLE ORGADMIN;
SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT1','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('MYORG.ACCOUNT2','ENABLE_ACCOUNT_DATABASE_REPLICATION','TRUE');
USE ROLE ACCOUNTADMIN;
ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2; - C. It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.
- D. No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.
Answer: A
Explanation:
Replication between accounts requires both accounts to have replication enabled. Since ACCOUNT1 (Enterprise) replicates to ACCOUNT2 (Standard), the edition mismatch must be explicitly overridden. The correct configuration in ACCOUNT1 is to enable account-level database replication using SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER and then issue ALTER DATABASE PROD_DB ENABLE REPLICATION TO ACCOUNTS MYORG.ACCOUNT2 IGNORE EDITION CHECK;. The IGNORE EDITION CHECK clause is mandatory because Snowflake editions differ between the two accounts.
NEW QUESTION # 39
A team is provisioning new lower environments from the production database using cloning. All production objects and references reside in the database, and do not have external references.
What set of object references needs to be re-pointed before granting access for usage?
- A. There are no object references that need to be re-pointed
- B. Sequences, views, secure views, and materialized views
- C. Sequences, storage integrations, views, secure views, and materialized views
- D. Sequences, views, and secure views
Answer: A
Explanation:
When cloning a database in Snowflake, all objects - including sequences, views, secure views, and materialized views - are fully contained within the cloned database. Since there are no external references, no object references need to be re-pointed before granting access.
NEW QUESTION # 40
A user has enrolled in Multi-factor Authentication (MFA) for connecting to Snowflake. The user informs the Snowflake Administrator that they lost their mobile phone the previous evening.
Which step should the Administrator take to allow the user to log in to the system, without revoking their MFA enrollment?
- A. Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
- B. Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.
- C. Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
- D. Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
Answer: B
Explanation:
The correct step is to use ALTER USER ... SET MINS_TO_BYPASS_MFA = <minutes> which temporarily suspends MFA for the specified duration, allowing the user to log in and reconfigure their MFA without revoking enrollment. This preserves MFA setup and is the supported method in Snowflake.
NEW QUESTION # 41
Which type of listing in the Snowflake Marketplace can be added and queried immediately?
- A. Monetized listing
- B. Regional listing
- C. Standard listing
- D. Personalized listing
Answer: C
Explanation:
A standard listing in the Snowflake Marketplace can be immediately added to an account and queried without requiring provider approval or additional setup.
NEW QUESTION # 42
A company has implemented Snowflake replication between two Snowflake accounts, both of which are running on a Snowflake Enterprise edition. The replication is for the database APP_DB containing only one schema, APP_SCHEMA. The company's time Travel retention policy is currently set for 30 days for both accounts. An Administrator has been asked to extend the time Travel retention policy to 60 days on the secondary database only.
How can this requirement be met?
- A. Set the data retention policy on the secondary database to 60 days.
- B. Set the data retention policy on the schemas in the secondary database to 60 days.
- C. Set the data retention policy on the primary database to 30 days and the schemas to 60 days.
- D. Set the data retention policy on the primary database to 60 days.
Answer: D
Explanation:
In Snowflake replication, Time Travel retention is determined by the primary database and is replicated to the secondary. The secondary cannot have a longer retention than the primary. To extend retention to 60 days on the secondary, the primary database’s retention must be increased to 60 days.
NEW QUESTION # 43
Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.
Company A's Administrator created a share.
What object should be added to the share to allow Company B access to the files?
- A. A secure view with a column for METADATA$FILENAME.
- B. A secure view with a column for pre-signed URLs.
- C. A secure view with a column for file URLs.
- D. A secure view with a column for the stage name and a column for the file path.
Answer: D
Explanation:
Sharing a secure view with a column for the stage name and a column for the file path allows Company B to access the referenced files through Snowflake's external or internal stage, without exposing direct URLs. This maintains security and supports seamless access for the recipient.
NEW QUESTION # 44
A Snowflake customer is experiencing higher costs than anticipated while migrating their data warehouse workloads from on-premises to Snowflake. The migration workloads have been deployed on a single warehouse and are characterized by a large number of small INSERTS rather than bulk loading of large extracts. That single warehouse has been configured as a single cluster, 2XL because there are many parallel INSERTS that are scheduled during nightly loads.
How can the Administrator reduce the costs, while minimizing the overall load times, for migrating data warehouse history?
- A. There should be another 2XL warehouse deployed to handle a portion of the load queries.
- B. The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.
- C. The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.
- D. The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.
Answer: D
Explanation:
For many small, parallel INSERTS, using a multi-cluster warehouse with smaller size (SMALL or XSMALL) allows more concurrent queries to run efficiently and reduces costs compared to a single large warehouse. This configuration improves concurrency without unnecessary compute expense.
NEW QUESTION # 45
What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)
- A. The account requires at least one ORGADMIN role within one of the organization's accounts.
- B. The account name must be unique among all Snowflake customers.
- C. The account name must be unique within the organization.
- D. The account name must be specified when the account is created.
- E. The account name is immutable and cannot be changed.
Answer: C,D
Explanation:
When creating a new account within a Snowflake organization, the account name must be specified at creation and it must be unique within the organization. It does not need to be unique across all Snowflake customers, only within that specific organization.
NEW QUESTION # 46
What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?
- A. 14 days
- B. 90 days
- C. 30 days
- D. 1 day
Answer: D
Explanation:
Transient databases, schemas, and tables are designed for temporary or non-critical data and therefore have a default Time Travel retention period of one day. Even in Enterprise Edition and higher, the default retention for transient objects remains one day, although permanent objects can have longer retention periods configured.
NEW QUESTION # 47
......
ADA-C02 Premium Exam Engine - Download Free PDF Questions: https://www.exams-boost.com/ADA-C02-valid-materials.html
ADA-C02 Dumps Questions Study Exam Guide : https://drive.google.com/open?id=19mX3zKAxG5Xd7RP4MXYjih_qsnD11l1B