Snowflake SnowPro Core COF-C03 Practice Test 114
Question 1130
[Query performance review] The team proposes: Inspect pruning and the overlap of the filter column's values, then tune a supported clustering strategy if warranted. Its actual requirement is: A performance engineer is benchmarking representative queries before accepting changes. A daily operational report filters on a narrow event-time range yet scans nearly the entire multi-terabyte event table. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which observation most directly validates success?
- The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
- The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
- Clustering information and workload-wide latency improve enough to justify the observed maintenance credits.
- A duplicate-key test returns one newest row per customer with deterministic tie-breaking criteria.
Explanation
Correct Answer
B:The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work. This is an outcome test of the specified selective filter micro-partition pruning action under the query performance review conditions. Partition metadata lets Snowflake skip micro-partitions whose ranges cannot satisfy the filter, but scattered values limit effective pruning.
Incorrect Answers
A:In this query performance review context, The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely. This is an outcome for a different requirement: An operations workflow must execute multiple related SQL statements with validation and controlled operational errors in one invocation. It cannot by itself validate the proposed selective filter micro-partition pruning action; the appropriate test is: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
C:In this query performance review context, Clustering information and workload-wide latency improve enough to justify the observed maintenance credits. This is an outcome for a different requirement: A very large orders table receives steady inserts and selective date filters have poor clustering; the team needs a durable performance-versus-credit decision. It cannot by itself validate the proposed selective filter micro-partition pruning action; the appropriate test is: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
D:In this query performance review context, A duplicate-key test returns one newest row per customer with deterministic tie-breaking criteria. This is an outcome for a different requirement: A table contains several rows per customer and an analyst wants exactly the latest row for each customer after computing ROW_NUMBER. It cannot by itself validate the proposed selective filter micro-partition pruning action; the appropriate test is: The report's partition-scan fraction falls and total bytes scanned improve after justified clustering work.
Question 1131
[Pipeline incident investigation] The team proposes: Use the compatible Snowflake Spark connector with the correct authentication, pushdown, and connector settings. Its actual requirement is: An on-call ingestion engineer needs a targeted fix that preserves source-to-target reconciliation. A Spark transformation job must exchange large Snowflake datasets efficiently with a supported connector rather than retrieve millions of rows through a GUI export. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results.
- SHOW GRANTS shows only the intended USAGE and SELECT path, and a tested UPDATE against the base table is denied.
- A representative Spark job reads authorized rows and logs an efficient query plan without exposing credentials.
- Topic offsets and target ingestion counts reconcile after a test publish and planned connector restart.
Explanation
Correct Answer
C:A representative Spark job reads authorized rows and logs an efficient query plan without exposing credentials. This is an outcome test of the specified spark connector distributed read action under the pipeline incident investigation conditions. The Spark connector integrates Snowflake data access with Spark distributed processing and can use supported query pushdown.
Incorrect Answers
A:Query history shows the intended Snowflake-executed statements and the Python client retrieves only intended final results. This is an outcome for a different requirement: A data engineer wants Python dataframe transformations to execute near governed Snowflake data without moving the full dataset to a workstation. It cannot by itself validate the proposed spark connector distributed read action; the appropriate test is: A representative Spark job reads authorized rows and logs an efficient query plan without exposing credentials.
B:In this pipeline incident investigation context, 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 spark connector distributed read action; the appropriate test is: A representative Spark job reads authorized rows and logs an efficient query plan without exposing credentials.
D:In this pipeline incident investigation context, Topic offsets and target ingestion counts reconcile after a test publish and planned connector restart. This is an outcome for a different requirement: A platform receives Kafka events and wants to land them in Snowflake with a connector rather than write a bespoke polling script. It cannot by itself validate the proposed spark connector distributed read action; the appropriate test is: A representative Spark job reads authorized rows and logs an efficient query plan without exposing credentials.
Question 1132
[Architecture planning workshop] A reviewer recommends: Keep data in managed database storage and resume compute only when processing is needed. The requirement remains: An internal platform architecture group is assessing the initial design. An administrator suspends every reporting warehouse overnight and the operations manager fears that previously committed tables will be erased. The reviewer must choose a supported mechanism for the precise requirement, not a generic product feature. Which explanation best justifies this recommendation?
- Unqualified object resolution depends on active session context; the warehouse alone does not specify which schema is targeted.
- Warehouse cache is local compute storage and is not the durable persisted-query-result cache or underlying table storage.
- Warehouses provide compute; they are not parents of schemas or tables within the Snowflake object catalog.
- The database storage layer persists committed table data independently from the lifecycle of virtual warehouse clusters.
Explanation
Correct Answer
D:In this architecture planning workshop context, The database storage layer persists committed table data independently from the lifecycle of virtual warehouse clusters. The recommendation is linked to observable evidence for this exact case: Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension. Merely choosing a nearby feature would not establish the needed capability.
Incorrect Answers
A:That option concerns session database and role context, not the requirement in this case. It does not justify the specific durable database storage separation action or its validation path: Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension.
B:That option concerns warehouse local data cache, not the requirement in this case. It does not justify the specific durable database storage separation action or its validation path: Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension.
C:That option concerns account and schema object hierarchy, not the requirement in this case. It does not justify the specific durable database storage separation action or its validation path: Queries return the same committed rows after a warehouse resumes, while compute credit consumption stops during suspension.
Question 1133
[Post-rollout service review] The team proposes: Plan explicit cross-region collaboration or replication and review cloud and region boundaries before selecting the transfer path. Its actual requirement is: An operations group is reassessing the installed data platform after a representative workload trial. A company operates accounts on two clouds and wants to access a dataset from the second account without assuming storage instantly appears in both regions. The conclusion must be justified with observable verification rather than an undocumented assumption. Which observation most directly validates success?
- Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured.
- The consumer creates a database from the share and can SELECT only granted objects, with provider revocation reflected in access.
- Replication status and a controlled secondary-account query confirm the expected dataset and documented lag.
- SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name.
Explanation
Correct Answer
A:Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured. This is an outcome test of the specified cross-region snowflake account planning action under the post-rollout service review conditions. Accounts have specific cloud and region locations, and cross-region data movement or listings require deliberate supported configuration.
Incorrect Answers
B:The consumer creates a database from the share and can SELECT only granted objects, with provider revocation reflected in access. This is an outcome for a different requirement: A Snowflake data provider wants a business partner who already has a Snowflake account to query governed datasets without copying daily CSV exports. It cannot by itself validate the proposed cross-region snowflake account planning action; the appropriate test is: Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured.
C:In this post-rollout service review context, Replication status and a controlled secondary-account query confirm the expected dataset and documented lag. This is an outcome for a different requirement: A multinational organization requires a recoverable approved dataset in another supported Snowflake account region for resilience planning. It cannot by itself validate the proposed cross-region snowflake account planning action; the appropriate test is: Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured.
D:In this post-rollout service review context, SHOW TABLES in the intended schema finds the table and the three-part object identifier resolves independently of warehouse name. This is an outcome for a different requirement: A developer tries to locate a table by naming a warehouse as its parent and cannot determine where the object should be created. It cannot by itself validate the proposed cross-region snowflake account planning action; the appropriate test is: Account region details, provider listing or replication status, and receiver access demonstrate that the target geography was configured.
Question 1134
[Post-rollout service review] An operations group is reassessing the installed data platform after a representative workload trial. An audited production dataset requires recovery mechanisms beyond a short staging lifecycle, and accidental deletion is a realistic threat. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Use applicable Time Travel UNDROP or historical recovery inside retention, recognizing that Fail-safe is a separate Snowflake-managed last resort.
- Use an appropriate permanent table with supported Time Travel retention and understand its Fail-safe protection.
- Use a transient table for rebuildable intermediate storage after documenting its shorter recovery protections.
- Select a strict COPY INTO error policy such as ABORT_STATEMENT and reconcile source counts before releasing downstream results.
Explanation
Correct Answer
B:Permanent tables support Time Travel and a Fail-safe period; choosing transient storage would change recoverability guarantees. In this post-rollout service review setting, the intended validation is: Table type and retention settings match the policy and a controlled within-retention restoration test succeeds.
Incorrect Answers
A:That action is relevant when 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. Use applicable Time Travel UNDROP or historical recovery inside retention, recognizing that Fail-safe is a separate Snowflake-managed last resort.
C:It is not the primary action for the stated permanent table recovery choice need.
D:That action is relevant when A financial batch is required to fail atomically when any unexpected malformed source record appears rather than silently omit data. Permanent tables support Time Travel and a Fail-safe period; choosing transient storage would change recoverability guarantees.
Question 1135
[Peak traffic performance incident] The team proposes: Implement an authorized stored procedure in a supported language and test its transactional and error-handling semantics. Its actual requirement is: A BI engineer is investigating the exact bottleneck observed under production-like load. An operations workflow must execute multiple related SQL statements with validation and controlled operational errors in one invocation. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- Queue time falls under concurrent load as cluster counts rise within the configured limits and resource usage remains observable.
- The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows.
- The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
- SELECT using the function gives the same result as the underlying expression for a boundary-value test set.
Explanation
Correct Answer
C:The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely. This is an outcome test of the specified stored procedure multi-step operation action under the peak traffic performance incident conditions. Stored procedures are suited to multi-statement procedural logic; ordinary scalar UDFs have different side-effect and execution constraints.
Incorrect Answers
A:In this peak traffic performance incident context, Queue time falls under concurrent load as cluster counts rise within the configured limits and resource usage remains observable. This is an outcome for a different requirement: During a product launch dozens of short BI queries queue even though each individual query already finishes quickly once it starts. It cannot by itself validate the proposed stored procedure multi-step operation action; the appropriate test is: The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
B:In this peak traffic performance incident context, The malformed test file causes the controlled load to abort without accepting an incomplete batch of financial rows. This is an outcome for a different requirement: A financial batch is required to fail atomically when any unexpected malformed source record appears rather than silently omit data. It cannot by itself validate the proposed stored procedure multi-step operation action; the appropriate test is: The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
D:In this peak traffic performance incident context, SELECT using the function gives the same result as the underlying expression for a boundary-value test set. This is an outcome for a different requirement: Several analytics teams need the same small deterministic transformation that returns one scalar value and is naturally expressed in SQL. It cannot by itself validate the proposed stored procedure multi-step operation action; the appropriate test is: The procedure reports a controlled result after applying the permitted sequence and handles the simulated error path safely.
Question 1136
[Production migration readiness] A production migration team is preparing a controlled cutover; the solution must preserve existing account isolation. A financial-services project requires a supported private connectivity pattern and enhanced compliance options rather than access from arbitrary public networks. 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?
- Use Cortex Search as though it alone provides a certified semantic definition of revenue aggregations in every structured table.
- Set a 90-day retention value in an unsupported edition and presume the statement will override product limits.
- Enable an extra data analyst role and assume it automatically creates a cloud PrivateLink endpoint.
- Assume ordinary SQL grants automatically create a private cloud endpoint or satisfy infrastructure-level isolation requirements.
Explanation
Correct Answer
D:The discriminating technical reason is: Private connectivity and enhanced security functionality have edition and cloud prerequisites that must be verified independently of ordinary RBAC. Assume ordinary SQL grants automatically create a private cloud endpoint or satisfy infrastructure-level isolation requirements.
Incorrect Answers
A:Under production migration readiness conditions, Use Cortex Search as though it alone provides a certified semantic definition of revenue aggregations in every structured table. That is a mistake for a different cortex analyst structured nl-to-sql task, where Business users want to ask plain-language questions against governed structured metrics with defined business terminology. It does not directly defeat the present business critical private connectivity requirement, whose proper treatment is: Evaluate the Business Critical or otherwise eligible edition and configure a supported private connectivity option for its cloud.
B:That is a mistake for a different enterprise edition feature selection task, where A risk team must retain a permanent table's recoverable history for more than one day and also wants enterprise governance capabilities. Under production migration readiness conditions, Set a 90-day retention value in an unsupported edition and presume the statement will override product limits.
C:That is a mistake for a different private network endpoint verification task, where A sensitive integration requires clients to use supported private cloud networking instead of routing all traffic through public endpoints. Under production migration readiness conditions, Enable an extra data analyst role and assume it automatically creates a cloud PrivateLink endpoint.
Question 1137
[Optimization regression test] A team is validating a targeted tuning plan against documented workloads and costs. A churn dataset has multiple events with identical timestamps per customer, and selecting the latest without a tie-breaker gives inconsistent winners. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Specify a deterministic secondary ordering key in ROW_NUMBER or another suitable window ranking expression.
- Use a supported API integration and external function pattern after confirming cloud/platform and security requirements.
- Create a scoped SQL user-defined function and grant the appropriate usage privileges to consuming roles.
- Use a deterministic MERGE condition on a true business key with MATCHED UPDATE and NOT MATCHED INSERT branches.
Explanation
Correct Answer
A:Window ordering must resolve ties to make latest-record selection reproducible across executions. In this optimization regression test setting, the intended validation is: A regression test with tied timestamps always chooses the same event according to the documented tie-breaker.
Incorrect Answers
B:That action is relevant when A Snowflake SQL process must invoke an allowed remote service through an established API gateway, with credentials controlled outside analyst worksheets. Window ordering must resolve ties to make latest-record selection reproducible across executions.
C:That action is relevant when Several analytics teams need the same small deterministic transformation that returns one scalar value and is naturally expressed in SQL. Window ordering must resolve ties to make latest-record selection reproducible across executions.
D:That action is relevant when A CRM staging feed has new customers and changed addresses and needs an idempotent update-or-insert into the curated customer table. Window ordering must resolve ties to make latest-record selection reproducible across executions.
Question 1138
[Production compliance review] A compliance reviewer is checking which safeguard actually enforces the stated boundary. A pipeline service role has object OWNERSHIP but its replacement needs controlled transfer with minimal risk to existing privilege chains. The conclusion must be justified with observable verification rather than an undocumented assumption. Which Snowflake action best meets this specific requirement?
- Inspect the active primary role and secondary-role configuration rather than assuming all granted roles participate in each statement.
- Plan an explicit OWNERSHIP transfer with the appropriate grant-management options and test dependent grants before cutover.
- Define custom least-privilege operational roles and keep broad system roles for controlled administration duties.
- Configure appropriate future grants for the required schema scope while preserving narrowly defined access roles.
Explanation
Correct Answer
B:Ownership is a distinct powerful privilege; transferring it can affect existing grants and operational control. In this production compliance review setting, the intended validation is: SHOW GRANTS confirms the new owner and the required downstream roles retain the intended authorized operations.
Incorrect Answers
A: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 ownership transfer safety need.
C:That action is relevant when A new team proposes using SYSADMIN as the day-to-day analyst role solely because it conveniently creates warehouses. Ownership is a distinct powerful privilege; transferring it can affect existing grants and operational control.
D:That action is relevant when Analysts repeatedly lose approved read access whenever the ingestion team creates another table in a governed reporting schema. Ownership is a distinct powerful privilege; transferring it can affect existing grants and operational control.
Question 1139
[Peak traffic performance incident] A BI engineer is investigating the exact bottleneck observed under production-like load. Analytical reports experience sporadic expensive, selective scan work that can benefit from offloading qualifying fragments. 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?
- Use a plain view with an identical SELECT and assume it stores refreshed aggregate rows permanently at no cost.
- Add idle multi-cluster capacity without investigating the one query's spill or plan shape.
- Assume switching on the service guarantees every simple SELECT is accelerated without checking eligibility.
- Buy a larger warehouse immediately without examining the query's active operators or whether the delay is queueing.
Explanation
Correct Answer
C:The discriminating technical reason is: Query Acceleration Service can offload eligible query components to shared compute; it does not replace base warehouse execution for every operation. Assume switching on the service guarantees every simple SELECT is accelerated without checking eligibility.
Incorrect Answers
A:Under peak traffic performance incident conditions, Use a plain view with an identical SELECT and assume it stores refreshed aggregate rows permanently at no cost.
B:That is a mistake for a different warehouse scale-up for complex query task, where A warehouse consistently spills intermediate data on a single memory-intensive analytical join while the queue length is close to zero. It does not directly defeat the present query acceleration service suitability requirement, whose proper treatment is: Evaluate Query Acceleration Service eligibility, configuration, and Query Profile signals for the actual workload.
D:It does not directly defeat the present query acceleration service suitability requirement, whose proper treatment is: Evaluate Query Acceleration Service eligibility, configuration, and Query Profile signals for the actual workload.
Question 1140
[Identity and governance change request] The team proposes: Use an appropriately supported programmatic identity with managed key-pair authentication and rotation controls. Its actual requirement is: A governance team is evaluating a controlled policy rollout without relaxing unrelated account access. An unattended ingestion service needs noninteractive authentication without embedding an employee's reusable password into scripts. The release needs an operationally defensible choice without accidentally changing unrelated access or data. Which observation most directly validates success?
- The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test.
- A test user signs in through the approved identity provider and receives only the expected Snowflake role access.
- Identity logs and a controlled sign-in test show the required second factor before an authorized session starts.
- A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
Explanation
Correct Answer
D:A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured. This is an outcome test of the specified workload identity key-pair authentication action under the identity and governance change request conditions. Key-pair authentication supports service access while avoiding hard-coded interactive user passwords, subject to secure private-key handling.
Incorrect Answers
A:The pipeline completes with acceptable spill, runtime, and compute spend after a like-for-like resource test. This is an outcome for a different requirement: A Python Snowpark pipeline uses large in-memory intermediate processing and repeatedly runs out of memory on a standard virtual warehouse. It cannot by itself validate the proposed workload identity key-pair authentication action; the appropriate test is: A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
B:In this identity and governance change request context, A test user signs in through the approved identity provider and receives only the expected Snowflake role access. This is an outcome for a different requirement: An enterprise uses a corporate identity provider and wants centrally controlled employee login instead of unmanaged separate passwords. It cannot by itself validate the proposed workload identity key-pair authentication action; the appropriate test is: A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.
C:Identity logs and a controlled sign-in test show the required second factor before an authorized session starts. This is an outcome for a different requirement: A data platform security assessment finds interactive users have weak password-only sign-in and require a stronger authentication factor. It cannot by itself validate the proposed workload identity key-pair authentication action; the appropriate test is: A pipeline authenticates with its approved public-key registration and fails when the key is revoked or misconfigured.