Course contents

SnowPro Core COF-C03 Study GuidePart 3: Access control and securityPractice Questions: Part 3

Practice Questions: Part 3

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.

Practice questions

  1. An administrator must list every privilege and every role that has been granted to role ANALYST. Which command returns this?

    1. SHOW FUTURE GRANTS TO ROLE analyst;
    2. SHOW GRANTS OF ROLE analyst;
    3. SHOW GRANTS TO ROLE analyst;
    4. SHOW GRANTS ON ROLE analyst;
  2. Which features make up Snowflake's column-level security? (Choose two.)

    1. Dynamic Data Masking
    2. Secure views
    3. Row access policies with mapping tables
    4. External Tokenization
    5. Object tagging
  3. 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?

    1. USAGE on database LOGISTICS
    2. USAGE on schema LOGISTICS.SHIPPING
    3. REFERENCES on table ROUTES
    4. OPERATE on warehouse OPS_WH
  4. 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?

    1. Nothing, because DEFAULT_ROLE grants the role at first login
    2. Running GRANT ROLE analyst TO USER for that user
    3. Setting DEFAULT_SECONDARY_ROLES = ('ALL') on the user
    4. Granting role ANALYST to role SYSADMIN
  5. Table 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?

    1. DATA_OPS owns it, and BI_READ has no privileges on it
    2. RELEASE_MGR owns it, and BI_READ has SELECT on it
    3. DATA_OPS owns it, and BI_READ has SELECT on it
    4. RELEASE_MGR owns it, and BI_READ has no privileges on it
  6. 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?

    1. GRANT ROLE sysadmin TO ROLE ml_eng;
    2. GRANT ROLE ml_eng TO ROLE sysadmin;
    3. GRANT OWNERSHIP ON ALL TABLES IN SCHEMA analytics.features TO ROLE sysadmin COPY CURRENT GRANTS;
    4. GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA analytics.features TO ROLE sysadmin;
  7. Why would a data engineer create a secure view instead of a standard view? (Choose two.)

    1. To encrypt the view's results in transit
    2. To make queries on the view run faster
    3. To mask a column on every access path to the base table
    4. To hide the view's definition from non-owners
    5. To block optimizer shortcuts that expose filtered rows
  8. 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?

    1. ACCOUNTADMIN
    2. USERADMIN
    3. SYSADMIN
    4. SECURITYADMIN
  9. 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?

    1. A projection policy on the REGION column
    2. A secure view over SALES that filters on REGION
    3. A row access policy on SALES mapped to REGION
    4. A masking policy on the REGION column
  10. 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?

    1. A row access policy that reads MARKETING_OPT_IN
    2. A masking policy on MARKETING_OPT_IN
    3. A secure view that uses CASE on PHONE
    4. A conditional masking policy on PHONE
  11. Which statements about database roles are true? (Choose two.)

    1. A database role can be granted to a share.
    2. A database role can be activated with USE ROLE.
    3. A database role can hold CREATE WAREHOUSE on the account.
    4. A database role can be granted directly to a user.
    5. A database role holds privileges only in its database.
  12. 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?

    1. GRANT IMPORTED PRIVILEGES ON DATABASE partner_sales TO ROLE reporting;
    2. GRANT DATABASE ROLE partner_sales.reader TO ROLE reporting;
    3. GRANT USAGE ON SHARE partner_share TO ROLE reporting;
    4. GRANT SELECT ON ALL TABLES IN DATABASE partner_sales TO ROLE reporting;
  13. 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?

    1. Up to 2 hours
    2. Up to 1 hour
    3. Up to 4 hours
    4. Up to 24 hours
  14. A company wants users and role memberships managed in Okta to be created, updated and disabled in Snowflake automatically. What should it configure?

    1. Key-pair authentication on each user
    2. A SCIM security integration
    3. A SAML 2.0 security integration
    4. An External OAuth security integration
  15. A data team creates a user with TYPE = SERVICE for an unattended nightly pipeline. Which methods can this user authenticate with? (Choose two.)

    1. Workload identity federation
    2. Key-pair authentication
    3. SAML single sign-on in a browser
    4. Password with a Duo push
    5. Password with an authenticator app (TOTP)
  16. 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?

    1. The connection is refused, because blocked lists from both policies apply
    2. The connection is refused, because the account policy blocks that address
    3. The connection is allowed, because only the user-level policy is evaluated
    4. The connection is allowed only after an administrator approves the exception
  17. 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?

    1. A separate masking policy written for each table
    2. A masking policy assigned to a tag
    3. A row access policy that calls IS_ROLE_IN_SESSION()
    4. A secure view in front of each of the 40 tables
  18. Which statements about network policies are true? (Choose two.)

    1. A network policy can limit which rows a role sees in a table.
    2. A network policy's name includes its database and schema.
    3. A policy with empty allowed and blocked lists allows every address.
    4. An address on both the allowed and blocked lists is refused.
    5. A policy on a security integration overrides a user-level policy.
  19. 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?

    1. Dynamic Data Masking that unmasks for the authorized role
    2. External Tokenization with detokenization at query time
    3. A secure view that exposes the column to that role only
    4. A row access policy that hides rows from other roles
  20. 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?

    1. An "insufficient privileges" error
    2. The LATAM rows only
    3. Every row, with the REGION column masked
    4. Zero rows, and the query succeeds
  21. 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?

    1. GRANT OWNERSHIP ON SCHEMA raw TO ROLE analyst;
    2. GRANT USAGE ON SCHEMA raw TO ROLE analyst WITH GRANT OPTION;
    3. GRANT SELECT ON FUTURE TABLES IN SCHEMA raw TO ROLE analyst;
    4. GRANT SELECT ON ALL TABLES IN SCHEMA raw TO ROLE analyst;
  22. 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?

    1. Neither, until the view is refreshed
    2. REPORTING and FINANCE_RO
    3. REPORTING only
    4. FINANCE_RO only
  23. Which are Snowflake's recommended practices for the ACCOUNTADMIN role? (Choose two.)

    1. Grant it to at least two users.
    2. Use it to run automated scripts and pipelines.
    3. Require MFA for every user who holds it.
    4. Use it to create databases and warehouses day to day.
    5. Make it the default role of every administrator.
  24. 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?

    1. Convert the schema to a managed access schema
    2. Add future grants on the schema for each consuming role
    3. Attach a row access policy to every table in the schema
    4. Transfer ownership of each new table to SECURITYADMIN
  25. 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?

    1. USERADMIN
    2. SECURITYADMIN
    3. SYSADMIN
    4. ORGADMIN
  26. 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.)

    1. They can be set up as FUTURE grants on a schema.
    2. They can't include CREATE or OWNERSHIP privileges.
    3. They can be granted only by SECURITYADMIN, not by the object's owner.
    4. They can be granted only to users of TYPE = SERVICE.
    5. They stay in place until someone revokes them.
  27. 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?

    1. The POLICY_REFERENCES view
    2. The LOGIN_HISTORY view
    3. The QUERY_HISTORY view
    4. The ACCESS_HISTORY view
  28. 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?

    1. An error, because masked columns can't be read by ACCOUNTADMIN
    2. Real values, because ACCOUNTADMIN inherits COMP_ADMIN through SYSADMIN
    3. Masked values, because CURRENT_ROLE() returns ACCOUNTADMIN
    4. Real values, because ACCOUNTADMIN is exempt from masking policies
  29. 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.)

    1. Privileges of roles granted to ANALYST
    2. Privileges granted to role DATA_ENGINEER
    3. Privileges granted to role ANALYST
    4. Privileges granted to role SYSADMIN
    5. Privileges granted to role PUBLIC
  30. 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?

    1. It succeeds, and DATA_ENGINEER becomes the table's owner
    2. It succeeds, and the user personally owns the table
    3. It fails, since only the primary role authorizes CREATE
    4. It succeeds, and ANALYST owns the new table