Free Snowflake ADA-C01 Exam Dumps Questions & Answers

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

• A.  create or replace masking policy maskstring as (val string) returns string -> case when is_role_in_session ('MASKED_VIEW_ROLE') then ' ** else val end;
  *,
• B.  create or replace masking policy maskString as (val string) returns string -> case when array_contains ('MASKED_VIEW_ROLE' :: variant, parse_json (current_available_roles ())) then '* else val end;
  ** '
• C.  create or replace masking policy maskstring as (val string) returns string -> case when invoker_role() in ('MASKED_VIEW_ROLE') then else val end;
  ' **
• D.  create or replace masking policy maskString as (val string) returns string -> case when current_role() in ('MASKED_VIEW_ROLE') then ' ********* ' else val end;

What Snowflake capabilities are commonly used in rollback scenarios? (Select TWO).

• A.  SELECT SYSTEM$CANCEL_QUERY('problematic_query_id');
• B.  CREATE TABLE prd_table_bkp AS SELECT * FROM TABLE(RESULT_SCAN('problematic_query_id'));
• C.  Contact Snowflake Support to retrieve Fail-safe data.
• D.  ALTER TABLE prd_table SWAP WITH prd_table_bkp;
• E.  CREATE TABLE prd_table_bkp CLONE prd_table BEFORE (STATEMENT => 'problematic_query_id');

MY_TABLE is a table that has not been updated or modified for several days. On 01 January 2021 at 07:01, a user executed a query to update this table. The query ID is
'8e5d0ca9-005e-44e6-b858-a8f5b37c5726'. It is now 07:30 on the same day.
Which queries will allow the user to view the historical data that was in the table before this query was executed? (Select THREE).

• A.  SELECT * FROM my table PRIOR TO STATEMENT '8e5d0ca9-005e-44e6-b858-a8f5b37c5726';
• B.  SELECT * FROM my table WITH TIME_TRAVEL (OFFSET => -60*30);
• C.  SELECT * FROM TIME_TRAVEL ('MY_TABLE', 2021-01-01 07:00:00);
• D.  SELECT * FROM my_table BEFORE (STATEMENT => '8e5d0ca9-005e-44e6-b858-a8f5b37c5726');
• E.  SELECT * FROM my_table AT (TIMESTAMP => '2021-01-01 07:00:00' :: timestamp);
• F.  SELECT * FROM my_table AT (OFFSET => -60*30);

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

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? (Select TWO).

• A.  OWNERSHIP on the task
• B.  OPERATE on the task
• C.  USAGE on the database and schema containing the task
• D.  OWNERSHIP on the database and schema containing the task
• E.  EXECUTE TASK on the task