Snowflake SnowPro Core Practice Test 20
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.
Question 191
A Snowflake engineer is examining this platform situation: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item. A proposed shortcut is: Use string split on a JSON document without parsing its array structure. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields.
- Use string split on a JSON document without parsing its array structure.
- Select Snowsight for suitable interactive tasks and supported Snowflake connectors, drivers or CLI for automated access.
- Use Snowflake tasks with explicit predecessors and monitored task graph behavior for supported SQL or procedure workflows.
Explanation
Correct Answer
A:The required acceptance condition is: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. Applied case: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item.
Incorrect Answers
B:For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Applied case: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item.
C:Select Snowsight for suitable interactive tasks and supported Snowflake connectors, drivers or CLI for automated access. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:Use Snowflake tasks with explicit predecessors and monitored task graph behavior for supported SQL or procedure workflows. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 192
A Snowflake implementation review finds: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item. The team proposes: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Zero-copy clones initially share existing micro-partitions, while subsequent modifications create independent data where changes occur.
- Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout.
- FLATTEN is a table function that expands elements of semi-structured arrays into rows.
- UI and programmatic clients connect to the same governed account but differ in interaction, automation and authentication patterns.
Explanation
Correct Answer
C:Demonstrable success requires: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. Applied case: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item.
Incorrect Answers
A:Zero-copy clones initially share existing micro-partitions, while subsequent modifications create independent data where changes occur. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
B:Iceberg tables use external cloud object storage and Iceberg metadata rather than Snowflake's native managed storage layout. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:UI and programmatic clients connect to the same governed account but differ in interaction, automation and authentication patterns. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 193
The data platform team has not yet approved changes. Current evidence indicates: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Compare access pattern, index availability, concurrency, constraint enforcement and compute cost.
- Validate path selection, output row counts, INDEX and VALUE on arrays including empty and missing cases.
- Review warehouse configuration, idle duration and metered credit history around overnight gaps.
- Inspect execution history before and after actions such as collect or write and compare data transfer size.
Explanation
Correct Answer
B:Confirm afterward that: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. Applied case: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item.
Incorrect Answers
A:Compare access pattern, index availability, concurrency, constraint enforcement and compute cost. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
C:Review warehouse configuration, idle duration and metered credit history around overnight gaps. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:Inspect execution history before and after actions such as collect or write and compare data transfer size. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 194
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item. 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.
- Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately.
- The approved design relies only on supported capabilities or explicitly plans the necessary edition change.
- Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components.
- Clusters grow for meaningful demand and shrink when the service target permits without sustaining idle peak capacity.
Explanation
Correct Answer
A:The approved implementation step was: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. Applied case: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item.
Incorrect Answers
B:The approved design relies only on supported capabilities or explicitly plans the necessary edition change. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
C:Cost analysis and architecture diagrams identify cloud services and warehouse activity as distinct components. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:Clusters grow for meaningful demand and shrink when the service target permits without sustaining idle peak capacity. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 195
An implementation sign-off request identifies the following problem: An events VARIANT contains a list of purchased products but a report returns one row per entire order instead of each item. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. Verify: Validate path selection, output row counts, INDEX and VALUE on arrays including empty and missing cases.
- Change: Set explicit current database and schema or use fully qualified identifiers for deployment-sensitive operations. Verify: Inspect CURRENT_DATABASE, CURRENT_SCHEMA, SHOW TABLES and fully qualified object names in the deployment session.
- Change: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. Verify: Compare service-level billing and account usage with warehouse usage for the relevant reporting period.
- 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.
Explanation
Correct Answer
A:The change is successful only when: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately.
Incorrect Answers
B:Change: Set explicit current database and schema or use fully qualified identifiers for deployment-sensitive operations. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
C:Change: Distinguish cloud-services-layer functions from virtual warehouse execution when analyzing processing and billable consumption. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:Change: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 196
A Snowflake engineer is examining this platform situation: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting. A proposed shortcut is: Use string split on a JSON document without parsing its array structure. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Let Snowflake manage compressed columnar micro-partitions for native table data and use pruning-aware design where necessary.
- Use string split on a JSON document without parsing its array structure.
- Use supported CLONE operations for a point-in-time logical snapshot and treat later changes to source and clone as separate.
- Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields.
Explanation
Correct Answer
D:The required acceptance condition is: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. Applied case: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting.
Incorrect Answers
A:Let Snowflake manage compressed columnar micro-partitions for native table data and use pruning-aware design where necessary. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
B:For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Applied case: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting.
C:Use supported CLONE operations for a point-in-time logical snapshot and treat later changes to source and clone as separate. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 197
A Snowflake implementation review finds: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting. The team proposes: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA.
- Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics.
- FLATTEN is a table function that expands elements of semi-structured arrays into rows.
- Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query.
Explanation
Correct Answer
C:Demonstrable success requires: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. Applied case: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting.
Incorrect Answers
A:Dynamic tables maintain query-defined results through managed refresh scheduling; target lag is an objective, not a hard real-time SLA. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
B:Information Schema and Snowflake shared-account usage views provide different metadata scopes and refresh characteristics. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:Additional clusters can reduce queuing under concurrency, but do not inherently accelerate one slow query. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 198
The data platform team has not yet approved changes. Current evidence indicates: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Verify client driver version, role, database, warehouse, authentication and query history for a representative operation.
- Validate path selection, output row counts, INDEX and VALUE on arrays including empty and missing cases.
- Compare account identifiers, regions, sharing or replication configuration and permitted data paths.
- Inspect stage file listings, directory table refresh and supported document-processing entry points.
Explanation
Correct Answer
B:Confirm afterward that: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. Applied case: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting.
Incorrect Answers
A:Verify client driver version, role, database, warehouse, authentication and query history for a representative operation. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
C:Compare account identifiers, regions, sharing or replication configuration and permitted data paths. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:Inspect stage file listings, directory table refresh and supported document-processing entry points. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 199
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting. 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.
- Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately.
- Each consumer processes only its authorized new changes without missing events due to another consumer's offset.
- The recovery runbook specifies the correct mechanism and realistic timing for historical incidents.
- Analysts can create and maintain notebooks in the supported current experience with governed data access.
Explanation
Correct Answer
A:The approved implementation step was: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields. Applied case: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting.
Incorrect Answers
B:Each consumer processes only its authorized new changes without missing events due to another consumer's offset. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
C:The recovery runbook specifies the correct mechanism and realistic timing for historical incidents. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
D:Analysts can create and maintain notebooks in the supported current experience with governed data access. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Question 200
For an original SnowPro Core educational scenario, consider: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting. Select THREE compatible elements: a proper correction, a targeted diagnostic and an acceptance result.
- Change: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields.
- Result: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately.
- Check: Validate path selection, output row counts, INDEX and VALUE on arrays including empty and missing cases.
- Result: Target queries finish within agreed latency while extra compute cost remains justified.
- Change: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration.
- Check: Inspect queued overload time, cluster count, concurrency and credit usage during a realistic peak.
Explanation
Correct Answer
A:Acceptance: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. Applied case: A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting.
B:Required intervention: Use LATERAL FLATTEN against the appropriate VARIANT array and select the expanded VALUE fields.
C:Acceptance: Each intended array element appears as a queryable row while empty or malformed payloads are handled deliberately. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
Incorrect Answers
D:Result: Target queries finish within agreed latency while extra compute cost remains justified. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
E:Change: Design a supported Snowflake Iceberg table with its external cloud data and metadata location and appropriate catalog configuration. A telemetry analyst needs one record per reading in a nested JSON array and is considering manual string splitting.
F:Check: Inspect queued overload time, cluster count, concurrency and credit usage during a realistic peak. FLATTEN is a table function that expands elements of semi-structured arrays into rows.
