Snowflake SnowPro Core Practice Test 19
Question 180
For an original SnowPro Core educational scenario, consider: A pipeline flattens every nested JSON attribute into VARCHAR columns and loses numeric or Boolean type information. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Check: Verify table type, historical retention expiration and documented support/recovery process before planning restoration.
- Check: Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples.
- Convert all JSON numerics and booleans to unvalidated string fields before analytics.
- Change: Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements.
- Change: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Explanation
Correct Answer
B:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. Required intervention: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
E:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. Acceptance: Flexible payloads remain queryable and critical measures retain correct types rather than becoming ambiguous text.
Incorrect Answers
A:Check: Verify table type, historical retention expiration and documented support/recovery process before planning restoration. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
C:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
D:Change: Tune MIN_CLUSTER_COUNT, MAX_CLUSTER_COUNT and supported scaling policy against measured concurrency requirements. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 181
A Snowflake engineer is examining this platform situation: A sensor payload contains an array of nested readings and analysts receive NULLs because the path uses the wrong key casing. A proposed shortcut is: Treat every nested JSON path as a guaranteed NUMBER without checking structure or content. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules.
- Treat every nested JSON path as a guaranteed NUMBER without checking structure or content.
- Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency.
- Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes.
Explanation
Correct Answer
D:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. Applied case: A sensor payload contains an array of nested readings and analysts receive NULLs because the path uses the wrong key casing.
Incorrect Answers
A:Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
B:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
C:Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
Question 182
A Snowflake implementation review finds: A sensor payload contains an array of nested readings and analysts receive NULLs because the path uses the wrong key casing. The team proposes: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism.
- Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics.
- Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
- Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute.
Explanation
Correct Answer
C:Relevant validation before approval: Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records. Applied case: A sensor payload contains an array of nested readings and analysts receive NULLs because the path uses the wrong key casing.
Incorrect Answers
A:Managed AI functions can operate within supported Snowflake services, but model output requires governance and validation rather than assumption of determinism. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
B:Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
D:Snowflake-managed cloud services coordinate metadata, access decisions and query optimization independently of warehouse compute. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
Question 183
The data platform team has not yet approved changes. Current evidence indicates: A sensor payload contains an array of nested readings and analysts receive NULLs because the path uses the wrong key casing. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Examine task graph history, predecessor states, warehouse permissions and failure handling.
- Compare access pattern, index availability, concurrency, constraint enforcement and compute cost.
- Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
- Create a controlled clone, compare initial storage and query results, then modify only the clone.
Explanation
Correct Answer
C:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. This check tests the actual data, compute or access boundary before an operationally risky change.
Incorrect Answers
A:Examine task graph history, predecessor states, warehouse permissions and failure handling. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
B:Compare access pattern, index availability, concurrency, constraint enforcement and compute cost. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
D:Create a controlled clone, compare initial storage and query results, then modify only the clone. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
Question 184
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A sensor payload contains an array of nested readings and analysts receive NULLs because the path uses the wrong key casing. 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.
- Valid nested values are extracted and malformed optional fields are flagged or safely handled.
- Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately.
- The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
- Clusters grow for meaningful demand and shrink when the service target permits without sustaining idle peak capacity.
Explanation
Correct Answer
A:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. The result must be validated using the documented dataset or access context.
Incorrect Answers
B:This option addresses a different Snowflake technical topic (FLATTEN on array elements) rather than the documented Semi-structured path navigation decision.
C:The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
D:This option addresses a different Snowflake technical topic (Warehouse scaling mode and minimum clusters) rather than the documented Semi-structured path navigation decision.
Question 185
An implementation sign-off request identifies the following problem: A sensor payload contains an array of nested readings and analysts receive NULLs because the path uses the wrong key casing. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Check the current account edition and feature-specific entitlement before promising governance, recovery or security behavior. Verify: Inspect edition, feature availability and limits for the named requirement in an isolated test account.
- Change: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes. Verify: Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
- Change: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration. Verify: Review catalog choice, external volume, object storage paths and metadata refresh requirements.
- Change: Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency. Verify: Compare requested time window, privileges, ingestion lag and query history against a sample event.
Explanation
Correct Answer
B:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. The change is successful only when: Valid nested values are extracted and malformed optional fields are flagged or safely handled.
Incorrect Answers
A:Change: Check the current account edition and feature-specific entitlement before promising governance, recovery or security behavior.
C:This option addresses a different Snowflake technical topic (Apache Iceberg table architecture) rather than the documented Semi-structured path navigation decision.
D:Change: Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
Question 186
A Snowflake engineer is examining this platform situation: A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER. A proposed shortcut is: Treat every nested JSON path as a guaranteed NUMBER without checking structure or content. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules.
- Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes.
- Treat every nested JSON path as a guaranteed NUMBER without checking structure or content.
- Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Explanation
Correct Answer
B:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules. A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER.
C:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. Use this instead: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes.
D:This option addresses a different Snowflake technical topic (Structured and semi-structured data types) rather than the documented Semi-structured path navigation decision.
Question 187
A Snowflake implementation review finds: A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER. The team proposes: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Distinct Snowflake warehouses have independent compute resources, so separating workloads reduces resource contention without copying database storage.
- Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
- Streams track table change offsets; consuming a stream in committed DML advances its position, so independent consumers need separate offsets.
- Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
Explanation
Correct Answer
D:Relevant validation before approval: Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records. Demonstrable success requires: Valid nested values are extracted and malformed optional fields are flagged or safely handled.
Incorrect Answers
A:Distinct Snowflake warehouses have independent compute resources, so separating workloads reduces resource contention without copying database storage. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
B:This option addresses a different Snowflake technical topic (Dynamic tables for declarative pipelines) rather than the documented Semi-structured path navigation decision.
C:This option addresses a different Snowflake technical topic (Streams for change data capture) rather than the documented Semi-structured path navigation decision.
Question 188
The data platform team has not yet approved changes. Current evidence indicates: A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
- Review warehouse configuration, idle duration and metered credit history around overnight gaps.
- Create a controlled clone, compare initial storage and query results, then modify only the clone.
- Compare table type, data-retention parameter, recovery needs and storage usage before conversion.
Explanation
Correct Answer
A:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. Applied case: A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER.
Incorrect Answers
B:Review warehouse configuration, idle duration and metered credit history around overnight gaps. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
C:Create a controlled clone, compare initial storage and query results, then modify only the clone. A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER.
D:Compare table type, data-retention parameter, recovery needs and storage usage before conversion. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
Question 189
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER. 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.
- The source remains unchanged and a practical test clone is created without an immediate full physical duplication.
- The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure.
- Valid nested values are extracted and malformed optional fields are flagged or safely handled.
- Target queries finish within agreed latency while extra compute cost remains justified.
Explanation
Correct Answer
C:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. The approved implementation step was: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes.
Incorrect Answers
A:The source remains unchanged and a practical test clone is created without an immediate full physical duplication. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
B:The targeted memory-intensive job succeeds economically without changing unrelated dashboard infrastructure. A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER.
D:Target queries finish within agreed latency while extra compute cost remains justified. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
Question 190
For an original SnowPro Core educational scenario, consider: A customer JSON record has missing optional fields and a SQL query crashes when casting an unexpected string to NUMBER. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Test a larger warehouse size for the memory- or compute-bound individual query and review profile improvement versus credits.
- Check: Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases.
- Change: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes.
- Treat every nested JSON path as a guaranteed NUMBER without checking structure or content.
- Check: Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
Explanation
Correct Answer
C:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. Evidence: Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
E:Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment. Inspect raw PARSE_JSON output, key names, TYPEOF and TRY_TO_NUMBER results on representative records.
Incorrect Answers
A:Change: Test a larger warehouse size for the memory- or compute-bound individual query and review profile improvement versus credits. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
B:Check: Test permissions, sample outputs, cost consumption, sensitive-data handling and false assertions against known cases. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
D:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Semi-structured paths and types must match document structure; missing keys and invalid casts need intentional treatment.
