Choose ADA-C02 most accurate study material

Snowflake ADA-C02 Exam Overview:

Snowflake ADA-C02 Exam Syllabus Topics:

Snowflake SnowPro Advanced Administrator ADA-C02 Sample Questions:

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

A) Leverage the CURRENT_DATE function for date calculations.
B) Wrap the query in a User-Defined Function (UDF) to match syntax execution.
C) Assign everyone on the sales team to the same security role.
D) Assign everyone on the sales team to the same virtual warehouse.

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

A) Instruct the user to append the normal URL with /?mode=mfa_bypass&code= to log on.
B) Alter the user and set DISABLE_MFA to true, which will suspend the MFA requirement for 24 hours.
C) Instruct the user to connect to Snowflake using SnowSQL, which does not support MFA authentication.
D) Alter the user and set MINS_TO_BYPASS_MFA to a value that will disable MFA long enough for the user to log in.

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

A) The INSERTS should be converted to several tables to avoid contention on large tables that slows down query processing.
B) There should be another 2XL warehouse deployed to handle a portion of the 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 2XL warehouse should be changed to 4XL to increase the number of threads available for parallel load queries.

4. What is the default data retention period for transient databases, schemas, and tables for Snowflake Enterprise edition and higher?

A) 90 days
B) 30 days
C) 1 day
D) 14 days

5. In which scenario will use of an external table simplify a data pipeline?

A) When accessing a Snowflake table from an external database within the same region
B) When continuously writing data from a Snowflake table to external storage
C) When accessing a Snowflake table from a relational database
D) When accessing a Snowflake table that references data files located in cloud storage

Solutions: