[Aug-2026] ADA-C02 Certification with Actual Questions from ActualTorrent [Q37-Q59]

Q37. If the query matches the definition, will Snowflake always dynamically rewrite the query to use a materialized view?

No, because joins are not supported by materialized views.

No, because the optimizer might decide against it.

No, because the materialized view may not be up-to-date.

Yes, because materialized views are always faster.

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

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

Q40. Which command can temporarily disable Multi-factor Authentication (MFA) for the Snowflake username user1 for 24 hours?

alter user user1 set MINS_TO_BYPASS_MFA=1440;

alter user user1 set DISABLE_MFA=1440;

alter user user1 set TEMPORARY_MFA_BYPASS=1440;

alter user user1 set HOURS_TO_BYPASS_MFA=24;

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

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

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

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.

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.

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.

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.

Q44. What are benefits of using Snowflake organizations? (Choose 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.

Q45. Which function is the role SECURITYADMIN responsible for that is not granted to role USERADMIN?

Reset a Snowflake user’s password

Manage system grants

Create new users

Create new roles

Q46. A team of developers created a new schema for a new project. The developers are assigned the role DEV_TEAM which was set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE DEV_TEAM;
GRANT USAGE, CREATE SCHEMA ON DATABASE DEV_DB01 TO ROLE DEV_TEAM;
GRANT USAGE ON WAREHOUSE DEV_WH TO ROLE DEV_TEAM;
Each team member’s access is set up using the following statements:
USE ROLE SECURITYADMIN;
CREATE ROLE JDOE_PROFILE;
CREATE USER JDOE LOGIN_NAME = ‘JDOE’ DEFAULT ROLE=’JDOE_PROFILE’;
GRANT ROLE JDOE_PROFILE TO USER JDOE;
GRANT ROLE DEV_TEAM TO ROLE JDOE_PROFILE;
New tables created by any of the developers are not accessible by the team as a whole.
How can an Administrator address this problem?

Assign ownership privilege to DEV_TEAM on the newly-created schema.

Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.

Set up future grants on the newly-created schemas.

Set up the new schema as a managed-access schema.

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

Q48. A Snowflake Administrator needs to set up Time Travel for a presentation area that includes facts and dimensions tables, and receives a lot of meaningless and erroneous IoT data. Time Travel is being used as a component of the company’s data quality process in which the ingestion pipeline should revert to a known quality data state if any anomalies are detected in the latest load. Data from the past 30 days may have to be retrieved because of latencies in the data acquisition process.
According to best practices, how should these requirements be met? (Choose two.)

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

The fact and dimension tables should have the same DATA_RETENTION_TIME_IN_DAYS.

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

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

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.

Q49. An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.
What privileges should be granted to the user to meet these requirements? (Choose two.)

EXECUTE TASK on the task

OWNERSHIP on the task

OPERATE on the task

USAGE on the database and schema containing the task

OWNERSHIP on the database and schema containing the task

Q50. Which type of listing in the Snowflake Marketplace can be added and queried immediately?

Monetized listing

Standard listing

Regional listing

Personalized listing

Q51. What SCIM integration types are supported in Snowflake? (Choose three.)

Amazon Web Services (AWS)

Google Cloud Platform (GCP)

Okta

Custom

Azure Active Directory (Azure AD)

Duo Security Provisioning Connector

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

Q53. What role or roles should be used to properly create the object required to setup OAuth 2.0 integration?

Any role with GRANT USAGE on SECURITY INTEGRATION

ACCOUNTADMIN and SYSADMIN

ACCOUNTADMIN and SECURITYADMIN

ACCOUNTADMIN only

Q54. When does auto-suspend occur for a multi-cluster virtual warehouse?

When there has been no activity on any cluster for the specified period of time.

After a specified period of time when an additional cluster has started on the maximum number of clusters specified for a warehouse.

When the minimum number of clusters is running and there is no activity for the specified period of time.

Auto-suspend does not apply for multi-cluster warehouses.

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

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

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

To save costs on warehouse shutdowns and startups for different queries

To save costs by running the warehouse as little as possible

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

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

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

Q59. What is required for stages, without credentials, to limit data exfiltration after a storage Integration and associated stages are created?

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;

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;

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;

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;

[Aug-2026] ADA-C02 Certification with Actual Questions from ActualTorrent [Q37-Q59]

Be the first to reply

Leave a Reply Cancel reply