Grab 75% Off This Black Friday: Use coupon code below to save on all exam bundles! - Ends in 0d 00h 00m 00s - Coupon code: 75only

ADA-C02 SnowPro Advanced: Administrator Questions and Answers

Questions 4

A Snowflake Administrator needs to create a virtual warehouse that supports several dashboards running various queries against the same database.

Why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL for this warehouse?

Options:

A.

To save costs on warehouse shutdowns and startups for different queries

B.

To save costs by running the warehouse as little as possible

C.

To keep the data cache warm to support good performance of similar queries

D.

To keep the query result cache warm for good performance on repeated queries

Buy Now
Questions 5

What is one characteristic of Snowflake’s transaction locking and concurrency model?

Options:

A.

A deadlock cannot occur in Snowflake, since concurrently executed queries and DML statements do not block one another.

B.

If two queries are concurrently executed against the same table, one of the two queries will be blocked until the other query completes.

C.

Transaction locking in Snowflake is enforced exclusively at the row and table levels.

D.

Queries executed within a given transaction see that transaction's uncommitted changes.

Buy Now
Questions 6

DatabaseA contains one schema, Schema1, which has many tables and views. The ANALYST role has privileges to select from every object in DatabaseA.Schema1. The SYSADMIN role clones DatabaseA as DatabaseA_clone.

Which privileges does the ANALYST role have on tables and views in DatabaseA_clone?

Choose two

Options:

A.

USAGE on the schema DatabaseA_clone

B.

USAGE on the database DatabaseA_clone.Schema1

C.

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

D.

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

E.

SELECT on all tables and views in DatabaseA_clone.Schema1

Buy Now
Questions 7

What is needed for credential-free stages to restrict data exfiltration after a storage integration and its associated stages have been created?

Options:

A.

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;

B.

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;

C.

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;

D.

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;

Buy Now
Questions 8

Which Snowflake capabilities are typically used for rollback scenarios?

Choose two

Options:

A.

SELECT SYSTEM$CANCEL_QUERY(‘problematic_query_id’);

B.

CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT = > ‘problematic_query_id’);

C.

CREATE TABLE prd_table_bkp as SELECT * from table(result_scan(‘problematic_query_id’()));

D.

ALTER TABLE prd_table SWAP WITH prd_table_bkp;

E.

Contact Snowflake Support to retrieve Fail-safe data.

Buy Now
Questions 9

A company has configured Snowflake replication between two Snowflake accounts, both running Snowflake Enterprise Edition. Replication applies to database APP_DB, which contains only one schema, APP_SCHEMA. The company’s Time Travel retention policy is currently 30 days in both accounts. An Administrator must extend the Time Travel retention policy to 60 days on the secondary database only.

How can this requirement be fulfilled?

Options:

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.

Buy Now
Questions 10

The following commands have been run:

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?

Options:

A.

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

B.

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

C.

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

D.

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

Buy Now
Questions 11

A Snowflake customer is incurring higher-than-expected costs while migrating data-warehouse workloads from on premises to Snowflake. The migration workloads run on one warehouse and consist of many small INSERT statements rather than bulk-loading large extracts. That warehouse is configured as a single 2XL cluster because many parallel INSERT statements are scheduled during nightly loads.

How can the Administrator lower costs while minimizing the overall time required to load data-warehouse history?

Options:

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 warehouse should be kept as a SMALL or XSMALL and configured as a multi-cluster warehouse to handle the parallel load queries.

D.

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

Buy Now
Questions 12

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the accountant role.

An application using the accountant role must use this warehouse to run financial reports and track the compute credits consumed by the warehouse. What minimum warehouse privileges should be granted to the role to satisfy these requirements?

Choose two

Options:

A.

OPERATE

B.

MODIFY

C.

MONITOR

D.

USAGE

E.

OWNERSHIP

Buy Now
Questions 13

A company has many users assigned to the ANALYST role who regularly query Snowflake through a reporting tool. The Administrator observes that the ANALYST users continuously keep two small clusters busy and occasionally require three or four clusters of that same size.

B. ased on this scenario, how should the Administrator configure a virtual warehouse to MOST efficiently support this user group?

Options:

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 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.

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 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.

Buy Now
Questions 14

Which statement enables a Snowflake Administrator to retrieve the network policy applied to the Snowflake account?

Options:

A.

SHOW NETWORK POLICIES IN ACCOUNT;

B.

SHOW PARAMETERS LIKE ‘NETWORK POLICY’ IN ACCOUNT;

C.

SHOW NETWORK POLICIES;

D.

DESC NETWORK POLICY < policy_name > ;

Buy Now
Questions 15

Which tasks are available to the ORGADMIN role?

Choose three

Options:

A.

Create one or more accounts in the organization.

B.

View a list of all regions enabled for the organization.

C.

Create secure views on application tables within the organization.

D.

View usage information for all accounts in the organization.

E.

Perform zero-copy cloning on account data.

F.

Create a reader account to share data with another organization.

Buy Now
Questions 16

A Snowflake Administrator must configure Time Travel for a presentation area containing fact and dimension tables that receives substantial meaningless and erroneous IoT data. Time Travel is part of the company’s data-quality process, where the ingestion pipeline must revert to a known, high-quality data state if anomalies are found in the most recent load. Because of latencies in the data-acquisition process, data from the prior 30 days might need to be retrieved.

Options:

A.

ccording to best practices, how should these requirements be satisfied?

Choose two

B.

Related data should not be placed together in the same schema. Facts and dimension tables should each have their own schemas.

C.

The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS.

D.

The DATA_RETENTION_TIME_IN_DAYS should be kept at the account level and never used for lower level containers (databases and schemas).

E.

Only TRANSIENT tables should be used to ensure referential integrity between the fact and dimension tables.

F.

The fact and dimension tables should be cloned together using the same Time Travel options to reduce potential referential integrity issues with the restored data.

Buy Now
Questions 17

Which commands can a user with the ORGADMIN role, but without the ACCOUNTADMIN role, perform?

Choose two

Options:

A.

SHOW REGIONS;

B.

SHOW USERS;

C.

SHOW ORGANIZATION ACCOUNTS;

D.

GRANT ROLE ORGADMIN TO USER < username > ;

E.

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER(

'ACCOUNT_LOCATOR',

'ENABLE_ACCOUNT_DATABASE_REPLICATION',

'true'

);

Buy Now
Questions 18

An Administrator must configure a Snowflake virtual warehouse for a new use case with these details:

B. etween 50 and 100 concurrent users will run reports.

C. osts must be minimized according to the number of users active at a particular time.

The virtual warehouse must automatically suspend and resume based on user activity.

Which configuration meets these requirements?

Options:

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

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = FALSE;

C.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = XXXLARGE

AUTO_SUSPEND = 60

AUTO_RESUME = TRUE;

D.

CREATE OR REPLACE WAREHOUSE reporting_wh

WAREHOUSE_SIZE = MEDIUM

MAX_CLUSTER_COUNT = 10

SCALING_POLICY = STANDARD

AUTO_SUSPEND = 600

AUTO_RESUME = TRUE;

Buy Now
Exam Code: ADA-C02
Exam Name: SnowPro Advanced: Administrator
Last Update: Nov 21, 2026
Questions: 60

PDF + Testing Engine

$42.5  $169.99

Testing Engine

$32.5  $129.99
buy now ADA-C02 testing engine

PDF (Q&A)

$27.5  $109.99
buy now ADA-C02 pdf
dumpsmate guaranteed to pass

24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 22 Nov 2026