Question 20A supplier with its own Snowflake account needs read-only access to a curated product catalog with no file export. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Data is distributed beyond the agreed provider-consumer trust boundary. One participant can infer or download another participant's sensitive underlying records. Unapproved supplier or customer information becomes visible externally. Repeated file copies become stale and extend data exposure. ExplanationCorrect Answer D:Repeated file copies become stale and extend data exposure. The direct prevention is to publish a secure direct share exposing only approved database objects. Secure Data Sharing lets consumers query provider-approved objects without copying the underlying data. Incorrect Answers A:Consumer access to a shared database does not grant arbitrary onward redistribution rights. The immediate omission risk in this case is: Repeated file copies become stale and extend data exposure. B:Clean-room designs constrain collaboration to permitted analyses without exposing unrestricted raw data. The immediate omission risk in this case is: Repeated file copies become stale and extend data exposure. C:Provider-side views can limit exposed columns and permitted values in a share. The immediate omission risk in this case is: Repeated file copies become stale and extend data exposure.
Question 21A company replicates a database but forgets that its downstream jobs also need relevant account objects. Which Snowflake configuration or operational action most directly addresses this situation? Inventory supported replication scope and account-level dependencies before declaring recovery-ready. Follow the supported failback workflow and reconcile data and ownership before resuming clients. Monitor replication status and effective recovery-point lag. Plan supported replication and failover capabilities with explicit activation steps. ExplanationCorrect Answer A:Recovering the database alone may not restore the surrounding account configuration and integrations. The matching action is to inventory supported replication scope and account-level dependencies before declaring recovery-ready. The secondary test account runs an approved end-to-end reporting workflow. Incorrect Answers B:Failback needs a controlled role transition rather than assuming the old primary is current. The operative distinction here is: Recovering the database alone may not restore the surrounding account configuration and integrations. The targeted change is: Inventory supported replication scope and account-level dependencies before declaring recovery-ready. C:Replicated data may lag behind a primary according to configured refresh and workload health. The operative distinction here is: Recovering the database alone may not restore the surrounding account configuration and integrations. The targeted change is: Inventory supported replication scope and account-level dependencies before declaring recovery-ready. D:Replication synchronizes eligible objects but failover requires a documented secondary-account design. The operative distinction here is: Recovering the database alone may not restore the surrounding account configuration and integrations. The targeted change is: Inventory supported replication scope and account-level dependencies before declaring recovery-ready.
Question 22A data engineering team wants the same reviewed SQL scripts accessible to multiple Snowflake developers directly from Git. An engineer proposes to configure supported Git repository integration with scoped credentials and repository policy. Which explanation best describes why this is appropriate? Drivers expose established database connectivity mechanisms to reporting clients. Git integration connects version-controlled code assets to authorized Snowflake workflows. Managed Kafka integration supports event-driven delivery without manual monthly file creation. The connector provides maintained SQL session and data retrieval behavior. ExplanationCorrect Answer B:Git integration connects version-controlled code assets to authorized Snowflake workflows. This is testable: two permitted developers inspect the same approved repository revision from Snowflake. Incorrect Answers A:Drivers expose established database connectivity mechanisms to reporting clients. For the current requirement, the decisive mechanism is: Git integration connects version-controlled code assets to authorized Snowflake workflows. The related action is: Configure supported Git repository integration with scoped credentials and repository policy. C:Managed Kafka integration supports event-driven delivery without manual monthly file creation. For the current requirement, the decisive mechanism is: Git integration connects version-controlled code assets to authorized Snowflake workflows. The related action is: Configure supported Git repository integration with scoped credentials and repository policy. D:The connector provides maintained SQL session and data retrieval behavior. For the current requirement, the decisive mechanism is: Git integration connects version-controlled code assets to authorized Snowflake workflows. The related action is: Configure supported Git repository integration with scoped credentials and repository policy.
Question 23A query only needs row counts from stored metadata but a developer starts a very large warehouse to calculate them. After the team decides to evaluate whether metadata-based optimizations or catalog statistics satisfy the question, which observation most directly validates the result? Query history identifies result reuse for the repeated eligible statement. Warm and cold runs show the expected change in disk-read behavior. The plan shows minimal or no warehouse scan for an eligible metadata-only question. The rerun returns updated source values rather than an out-of-date cached result. ExplanationCorrect Answer C:The plan shows minimal or no warehouse scan for an eligible metadata-only question. This matters because certain query answers can be resolved from metadata without scanning all rows. Incorrect Answers A:Eligible unchanged query text and underlying data can reuse stored results without full reexecution. This is not the decisive validation for the stated requirement. The relevant evidence is: The plan shows minimal or no warehouse scan for an eligible metadata-only question. B:Warehouse-local data caching is tied to the life of its compute resources. This is not the decisive validation for the stated requirement. The relevant evidence is: The plan shows minimal or no warehouse scan for an eligible metadata-only question. D:Persisted result reuse depends on data validity and query eligibility. This is not the decisive validation for the stated requirement. The relevant evidence is: The plan shows minimal or no warehouse scan for an eligible metadata-only question.
Question 24A Java service needs a maintained programmatic Snowflake connection with SQL query support. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Performance triage proceeds without the relevant visual execution evidence. Unreviewed local edits cannot be traced to the production run. Manual changes leave different object grants and names between environments. A homegrown connection layer lacks supported authentication and driver behavior. ExplanationCorrect Answer D:A homegrown connection layer lacks supported authentication and driver behavior. The direct prevention is to choose the supported Snowflake JDBC driver and configure secure authentication. The JDBC interface integrates Java applications with Snowflake's SQL protocol. Incorrect Answers A:Snowsight presents interactive execution and activity evidence for eligible queries. The immediate omission risk in this case is: A homegrown connection layer lacks supported authentication and driver behavior. B:Versioned deployment makes changes traceable and repeatable across environments. The immediate omission risk in this case is: A homegrown connection layer lacks supported authentication and driver behavior. C:Repeatable command execution reduces environment drift from interactive manual changes. The immediate omission risk in this case is: A homegrown connection layer lacks supported authentication and driver behavior.
Question 25An analyst repeats identical deterministic SQL over unchanged data and is surprised at a near-instant result. Which Snowflake configuration or operational action most directly addresses this situation? Check whether the persisted query result cache served the repeated statement. Consider warehouse cache warmth and suspension effects when benchmarking. Evaluate whether metadata-based optimizations or catalog statistics satisfy the question. Review result-cache eligibility and statement identity rather than assuming semantic equivalence. ExplanationCorrect Answer A:Eligible unchanged query text and underlying data can reuse stored results without full reexecution. The matching action is to check whether the persisted query result cache served the repeated statement. Query history identifies result reuse for the repeated eligible statement. Incorrect Answers B:Warehouse-local data caching is tied to the life of its compute resources. The operative distinction here is: Eligible unchanged query text and underlying data can reuse stored results without full reexecution. The targeted change is: Check whether the persisted query result cache served the repeated statement. C:Certain query answers can be resolved from metadata without scanning all rows. The operative distinction here is: Eligible unchanged query text and underlying data can reuse stored results without full reexecution. The targeted change is: Check whether the persisted query result cache served the repeated statement. D:Persisted results depend on supported matching and validity conditions, not merely human meaning. The operative distinction here is: Eligible unchanged query text and underlying data can reuse stored results without full reexecution. The targeted change is: Check whether the persisted query result cache served the repeated statement.
Question 26An application must translate natural-language business questions into governed SQL over known metrics. An engineer proposes to explore Cortex Analyst with a curated semantic model for the authorized datasets. Which explanation best describes why this is appropriate? Search services index text for relevance-based retrieval in supported apps. Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. Notebook interfaces combine code cells, data exploration and reproducible analysis assets. Streamlit can provide an interactive app interface over governed Snowflake data. ExplanationCorrect Answer B:Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. This is testable: representative questions produce reviewed SQL matching approved measures and filters. Incorrect Answers A:Search services index text for relevance-based retrieval in supported apps. For the current requirement, the decisive mechanism is: Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. The related action is: Explore Cortex Analyst with a curated semantic model for the authorized datasets. C:Notebook interfaces combine code cells, data exploration and reproducible analysis assets. For the current requirement, the decisive mechanism is: Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. The related action is: Explore Cortex Analyst with a curated semantic model for the authorized datasets. D:Streamlit can provide an interactive app interface over governed Snowflake data. For the current requirement, the decisive mechanism is: Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. The related action is: Explore Cortex Analyst with a curated semantic model for the authorized datasets.
Question 27An operations team needs query history by user for an attribution review over a longer period. After the team decides to query appropriate ACCOUNT_USAGE query history views with permitted access, which observation most directly validates the result? A controlled quota event creates the expected warning before an overrun. A later refresh includes the known query and matches its original timestamp. The report lists query IDs, users, warehouses and usage time windows. The estimated total agrees with observed warehouse metering within timing tolerances. ExplanationCorrect Answer C:The report lists query IDs, users, warehouses and usage time windows. This matters because account usage views provide historical activity records useful for account-level attribution. Incorrect Answers A:Resource monitors help track supported warehouse credit usage and trigger notification or suspension actions. This is not the decisive validation for the stated requirement. The relevant evidence is: The report lists query IDs, users, warehouses and usage time windows. B:Some historical account usage views are delayed relative to live query monitoring. This is not the decisive validation for the stated requirement. The relevant evidence is: The report lists query IDs, users, warehouses and usage time windows. D:Warehouse cost depends on size and actual running duration, with minimum charge semantics. This is not the decisive validation for the stated requirement. The relevant evidence is: The report lists query IDs, users, warehouses and usage time windows.
Question 28An enterprise uses corporate SSO but analysts still sign in with independent local Snowflake passwords. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Password disclosure alone can authorize a session. Credential leakage compromises a human identity and breaks when its password changes. Integration credentials remain difficult to limit and revoke. Employees retain unmanaged alternate authentication paths. ExplanationCorrect Answer D:Employees retain unmanaged alternate authentication paths. The direct prevention is to configure supported federated authentication and enforce the approved sign-in policy. SSO centralizes identity controls under the organization's identity provider. Incorrect Answers A:A second authentication factor reduces risk from password-only compromise. The immediate omission risk in this case is: Employees retain unmanaged alternate authentication paths. B:Service identities should authenticate without embedding reusable employee passwords. The immediate omission risk in this case is: Employees retain unmanaged alternate authentication paths. C:OAuth separates delegated authorization and token lifetimes from persistent user passwords. The immediate omission risk in this case is: Employees retain unmanaged alternate authentication paths.
Question 29A reporting role has SELECT on a table but no permission to traverse its database and schema. Which Snowflake configuration or operational action most directly addresses this situation? Grant minimal database and schema USAGE in addition to table SELECT. Switch to an approved service-owned primary role before creating objects. Route grant changes through the schema owner or a role holding MANAGE GRANTS. Redesign role inheritance so authorized parent roles inherit privileges from narrower child roles. ExplanationCorrect Answer A:Snowflake requires both object access and usable parent namespaces to resolve a table. The matching action is to grant minimal database and schema USAGE in addition to table SELECT. A role-scoped query succeeds for the intended table but not an unrelated schema. Incorrect Answers B:Object creation uses the active primary role to assign ownership in Snowflake. The operative distinction here is: Snowflake requires both object access and usable parent namespaces to resolve a table. The targeted change is: Grant minimal database and schema USAGE in addition to table SELECT. C:Managed access schemas centralize object privilege decisions rather than delegating them to every object owner. The operative distinction here is: Snowflake requires both object access and usable parent namespaces to resolve a table. The targeted change is: Grant minimal database and schema USAGE in addition to table SELECT. D:Role hierarchy privileges move to roles granted the lower role, not in reverse. The operative distinction here is: Snowflake requires both object access and usable parent namespaces to resolve a table. The targeted change is: Grant minimal database and schema USAGE in addition to table SELECT.
Question 30A warehouse report shows cumulative revenue but orders rows by a text label rather than transaction date. An engineer proposes to define the intended ordered window frame over the actual transaction timestamp. Which explanation best describes why this is appropriate? MERGE applies conditional DML using source-target match rules in one statement. Window order and frame rules determine which earlier values contribute to a running total. QUALIFY filters results of window expressions without wrapping every query in a subquery. User-defined functions package reusable expressions under access control. ExplanationCorrect Answer B:Window order and frame rules determine which earlier values contribute to a running total. This is testable: a three-record test yields the expected monotonic cumulative sum. Incorrect Answers A:MERGE applies conditional DML using source-target match rules in one statement. For the current requirement, the decisive mechanism is: Window order and frame rules determine which earlier values contribute to a running total. The related action is: Define the intended ordered window frame over the actual transaction timestamp. C:QUALIFY filters results of window expressions without wrapping every query in a subquery. For the current requirement, the decisive mechanism is: Window order and frame rules determine which earlier values contribute to a running total. The related action is: Define the intended ordered window frame over the actual transaction timestamp. D:User-defined functions package reusable expressions under access control. For the current requirement, the decisive mechanism is: Window order and frame rules determine which earlier values contribute to a running total. The related action is: Define the intended ordered window frame over the actual transaction timestamp.