SnowPro Administrator ADA-C02 Practice Questions & Answers • ExamPrepare

33 questions in this view

Page 1 of 6

Question 1

Several MERGE operations on a table, SALES.TRANSACTIONS, are failing with this error:

Transaction aborted due to concurrent update conflict

The table is updated frequently by multiple data pipelines throughout the day.

Which guidance should an Administrator provide to help improve DML concurrency and reduce locking conflicts?

Increase the LOCK_TIMEOUT parameter to allow statements to wait longer for locks, reducing transaction failures during peak concurrent workloads.
Use explicit BEGIN TRANSACTION and COMMIT statements to control transaction boundaries and isolate concurrent sessions, ensuring predictable lock management during heavy update periods.
Split MERGE statements into incremental batches using a temporary staging table. This allows for committing smaller transactions and reducing contention across concurrent DML operations.
Re-cluster the SALES.TRANSACTIONS table using a CLUSTER BY expression on frequently updated columns to improve micro-partition distribution and minimize row-level contention during concurrent writes.

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 2

Administrators are establishing the initial role hierarchy and object creation strategy for a company and want to ensure security and ease of maintenance.

How should this strategy be configured for users that need to set up and establish an object?

Grant the MANAGE GRANTS privilege to a custom role.
Grant the CREATE DATABASE and USAGE privileges to a custom role.
Grant the OWNERSHIP privilege on all future databases to the SYSADMIN role.
Grant the CREATE DATABASE privilege to a custom role and grant that role to the SYSADMIN .

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 3

An Administrator is using a Python script to connect to a Snowflake account, sales_prod, that is part of the acme_org organization.

Which value should the administrator use to specify the account within the script?

acme_org-sales_prod
https://acme_org-sales_prod.snowflakecomputing.com
sales_prod.acme_org.snowflakecomputing.com
acme_org.sales_prod

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 4

An external stage needs to be configured for data ingestion from cloud storage. The security policy does not allow hardcoded credentials in Snowflake and enforces a least-privilege access model across all environments.

How should the external stage be created to meet the security requirements?

Define the stage with access keys or Shared Access Signature (SAS) tokens in the CREATE STAGE command.
Configure a STORAGE INTEGRATION object with Role-Based Access Control (RBAC).
Use temporary credentials from a Snowflake service user and refresh through SnowSQL automated scripts.
Apply public read access to the cloud storage container and reference it in the stage definition.

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 5

A user needs to retire the account, MYACCT, from one region and create a new account with the same account identifier in a different region. The Administrator ran these statements:

CREATE ACCOUNT MYACCT_2 ...;

ALTER ACCOUNT MYACCT RENAME TO MYACCT_OLD SAVE_OLD_URL = FALSE;

ALTER ACCOUNT MYACCT_2 RENAME TO MYACCT SAVE_OLD_URL = FALSE;

DROP ACCOUNT MYACCT_OLD GRACE_PERIOD_IN_DAYS = 3;

What will be the result of running these statements? (Select TWO).

Renaming MYACCT_2 to MYACCT will fail.
Users navigating to the account URL for MYACCT will be directed to the new account.
Users navigating to the account URL for MYACCT will be directed to the old account.
The Administrator will be able to create another account called MYACCT_OLD .
The Administrator will be able restore the account, MYACCT_OLD , using UNDROP ACCOUNT MYACCT_OLD; .

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.

Question 6

An Administrator is implementing a cost governance strategy across a multi-tenant architecture. Each tenant has its own virtual warehouse. The Administrator must:

1. Enforce a monthly credit quota per tenant

2. Suspend warehouses when the quota is exceeded

3. Prevent tenants from bypassing limits by switching to other warehouses

4. Minimize administrative overhead when managing these controls

Which approach meets these requirements?

Create a single resource monitor and assign it to all warehouses with a SUSPEND_IMMEDIATE action at 100%.
Create separate resource monitors for each tenant’s warehouse with SUSPEND at 100% and assign warehouses to the respective roles.
Use a centralized resource monitor with NOTIFY at 80% and rely on warehouse auto-suspend to control usage.
Assign ownership of all warehouses to a single role and grant usage on each warehouse to the respective tenant role.

Select an answer above, then submit your vote. Reading or practicing does not cast a vote.