Snowflake SnowPro Core COF-C03 Practice Test 9
Question 80
[Production compliance review] A compliance reviewer is checking which safeguard actually enforces the stated boundary. Analysts repeatedly lose approved read access whenever the ingestion team creates another table in a governed reporting schema. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Plan an explicit OWNERSHIP transfer with the appropriate grant-management options and test dependent grants before cutover.
- Use the account, database, schema, and object hierarchy and reference the table using database.schema.table where appropriate.
- Use a managed access schema and put the relevant grant authority under the schema owner or a role with MANAGE GRANTS.
- Configure appropriate future grants for the required schema scope while preserving narrowly defined access roles.
Explanation
Correct Answer
D:Future grants apply designated privileges to newly created objects and avoid uncontrolled ad hoc grant repetition. In this production compliance review setting, the intended validation is: A newly created sample table receives the expected SELECT grant without adding unrelated elevated ownership.
Incorrect Answers
A:That action is relevant when A pipeline service role has object OWNERSHIP but its replacement needs controlled transfer with minimal risk to existing privilege chains. It is not the primary action for the stated future grants in new schema need.
B:That action is relevant when A developer tries to locate a table by naming a warehouse as its parent and cannot determine where the object should be created. It is not the primary action for the stated future grants in new schema need.
C:That action is relevant when A governance team wants object owners inside a schema to be unable to distribute arbitrary grants without review by the schema's grant administrator. It is not the primary action for the stated future grants in new schema need.
Question 81
[Identity and governance change request] A reviewer recommends: Enforce and verify appropriate Snowflake MFA or federated IdP MFA controls according to the active policy. The requirement remains: A governance team is evaluating a controlled policy rollout without relaxing unrelated account access. A data platform security assessment finds interactive users have weak password-only sign-in and require a stronger authentication factor. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- MFA protects interactive sign-in beyond knowledge of a single password; it is separate from table permissions.
- Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy.
- Access control and query planning belong to Snowflake cloud services; extra warehouse CPU does not grant missing privileges.
- Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling.
Explanation
Correct Answer
A:In this identity and governance change request context, MFA protects interactive sign-in beyond knowledge of a single password; it is separate from table permissions. The recommendation is linked to observable evidence for this exact case: Identity logs and a controlled sign-in test show the required second factor before an authorized session starts. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
B:That option concerns network policy address restrictions, not the requirement in this case. Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy.
C:That option concerns cloud services authentication boundary, not the requirement in this case. It does not justify the specific multifactor authentication enrollment action or its validation path: Identity logs and a controlled sign-in test show the required second factor before an authorized session starts.
D:That option concerns workload identity key-pair authentication, not the requirement in this case. Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling.
Question 82
[Security control assessment] A quarterly access-control audit requires an evidence-backed answer. A new team proposes using SYSADMIN as the day-to-day analyst role solely because it conveniently creates warehouses. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Create a narrowly scoped reader role with USAGE on parent containers and SELECT on the approved view, then grant it to the user.
- Define custom least-privilege operational roles and keep broad system roles for controlled administration duties.
- Configure a supported federated SSO security integration and verify identity, certificates, and account routing.
- Inspect the active primary role and secondary-role configuration rather than assuming all granted roles participate in each statement.
Explanation
Correct Answer
B:System-defined administrative roles are broad; custom roles can reflect separation of duties without giving each analyst infrastructure authority. In this security control assessment setting, the intended validation is: Analyst queries work under the custom role while CREATE WAREHOUSE and global role-management attempts are denied.
Incorrect Answers
A:That action is relevant when A finance analyst needs SELECT on a curated reporting view but must not modify the underlying transactions table or own the database. It is not the primary action for the stated custom roles versus system roles need.
C:That action is relevant when An enterprise uses a corporate identity provider and wants centrally controlled employee login instead of unmanaged separate passwords. It is not the primary action for the stated custom roles versus system roles need.
D:That action is relevant when A user has an approved reporting role and a separate engineering role but a worksheet unexpectedly lacks SELECT even though the second role has the grant. It is not the primary action for the stated custom roles versus system roles need.
Question 83
[Post-rollout service review] An operations group is reassessing the installed data platform after a representative workload trial. A support workflow needs a concise natural-language summary of customer messages rather than a numeric SQL aggregation. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Assume a dynamic table is updated instantly on every source write regardless of its refresh behavior and target lag.
- Grant SELECT on the source table and assume this automatically authorizes unrestricted outbound HTTPS calls to any public API.
- Expect a standard numeric aggregation function to generate a context-aware natural-language synopsis of message meaning.
- Treat an arbitrary external CSV stage as an automatically write-compatible Iceberg table without creating table metadata.
Explanation
Correct Answer
C:The discriminating technical reason is: A generative or summarization function fits a text transformation task, whereas a SQL COUNT does not express a message summary. This directly undermines cortex generative text operation in the specified context.
Incorrect Answers
A:That is a mistake for a different dynamic table declarative refresh task, where A reporting team wants a transformation query to maintain refreshed output automatically under a target freshness requirement. Under post-rollout service review conditions, Assume a dynamic table is updated instantly on every source write regardless of its refresh behavior and target lag.
B:That is a mistake for a different external function api integration task, where A Snowflake SQL process must invoke an allowed remote service through an established API gateway, with credentials controlled outside analyst worksheets. Under post-rollout service review conditions, Grant SELECT on the source table and assume this automatically authorizes unrestricted outbound HTTPS calls to any public API.
D:That is a mistake for a different iceberg interoperability decision task, where A platform team must exchange a lakehouse table through an Apache Iceberg-compatible metadata/catalog workflow instead of migrating every file to proprietary table storage. Under post-rollout service review conditions, Treat an arbitrary external CSV stage as an automatically write-compatible Iceberg table without creating table metadata.
Question 84
[Query performance review] The team proposes: Load the payload into a VARIANT column and use supported path extraction and casts for downstream typed calculations. Its actual requirement is: A performance engineer is benchmarking representative queries before accepting changes. A mobile application sends JSON documents with evolving optional fields, and developers want to retain the nested payload without predefining every scalar column. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- Separate user-role tests return only the authorized region's row keys while total source data remains unchanged.
- A record with three purchase objects yields three item rows with the same parent identifier and expected element values.
- The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
- SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
Explanation
Correct Answer
D:SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic. This is an outcome test of the specified variant semi-structured access action under the query performance review conditions. VARIANT supports semi-structured values and path access, unlike a single plain numeric column for arbitrarily nested data.
Incorrect Answers
A:In this query performance review context, Separate user-role tests return only the authorized region's row keys while total source data remains unchanged. This is an outcome for a different requirement: Regional managers share a table but must see only the geographic rows permitted by their assigned region. It cannot by itself validate the proposed variant semi-structured access action; the appropriate test is: SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
B:In this query performance review context, A record with three purchase objects yields three item rows with the same parent identifier and expected element values. This is an outcome for a different requirement: An event JSON record contains a purchases array and analysts need one relational row per purchase item while retaining the parent event identifier. It cannot by itself validate the proposed variant semi-structured access action; the appropriate test is: SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
C:In this query performance review context, The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work. This is an outcome for a different requirement: A daily operational report filters on a narrow event-time range yet scans nearly the entire multi-terabyte event table. It cannot by itself validate the proposed variant semi-structured access action; the appropriate test is: SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
Question 85
[Production compliance review] The team proposes: Attach a dynamic data masking policy to the sensitive column with conditions appropriate for the approved role model. Its actual requirement is: A compliance reviewer is checking which safeguard actually enforces the stated boundary. A customer table contains national identifiers; privileged reviewers may see full values but ordinary analysts should receive redacted values. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
- Separate user-role tests return only the authorized region's row keys while total source data remains unchanged.
- Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target.
- Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection.
Explanation
Correct Answer
A:Masking evaluates the policy at query time so access to rows need not imply visibility of the underlying sensitive value. This is an outcome test of the specified dynamic data masking policy action under the production compliance review conditions.
Incorrect Answers
B:In this production compliance review context, Separate user-role tests return only the authorized region's row keys while total source data remains unchanged. This is an outcome for a different requirement: Regional managers share a table but must see only the geographic rows permitted by their assigned region. It cannot by itself validate the proposed dynamic data masking policy action; the appropriate test is: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
C:In this production compliance review context, Dynamic table refresh history and data timestamps show the defined query output meeting the practical freshness target. This is an outcome for a different requirement: A reporting team wants a transformation query to maintain refreshed output automatically under a target freshness requirement. It cannot by itself validate the proposed dynamic data masking policy action; the appropriate test is: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
D:In this production compliance review context, Classification reports flag representative PII columns, and subsequent policy checks demonstrate intended protection. This is an outcome for a different requirement: A governance group is auditing hundreds of columns for sensitive categories before attaching masking controls. It cannot by itself validate the proposed dynamic data masking policy action; the appropriate test is: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
Question 86
[Partner onboarding review] The team proposes: Evaluate the Snowflake Native App Framework and supported listing or package deployment lifecycle for consumers. Its actual requirement is: A privacy reviewer checks a collaboration rollout before new partner access is granted. A software vendor needs to package governed application logic with Snowflake-integrated deployment instead of sending a collection of ad hoc scripts. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model.
- A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
- An eligible test consumer finds the listing and follows its access or request workflow without unauthorized source-table exposure.
- The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
Explanation
Correct Answer
B:A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow. This is an outcome test of the specified native app distribution to consumers action under the partner onboarding review conditions. Native Apps distribute application capabilities with managed privileges and application artifacts under a supported deployment model.
Incorrect Answers
A:In this partner onboarding review context, The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model. This is an outcome for a different requirement: An analytics team wants a small interactive application that queries governed Snowflake data without maintaining a standalone app server. It cannot by itself validate the proposed native app distribution to consumers action; the appropriate test is: A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
C:In this partner onboarding review context, An eligible test consumer finds the listing and follows its access or request workflow without unauthorized source-table exposure. This is an outcome for a different requirement: A publisher needs customers to discover and request an approved dataset through a catalog rather than exchange account identifiers manually. It cannot by itself validate the proposed native app distribution to consumers action; the appropriate test is: A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
D:The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider. This is an outcome for a different requirement: A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. It cannot by itself validate the proposed native app distribution to consumers action; the appropriate test is: A test consumer installs the app, grants only required permissions, and executes the advertised permitted workflow.
Question 87
[Security control assessment] The team proposes: Inspect Snowflake Trust Center findings and follow documented remediation and review workflow for the supported account. Its actual requirement is: A quarterly access-control audit requires an evidence-backed answer. A security officer needs a centralized view of account configuration risks such as weak account controls and recommended fixes. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- Historical usage matches billed and recorded account activity after the documented latency window has elapsed.
- A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
- A relevant finding changes state after the corrective configuration and a refreshed review or scan.
- The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider.
Explanation
Correct Answer
C:A relevant finding changes state after the corrective configuration and a refreshed review or scan. This is an outcome test of the specified trust center posture findings action under the security control assessment conditions. Trust Center helps surface account security posture risks; it does not independently grant access or repair every issue automatically.
Incorrect Answers
A:In this security control assessment context, Historical usage matches billed and recorded account activity after the documented latency window has elapsed. This is an outcome for a different requirement: Compliance teams reconcile last week's credit spending and access history across the account and need consistent long-range audit views. It cannot by itself validate the proposed trust center posture findings action; the appropriate test is: A relevant finding changes state after the corrective configuration and a refreshed review or scan.
B:In this security control assessment context, A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can. This is an outcome for a different requirement: A governance team wants object owners inside a schema to be unable to distribute arbitrary grants without review by the schema's grant administrator. It cannot by itself validate the proposed trust center posture findings action; the appropriate test is: A relevant finding changes state after the corrective configuration and a refreshed review or scan.
D:In this security control assessment context, The reader account signs in and queries the intended shared database while billing and warehouse usage are monitored by the provider. This is an outcome for a different requirement: A small research partner needs curated data but has no existing Snowflake account and the provider wants a controlled hosted-consumer path. It cannot by itself validate the proposed trust center posture findings action; the appropriate test is: A relevant finding changes state after the corrective configuration and a refreshed review or scan.
Question 88
[Query performance review] A performance engineer is benchmarking representative queries before accepting changes. A team reruns an unchanged SELECT but sometimes receives cached results and sometimes spends compute again after underlying data changes. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Assign ELT and dashboard queries to separate Snowflake virtual warehouses while keeping shared storage.
- Use ROW_NUMBER with PARTITION BY and an ordered window, then filter the window result with QUALIFY.
- Create an appropriately permissioned named internal stage and define a compatible file format for the incoming files.
- Inspect persisted query result cache eligibility, deterministic SQL, underlying data changes, and result reuse settings.
Explanation
Correct Answer
D:Result reuse depends on strict eligibility and unchanged relevant data; it is distinct from local warehouse data-cache reuse. In this query performance review setting, the intended validation is: Two eligible unchanged executions show a reuse indicator, while changed data causes fresh evaluation under documented conditions.
Incorrect Answers
A:That action is relevant when A retailer's nightly ELT job saturates compute while an unrelated dashboard must keep predictable query latency; both workloads read the same sales tables. It is not the primary action for the stated persisted result reuse conditions need.
B:That action is relevant when A table contains several rows per customer and an analyst wants exactly the latest row for each customer after computing ROW_NUMBER. It is not the primary action for the stated persisted result reuse conditions need.
C:That action is relevant when A team needs a stable staging location where several engineers can PUT source files and run repeatable bulk loads for the same project. It is not the primary action for the stated persisted result reuse conditions need.
Question 89
[Identity and governance change request] A governance team is evaluating a controlled policy rollout without relaxing unrelated account access. A customer table contains national identifiers; privileged reviewers may see full values but ordinary analysts should receive redacted values. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which specific design mistake would most directly defeat the intended result?
- Create a separate unrestricted duplicate table for analysts and rely on a comment saying identifiers are confidential.
- Grant USAGE on a warehouse and assume that alone restricts the connecting client's source IP address.
- Call a standard read-only view a continuously materialized table with guaranteed five-second refresh history.
- Assume a dynamic table is updated instantly on every source write regardless of its refresh behavior and target lag.
Explanation
Correct Answer
A:The discriminating technical reason is: Masking evaluates the policy at query time so access to rows need not imply visibility of the underlying sensitive value. This directly undermines dynamic data masking policy in the specified context.
Incorrect Answers
B:That is a mistake for a different network policy address restrictions task, where An organization must restrict logins to approved corporate egress ranges even when credentials are correct. Under identity and governance change request conditions, Grant USAGE on a warehouse and assume that alone restricts the connecting client's source IP address.
C:That is a mistake for a different dynamic table downstream freshness task, where A pipeline repeatedly joins newly ingested transactions to reference data and needs a declarative freshness objective instead of hand-managed CDC steps. Under identity and governance change request conditions, Call a standard read-only view a continuously materialized table with guaranteed five-second refresh history.
D:That is a mistake for a different dynamic table declarative refresh task, where A reporting team wants a transformation query to maintain refreshed output automatically under a target freshness requirement. Under identity and governance change request conditions, Assume a dynamic table is updated instantly on every source write regardless of its refresh behavior and target lag.
Question 90
[Architecture planning workshop] The team proposes: Use Snowpark for Python with an appropriately provisioned execution context and pushdown-compatible dataframe operations. Its actual requirement is: An internal platform architecture group is assessing the initial design. A data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- SELECT against the external table returns staged records after location metadata has been refreshed appropriately.
- Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.
- Both analysts resolve the same fully qualified table after aligning role permissions and namespace context.
- The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model.
Explanation
Correct Answer
B:Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results. This is an outcome test of the specified snowpark python pushdown action under the architecture planning workshop conditions. Snowpark builds logical plans executed in Snowflake, reducing unnecessary client-side transfers for supported operations.
Incorrect Answers
A:In this architecture planning workshop context, SELECT against the external table returns staged records after location metadata has been refreshed appropriately. This is an outcome for a different requirement: A data scientist needs governed SQL reads over files remaining in external object storage, without an ordinary Snowflake-managed load step. It cannot by itself validate the proposed snowpark python pushdown action; the appropriate test is: Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.
C:Both analysts resolve the same fully qualified table after aligning role permissions and namespace context. This is an outcome for a different requirement: Two analysts run identical unqualified table names but receive different results because their sessions point at different current databases. It cannot by itself validate the proposed snowpark python pushdown action; the appropriate test is: Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.
D:In this architecture planning workshop context, The approved user opens the app and sees data consistent with granted object privileges under the configured app execution model. This is an outcome for a different requirement: An analytics team wants a small interactive application that queries governed Snowflake data without maintaining a standalone app server. It cannot by itself validate the proposed snowpark python pushdown action; the appropriate test is: Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.