Snowflake SnowPro Core Practice Test 79
Question 780
For an original SnowPro Core educational scenario, consider: An engineer modifies every SQL statement despite queue time dominating the end-to-end latency. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Compare query profile, clustering depth, maintenance credits and representative workload results.
- Change: Tune appropriate suspension and workload locality after measuring warehouse data-cache benefit and idle credit cost.
- Assume query queuing can be eliminated by adding ORDER BY to every SELECT.
- Check: Compare average execution versus queue time and cluster saturation during a simulated peak.
- Change: Evaluate concurrency scaling or workload separation and review queued overload time before rewriting correct SQL.
Explanation
Correct Answer
D:High concurrency can cause queuing independently of individual query efficiency; multi-cluster compute targets concurrent demand. Acceptance: User-facing latency improves by reducing wait time while maintaining correctness and reasonable credits.
E:High concurrency can cause queuing independently of individual query efficiency; multi-cluster compute targets concurrent demand. Evidence: Compare average execution versus queue time and cluster saturation during a simulated peak.
Incorrect Answers
A:Evaluate concurrency scaling or workload separation and review queued overload time before rewriting correct SQL.
B:Change: Tune appropriate suspension and workload locality after measuring warehouse data-cache benefit and idle credit cost. An engineer modifies every SQL statement despite queue time dominating the end-to-end latency.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. High concurrency can cause queuing independently of individual query efficiency; multi-cluster compute targets concurrent demand.
Question 781
A Snowflake engineer is examining this platform situation: A selective filtering and aggregation workload is a candidate for acceleration but warehouse sizing alone yields diminishing returns. A proposed shortcut is: Declare that Query Acceleration Service substitutes for proper SQL design in every query. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Express supported filters and transformations as Snowpark operations and use governed execution runtimes for Python-specific steps.
- Track query duration, warehouse and serverless credits, data volume and service objectives together for tuning decisions.
- Declare that Query Acceleration Service substitutes for proper SQL design in every query.
- Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls.
Explanation
Correct Answer
D:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. Applied case: A selective filtering and aggregation workload is a candidate for acceleration but warehouse sizing alone yields diminishing returns.
Incorrect Answers
A:Express supported filters and transformations as Snowpark operations and use governed execution runtimes for Python-specific steps. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
B:Track query duration, warehouse and serverless credits, data volume and service objectives together for tuning decisions. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
C:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
Question 782
A Snowflake implementation review finds: A selective filtering and aggregation workload is a candidate for acceleration but warehouse sizing alone yields diminishing returns. The team proposes: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Dynamic table target lag guides managed refresh behavior but does not promise zero-latency propagation or free compute.
- Search optimization maintains a search access path for eligible lookup patterns, with storage and maintenance costs distinct from warehouse scans.
- Clustering can improve locality and pruning but consumes maintenance resources and is not a universal tuning step.
- Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Explanation
Correct Answer
D:Relevant validation before approval: Inspect query eligibility and acceleration history plus incremental service credits for representative workloads. Applied case: A selective filtering and aggregation workload is a candidate for acceleration but warehouse sizing alone yields diminishing returns.
Incorrect Answers
A:Dynamic table target lag guides managed refresh behavior but does not promise zero-latency propagation or free compute. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
B:This option addresses a different Snowflake technical topic (Search Optimization Service) rather than the documented Query Acceleration Service eligibility decision.
C:Clustering can improve locality and pruning but consumes maintenance resources and is not a universal tuning step. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 783
The data platform team has not yet approved changes. Current evidence indicates: A selective filtering and aggregation workload is a candidate for acceleration but warehouse sizing alone yields diminishing returns. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Check query eligibility, refresh behavior, query rewrite usage and storage or maintenance charges.
- Inspect query eligibility and acceleration history plus incremental service credits for representative workloads.
- Inspect profile operator times, spilled bytes, join row counts and warehouse configuration.
- Compare QUERY_HISTORY result reuse and query text or underlying data changes in a controlled test.
Explanation
Correct Answer
B:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. This check tests the actual data, compute or access boundary before an operationally risky change.
Incorrect Answers
A:Check query eligibility, refresh behavior, query rewrite usage and storage or maintenance charges. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
C:Inspect profile operator times, spilled bytes, join row counts and warehouse configuration. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
D:Compare QUERY_HISTORY result reuse and query text or underlying data changes in a controlled test. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 784
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A selective filtering and aggregation workload is a candidate for acceleration but warehouse sizing alone yields diminishing returns. The service owner needs positive and negative results and evidence that legitimate data workflows still function. Which acceptance result demonstrates correct platform behavior without disrupting authorized workflows? Select ONE best answer.
- Each intended nested element is represented with correct types and no accidental Cartesian explosion.
- User-facing latency improves by reducing wait time while maintaining correctness and reasonable credits.
- Measured eligible queries improve sufficiently to justify serverless charges.
- Exactly the intended ranked records remain with deterministic tie rules.
Explanation
Correct Answer
C:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:Each intended nested element is represented with correct types and no accidental Cartesian explosion. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
B:User-facing latency improves by reducing wait time while maintaining correctness and reasonable credits. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
D:Exactly the intended ranked records remain with deterministic tie rules. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 785
An implementation sign-off request identifies the following problem: A selective filtering and aggregation workload is a candidate for acceleration but warehouse sizing alone yields diminishing returns. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Use selective predicates on suitable stored columns and evaluate micro-partition pruning before adding other optimizations. Verify: Inspect query profile scanned partitions, predicate form and representative date distribution.
- Change: Evaluate concurrency scaling or workload separation and review queued overload time before rewriting correct SQL. Verify: Compare average execution versus queue time and cluster saturation during a simulated peak.
- Change: Use suitable TRY_TO_NUMBER or TRY_TO_DATE style conversions with separate bad-record detection and remediation. Verify: Count conversion failures, review source examples and reconcile accepted versus quarantined records.
- Change: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls. Verify: Inspect query eligibility and acceleration history plus incremental service credits for representative workloads.
Explanation
Correct Answer
D:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. The change is successful only when: Measured eligible queries improve sufficiently to justify serverless charges.
Incorrect Answers
A:Change: Use selective predicates on suitable stored columns and evaluate micro-partition pruning before adding other optimizations. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
B:Change: Evaluate concurrency scaling or workload separation and review queued overload time before rewriting correct SQL. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
C:Change: Use suitable TRY_TO_NUMBER or TRY_TO_DATE style conversions with separate bad-record detection and remediation. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 786
A Snowflake engineer is examining this platform situation: A team enables Query Acceleration Service and assumes every query, including tiny metadata queries, must become faster. A proposed shortcut is: Declare that Query Acceleration Service substitutes for proper SQL design in every query. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Review dynamic table refresh history, eligibility and resource use, then set an achievable target lag for business freshness needs.
- Declare that Query Acceleration Service substitutes for proper SQL design in every query.
- Use the query profile to identify spill or join skew, then consider query changes and supported warehouse resizing.
- Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls.
Explanation
Correct Answer
D:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. Applied case: A team enables Query Acceleration Service and assumes every query, including tiny metadata queries, must become faster.
Incorrect Answers
A:Review dynamic table refresh history, eligibility and resource use, then set an achievable target lag for business freshness needs. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
B:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. Use this instead: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls.
C:Use the query profile to identify spill or join skew, then consider query changes and supported warehouse resizing. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 787
A Snowflake implementation review finds: A team enables Query Acceleration Service and assumes every query, including tiny metadata queries, must become faster. The team proposes: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
- Materialized views retain precomputed query results and have feature restrictions and maintenance tradeoffs.
- Window calculations evaluate over logical row partitions without necessarily collapsing rows as a GROUP BY does.
- QUALIFY filters query results after window functions are evaluated and is distinct from ordinary WHERE filtering.
Explanation
Correct Answer
A:Relevant validation before approval: Inspect query eligibility and acceleration history plus incremental service credits for representative workloads. Applied case: A team enables Query Acceleration Service and assumes every query, including tiny metadata queries, must become faster.
Incorrect Answers
B:Materialized views retain precomputed query results and have feature restrictions and maintenance tradeoffs. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
C:Window calculations evaluate over logical row partitions without necessarily collapsing rows as a GROUP BY does. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
D:QUALIFY filters query results after window functions are evaluated and is distinct from ordinary WHERE filtering. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 788
The data platform team has not yet approved changes. Current evidence indicates: A team enables Query Acceleration Service and assumes every query, including tiny metadata queries, must become faster. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Test row_number or moving-average output for customers with multiple timestamps and ties.
- Inspect query profile scanned partitions, predicate form and representative date distribution.
- Compare average execution versus queue time and cluster saturation during a simulated peak.
- Inspect query eligibility and acceleration history plus incremental service credits for representative workloads.
Explanation
Correct Answer
D:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. If confirmed, the proportionate intervention is: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls.
Incorrect Answers
A:Test row_number or moving-average output for customers with multiple timestamps and ties. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
B:Inspect query profile scanned partitions, predicate form and representative date distribution. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
C:Compare average execution versus queue time and cluster saturation during a simulated peak. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 789
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A team enables Query Acceleration Service and assumes every query, including tiny metadata queries, must become faster. The service owner needs positive and negative results and evidence that legitimate data workflows still function. Which acceptance result demonstrates correct platform behavior without disrupting authorized workflows? Select ONE best answer.
- Repeat eligible queries can avoid recomputing results without returning stale data after changes.
- Measured eligible queries improve sufficiently to justify serverless charges.
- The query reads fewer relevant partitions while returning identical filtered rows.
- Important queries improve enough to justify ongoing clustering expense without changing business results.
Explanation
Correct Answer
B:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. The approved implementation step was: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls.
Incorrect Answers
A:Repeat eligible queries can avoid recomputing results without returning stale data after changes. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
C:The query reads fewer relevant partitions while returning identical filtered rows. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
D:Important queries improve enough to justify ongoing clustering expense without changing business results. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
Question 790
For an original SnowPro Core educational scenario, consider: A team enables Query Acceleration Service and assumes every query, including tiny metadata queries, must become faster. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Inspect query eligibility and acceleration history plus incremental service credits for representative workloads.
- Check: Check query eligibility, refresh behavior, query rewrite usage and storage or maintenance charges.
- Declare that Query Acceleration Service substitutes for proper SQL design in every query.
- Change: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls.
- Change: Track query duration, warehouse and serverless credits, data volume and service objectives together for tuning decisions.
Explanation
Correct Answer
A:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. Required intervention: Evaluate supported Query Acceleration Service on eligible queries using its estimate and cost controls.
D:Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits. Evidence: Inspect query eligibility and acceleration history plus incremental service credits for representative workloads.
Incorrect Answers
B:Check: Check query eligibility, refresh behavior, query rewrite usage and storage or maintenance charges. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
E:Change: Track query duration, warehouse and serverless credits, data volume and service objectives together for tuning decisions. Query acceleration can offload eligible portions of selected workloads to serverless compute; not every query or operator benefits.
