Free Snowflake ADA-C02 Exam Dumps Questions & Answers

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

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

• A.ACCOUNTADMIN and SYSADMIN
• B.ACCOUNTADMIN only
• C.Any role with GRANT USAGE on SECURITY INTEGRATION
• D.ACCOUNTADMIN and SECURITYADMIN

The following SQL command was executed:
Use role SECURITYADMIN;
Grant ownership
On future tables
In schema PROD.WORKING
To role PROD_WORKING_OWNER;
Grant role PROD_WORKING_OWNER to role SYSADMIN;
Use role ACCOUNTADMIN;
Create table PROD.WORKING.XYZ (value number);
Which role(s) can alter or drop table XYZ?

• A.Because ACCOUNTADMIN created the table, only the ACCOUNTADMIN role can alter or drop table XYZ.
• B.PROD_WORKING_OWNER, ACCOUNTADMIN, and SYSADMIN can alter or drop table XYZ.
• C.SECURITYADMIN, SYSADMIN, and ACCOUNTADMIN can alter or drop table XYZ.
• D.Only the PROD_WORKING_OWNER role can alter or drop table XYZ.

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 temporary table with a retention time of 0 days.
• B.Create it as a permanent table with a retention time of 0 days.
• C.Create it as a transient table with a retention time of 0 days.
• D.Create it as an external table, which will not incur Time Travel costs.

Which statement allows a Snowflake Administrator to retrieve the network policy applied to their Snowflake account?

• A.SHOW PARAMETERS LIKE ‘NETWORK POLICY’ IN ACCOUNT;
• B.SHOW NETWORK POLICIES;
• C.DESC NETWORK POLICY <policy_name>;
• D.SHOW NETWORK POLICIES IN ACCOUNT;