Ultimate Guide to Prepare ADA-C02 Certification Exam for SnowPro Advanced in 2026
Use Real ADA-C02 Dumps - Snowflake Correct Answers updated on 2026
NEW QUESTION # 24
What are characteristics of Dynamic Data Masking? (Choose two.)
- A. A single masking policy can be applied to columns in different tables.
- B. A masking policy that is currently set on a table can be dropped.
- C. The role that creates the masking policy will always see unmasked data in query results.
- D. A single masking policy can be applied to columns with different data types.
- E. A masking policy can be applied to the VALUE column of an external table.
Answer: A,B
Explanation:
A masking policy applied to a table or column can be dropped or replaced as needed.
The same masking policy can be reused and applied to columns in different tables.
NEW QUESTION # 25
For Snowflake network policies, what will occur when the account level and user level network policies are both defined?
- A. A network policy error will be generated with no definitions provided.
- B. The user_level network policies will not be supported.
- C. The user_level policy will override the account_level policy.
- D. The account_level policy will override the user_level policy.
Answer: C
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 # 26
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?
- A. The table is not big enough to take advantage of the clustering key.
- B. The cardinality of the stores to transaction count ratio is too low to use the STORE_ID as a clustering key.
- C. Sales across stores are not uniformly distributed.
- D. The STORE_ID should be numeric.
Answer: C
Explanation:
Clustering is effective when data distribution across the clustering key is relatively uniform. In this case, most transactions are concentrated in only 20 of the 1000 stores, leading to skewed data distribution. This imbalance causes poor pruning, since large portions of micro-partitions still need to be scanned, even for queries targeting specific stores.
NEW QUESTION # 27
Which actions are considered breaking changes to data that is shared with consumers in the Snowflake Marketplace? (Choose two.)
- A. Adding region availability to the listing
- B. Deleting data from a table
- C. Unpublishing the data listing
- D. Dropping a column from a table
- E. Renaming a table
Answer: D,E
Explanation:
Dropping a column from a table or renaming a table breaks the shared schema and can cause dependent queries to fail for consumers. These are considered breaking changes to shared data in the Snowflake Marketplace.
NEW QUESTION # 28
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.)
- A. SELECT on all tables and views in DatabaseA_clone.Schema1
- B. SELECT on all tables, and only non-secure views in DatabaseA_clone.Schema1
- C. USAGE on the schema DatabaseA_clone
- D. USAGE on the database DatabaseA_clone.Schema1
- E. SELECT on all tables, and only secure views in DatabaseA_clone.Schema1
Answer: A,C
Explanation:
When a database is cloned, the privileges granted on objects within the source database are preserved in the cloned database. Roles that had privileges on objects such as tables and views continue to have those privileges on the corresponding cloned objects. Therefore, the ANALYST role retains SELECT privileges on all tables and views within the cloned schema.
In addition, the cloned database and schema inherit the same access control configuration, allowing the role to use the schema within the cloned database.
NEW QUESTION # 29
Which type of listing in the Snowflake Marketplace can be added and queried immediately?
- A. Standard listing
- B. Personalized listing
- C. Regional listing
- D. Monetized listing
Answer: A
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 # 30
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?
- A. All existing tables in schema PROD.WORKING will be visible to both users.
- B. Tables created by either user A or user B will be visible to both users.
- C. Both user A and user B can create tables in the PROD.WORKING schema.
- D. Only user B can create tables, because all privileges were transferred to PROD_SUPERVISOR.
Answer: C
Explanation:
Granting ALL PRIVILEGES on the schema PROD.WORKING to both roles (PROD_ANALYST and PROD_SUPERVISOR) gives each user (A and B) full schema-level rights, including the ability to create tables. Since both roles received these grants independently, both users can create tables in the schema.
NEW QUESTION # 31
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 # 32
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?
- A. 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.
- B. Use bi-directional data sharing among offices in the same region and replication among offices across the continents.
- C. Move all the Snowflake accounts to a single region, and implement data sharing.
- D. Use data replication everywhere to reduce costs associated with same-region sharing.
Answer: B
Explanation:
Direct data sharing is the most cost-efficient method when accounts are in the same region and cloud. For cross-continent or cross-cloud sharing, Snowflake requires replication. Combining both - data sharing within the same region and replication across continents - ensures compliance, minimizes costs, and enables bi-directional sharing.
NEW QUESTION # 33
What are the requirements when creating a new account within an organization in Snowflake? (Choose two.)
- A. The account name must be unique within the organization.
- B. The account requires at least one ORGADMIN role within one of the organization's accounts.
- C. The account name is immutable and cannot be changed.
- D. The account name must be specified when the account is created.
- E. The account name must be unique among all Snowflake customers.
Answer: A,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 # 34
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 = xxxlarge
max_cluster_count = 10
scaling_policy = standard
auto_suspend = 600
auto_resume = false; - 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 = medium
auto_suspend = 600
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;
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 # 35
If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?
- A. No, because the optimizer might decide against it.
- B. No, because the materialized view may not be up-to-date.
- C. Yes, because materialized views are always faster.
- D. No, because joins are not supported by materialized views.
Answer: A
Explanation:
Even if a query matches the definition of a materialized view, the Snowflake optimizer may decide not to rewrite the query to use it. The optimizer evaluates factors such as freshness, cost, and efficiency before choosing whether or not to substitute the materialized view.
NEW QUESTION # 36
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 file URLs.
- B. A secure view with a column for the stage name and a column for the file path.
- C. A secure view with a column for pre-signed URLs.
- D. A secure view with a column for METADATA$FILENAME.
Answer: B
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 # 37
A Snowflake Administrator wants to create a virtual warehouse that supports several dashboards, issuing various queries on the same database.
For this warehouse, why should the Administrator consider setting AUTO_SUSPEND to 0 or NULL?
- A. To save costs on warehouse shutdowns and startups for different queries
- B. To keep the query result cache warm for good performance on repeated queries
- C. To save costs by running the warehouse as little as possible
- D. To keep the data cache warm to support good performance of similar queries
Answer: D
Explanation:
Setting AUTO_SUSPEND to 0 or NULL prevents the warehouse from suspending, which keeps the data cache warm. This improves performance for dashboards and workloads that frequently run similar queries, since the warehouse avoids cache loss from suspending and resuming.
NEW QUESTION # 38
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?
- A. The new role can only take effect after USERADMIN has logged out.
- B. The DEVELOPER_ROLE needs to be granted to SYSADMIN before user PTORRES will be able to use the role.
- C. USERADMIN needs to explicitly grant the DEVELOPER_ROLE to the new USER.
- D. The new role will only take effect once the identity provider has synchronized by way of SCIM with the Snowflake account.
Answer: C
Explanation:
Creating a user in Snowflake does not automatically grant them roles beyond PUBLIC. To use DEVELOPER_ROLE, the USERADMIN (or another role with MANAGE GRANTS privilege) must explicitly grant DEVELOPER_ROLE to PTORRES. Without this grant, the user cannot assume the role.
NEW QUESTION # 39
When adding secure views to a share in Snowflake, which function is needed to authorize users from another account to access rows in a base table?
- A. CURRENT USER
- B. CURRENT ACCOUNT
- C. CURRENT CLIENT
- D. CURRENT ROLE
Answer: B
Explanation:
When building secure views for data sharing, the CURRENT_ACCOUNT function is used to identify and authorize the consuming account. This ensures that row-level security can be enforced per consumer account accessing the shared data.
NEW QUESTION # 40
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?
- A. Create it as a permanent table with a retention time of 0 days.
- B. Create it as an external table, which will not incur Time Travel costs.
- C. Create it as a transient table with a retention time of 0 days.
- D. Create it as a temporary table with a retention time of 0 days.
Answer: C
Explanation:
A transient table is best suited for staging because it avoids long-term storage costs by not maintaining Fail-safe and can have Time Travel retention set to 0 days. This minimizes storage costs while still providing performance comparable to permanent tables, making it the optimal choice for daily staging data.
NEW QUESTION # 41
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. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of bar_policy.
- B. No, because 3.3.3.10 is not found in the ALLOWED_IP_LIST of foo_policy.
- C. Yes, because 3.3.3.10 is found in the ALLOWED_IP_LIST of foo_policy.
- D. No, because 3.3.3.10 is found in the BLOCKED_IP_LIST of bar_policy.
Answer: D
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 # 42
What Snowflake capabilities are commonly used in rollback scenarios? (Choose two.)
- A. ALTER TABLE prd_table SWAP WITH prd_table_bkp;
- B. CREATE TABLE prd_table_bkp as SELECT * from table(result_scan('problematic_query_id'));
- C. SELECT SYSTEM$CANCEL_QUERY('problematic_query_id');
- D. CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => 'problematic_query_id');
- E. Contact Snowflake Support to retrieve Fail-safe data.
Answer: A,D
Explanation:
Creating a clone of a table at a point in time before a problematic statement uses Snowflake Time Travel to restore the table’s previous state without copying data. This allows recovery of the table as it existed before the issue occurred.
Swapping tables enables a fast rollback by exchanging the original production table with the restored backup table. This operation is metadata-only and allows immediate restoration of the previous version of the data with minimal downtime.
NEW QUESTION # 43
......
SnowPro Advanced -ADA-C02 Exam-Practice-Dumps: https://www.newpassleader.com/Snowflake/ADA-C02-exam-preparation-materials.html
ADA-C02 Premium Files Test pdf - Free Dumps Collection: https://drive.google.com/open?id=1l-WJavYu66qDwi8A0C1o5-_DxolZslSV