This certification validates practical skills in database management, including data preparation, analysis, governance, and communicating reliable insights. It is intended for professionals who build or operate data-driven solutions.
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?
Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?
Which authentication methods are available when connecting to Snowflake using the SQL API? (Choose two.)
The following SQL command was executed:
Which role(s) can alter or drop table XYZ?
The following commands were executed:
Grant usage on database PROD to role PROD_ANALYST;
Grant usage on database PROD to role PROD_SUPERVISOR;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_ANALYST;
Grant ALL PRIVILEGES on schema PROD.WORKING to role PROD_SUPERVISOR;
Grant role PROD_ANALYST to user A;
Grant role PROD_SUPERVISOR to user B;
What authority does each user have on the WORKING schema?