Latest 2026 Realistic Verified ADA-C01 Dumps - 100% Free ADA-C01 Exam Dumps [Q37-Q58]

NO.37 The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD. WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number) ;
Which role(s) can alter or drop table XYZ?

Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.

SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.

PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.

Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

NO.38 Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Select 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.39 An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Select TWO).

Implement views on top of base tables that exclude or mask sensitive data.

Implement row access policies and Dynamic Data Masking policies.

Include masking rules as part of data ingestion and transformation pipelines.

Use a third-party tool to share the data.

Use zero-copy cloning to replicate the database schema and provide access as needed.

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 access control policy will be put into place when future grants are assigned to both database and schema objects?

Database privileges will take precedence over schema privileges.

Schema privileges will take precedence over database privileges.

An access policy combining both the database object and the schema object will be used, with the most permissive policy taking precedence.

An access policy combining both the database object and the schema object will be used, with the most restrictive policy taking precedence.

NO.42 What are characteristics of Dynamic Data Masking? (Select TWO).

A masking policy that is currently set on a table can be dropped.

A single masking policy can be applied to columns in different tables.

A masking policy can be applied to the VALUE column of an external table.

The role that creates the masking policy will always see unmasked data in query results.

A single masking policy can be applied to columns with different data types.

NO.43 A company’s Snowflake account has multiple roles. Each role should have access only to data that resides in the given role’s specific region.
When creating a row access policy, which code snippet below will provide privileges to the role ALL_ACCESS_ROLE to see all rows regardless of region, while the other roles can only see rows for their own regions?

create or replace row access policy region policy as (region_value varchar) returns boolean ->
‘ALL ACCESS_ROLE’ = current_role ()
and exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

create or replace row access policy region policy as (region_value varchar) returns boolean -> exists ( select 1 from entitlement_table where role = current_role () and region = region_value )

create or replace row access policy region policy as (region_value varchar) returns boolean ->
‘ALL_ACCESS_ROLE’ = current_role ()
or exists (
select 1 from entitlement_table
where role = current_role ()
and region = region_value
)

create or replace row access policy region policy as (region_value varchar) returns boolean ->
‘ALL ACCESS ROLE’ = current_role ()
)

NO.44 Which statement allows this user to access this Snowflake account from a specific IP address (192.168.1.100) while blocking their access from anywhere else?

CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = (‘192.168.1.100’);
ALTER USER ABC SET NETWORK_POLICY = ‘ADMIN_POLICY’;
User ABC is the only user with an ACCOUNTADMIN role.

CREATE NETWORK POLICY ADMIN POLICY
ALLOWED_IP_LIST = (‘192.168.1.100’);
ALTER ROLE ACCOUNTADMIN SET NETWORK_POLICY = ‘ADMIN_POLICY’;

CREATE NETWORK POLICY ADMIN_POLICY
ALLOWED IP LIST = (‘192.168.1.100’)
BLOCKED_IP_LIST = (‘0.0.0.0/0’);
ALTER USER ABC SET NETWORK_POLICY = ‘ADMIN_POLICY’;

CREATE OR REPLACE NETWORK POLICY ADMIN_POLICY
ALLOWED_IP_LIST = (‘192.168. 1. 100/0’) ;
ALTER USER ABC SET NETWORK_POLICY = ‘ADMIN_POLICY’;

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

There should be another 2XL warehouse deployed to handle a portion of the load queries.

The 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.

The warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.

NO.46 A large international company with many operating regions requires data to be shared bi-directionally among all offices (head office to regional offices and regional offices among themselves). This company is a Snowflake account holder with European operations deployed in Microsoft Azure (single region) while North American regional offices are using AWS (single region) as their deployment cloud. This setup is required to comply with Personal Identifiable Information (PII) regulations in some of the European countries. The corporate head office is in Europe.
How can this data be shared bi-directionally, while MINIMIZING costs?

Use data replication everywhere to reduce costs associated with same-region sharing.

Use the PUT command to move files to an Amazon S3 bucket and Azure Blobs, and use an external file management application to move files within the corporate VPC.

Move all the Snowflake accounts to a single region, and implement data sharing.

Use bi-directional data sharing among offices in the same region and replication among offices across the continents.

