Online Access Free ADA-C02 Exam Questions

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 only secure views in DatabaseA_clone.Schema1
• B.USAGE on the database DatabaseA_clone.Schema1
• C.SELECT on all tables and views in DatabaseA_clone.Schema1
• D.USAGE on the schema DatabaseA_clone
• E.SELECT on all tables, and only non-secure views in DatabaseA_clone.Schema1

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

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

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

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

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

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?

• A.Set up future grants on the newly-created schemas.
• B.Assign usage privilege on the virtual warehouse DEV_WH to the role JDOE_PROFILE.
• C.Assign ownership privilege to DEV_TEAM on the newly-created schema.
• D.Set up the new schema as a managed-access schema.