QuestionQ1
Manage and administer Snowflake accounts, data security, and governanceThe following commands have been run:
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?
QuestionQ2
Manage and administer Snowflake accounts, data security, and governanceWhich steps are needed to configure OKTAAPI token integration in Snowflake?
Community Discussion
QuestionQ3
Manage and administer Snowflake accounts, data security, and governanceWhich command can temporarily disable multi-factor authentication (MFA) for the Snowflake username user1 for 24 hours?
Community Discussion
QuestionQ4
Manage and maintain database objects and virtual warehousesA virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the accountant role.
An application using the accountant role must use this warehouse to run financial reports and track the compute credits consumed by the warehouse. What minimum warehouse privileges should be granted to the role to satisfy these requirements?
Community Discussion
QuestionQ5
Manage and administer Snowflake accounts, data security, and governanceA user has enrolled in multi-factor authentication (MFA) to connect to Snowflake. The user tells the Snowflake Administrator that they lost their mobile phone the prior evening.
Which action should the Administrator take to enable the user to sign in to the system without revoking the user’s MFA enrollment?
Community Discussion