Practice Questions · Part 3
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
SnowPro Core COF-C03 Study GuidePart 3: Access control and securityPractice Questions: Part 3
Thirty questions in the exam's format: single choice and multiple select, no topic hints. Answer each one, then read the explanation even when you got it right.
An administrator must list every privilege and every role that has been granted to role ANALYST. Which command returns this?
SHOW FUTURE GRANTS TO ROLE analyst;SHOW GRANTS OF ROLE analyst;SHOW GRANTS TO ROLE analyst;SHOW GRANTS ON ROLE analyst;Which features make up Snowflake's column-level security? (Choose two.)
Role OPS_READ holds USAGE on warehouse OPS_WH, USAGE on schema LOGISTICS.SHIPPING and SELECT on table LOGISTICS.SHIPPING.ROUTES. A query on the table fails with "Object 'LOGISTICS.SHIPPING.ROUTES' does not exist or not authorized." What is missing?
A user administrator runs CREATE USER with DEFAULT_ROLE = analyst and DEFAULT_WAREHOUSE = bi_wh. ANALYST already holds USAGE on BI_WH. What else is required before the new user can work as ANALYST?
GRANT ROLE analyst TO USER for that userDEFAULT_SECONDARY_ROLES = ('ALL') on the userTable PROD.CORE.ORDERS is owned by role DATA_OPS, and SELECT on it is granted to role BI_READ. No future grants exist in schema QA.CORE. A user working as RELEASE_MGR runs CREATE TABLE qa.core.orders CLONE prod.core.orders COPY GRANTS; What is true about the clone?
Custom role ML_ENG created schema ANALYTICS.FEATURES and owns it and every table in it. ML_ENG is granted only to user nadia. SYSADMIN owns database ANALYTICS. Which statement lets a user working as SYSADMIN alter those tables while ML_ENG stays their owner?
GRANT ROLE sysadmin TO ROLE ml_eng;GRANT ROLE ml_eng TO ROLE sysadmin;GRANT OWNERSHIP ON ALL TABLES IN SCHEMA analytics.features TO ROLE sysadmin COPY CURRENT GRANTS;GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA analytics.features TO ROLE sysadmin;Why would a data engineer create a secure view instead of a standard view? (Choose two.)
Custom role ETL_ROLE was created by USERADMIN, is granted to SYSADMIN, and owns 12 tables. A user whose current role is SECURITYADMIN runs DROP ROLE etl_role; Which role owns the 12 tables afterward?
In an Enterprise edition account, sessions with role EUROPE_ANALYST must see only the rows of table SALES where REGION = 'EUROPE'. Other rows must not come back through any access path, including direct queries on SALES. What should the security team use?
Table CONTACTS has columns PHONE and MARKETING_OPT_IN. Support staff must see the real PHONE only on rows where MARKETING_OPT_IN is 'Y' and a masked value elsewhere, on every query of the table, including direct ones. Every row must still be returned. What meets this?
Which statements about database roles are true? (Choose two.)
A provider granted USAGE on a database and SELECT on three of its tables directly to a share, without using database roles. In the consumer account, an administrator created database PARTNER_SALES from that share. Which statement lets the local role REPORTING query the shared tables?
GRANT IMPORTED PRIVILEGES ON DATABASE partner_sales TO ROLE reporting;GRANT DATABASE ROLE partner_sales.reader TO ROLE reporting;GRANT USAGE ON SHARE partner_share TO ROLE reporting;GRANT SELECT ON ALL TABLES IN DATABASE partner_sales TO ROLE reporting;An account sets ALLOW_CLIENT_MFA_CACHING = TRUE so that a driver reconnecting several times doesn't prompt for MFA on every connection. For how long can a cached MFA token be reused?
A company wants users and role memberships managed in Okta to be created, updated and disabled in Snowflake automatically. What should it configure?
A data team creates a user with TYPE = SERVICE for an unattended nightly pipeline. Which methods can this user authenticate with? (Choose two.)
Account-level network policy CORP_NET allows 198.51.100.0/24 and blocks 198.51.100.9. User LINA has her own policy, LINA_NET, which allows 198.51.100.0/24 and blocks nothing. Lina connects from 198.51.100.9. What happens?
Email addresses sit in columns across 40 tables, and new email columns keep being added. The governance team wants to define "mask emails for every role except HR_ADMIN" once and have it protect each email column, new ones included, as soon as the column is labeled. What should it use?
Which statements about network policies are true? (Choose two.)
Regulation forbids storing clear-text card numbers anywhere in Snowflake, yet one authorized role must see real card numbers in query results. Which approach fits?
Table SALES has a row access policy that returns TRUE when IS_ROLE_IN_SESSION() is TRUE for a role listed in a mapping table. The mapping table has a row for LATAM_ANALYST. Lina holds roles ANALYST and LATAM_ANALYST. ANALYST holds SELECT on SALES, and LATAM_ANALYST isn't granted to ANALYST. Her session runs USE ROLE analyst; and USE SECONDARY ROLES NONE; then queries SALES. What does she get?
A pipeline creates new tables in schema RAW every day. Role ANALYST already holds USAGE on the database and the schema. Which statement makes every table created in RAW from now on readable by ANALYST without further grants?
GRANT OWNERSHIP ON SCHEMA raw TO ROLE analyst;GRANT USAGE ON SCHEMA raw TO ROLE analyst WITH GRANT OPTION;GRANT SELECT ON FUTURE TABLES IN SCHEMA raw TO ROLE analyst;GRANT SELECT ON ALL TABLES IN SCHEMA raw TO ROLE analyst;An administrator runs GRANT SELECT ON FUTURE VIEWS IN DATABASE mart_db TO ROLE reporting; and later GRANT SELECT ON FUTURE VIEWS IN SCHEMA mart_db.finance TO ROLE finance_ro; A pipeline then creates a new view in MART_DB.FINANCE. Which roles get SELECT on that view?
Which are Snowflake's recommended practices for the ACCOUNTADMIN role? (Choose two.)
Engineers create and own tables in schema FINANCE_STG. A governance team wants decisions about who may access those tables made centrally rather than by each table's owner, while the engineers keep owning their tables. What should the team do?
A company wants a system role, below ACCOUNTADMIN, for daily work that includes granting and revoking privileges on any object in the account. Which role fits?
A table owner grants SELECT on one table directly to a user, through user-based access control (UBAC). Which statements about privileges granted to users are true? (Choose two.)
An auditor asks which users read the SALARY column during the last quarter, including reads made through views. Which source in SNOWFLAKE.ACCOUNT_USAGE answers this?
A masking policy on PAYROLL.BONUS returns the real value only when CURRENT_ROLE() = 'COMP_ADMIN'. COMP_ADMIN is granted to SYSADMIN. A user working as ACCOUNTADMIN queries the column. What does that user see?
A user holds roles ANALYST and DATA_ENGINEER. ANALYST is granted to SYSADMIN. The session runs USE ROLE analyst; and USE SECONDARY ROLES NONE; When the user runs a SELECT, which privileges can authorize it? (Choose three.)
A user's primary role is ANALYST and secondary roles are set to ALL. Only the user's other role, DATA_ENGINEER, holds CREATE TABLE on schema RAW. The user runs CREATE TABLE raw.t1 (id INT); What happens?
Finish this set to count it as done.