[Q37-Q55] ADA-C02 Dumps Free Test Engine Player Verified Updated [Aug 20, 2026]

NO.37 Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

SHOW REGIONS;

SHOW USERS;

SHOW ORGANIZATION ACCOUNTS;

GRANT ROLE ORGADMIN TO USER <username>;

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(‘ACCOUNT_LOCATOR’,’ENABLE_ACCOUNT_DATABASE_REPLICATION’,’true’);

NO.38 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?

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.

No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.

Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.

No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.

NO.39 In general, the monthly billing for database replication is proportional to which variables? (Choose two.)

The frequency of changes to the primary database as a result of data loading or DML operations

The amount of table data in the primary database that changes as a result of data loading or DML operations

The frequency of the secondary database refreshes from the primary database

The number of times data moves across regions and/or cloud service providers between the primary and secondary database accounts

The number and size of warehouses defined in the primary account

NO.40 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 secure view with a column for file URLs.

A secure view with a column for pre-signed URLs.

A secure view with a column for METADATA$FILENAME.

A secure view with a column for the stage name and a column for the file path.

NO.41 What information is required from the Identity Provider (IdP) to enable federated authentication in Snowflake? (Choose two.)

IdP account details

URL endpoint for SAML requests

SAML response format

Authentication certificate

IdP encryption key

NO.42 The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?

Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.

Tables created by either user A or user B will be visible to both users.

All existing tables in schema PROD.WORKING will be visible to both users.

Both user A and user B can create tables in the PROD.WORKING schema.

NO.43 What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?

1 day

14 days

30 days

90 days

NO.44 A Snowflake account is configured with SCIM provisioning for user accounts and has bi-directional synchronization for user identities. An Administrator with access to SECURITYADMIN uses the Snowflake UI to create a user by issuing the following commands:
use role USERADMIN;
create or replace role DEVELOPER_ROLE;
create user PTORRES PASSWORD = ‘hello world!’ MUST_CHANGE_PASSWORD = FALSE
default_role = DEVELOPER_ROLE;
The new user named PTORRES successfully logs in, but sees a default role of PUBLIC in the web UI. When attempted, the following command fails:
use DEVELOPER_ROLE;
Why does this command fail?

The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.

The new role can only take effect after USERADMIN has logged out.

USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.

The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.

NO.45 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?

select * from LINEITEM sample bernoulli (20);

select * from LINEITEM sample system (20);

select * from LINEITEM tablesample block (20 rows);

select * from LINEITEM tablesample system (20) seed (1);

NO.46 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?

SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(1)));

SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(),
OBJECT_CONSTRUCT(*)
FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));

SHOW WAREHOUSES;
INSERT INTO VWH_META
SELECT CURRENT_TIMESTAMP(), *
FROM TABLE(RESULT_SCAN(SELECT LAST_QUERY_ID(-1)));

NO.47 What session parameter can be used to test the integrity of secure views based on the account that is accessing that view?

MIMIC CONSUMER ACCOUNT

TEST ACCOUNT ID

PRODUCER TEST ACCT

SIMULATED DATA SHARING CONSUMER

NO.48 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?

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;

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;

No configuration steps are necessary in ACCOUNT1. Replicating databases across accounts within the same Snowflake organization is enabled by default.

It is not possible to replicate a database from an Enterprise edition Snowflake account to a Standard edition Snowflake account.

NO.49 What are benefits of creating and maintaining resource monitors in Snowflake? (Choose three.)

The cost of running a resource monitor is only 10% of a credit, per day of operation.

Multiple resource monitors can be applied to a single virtual warehouse.

Resource monitors add no additional load to virtual warehouse compute.

Multiple triggers can be configured across various virtual warehouse thresholds.

Resource monitor governance is tightly controlled and monitors can only be created by the ACCOUNTADMIN role or users with the CREATE MONITOR privilege.

Resource monitors can be applied to more than one virtual warehouse.

NO.50 A company enabled replication between accounts and is ready to replicate data across regions in the same cloud service provider.
The primary database object is : PROD_AWS_EAST. Location : AWS_EAST
The secondary database object is : PROD_AWS_WEST. Location : AWS_WEST
What command and account location is needed to refresh the data?

Location : AWS_WEST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

Location : AWS_WEST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

Location : AWS_EAST
Command : REFRESH DATABASE PROD_AWS_WEST REFRESH;

Location : AWS_EAST
Command : ALTER DATABASE PROD_AWS_WEST REFRESH;

NO.51 A Snowflake Administrator has a multi-cluster virtual warehouse and is using the Snowflake Business-Critical edition. The minimum number of clusters is set to 2 and the maximum number of clusters is set to 10. This configuration works well for the standard workload, rarely exceeding 5 running clusters. However, once a month the Administrator notes that there are a few complex long-running queries that are causing increased queue time and the warehouse reaches its maximum limit at 10 clusters.
Which solutions will address the issues happening once a month? (Choose two.)

Use a task to increase the cluster size for the time period that the more complex queries are running and another task to reduce the size of the cluster once the complex queries complete.

Have the group running the complex monthly queries use a separate appropriately-sized warehouse to support their workload.

Increase the multi-cluster maximum to 20 or more clusters.

Examine the complex queries and determine if they can be made more efficient using clustering keys or materialized views.

Increase the minimum number of clusters started in the multi-cluster configuration to 5.

NO.52 A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) that has been clustered by the STORE_ID column (varchar(50)). The vast majority of analyses on this table are grouped by STORE_ID to look at store performance.
There are 1000 stores operated by the retailer but most sales come from only 20 stores. The Administrator notes that most queries are currently experiencing poor pruning, with large amounts of bytes processed by even simple queries.
Why is this occurring?

The STORE_ID should be numeric.

The table is not big enough to take advantage of the clustering key.

Sales across stores are not uniformly distributed.

The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.

NO.53 What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Choose two.)

SYSADMIN

SECURITYADMIN

ACCOUNTADMIN

IMPORT SHARE and CREATE DATABASE

IMPORT PRIVILEGES and SHARED DATABASE

NO.54 DatabaseA has a single schema called Schema1. This schema contains many tables and views. The ANALYST role has privileges to select from all objects in DatabaseA.Schema1. The SYSADMIN role clones DatabaseA to DatabaseA_clone.
What privileges does the ANALYST role have on tables and views in DatabaseA_clone? (Choose two.)

USAGE on the schema DatabaseA_clone

USAGE on the database DatabaseA_clone.Schema1

SELECT on all tables, and only non-secure views in DatabaseA_clone.Schema1

SELECT on all tables, and only secure views in DatabaseA_clone.Schema1

SELECT on all tables and views in DatabaseA_clone.Schema1

NO.55 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?

Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.

Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.

Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.

Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.