Question 360A pipeline loads JSON strings into VARCHAR and later tries to access nested keys as VARIANT values. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Lexical comparison produces incorrect monetary totals. Nested items remain inaccessible to relational aggregation. Unexpected row explosions inflate metrics and compute cost. Ad hoc string parsing yields brittle or missing nested values. ExplanationCorrect Answer D:Ad hoc string parsing yields brittle or missing nested values. The direct prevention is to parse the JSON into a VARIANT representation before path queries. VARIANT preserves semi-structured types and supports documented element-path access. Incorrect Answers A:Typed conversion clarifies semantics for numeric predicates and calculations. The immediate omission risk in this case is: Ad hoc string parsing yields brittle or missing nested values. B:FLATTEN expands array or object elements to relational rows for downstream SQL. The immediate omission risk in this case is: Ad hoc string parsing yields brittle or missing nested values. C:Expansion multiplies source rows by the selected collection's elements. The immediate omission risk in this case is: Ad hoc string parsing yields brittle or missing nested values.
Question 361A service needs to continue past selected bad files while retaining an audit of rejected rows. Which Snowflake configuration or operational action most directly addresses this situation? Choose an appropriate ON_ERROR option and record rejected-file diagnostics. Review load history, staged file metadata and target row counts before choosing a reload. Inspect Snowflake COPY load-history behavior and use an explicit reload strategy only when intended. Validate staged data using a supported COPY validation or error-inspection workflow. ExplanationCorrect Answer A:COPY error-handling options determine whether loading aborts, skips or continues. The matching action is to choose an appropriate ON_ERROR option and record rejected-file diagnostics. The load report shows both successful files and explicit rejected-file counts. Incorrect Answers B:Snowflake records file-loading outcomes that can support safe reconciliation. The operative distinction here is: COPY error-handling options determine whether loading aborts, skips or continues. The targeted change is: Choose an appropriate ON_ERROR option and record rejected-file diagnostics. C:COPY tracks previously loaded files to help avoid accidental duplicate ingestion. The operative distinction here is: COPY error-handling options determine whether loading aborts, skips or continues. The targeted change is: Choose an appropriate ON_ERROR option and record rejected-file diagnostics. D:Pre-load validation surfaces parsing and column conversion problems. The operative distinction here is: COPY error-handling options determine whether loading aborts, skips or continues. The targeted change is: Choose an appropriate ON_ERROR option and record rejected-file diagnostics.
Question 362A deployment pipeline must create schemas consistently without manual browser clicks in each environment. An engineer proposes to use Snowflake CLI or supported scripted SQL automation with controlled credentials. Which explanation best describes why this is appropriate? IDE tools can combine local authoring with Snowflake execution while authentication remains controlled. Repeatable command execution reduces environment drift from interactive manual changes. Snowsight presents interactive execution and activity evidence for eligible queries. Versioned deployment makes changes traceable and repeatable across environments. ExplanationCorrect Answer B:Repeatable command execution reduces environment drift from interactive manual changes. This is testable: the pipeline provisions identical approved objects in two test accounts. Incorrect Answers A:IDE tools can combine local authoring with Snowflake execution while authentication remains controlled. For the current requirement, the decisive mechanism is: Repeatable command execution reduces environment drift from interactive manual changes. The related action is: Use Snowflake CLI or supported scripted SQL automation with controlled credentials. C:Snowsight presents interactive execution and activity evidence for eligible queries. For the current requirement, the decisive mechanism is: Repeatable command execution reduces environment drift from interactive manual changes. The related action is: Use Snowflake CLI or supported scripted SQL automation with controlled credentials. D:Versioned deployment makes changes traceable and repeatable across environments. For the current requirement, the decisive mechanism is: Repeatable command execution reduces environment drift from interactive manual changes. The related action is: Use Snowflake CLI or supported scripted SQL automation with controlled credentials.
Question 363A view owner updates its SQL but an analyst still believes the view stores an old static snapshot. After the team decides to explain standard-view evaluation against source tables at query time, which observation most directly validates the result? Consumer access exposes permitted results without disclosing protected view definitions. Query plans and maintenance credits show whether the materialization is worthwhile. An approved source-row change appears through the view without a view reload step. Reading the view returns current authorized source rows without a separate reload. ExplanationCorrect Answer C:An approved source-row change appears through the view without a view reload step. This matters because standard views evaluate their definition using current authorized data. Incorrect Answers A:Secure views restrict certain optimizations and metadata exposure for protected sharing patterns. This is not the decisive validation for the stated requirement. The relevant evidence is: An approved source-row change appears through the view without a view reload step. B:Materialized views maintain eligible precomputed results for repeated query access. This is not the decisive validation for the stated requirement. The relevant evidence is: An approved source-row change appears through the view without a view reload step. D:A standard view saves a query definition rather than materializing its full result table. This is not the decisive validation for the stated requirement. The relevant evidence is: An approved source-row change appears through the view without a view reload step.
Question 364A CSV ingestion splits customer names at embedded commas even when the source uses quoted fields. 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 loader cannot locate a permitted staged source for COPY INTO. Single-user staging assumptions break shared ingestion jobs. Parsed columns shift and records contain corrupted customer data. ExplanationCorrect Answer D:Parsed columns shift and records contain corrupted customer data. The direct prevention is to define a suitable CSV FILE FORMAT with the correct delimiter and enclosure settings. A file format controls how COPY parses delimiters, quotes and other source conventions. Incorrect Answers A:Semi-structured file types need their own parser and column mapping strategy. The immediate omission risk in this case is: Parsed columns shift and records contain corrupted customer data. B:Bulk loading from local files uses a Snowflake-managed stage to make the source accessible. The immediate omission risk in this case is: Parsed columns shift and records contain corrupted customer data. C:A named stage is a reusable schema object rather than a user-only scratch location. The immediate omission risk in this case is: Parsed columns shift and records contain corrupted customer data.
Question 365A retailer proposes placing each warehouse's data inside its compute nodes to prevent other teams reading it. Which Snowflake configuration or operational action most directly addresses this situation? Separate shared managed storage from independently permissioned virtual warehouses. Rely on the Snowflake cloud services layer for authentication and metadata operations. Distinguish stored-data charges from warehouse compute and cloud-service consumption. Place competing workloads on separate virtual warehouses over the same governed tables. ExplanationCorrect Answer A:Snowflake stores table data centrally while compute clusters enforce authorized access without owning separate data copies. The matching action is to separate shared managed storage from independently permissioned virtual warehouses. Two permitted warehouses query the same updated table while their compute resources remain isolated. Incorrect Answers B:Snowflake central services handle access checks, metadata and optimization independently of a specific warehouse. The operative distinction here is: Snowflake stores table data centrally while compute clusters enforce authorized access without owning separate data copies. The targeted change is: Separate shared managed storage from independently permissioned virtual warehouses. C:Compute, persistent storage and qualifying cloud services have different meters and operational controls. The operative distinction here is: Snowflake stores table data centrally while compute clusters enforce authorized access without owning separate data copies. The targeted change is: Separate shared managed storage from independently permissioned virtual warehouses. D:Compute isolation allows teams to size and schedule processing without copying the underlying data. The operative distinction here is: Snowflake stores table data centrally while compute clusters enforce authorized access without owning separate data copies. The targeted change is: Separate shared managed storage from independently permissioned virtual warehouses.
Question 366A provider shares a sensitive table directly and discovers consumers can inspect fields beyond the approved reporting subset. An engineer proposes to share a suitably secure governed view instead of the unrestricted base table. Which explanation best describes why this is appropriate? Clean-room designs constrain collaboration to permitted analyses without exposing unrestricted raw data. Provider-side views can limit exposed columns and permitted values in a share. Reader accounts let a provider enable restricted data consumption for eligible partners. Secure Data Sharing lets consumers query provider-approved objects without copying the underlying data. ExplanationCorrect Answer B:Provider-side views can limit exposed columns and permitted values in a share. This is testable: a consumer query cannot retrieve restricted internal columns. Incorrect Answers A:Clean-room designs constrain collaboration to permitted analyses without exposing unrestricted raw data. For the current requirement, the decisive mechanism is: Provider-side views can limit exposed columns and permitted values in a share. The related action is: Share a suitably secure governed view instead of the unrestricted base table. C:Reader accounts let a provider enable restricted data consumption for eligible partners. For the current requirement, the decisive mechanism is: Provider-side views can limit exposed columns and permitted values in a share. The related action is: Share a suitably secure governed view instead of the unrestricted base table. D:Secure Data Sharing lets consumers query provider-approved objects without copying the underlying data. For the current requirement, the decisive mechanism is: Provider-side views can limit exposed columns and permitted values in a share. The related action is: Share a suitably secure governed view instead of the unrestricted base table.
Question 367A contractor connects from a prohibited public network despite valid object grants. After the team decides to apply a scoped network policy allowing only approved client sources, which observation most directly validates the result? A rotated service credential succeeds without exposing a password in job configuration. A designated test user authenticates through the authorized provider workflow. A permitted address connects while the blocked address cannot establish a session. The app performs permitted queries and a revoked token no longer authenticates. ExplanationCorrect Answer C:A permitted address connects while the blocked address cannot establish a session. This matters because network access rules evaluate connection origin separately from role permissions. Incorrect Answers A:Service identities should authenticate without embedding reusable employee passwords. This is not the decisive validation for the stated requirement. The relevant evidence is: A permitted address connects while the blocked address cannot establish a session. B:SSO centralizes identity controls under the organization's identity provider. This is not the decisive validation for the stated requirement. The relevant evidence is: A permitted address connects while the blocked address cannot establish a session. D:OAuth separates delegated authorization and token lifetimes from persistent user passwords. This is not the decisive validation for the stated requirement. The relevant evidence is: A permitted address connects while the blocked address cannot establish a session.
Question 368A single transactions table contains regions but regional teams may view only their own records. If the responsible team does not correct this condition, which outcome is the most relevant remaining risk? Policy drift remains invisible until a user encounters leaked values. Sensitive identifiers appear in every permitted query result. An overbroad filter blocks legitimate business data. One tenant can view another tenant's rows despite having SELECT. ExplanationCorrect Answer D:One tenant can view another tenant's rows despite having SELECT. The direct prevention is to implement a row access policy keyed to the approved regional authorization. Row policies filter which table records are visible to a querying role. Incorrect Answers A:Policy metadata enables compliance checks without granting raw data access. The immediate omission risk in this case is: One tenant can view another tenant's rows despite having SELECT. B:A masking expression can return different permitted representations based on the querying role. The immediate omission risk in this case is: One tenant can view another tenant's rows despite having SELECT. C:Access-control expressions must distinguish authorized matches from unintended denials. The immediate omission risk in this case is: One tenant can view another tenant's rows despite having SELECT.
Question 369An auditor wants to detect whether a policy applies to an object without reading prohibited values. Which Snowflake configuration or operational action most directly addresses this situation? Inspect governance metadata and effective policy assignments under an authorized audit role. Apply an appropriate dynamic data masking policy to the sensitive column. Implement a row access policy keyed to the approved regional authorization. Review effective masking and projection paths across derived objects before sharing the view. ExplanationCorrect Answer A:Policy metadata enables compliance checks without granting raw data access. The matching action is to inspect governance metadata and effective policy assignments under an authorized audit role. The audit output identifies the target column and its masking assignment. Incorrect Answers B:A masking expression can return different permitted representations based on the querying role. The operative distinction here is: Policy metadata enables compliance checks without granting raw data access. The targeted change is: Inspect governance metadata and effective policy assignments under an authorized audit role. C:Row policies filter which table records are visible to a querying role. The operative distinction here is: Policy metadata enables compliance checks without granting raw data access. The targeted change is: Inspect governance metadata and effective policy assignments under an authorized audit role. D:Governance must be tested at actual access points rather than inferred from a single column tag. The operative distinction here is: Policy metadata enables compliance checks without granting raw data access. The targeted change is: Inspect governance metadata and effective policy assignments under an authorized audit role.
Question 370A dashboard always filters by highly selective customer key while data is organized only by event date. An engineer proposes to compare search optimization and clustering using real predicate frequencies and costs. Which explanation best describes why this is appropriate? Eligible materialized views store maintained results that can avoid repeated full recomputation. Different optimization techniques suit point lookups versus broad range pruning. Small tables often cannot amortize clustering maintenance against query savings. A standard view stores its SQL definition; materialized views maintain results separately. ExplanationCorrect Answer B:Different optimization techniques suit point lookups versus broad range pruning. This is testable: the selected technique meets customer-key latency with justified maintenance charges. Incorrect Answers A:Eligible materialized views store maintained results that can avoid repeated full recomputation. For the current requirement, the decisive mechanism is: Different optimization techniques suit point lookups versus broad range pruning. The related action is: Compare search optimization and clustering using real predicate frequencies and costs. C:Small tables often cannot amortize clustering maintenance against query savings. For the current requirement, the decisive mechanism is: Different optimization techniques suit point lookups versus broad range pruning. The related action is: Compare search optimization and clustering using real predicate frequencies and costs. D:A standard view stores its SQL definition; materialized views maintain results separately. For the current requirement, the decisive mechanism is: Different optimization techniques suit point lookups versus broad range pruning. The related action is: Compare search optimization and clustering using real predicate frequencies and costs.