Which action can be performed by the SYSADMIN role without requiring elevated privileges from the ACCOUNTADMIN or SECURITYADMIN role?
Answer(s): C
The SYSADMIN role is responsible for managing database objects and compute resources, including creating, modifying, and operating virtual warehouses without requiring higher-level administrative privileges.
Which security features are used to control inbound access to Snowflake and internal stages? (Choose two.)
Answer(s): C,E
Network policies restrict inbound access to Snowflake by controlling allowed IP addresses, while authentication policies define how users authenticate, including security requirements such as MFA, helping control secure access to Snowflake and its resources.
Which built-in function should be used to determine if the current role has inherited privileges from another specified role?
This function checks whether a specified role is currently active in the session, including roles inherited through role hierarchy, allowing verification of inherited privileges.
A Snowflake user is using the QUERY_HISTORY view in the ACCOUNT_USAGE schema to gather information about two queries that ran in the past 10 minutes, but the expected data is missing.What would cause this to occur?
The ACCOUNT_USAGE views have a latency (typically up to 45 minutes), so recently executed queries may not yet appear when querying QUERY_HISTORY.
Which feature allows a user to review the monthly projected costs of a Snowflake resource against the monthly actual costs?
Answer(s): A
Budgets provide visibility into projected monthly costs compared to actual usage, enabling users to monitor and manage spending against defined expectations.
A team needs to monitor and receive alerts for Snowpipe credit usage.Why should a custom budget be used instead of a resource monitor?
Answer(s): D
Custom budgets can monitor costs across both warehouse and serverless features like Snowpipe and can be scoped using object tags, whereas resource monitors apply only to virtual warehouse usage.
These application roles exist in a company's environment: DEVELOPER_ROLE and ETL_ROLE. Both roles have been granted USAGE, CREATE, and SELECT privileges on the same database and schema table object.A user with the DEVELOPER_ROLE creates a new table named MYTABLE within the MYDB.MYSCH schema. When a user with the ETL_ROLE attempts to access MYDB.MYSCH.MYTABLE, they receive an error indicating insufficient privileges.Which statement will enable the ETL_ROLE to access MYDB.MYSCH.MYTABLE upon its creation?
Granting privileges on future tables in the schema ensures that any newly created tables automatically inherit the required access for the role, eliminating the need to grant permissions manually after each creation.
Which security feature supports the replacement of active keys to enhance key-pair authentication?
Key rotation allows replacing active keys with new ones to maintain security, ensuring that key-pair authentication remains protected over time.
Post your Comments and Discuss Snowflake SnowPro Core COF-C03 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the SnowPro Core COF-C03 content, but please register or login to continue.