NO.47 What are benefits of creating and maintaining resource monitors in Snowflake? (Select 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.48 An Administrator has been asked to support the company’s application team need to build a loyalty program for its customers. The customer table contains Personal Identifiable Information (PII), and the application team’s role is DEVELOPER.
CREATE TABLE customer_data (
customer_first_name string,
customer_last_name string,
customer_address string,
customer_email string,
… some other columns,
);
The application team would like to access the customer data, but the email field must be obfuscated.
How can the Administrator protect the sensitive information, while maintaining the usability of the data?

Create a view on the customer_data table to eliminate the email column by omitting it from the SELECT clause. Grant the role DEVELOPER access to the view.

Create a separate table for all the non-Pll columns and grant the role DEVELOPER access to the new table.

Use the CURRENT_ROLE and CURRENT_USER context functions to integrate with a secure view and filter the sensitive data.

Use the CURRENT_ROLE context function to integrate with a masking policy on the fields that contain sensitive data.

NO.49 A requirement has been identified to allow members of a corporate Data Product team to bring in data sets from the Snowflake Marketplace. The members of this team use the role DP_TEAM.
What grant statements must the ACCOUNTADMIN execute in order for the DP TEAM role to import and work with data from the Marketplace?

grant marketplace in account to role dp_team;
grant create database from share to role dp_team;

grant usage on snowflake_marketplace to role dp_team;
grant create database on account to role dp_team;

grant imported privileges on account to role dp_team;
grant create database on account to role dp_team;

grant import share on account to role dp_team;
grant create database on account to role dp_team;

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

Sequences, views, and secure views

Sequences, views, secure views, and materialized views

Sequences, storage integrations, views, secure views, and materialized views

There are no object references that need to be re-pointed

NO.51 In general, the monthly billing for database replication is proportional to which variables? (Select 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.52 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 userl 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.53 What roles can be used to create network policies within Snowflake accounts? (Select THREE).

Any role that owns the database where the network policy is created

SECURITYADMIN

Any role with the global permission of CREATE NETWORK POLICY

ACCOUNTADMIN

SYSADMIN

ORGADMIN

NO.54 An Administrator loads data into a staging table every day. Once loaded, users from several different departments perform transformations on the data and load it into different production tables.
How should the staging table be created and used to MINIMIZE storage costs and MAXIMIZE performance?

Create it as an external table, which will not incur Time Travel costs.

Create it as a transient table with a retention time of 0 days.

Create it as a temporary table with a retention time of 0 days.

Create it as a permanent table with a retention time of 0 days.

NO.55 What are benefits of using Snowflake organizations? (Select TWO).

Administrators can change Snowflake account editions on-demand based on need.

Administrators can monitor and understand usage across all accounts in the organization.

Administrators can simplify data movement across all accounts within the organization.

User administration is simplified across all accounts within the organization.

Administrators have the ability to create accounts in any available cloud provider or region.

NO.56 An organization’s sales team leverages this Snowflake query a few times a day:
SELECT CUSTOMER ID, CUSTOMER_NAME, ADDRESS, PHONE NO
FROM CUSTOMERS
WHERE LAST UPDATED BETWEEN TO_DATE (CURRENT_TIMESTAMP) AND (TO_DATE (CURRENT_TIMESTAMP) -7); What can the Snowflake Administrator do to optimize the use of persisted query results whenever possible?

Wrap the query in a User-Defined Function (UDF) to match syntax execution.

Assign everyone on the sales team to the same virtual warehouse.

Assign everyone on the sales team to the same security role.

Leverage the CURRENT_DATE function for date calculations.

NO.57 A Snowflake Administrator created a role ROLE_MANAGED_ACCESS and a schema SCHEMA_MANAGED_ACCESS as follows:
USE ROLE SECURITYADMIN;
CREATE ROLE ROLE_MANAGED_ACCESS;
GRANT ROLE ROLE_MANAGED_ACCESS TO ROLE SYSADMIN;
GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE ROLE_MANAGED_ACCESS;
GRANT ALL privileges ON DATABASE WORK TO ROLE ROLE_MANAGED_ACCESS;
USE ROLE ROLE_MANAGED_ACCESS;
CREATE SCHEMA SCHEMA_MANAGED_ACCESS WITH MANAGED ACCESS;
USE ROLE SECURITYADMIN;
GRANT SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA MANAGED ACCESS to ROLE_MANAGED_ACCESS; The Administrator now wants to disable the managed access on the schema.
How can this be accomplished?

ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;

USE ROLE ROLE MANAGED_ACCESS;
DROP SCHEMA WORK. SCHEMA_MANAGED_ACCESS;
CREATE SCHEMA SCHEMA_MANAGED_ACCESS;
Then recreate all needed objects.

REVOKE SELECT, INSERT ON FUTURE TABLES IN SCHEMA SCHEMA_MANAGED_ACCESS FROM ROLE_MANAGED_ACCESS; ALTER SCHEMA SCHEMA MANAGED ACCESS DISABLE MANAGED ACCESS;