Question 330A sales team needs the latest order per customer but GROUP BY discards nonaggregated order columns. An engineer proposes to use ROW_NUMBER() with a customer partition and descending order timestamp, filtered appropriately. Which explanation best describes why this is appropriate? Window order and frame rules determine which earlier values contribute to a running total. A window ordering assigns ranks while preserving original row attributes. MERGE applies conditional DML using source-target match rules in one statement. User-defined functions package reusable expressions under access control. ExplanationCorrect Answer B:A window ordering assigns ranks while preserving original row attributes. This is testable: exactly one latest record per customer is returned under a deterministic tie-breaker. Incorrect Answers A:Window order and frame rules determine which earlier values contribute to a running total. For the current requirement, the decisive mechanism is: A window ordering assigns ranks while preserving original row attributes. The related action is: Use ROW_NUMBER() with a customer partition and descending order timestamp, filtered appropriately. C:MERGE applies conditional DML using source-target match rules in one statement. For the current requirement, the decisive mechanism is: A window ordering assigns ranks while preserving original row attributes. The related action is: Use ROW_NUMBER() with a customer partition and descending order timestamp, filtered appropriately. D:User-defined functions package reusable expressions under access control. For the current requirement, the decisive mechanism is: A window ordering assigns ranks while preserving original row attributes. The related action is: Use ROW_NUMBER() with a customer partition and descending order timestamp, filtered appropriately.
Question 331A monitoring script cannot tell which user launched a destructive SQL statement. After the team decides to capture QUERY_HISTORY identifiers and available user/role attribution in its audit review, which observation most directly validates the result? The requested historical query appears in the permitted account-usage view. The benchmark links each measured run to a reproducible configuration. The target statement is associated with its user, query ID and time range. The incident report names the query IDs and users responsible for the spike. ExplanationCorrect Answer C:The target statement is associated with its user, query ID and time range. This matters because snowflake execution metadata ties statements to recorded session actors. Incorrect Answers A:Snowsight's recent-activity window differs from longer-term account usage availability. This is not the decisive validation for the stated requirement. The relevant evidence is: The target statement is associated with its user, query ID and time range. B:Performance comparisons are meaningful only with comparable inputs and execution environments. This is not the decisive validation for the stated requirement. The relevant evidence is: The target statement is associated with its user, query ID and time range. D:Query history can identify SQL statements and actors using a compute resource. This is not the decisive validation for the stated requirement. The relevant evidence is: The target statement is associated with its user, query ID and time range.
Question 332A data provider wants to hide query-definition details while exposing controlled results to consumers. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Duplicated reporting tables diverge from updated sources. Recurring expensive aggregation remains unoptimized or hidden maintenance spend grows. Further nesting obscures the true workload bottleneck. Sensitive logic or intermediate information can leak to a recipient. ExplanationCorrect Answer D:Sensitive logic or intermediate information can leak to a recipient. The direct prevention is to consider a secure view with explicit access policies rather than an unrestricted standard view. Secure views restrict certain optimizations and metadata exposure for protected sharing patterns. Incorrect Answers A:A standard view saves a query definition rather than materializing its full result table. The immediate omission risk in this case is: Sensitive logic or intermediate information can leak to a recipient. B:Materialized views maintain eligible precomputed results for repeated query access. The immediate omission risk in this case is: Sensitive logic or intermediate information can leak to a recipient. C:A view is a logical SQL abstraction and excessive nesting can complicate optimization and diagnosis. The immediate omission risk in this case is: Sensitive logic or intermediate information can leak to a recipient.
Question 333A finance report mixes HAVING with a window function filter and receives invalid SQL behavior. Which Snowflake configuration or operational action most directly addresses this situation? Apply QUALIFY to supported window-function results after defining their windows. Use ROW_NUMBER() with a customer partition and descending order timestamp, filtered appropriately. Implement a suitably governed UDF with reviewed input and output types. Define the intended ordered window frame over the actual transaction timestamp. ExplanationCorrect Answer A:QUALIFY filters results of window expressions without wrapping every query in a subquery. The matching action is to apply QUALIFY to supported window-function results after defining their windows. The top-ranked partition rows match a reviewed expected output. Incorrect Answers B:A window ordering assigns ranks while preserving original row attributes. The operative distinction here is: QUALIFY filters results of window expressions without wrapping every query in a subquery. The targeted change is: Apply QUALIFY to supported window-function results after defining their windows. C:User-defined functions package reusable expressions under access control. The operative distinction here is: QUALIFY filters results of window expressions without wrapping every query in a subquery. The targeted change is: Apply QUALIFY to supported window-function results after defining their windows. D:Window order and frame rules determine which earlier values contribute to a running total. The operative distinction here is: QUALIFY filters results of window expressions without wrapping every query in a subquery. The targeted change is: Apply QUALIFY to supported window-function results after defining their windows.
Question 334A BI tool needs to query Snowflake through a standard interface rather than custom SQL over a REST webhook. An engineer proposes to use an appropriate supported ODBC or JDBC driver for the BI platform. Which explanation best describes why this is appropriate? API integrations govern eligible external endpoints and execution authorization. Drivers expose established database connectivity mechanisms to reporting clients. Managed Kafka integration supports event-driven delivery without manual monthly file creation. Storage integrations couple Snowflake permissions to cloud IAM policies and approved resource paths. ExplanationCorrect Answer B:Drivers expose established database connectivity mechanisms to reporting clients. This is testable: the BI test connection can enumerate and query the authorized schema. Incorrect Answers A:API integrations govern eligible external endpoints and execution authorization. For the current requirement, the decisive mechanism is: Drivers expose established database connectivity mechanisms to reporting clients. The related action is: Use an appropriate supported ODBC or JDBC driver for the BI platform. C:Managed Kafka integration supports event-driven delivery without manual monthly file creation. For the current requirement, the decisive mechanism is: Drivers expose established database connectivity mechanisms to reporting clients. The related action is: Use an appropriate supported ODBC or JDBC driver for the BI platform. D:Storage integrations couple Snowflake permissions to cloud IAM policies and approved resource paths. For the current requirement, the decisive mechanism is: Drivers expose established database connectivity mechanisms to reporting clients. The related action is: Use an appropriate supported ODBC or JDBC driver for the BI platform.
Question 335An analyst needs yesterday's metric values without overwriting today's currently valid table. After the team decides to use an eligible AT or BEFORE Time Travel query for the intended historical point, which observation most directly validates the result? The runbook documents the supported recovery boundary and escalation process. The data-protection matrix shows the actual table type and available retention. A controlled comparison returns yesterday's and today's distinct approved metrics. A cloned test table is created quickly and its later updates do not mutate production. ExplanationCorrect Answer C:A controlled comparison returns yesterday's and today's distinct approved metrics. This matters because historical query syntax accesses retained earlier data versions within the supported window. Incorrect Answers A:Fail-safe is a last-resort recovery mechanism, not a normal customer SQL time-travel query path. This is not the decisive validation for the stated requirement. The relevant evidence is: A controlled comparison returns yesterday's and today's distinct approved metrics. B:Fail-safe applies to eligible permanent objects, not transient or temporary table storage. This is not the decisive validation for the stated requirement. The relevant evidence is: A controlled comparison returns yesterday's and today's distinct approved metrics. D:Clones initially reference shared existing micro-partitions and diverge as data changes. This is not the decisive validation for the stated requirement. The relevant evidence is: A controlled comparison returns yesterday's and today's distinct approved metrics.
Question 336A reloadable transient staging table is designed with a guarantee of seven-day Fail-safe recovery. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? A recoverable dropped table remains unavailable to production users. The analyst changes production data just to reconstruct a historical report. Operators promise self-service historical queries that Fail-safe does not expose. Disaster recovery promises cannot be fulfilled for transient staging data. ExplanationCorrect Answer D:Disaster recovery promises cannot be fulfilled for transient staging data. The direct prevention is to correct the recovery claim because transient tables do not provide Fail-safe. Fail-safe applies to eligible permanent objects, not transient or temporary table storage. Incorrect Answers A:Time Travel supports restoring eligible historical table states before the retention window expires. The immediate omission risk in this case is: Disaster recovery promises cannot be fulfilled for transient staging data. B:Historical query syntax accesses retained earlier data versions within the supported window. The immediate omission risk in this case is: Disaster recovery promises cannot be fulfilled for transient staging data. C:Fail-safe is a last-resort recovery mechanism, not a normal customer SQL time-travel query path. The immediate omission risk in this case is: Disaster recovery promises cannot be fulfilled for transient staging data.
Question 337A developer needs a fast test copy of a 20 TB production table without duplicating all storage immediately. Which Snowflake configuration or operational action most directly addresses this situation? Create a zero-copy clone of the eligible table under an authorized development schema. Correct the recovery claim because transient tables do not provide Fail-safe. Use UNDROP TABLE under the eligible table and retention conditions. Use an eligible AT or BEFORE Time Travel query for the intended historical point. ExplanationCorrect Answer A:Clones initially reference shared existing micro-partitions and diverge as data changes. The matching action is to create a zero-copy clone of the eligible table under an authorized development schema. A cloned test table is created quickly and its later updates do not mutate production. Incorrect Answers B:Fail-safe applies to eligible permanent objects, not transient or temporary table storage. The operative distinction here is: Clones initially reference shared existing micro-partitions and diverge as data changes. The targeted change is: Create a zero-copy clone of the eligible table under an authorized development schema. C:Time Travel supports restoring eligible historical table states before the retention window expires. The operative distinction here is: Clones initially reference shared existing micro-partitions and diverge as data changes. The targeted change is: Create a zero-copy clone of the eligible table under an authorized development schema. D:Historical query syntax accesses retained earlier data versions within the supported window. The operative distinction here is: Clones initially reference shared existing micro-partitions and diverge as data changes. The targeted change is: Create a zero-copy clone of the eligible table under an authorized development schema.
Question 338A support team needs text sentiment scoring from permitted customer messages using managed AI SQL. An engineer proposes to evaluate an eligible Cortex AI SQL function with appropriate data-access controls. Which explanation best describes why this is appropriate? Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. Cortex AI SQL functions apply hosted AI capabilities to selected content inside Snowflake workflows. Notebook interfaces combine code cells, data exploration and reproducible analysis assets. Search services index text for relevance-based retrieval in supported apps. ExplanationCorrect Answer B:Cortex AI SQL functions apply hosted AI capabilities to selected content inside Snowflake workflows. This is testable: a sample query returns the expected response shape under the approved role. Incorrect Answers A:Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. For the current requirement, the decisive mechanism is: Cortex AI SQL functions apply hosted AI capabilities to selected content inside Snowflake workflows. The related action is: Evaluate an eligible Cortex AI SQL function with appropriate data-access controls. C:Notebook interfaces combine code cells, data exploration and reproducible analysis assets. For the current requirement, the decisive mechanism is: Cortex AI SQL functions apply hosted AI capabilities to selected content inside Snowflake workflows. The related action is: Evaluate an eligible Cortex AI SQL function with appropriate data-access controls. D:Search services index text for relevance-based retrieval in supported apps. For the current requirement, the decisive mechanism is: Cortex AI SQL functions apply hosted AI capabilities to selected content inside Snowflake workflows. The related action is: Evaluate an eligible Cortex AI SQL function with appropriate data-access controls.
Question 339A service must run at 07:00 but the warehouse has been manually suspended without auto-resume. After the team decides to enable approved auto-resume or explicitly resume the warehouse before the scheduled run, which observation most directly validates the result? Startup counts and billable time fall after the revised threshold. Before/after query history differentiates in-flight jobs from queries started after resize. A controlled run succeeds from the suspended state without manual intervention. The role can execute its assigned job but cannot change BI warehouse size. ExplanationCorrect Answer C:A controlled run succeeds from the suspended state without manual intervention. This matters because suspended warehouses require a supported start path before executing compute work. Incorrect Answers A:Too-short suspend windows cause repeated startups with minimum usage charges and cache loss. This is not the decisive validation for the stated requirement. The relevant evidence is: A controlled run succeeds from the suspended state without manual intervention. B:New capacity is available for subsequently started or queued work rather than rewriting already-running computation. This is not the decisive validation for the stated requirement. The relevant evidence is: A controlled run succeeds from the suspended state without manual intervention. D:Warehouse usage and modification are distinct privileges. This is not the decisive validation for the stated requirement. The relevant evidence is: A controlled run succeeds from the suspended state without manual intervention.
Question 340A team wants one reusable scalar calculation across several SQL reports and duplicates the expression manually. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Filters run at the wrong stage and return extra records. The report selects an arbitrary earlier order or loses important columns. Replays accumulate multiple rows for the same business key. Copied expressions diverge when tax or business rules change. ExplanationCorrect Answer D:Copied expressions diverge when tax or business rules change. The direct prevention is to implement a suitably governed UDF with reviewed input and output types. User-defined functions package reusable expressions under access control. Incorrect Answers A:QUALIFY filters results of window expressions without wrapping every query in a subquery. The immediate omission risk in this case is: Copied expressions diverge when tax or business rules change. B:A window ordering assigns ranks while preserving original row attributes. The immediate omission risk in this case is: Copied expressions diverge when tax or business rules change. C:MERGE applies conditional DML using source-target match rules in one statement. The immediate omission risk in this case is: Copied expressions diverge when tax or business rules change.