Question 230A pipeline runs under the wrong role and receives privileges intended for a different service. An engineer proposes to set and verify the session's authorized primary role before execution. Which explanation best describes why this is appropriate? Session variables are scoped to the connection rather than durable account metadata. The current role determines object ownership on CREATE and contributes effective privileges. Unqualified SQL names depend on the current session namespace. More specific supported parameter scopes can override broader account values. ExplanationCorrect Answer B:The current role determines object ownership on CREATE and contributes effective privileges. This is testable: cURRENT_ROLE() and execution history show the approved deployment role. Incorrect Answers A:Session variables are scoped to the connection rather than durable account metadata. For the current requirement, the decisive mechanism is: The current role determines object ownership on CREATE and contributes effective privileges. The related action is: Set and verify the session's authorized primary role before execution. C:Unqualified SQL names depend on the current session namespace. For the current requirement, the decisive mechanism is: The current role determines object ownership on CREATE and contributes effective privileges. The related action is: Set and verify the session's authorized primary role before execution. D:More specific supported parameter scopes can override broader account values. For the current requirement, the decisive mechanism is: The current role determines object ownership on CREATE and contributes effective privileges. The related action is: Set and verify the session's authorized primary role before execution.
Question 231A long-disabled change-data stream can no longer produce reliable offsets after source retention is exceeded. After the team decides to monitor stream staleness and recover with a supported reinitialization and reconciliation procedure, which observation most directly validates the result? Task graph history shows the child runs only after its parent succeeds. After committed processing, the subsequent stream read contains only later changes. The rebuilt pipeline reconciles a checkpointed source snapshot and resumes incremental processing. Task history shows successful runs with the intended owner role. ExplanationCorrect Answer C:The rebuilt pipeline reconciles a checkpointed source snapshot and resumes incremental processing. This matters because change tracking depends on historical metadata remaining available for stream consumption. Incorrect Answers A:Task predecessor relationships enforce ordered execution of dependent SQL work. This is not the decisive validation for the stated requirement. The relevant evidence is: The rebuilt pipeline reconciles a checkpointed source snapshot and resumes incremental processing. B:Stream offsets advance when change records are consumed in a committed transaction. This is not the decisive validation for the stated requirement. The relevant evidence is: The rebuilt pipeline reconciles a checkpointed source snapshot and resumes incremental processing. D:Task execution requires permissions for the SQL objects it accesses. This is not the decisive validation for the stated requirement. The relevant evidence is: The rebuilt pipeline reconciles a checkpointed source snapshot and resumes incremental processing.
Question 232A release manager reviews SQL in Git but runs an unversioned local copy in production. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? A homegrown connection layer lacks supported authentication and driver behavior. Manual changes leave different object grants and names between environments. Credentials leak through version-controlled files or unsupported editor scripts. Unreviewed local edits cannot be traced to the production run. ExplanationCorrect Answer D:Unreviewed local edits cannot be traced to the production run. The direct prevention is to link the deployed SQL workflow to a reviewed source revision and record the executed commit. Versioned deployment makes changes traceable and repeatable across environments. Incorrect Answers A:The JDBC interface integrates Java applications with Snowflake's SQL protocol. The immediate omission risk in this case is: Unreviewed local edits cannot be traced to the production run. B:Repeatable command execution reduces environment drift from interactive manual changes. The immediate omission risk in this case is: Unreviewed local edits cannot be traced to the production run. C:IDE tools can combine local authoring with Snowflake execution while authentication remains controlled. The immediate omission risk in this case is: Unreviewed local edits cannot be traced to the production run.
Question 233A data engineering team wants the same reviewed SQL scripts accessible to multiple Snowflake developers directly from Git. Which Snowflake configuration or operational action most directly addresses this situation? Configure supported Git repository integration with scoped credentials and repository policy. Use an appropriate supported ODBC or JDBC driver for the BI platform. Adopt the supported Snowflake Python connector with controlled connection parameters. Evaluate a supported Snowflake Kafka ingestion connector aligned with freshness requirements. ExplanationCorrect Answer A:Git integration connects version-controlled code assets to authorized Snowflake workflows. The matching action is to configure supported Git repository integration with scoped credentials and repository policy. Two permitted developers inspect the same approved repository revision from Snowflake. Incorrect Answers B:Drivers expose established database connectivity mechanisms to reporting clients. The operative distinction here is: Git integration connects version-controlled code assets to authorized Snowflake workflows. The targeted change is: Configure supported Git repository integration with scoped credentials and repository policy. C:The connector provides maintained SQL session and data retrieval behavior. The operative distinction here is: Git integration connects version-controlled code assets to authorized Snowflake workflows. The targeted change is: Configure supported Git repository integration with scoped credentials and repository policy. D:Managed Kafka integration supports event-driven delivery without manual monthly file creation. The operative distinction here is: Git integration connects version-controlled code assets to authorized Snowflake workflows. The targeted change is: Configure supported Git repository integration with scoped credentials and repository policy.
Question 234A time-series table is repeatedly filtered by date but data arrives heavily interleaved across devices. An engineer proposes to evaluate clustering keys for the stable selective date access pattern. Which explanation best describes why this is appropriate? A standard view stores its SQL definition; materialized views maintain results separately. Clustering can improve micro-partition locality and pruning for suitable large datasets. Small tables often cannot amortize clustering maintenance against query savings. Different optimization techniques suit point lookups versus broad range pruning. ExplanationCorrect Answer B:Clustering can improve micro-partition locality and pruning for suitable large datasets. This is testable: the partition-scan ratio improves on date-filtered representative queries. Incorrect Answers A:A standard view stores its SQL definition; materialized views maintain results separately. For the current requirement, the decisive mechanism is: Clustering can improve micro-partition locality and pruning for suitable large datasets. The related action is: Evaluate clustering keys for the stable selective date access pattern. C:Small tables often cannot amortize clustering maintenance against query savings. For the current requirement, the decisive mechanism is: Clustering can improve micro-partition locality and pruning for suitable large datasets. The related action is: Evaluate clustering keys for the stable selective date access pattern. D:Different optimization techniques suit point lookups versus broad range pruning. For the current requirement, the decisive mechanism is: Clustering can improve micro-partition locality and pruning for suitable large datasets. The related action is: Evaluate clustering keys for the stable selective date access pattern.
Question 235An administrator sets an account-level parameter but a user session keeps using its earlier override. After the team decides to inspect session, user and account parameter precedence before changing account defaults, which observation most directly validates the result? Query History attributes the run to the intended development compute resource. The same SQL selects the expected table with either worksheet's default context. The effective parameter value matches the expected setting in the user's fresh session. A newly opened session runs correctly after the variable initialization step. ExplanationCorrect Answer C:The effective parameter value matches the expected setting in the user's fresh session. This matters because more specific supported parameter scopes can override broader account values. Incorrect Answers A:Current warehouse context determines where eligible SQL statements execute. This is not the decisive validation for the stated requirement. The relevant evidence is: The effective parameter value matches the expected setting in the user's fresh session. B:Unqualified SQL names depend on the current session namespace. This is not the decisive validation for the stated requirement. The relevant evidence is: The effective parameter value matches the expected setting in the user's fresh session. D:Session variables are scoped to the connection rather than durable account metadata. This is not the decisive validation for the stated requirement. The relevant evidence is: The effective parameter value matches the expected setting in the user's fresh session.
Question 236A developer uploads a local CSV file directly into a table name without staging it. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? The loader misinterprets nested fields and loses the original structure. The load fails despite files having been uploaded to the wrong stage context. Parsed columns shift and records contain corrupted customer data. The loader cannot locate a permitted staged source for COPY INTO. ExplanationCorrect Answer D:The loader cannot locate a permitted staged source for COPY INTO. The direct prevention is to stage the local file using a supported internal stage before executing COPY INTO. Bulk loading from local files uses a Snowflake-managed stage to make the source accessible. Incorrect Answers A:Semi-structured file types need their own parser and column mapping strategy. The immediate omission risk in this case is: The loader cannot locate a permitted staged source for COPY INTO. B:Internal stage types have different visibility and ownership semantics. The immediate omission risk in this case is: The loader cannot locate a permitted staged source for COPY INTO. C:A file format controls how COPY parses delimiters, quotes and other source conventions. The immediate omission risk in this case is: The loader cannot locate a permitted staged source for COPY INTO.
Question 237An application must translate natural-language business questions into governed SQL over known metrics. Which Snowflake configuration or operational action most directly addresses this situation? Explore Cortex Analyst with a curated semantic model for the authorized datasets. Evaluate Cortex Search with role-appropriate document ingestion and retrieval controls. Evaluate Streamlit in Snowflake with controlled app roles and data access. Use Snowflake Notebooks with supported execution resources and reviewed permissions. ExplanationCorrect Answer A:Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. The matching action is to explore Cortex Analyst with a curated semantic model for the authorized datasets. Representative questions produce reviewed SQL matching approved measures and filters. Incorrect Answers B:Search services index text for relevance-based retrieval in supported apps. The operative distinction here is: Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. The targeted change is: Explore Cortex Analyst with a curated semantic model for the authorized datasets. C:Streamlit can provide an interactive app interface over governed Snowflake data. The operative distinction here is: Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. The targeted change is: Explore Cortex Analyst with a curated semantic model for the authorized datasets. D:Notebook interfaces combine code cells, data exploration and reproducible analysis assets. The operative distinction here is: Cortex Analyst maps questions to SQL using semantic definitions rather than arbitrary table guesses. The targeted change is: Explore Cortex Analyst with a curated semantic model for the authorized datasets.
Question 238A governance team wants alerts when an important data quality metric breaches a defined threshold. An engineer proposes to configure a supported Snowflake alert or monitoring workflow for the evaluated condition. Which explanation best describes why this is appropriate? Trust Center surfaces supported posture and risk findings in the account context. Alerts can evaluate scheduled conditions and trigger authorized notification actions. Account audit records connect changes and execution to actors and timestamps. Security findings require evidence-based remediation rather than status-only dismissal. ExplanationCorrect Answer B:Alerts can evaluate scheduled conditions and trigger authorized notification actions. This is testable: a controlled threshold breach generates the expected alert record. Incorrect Answers A:Trust Center surfaces supported posture and risk findings in the account context. For the current requirement, the decisive mechanism is: Alerts can evaluate scheduled conditions and trigger authorized notification actions. The related action is: Configure a supported Snowflake alert or monitoring workflow for the evaluated condition. C:Account audit records connect changes and execution to actors and timestamps. For the current requirement, the decisive mechanism is: Alerts can evaluate scheduled conditions and trigger authorized notification actions. The related action is: Configure a supported Snowflake alert or monitoring workflow for the evaluated condition. D:Security findings require evidence-based remediation rather than status-only dismissal. For the current requirement, the decisive mechanism is: Alerts can evaluate scheduled conditions and trigger authorized notification actions. The related action is: Configure a supported Snowflake alert or monitoring workflow for the evaluated condition.
Question 239A source file uses case-sensitive JSON keys but a query references a differently capitalized key path. After the team decides to use the exact correct case for element keys when extracting VARIANT fields, which observation most directly validates the result? A controlled three-element array produces exactly three expected output records. A two-line order produces two item rows with the correct parent ID. A test path returns the expected non-null value for the original key. A sample nested field is retrieved with the expected value and type. ExplanationCorrect Answer C:A test path returns the expected non-null value for the original key. This matters because semi-structured element paths follow JSON key semantics independently of SQL identifier rules. Incorrect Answers A:Expansion multiplies source rows by the selected collection's elements. This is not the decisive validation for the stated requirement. The relevant evidence is: A test path returns the expected non-null value for the original key. B:FLATTEN expands array or object elements to relational rows for downstream SQL. This is not the decisive validation for the stated requirement. The relevant evidence is: A test path returns the expected non-null value for the original key. D:VARIANT preserves semi-structured types and supports documented element-path access. This is not the decisive validation for the stated requirement. The relevant evidence is: A test path returns the expected non-null value for the original key.
Question 240A team wants to deploy a small Python data app for business stakeholders inside Snowflake. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Untracked model files yield unclear provenance and inconsistent predictions. Teams deploy ungoverned external model calls for an in-platform task. Full-data downloads create extra data movement and uncontrolled copies. A separate unmanaged web tier duplicates access controls and data movement. ExplanationCorrect Answer D:A separate unmanaged web tier duplicates access controls and data movement. The direct prevention is to evaluate Streamlit in Snowflake with controlled app roles and data access. Streamlit can provide an interactive app interface over governed Snowflake data. Incorrect Answers A:A model registry provides versioned model artifacts and tracked deployment metadata. The immediate omission risk in this case is: A separate unmanaged web tier duplicates access controls and data movement. B:Cortex AI SQL functions apply hosted AI capabilities to selected content inside Snowflake workflows. The immediate omission risk in this case is: A separate unmanaged web tier duplicates access controls and data movement. C:Snowpark lets supported language logic execute close to Snowflake-managed data. The immediate omission risk in this case is: A separate unmanaged web tier duplicates access controls and data movement.