ADA-C02 무료 덤프문제 온라인 액세스

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

• A.1 day
• B.30 days
• C.90 days
• D.14 days

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

• A.Okta
• B.Google Cloud Platform (GCP)
• C.Azure Active Directory (Azure AD)
• D.Duo Security Provisioning Connector
• E.Custom
• F.Amazon Web Services (AWS)

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

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.No, because joins are not supported by materialized views.
• D.Yes, because materialized views are always faster.

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

• A.alter user user1 set DISABLE_MFA=1440;
• B.alter user user1 set HOURS_TO_BYPASS_MFA=24;
• C.alter user user1 set TEMPORARY_MFA_BYPASS=1440;
• D.alter user user1 set MINS_TO_BYPASS_MFA=1440;