Snowflake SnowPro Core COF-C03 Practice Test 107
Question 1060
[Identity and governance change request] A reviewer recommends: Create and attach an appropriate Snowflake network policy or network rule-based policy for the specified identities and IP ranges. The requirement remains: A governance team is evaluating a controlled policy rollout without relaxing unrelated account access. An organization must restrict logins to approved corporate egress ranges even when credentials are correct. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which explanation best justifies this recommendation?
- Masking evaluates the policy at query time so access to rows need not imply visibility of the underlying sensitive value.
- Classification identifies candidate sensitive data; policy enforcement is a separate governance decision that requires accurate mapping.
- Roles can inherit privileges from other roles through deliberate grants, making functional privilege layering auditable.
- Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy.
Explanation
Correct Answer
D:In this identity and governance change request context, Network restrictions add connection-layer allow/deny rules; SQL role grants do not enforce origin address policy. The recommendation is linked to observable evidence for this exact case: An approved corporate source can connect while a test connection from an excluded source is rejected. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:For the identity and governance change request conditions, Masking evaluates the policy at query time so access to rows need not imply visibility of the underlying sensitive value. That explanation applies to a different dynamic data masking policy problem: A customer table contains national identifiers; privileged reviewers may see full values but ordinary analysts should receive redacted values. It does not justify the specific network policy address restrictions action or its validation path: An approved corporate source can connect while a test connection from an excluded source is rejected.
B:Classification identifies candidate sensitive data; policy enforcement is a separate governance decision that requires accurate mapping.
C:That option concerns inherited functional role grants, not the requirement in this case. It does not justify the specific network policy address restrictions action or its validation path: An approved corporate source can connect while a test connection from an excluded source is rejected.
Question 1061
[Security control assessment] A reviewer recommends: Attach a dynamic data masking policy to the sensitive column with conditions appropriate for the approved role model. The requirement remains: A quarterly access-control audit requires an evidence-backed answer. A customer table contains national identifiers; privileged reviewers may see full values but ordinary analysts should receive redacted values. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which explanation best justifies this recommendation?
- Masking evaluates the policy at query time so access to rows need not imply visibility of the underlying sensitive value.
- Dynamic tables express desired query results declaratively and Snowflake orchestrates refresh instead of requiring a bespoke stream/task graph for every stage.
- Classification identifies candidate sensitive data; policy enforcement is a separate governance decision that requires accurate mapping.
- Snowflake's role-based access control separates namespace visibility from object-level privileges and does not require administrative ownership for reading.
Explanation
Correct Answer
A:In this security control assessment context, Masking evaluates the policy at query time so access to rows need not imply visibility of the underlying sensitive value. The recommendation is linked to observable evidence for this exact case: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
B:For the security control assessment conditions, Dynamic tables express desired query results declaratively and Snowflake orchestrates refresh instead of requiring a bespoke stream/task graph for every stage. That explanation applies to a different dynamic table declarative refresh problem: A reporting team wants a transformation query to maintain refreshed output automatically under a target freshness requirement. It does not justify the specific dynamic data masking policy action or its validation path: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
C:That explanation applies to a different automated sensitive-data classification problem: A governance group is auditing hundreds of columns for sensitive categories before attaching masking controls.
D:For the security control assessment conditions, Snowflake's role-based access control separates namespace visibility from object-level privileges and does not require administrative ownership for reading. That explanation applies to a different least-privilege read role problem: A finance analyst needs SELECT on a curated reporting view but must not modify the underlying transactions table or own the database. It does not justify the specific dynamic data masking policy action or its validation path: The same column returns full data for an authorized reviewer and masked data for a standard analyst under controlled tests.
Question 1062
[Architecture planning workshop] The team proposes: Publish an appropriately designed secure view and grant only the needed access to the consumer role. Its actual requirement is: An internal platform architecture group is assessing the initial design. A data provider must hide sensitive query definition details while exposing a restricted projection of source data to consumers. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows.
- The consumer can select authorized rows and columns without seeing prohibited source objects or view-definition details.
- SHOW GRANTS shows only the intended USAGE and SELECT path, and a tested UPDATE against the base table is denied.
- The dashboard query can benefit from the maintained aggregate and maintenance costs fit the service budget.
Explanation
Correct Answer
B:The consumer can select authorized rows and columns without seeing prohibited source objects or view-definition details. This is an outcome test of the specified secure view exposure boundary action under the architecture planning workshop conditions. Secure views add protection against exposure of their underlying definition and some optimizer behavior compared with ordinary views.
Incorrect Answers
A:In this architecture planning workshop context, Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows. This is an outcome for a different requirement: Business users want to ask plain-language questions against governed structured metrics with defined business terminology. It cannot by itself validate the proposed secure view exposure boundary action; the appropriate test is: The consumer can select authorized rows and columns without seeing prohibited source objects or view-definition details.
C:SHOW GRANTS shows only the intended USAGE and SELECT path, and a tested UPDATE against the base table is denied. This is an outcome for a different requirement: A finance analyst needs SELECT on a curated reporting view but must not modify the underlying transactions table or own the database. It cannot by itself validate the proposed secure view exposure boundary action; the appropriate test is: The consumer can select authorized rows and columns without seeing prohibited source objects or view-definition details.
D:The dashboard query can benefit from the maintained aggregate and maintenance costs fit the service budget. This is an outcome for a different requirement: A dashboard repeatedly calculates the same expensive aggregate over a large base table while the source changes incrementally. It cannot by itself validate the proposed secure view exposure boundary action; the appropriate test is: The consumer can select authorized rows and columns without seeing prohibited source objects or view-definition details.
Question 1063
[Peak traffic performance incident] 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 BI engineer is investigating the exact bottleneck observed under production-like load. A mobile application sends JSON documents with evolving optional fields, and developers want to retain the nested payload without predefining every scalar column. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- 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.
- Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows.
Explanation
Correct Answer
C: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 peak traffic performance incident conditions. VARIANT supports semi-structured values and path access, unlike a single plain numeric column for arbitrarily nested data.
Incorrect Answers
A:In this peak traffic performance incident 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.
B:In this peak traffic performance incident 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.
D:Representative business questions produce reviewable SQL aligned with the approved semantic definitions and permitted result rows. This is an outcome for a different requirement: Business users want to ask plain-language questions against governed structured metrics with defined business terminology. 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 1064
[Security control assessment] A reviewer recommends: Use a managed access schema and put the relevant grant authority under the schema owner or a role with MANAGE GRANTS. The requirement remains: A quarterly access-control audit requires an evidence-backed answer. A governance team wants object owners inside a schema to be unable to distribute arbitrary grants without review by the schema's grant administrator. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which explanation best justifies this recommendation?
- Roles can inherit privileges from other roles through deliberate grants, making functional privilege layering auditable.
- Warehouses provide compute; they are not parents of schemas or tables within the Snowflake object catalog.
- Future grants apply designated privileges to newly created objects and avoid uncontrolled ad hoc grant repetition.
- Managed access centralizes grant management and changes who can authorize privileges on contained objects.
Explanation
Correct Answer
D:In this security control assessment context, Managed access centralizes grant management and changes who can authorize privileges on contained objects. The recommendation is linked to observable evidence for this exact case: A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:It does not justify the specific managed access schema grants action or its validation path: A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
B:For the security control assessment conditions, Warehouses provide compute; they are not parents of schemas or tables within the Snowflake object catalog. That explanation applies to a different account and schema object hierarchy problem: A developer tries to locate a table by naming a warehouse as its parent and cannot determine where the object should be created. It does not justify the specific managed access schema grants action or its validation path: A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
C:That option concerns future grants in new schema, not the requirement in this case. It does not justify the specific managed access schema grants action or its validation path: A table owner cannot independently grant arbitrary object privileges while the authorized grant administrator can.
Question 1065
[Post-rollout service review] A reviewer recommends: Confirm that the account edition and object support the requested extended Time Travel retention, then set a supported retention period. The requirement remains: An operations group is reassessing the installed data platform after a representative workload trial. A risk team must retain a permanent table's recoverable history for more than one day and also wants enterprise governance capabilities. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- Extended retention for permanent objects is edition-dependent; selecting an appropriate edition precedes setting a longer recoverability window.
- Time Travel supports self-service historical access during configured retention; Fail-safe is not an ordinary user-queryable history store.
- Private connectivity and enhanced security functionality have edition and cloud prerequisites that must be verified independently of ordinary RBAC.
- Permanent tables support Time Travel and a Fail-safe period; choosing transient storage would change recoverability guarantees.
Explanation
Correct Answer
A:In this post-rollout service review context, Extended retention for permanent objects is edition-dependent; selecting an appropriate edition precedes setting a longer recoverability window. The recommendation is linked to observable evidence for this exact case: Account edition and the table's retention parameter demonstrate a supported value, and a within-window historical read succeeds. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
B:For the post-rollout service review conditions, Time Travel supports self-service historical access during configured retention; Fail-safe is not an ordinary user-queryable history store. That explanation applies to a different time travel versus fail-safe recoverability problem: A production permanent table was dropped within its configured retention period, and an operator needs a self-service recovery plan rather than a support escalation. It does not justify the specific enterprise edition feature selection action or its validation path: Account edition and the table's retention parameter demonstrate a supported value, and a within-window historical read succeeds.
C:That option concerns business critical private connectivity, not the requirement in this case. It does not justify the specific enterprise edition feature selection action or its validation path: Account edition and the table's retention parameter demonstrate a supported value, and a within-window historical read succeeds.
D:That option concerns permanent table recovery choice, not the requirement in this case. It does not justify the specific enterprise edition feature selection action or its validation path: Account edition and the table's retention parameter demonstrate a supported value, and a within-window historical read succeeds.
Question 1066
[Post-rollout service review] The team proposes: Create a temporary table for the session-scoped scratch result and avoid relying on it after disconnect. Its actual requirement is: An operations group is reassessing the installed data platform after a representative workload trial. A SQL worksheet needs a scratch table only for calculations performed in a single session and must not expose it as a durable shared object. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- The table reports TRANSIENT type, and a documented rerun reconstructs the intermediate rows without relying on Fail-safe.
- The scratch object is visible in its creator session and ceases to be a usable persistent dataset after the session ends.
- Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension.
- Both analysts resolve the same fully qualified table after aligning role permissions and namespace context.
Explanation
Correct Answer
B:The scratch object is visible in its creator session and ceases to be a usable persistent dataset after the session ends. This is an outcome test of the specified temporary session-bound data action under the post-rollout service review conditions. Temporary tables are session-scoped and suited to disposable intermediate data, unlike persistent shared tables.
Incorrect Answers
A:In this post-rollout service review context, The table reports TRANSIENT type, and a documented rerun reconstructs the intermediate rows without relying on Fail-safe. This is an outcome for a different requirement: An ingestion team keeps rebuildable intermediate records with no requirement for Snowflake-managed Fail-safe recovery. It cannot by itself validate the proposed temporary session-bound data action; the appropriate test is: The scratch object is visible in its creator session and ceases to be a usable persistent dataset after the session ends.
C:In this post-rollout service review context, Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension. This is an outcome for a different requirement: An administrator suspends every reporting warehouse overnight and the operations manager fears that previously committed tables will be erased. It cannot by itself validate the proposed temporary session-bound data action; the appropriate test is: The scratch object is visible in its creator session and ceases to be a usable persistent dataset after the session ends.
D:In this post-rollout service review context, 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 temporary session-bound data action; the appropriate test is: The scratch object is visible in its creator session and ceases to be a usable persistent dataset after the session ends.
Question 1067
[Optimization regression test] A reviewer recommends: Inspect spill and execution profile, then evaluate more memory, predicate reduction, or join/query restructuring. The requirement remains: A team is validating a targeted tuning plan against documented workloads and costs. A large GROUP BY and join spills extensively to remote storage and takes much longer than expected even without query queueing. The conclusion must be justified with observable verification rather than an undocumented assumption. Which explanation best justifies this recommendation?
- A single heavyweight query's memory and compute needs are a scale-up or query-tuning problem, not inherently a scale-out problem.
- Query Acceleration Service can offload eligible query components to shared compute; it does not replace base warehouse execution for every operation.
- Remote spill reflects insufficient in-memory execution resources or excessive intermediate data, unlike simple concurrency queue time.
- Query Profile provides evidence about actual execution instead of assuming all slow SQL has the same cause.
Explanation
Correct Answer
C:In this optimization regression test context, Remote spill reflects insufficient in-memory execution resources or excessive intermediate data, unlike simple concurrency queue time. The recommendation is linked to observable evidence for this exact case: Remote spill bytes and elapsed time decrease on a representative workload after the targeted change. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns warehouse scale-up for complex query, not the requirement in this case. It does not justify the specific remote spill diagnosis action or its validation path: Remote spill bytes and elapsed time decrease on a representative workload after the targeted change.
B:That option concerns query acceleration service suitability, not the requirement in this case. It does not justify the specific remote spill diagnosis action or its validation path: Remote spill bytes and elapsed time decrease on a representative workload after the targeted change.
D:That option concerns query profile bottleneck localization, not the requirement in this case. It does not justify the specific remote spill diagnosis action or its validation path: Remote spill bytes and elapsed time decrease on a representative workload after the targeted change.
Question 1068
[Provider and consumer workshop] A data collaboration team is defining the permitted provider and consumer relationship. A publisher needs customers to discover and request an approved dataset through a catalog rather than exchange account identifiers manually. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which Snowflake action best meets this specific requirement?
- Evaluate and provision a Snowflake reader account with authorized shares and documented provider billing responsibilities.
- Configure supported database or account replication and plan promotion or failover procedures for the desired recovery objectives.
- Create a secure direct share for eligible objects and grant it to the approved consumer account under supported region and cloud conditions.
- Create and govern a suitable Snowflake Marketplace listing with the intended visibility, terms, and fulfillment model.
Explanation
Correct Answer
D:In this provider and consumer workshop setting, the intended validation is: An eligible test consumer finds the listing and follows its access or request workflow without unauthorized source-table exposure.
Incorrect Answers
A:It is not the primary action for the stated marketplace listing discovery need.
B:That action is relevant when A multinational organization requires a recoverable approved dataset in another supported Snowflake account region for resilience planning. It is not the primary action for the stated marketplace listing discovery need.
C:That action is relevant when A Snowflake data provider wants a business partner who already has a Snowflake account to query governed datasets without copying daily CSV exports. Create a secure direct share for eligible objects and grant it to the approved consumer account under supported region and cloud conditions.
Question 1069
[Production compliance review] A compliance reviewer is checking which safeguard actually enforces the stated boundary. Compliance teams reconcile last week's credit spending and access history across the account and need consistent long-range audit views. The conclusion must be justified with observable verification rather than an undocumented assumption. Which specific design mistake would most directly defeat the intended result?
- Treat ACCOUNT_USAGE as a zero-latency feed and conclude recent events never occurred when rows are delayed.
- Resize compute warehouses to hide a missing authentication policy finding from the security dashboard.
- Resize the warehouse without checking session role activation because compute can substitute for a dormant access role.
- Write one object-storage CSV per row and assume ordinary hourly COPY INTO is a direct streaming interface.
Explanation
Correct Answer
A:The discriminating technical reason is: Account usage views support historical auditing but can lag live activity; they are distinct from instant session state. Treat ACCOUNT_USAGE as a zero-latency feed and conclude recent events never occurred when rows are delayed.
Incorrect Answers
B:That is a mistake for a different trust center posture findings task, where A security officer needs a centralized view of account configuration risks such as weak account controls and recommended fixes. Under production compliance review conditions, Resize compute warehouses to hide a missing authentication policy finding from the security dashboard.
C:Under production compliance review conditions, Resize the warehouse without checking session role activation because compute can substitute for a dormant access role. It does not directly defeat the present account_usage audit latency requirement, whose proper treatment is: Query appropriate SNOWFLAKE.ACCOUNT_USAGE views with awareness of documented ingestion latency and necessary privileges.
D:That is a mistake for a different snowpipe streaming low latency task, where An IoT product emits row events continuously and needs lower-latency ingestion than file-batched loading provides. Under production compliance review conditions, Write one object-storage CSV per row and assume ordinary hourly COPY INTO is a direct streaming interface.
Question 1070
[Query performance review] 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 Snowflake action best meets this specific requirement?
- Inspect pruning and the overlap of the filter column's values, then tune a supported clustering strategy if warranted.
- Load the payload into a VARIANT column and use supported path extraction and casts for downstream typed calculations.
- Define and attach a row access policy that evaluates approved regional role or mapping criteria.
- Use Snowflake PIVOT on the supported aggregation and quarter categories or an equivalent conditional aggregate.
Explanation
Correct Answer
B:VARIANT supports semi-structured values and path access, unlike a single plain numeric column for arbitrarily nested data. In this query performance review setting, the intended validation is: SELECT of nested attributes returns expected scalar values and missing optional fields are handled according to the SQL logic.
Incorrect Answers
A:That action is relevant when A daily operational report filters on a narrow event-time range yet scans nearly the entire multi-terabyte event table. VARIANT supports semi-structured values and path access, unlike a single plain numeric column for arbitrarily nested data.
C:That action is relevant when Regional managers share a table but must see only the geographic rows permitted by their assigned region. VARIANT supports semi-structured values and path access, unlike a single plain numeric column for arbitrarily nested data.
D:That action is relevant when A quarterly metrics report stores one row per region and quarter but the executive view needs a separate column for each quarter. VARIANT supports semi-structured values and path access, unlike a single plain numeric column for arbitrarily nested data.