Snowflake SnowPro Core Practice Test 18
Question 170
For an original SnowPro Core educational scenario, consider: An audit plan treats Fail-safe as a zero-cost customer-managed backup with unlimited retention. Select TWO complementary steps: the targeted correction and its strongest prechange validation.
- Change: Select Snowsight for suitable interactive tasks and supported Snowflake connectors, drivers or CLI for automated access.
- Check: Examine task graph history, predecessor states, warehouse permissions and failure handling.
- Change: Use Time Travel for self-service history and regard Fail-safe on eligible permanent objects as a limited Snowflake-assisted recovery mechanism.
- Check: Verify table type, historical retention expiration and documented support/recovery process before planning restoration.
- Run SELECT AT against Fail-safe as though it were an unlimited public snapshot store.
Explanation
Correct Answer
C:Fail-safe is not an ordinary customer-queryable historical table interface and it has different guarantees and storage implications from Time Travel. Evidence: Verify table type, historical retention expiration and documented support/recovery process before planning restoration.
D:Fail-safe is not an ordinary customer-queryable historical table interface and it has different guarantees and storage implications from Time Travel. Required intervention: Use Time Travel for self-service history and regard Fail-safe on eligible permanent objects as a limited Snowflake-assisted recovery mechanism.
Incorrect Answers
A:Change: Select Snowsight for suitable interactive tasks and supported Snowflake connectors, drivers or CLI for automated access. Fail-safe is not an ordinary customer-queryable historical table interface and it has different guarantees and storage implications from Time Travel.
B:Check: Examine task graph history, predecessor states, warehouse permissions and failure handling. Fail-safe is not an ordinary customer-queryable historical table interface and it has different guarantees and storage implications from Time Travel.
E:For this select two assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it. Fail-safe is not an ordinary customer-queryable historical table interface and it has different guarantees and storage implications from Time Travel.
Question 171
A Snowflake engineer is examining this platform situation: An order feed contains heterogeneous JSON attributes while the billing ID and amount must remain reliably typed for reporting. A proposed shortcut is: Convert all JSON numerics and booleans to unvalidated string fields before analytics. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Convert all JSON numerics and booleans to unvalidated string fields before analytics.
- Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules.
- Check the current account edition and feature-specific entitlement before promising governance, recovery or security behavior.
- Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Explanation
Correct Answer
D:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. Applied case: An order feed contains heterogeneous JSON attributes while the billing ID and amount must remain reliably typed for reporting.
Incorrect Answers
A:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. For this best change assessment, the shortcut changes or bypasses the necessary correctness, governance or operational boundary rather than correcting it.
B:Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
C:Check the current account edition and feature-specific entitlement before promising governance, recovery or security behavior. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 172
A Snowflake implementation review finds: An order feed contains heterogeneous JSON attributes while the billing ID and amount must remain reliably typed for reporting. The team proposes: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- UI and programmatic clients connect to the same governed account but differ in interaction, automation and authentication patterns.
- Fail-safe is not an ordinary customer-queryable historical table interface and it has different guarantees and storage implications from Time Travel.
- VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
- Transient tables forgo Fail-safe; permanent tables generally support both Time Travel and Fail-safe subject to edition and object retention settings.
Explanation
Correct Answer
C:Demonstrable success requires: Flexible payloads remain queryable and critical measures retain correct types rather than becoming ambiguous text. This principle explains the proposed technical approach, which is: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Snowsight and programmatic tools) rather than the documented Structured and semi-structured data types decision.
B:Fail-safe is not an ordinary customer-queryable historical table interface and it has different guarantees and storage implications from Time Travel. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
D:Transient tables forgo Fail-safe; permanent tables generally support both Time Travel and Fail-safe subject to edition and object retention settings. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 173
The data platform team has not yet approved changes. Current evidence indicates: An order feed contains heterogeneous JSON attributes while the billing ID and amount must remain reliably typed for reporting. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers.
- Reproduce creation, querying and session close using two independent connections.
- Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples.
- Create a controlled clone, compare initial storage and query results, then modify only the clone.
Explanation
Correct Answer
C:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. If confirmed, the proportionate intervention is: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Incorrect Answers
A:Inspect stream contents and consumption behavior using controlled inserts, updates and two separate downstream consumers. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
B:Reproduce creation, querying and session close using two independent connections. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
D:Create a controlled clone, compare initial storage and query results, then modify only the clone. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 174
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: An order feed contains heterogeneous JSON attributes while the billing ID and amount must remain reliably typed for reporting. 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.
- Approved use cases generate useful drafts without bypassing classification or uncritically treating model output as factual truth.
- Valid nested values are extracted and malformed optional fields are flagged or safely handled.
- Idle hours stop consuming warehouse compute and the next permitted query resumes processing as expected.
- Flexible payloads remain queryable and critical measures retain correct types rather than becoming ambiguous text.
Explanation
Correct Answer
D:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. The approved implementation step was: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Snowflake Cortex AI SQL functions) rather than the documented Structured and semi-structured data types decision.
B:Valid nested values are extracted and malformed optional fields are flagged or safely handled. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
C:Idle hours stop consuming warehouse compute and the next permitted query resumes processing as expected. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 175
An implementation sign-off request identifies the following problem: An order feed contains heterogeneous JSON attributes while the billing ID and amount must remain reliably typed for reporting. Which paired technical change and validation should close the implementation review? Select ONE best answer.
- Change: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types. Verify: Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples.
- 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: Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules. Verify: Compare QUERY_HISTORY warehouse identifiers, queued time and load before and after changing session warehouse assignments.
- Change: Set workload-suitable AUTO_SUSPEND and AUTO_RESUME values and validate startup behavior and billing. Verify: Review warehouse configuration, idle duration and metered credit history around overnight gaps.
Explanation
Correct Answer
A:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. The change is successful only when: Flexible payloads remain queryable and critical measures retain correct types rather than becoming ambiguous text.
Incorrect Answers
B:Change: Use correct VARIANT path expressions with explicit type conversion and null-safe handling for heterogeneous attributes. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
C:Change: Place ETL and interactive queries on independently configured warehouses with workload-appropriate sizes and schedules. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
D:Change: Set workload-suitable AUTO_SUSPEND and AUTO_RESUME values and validate startup behavior and billing. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 176
A Snowflake engineer is examining this platform situation: A pipeline flattens every nested JSON attribute into VARCHAR columns and loses numeric or Boolean type information. A proposed shortcut is: Convert all JSON numerics and booleans to unvalidated string fields before analytics. What should the Snowflake engineer recommend as the narrowly scoped correction? Select ONE best answer.
- Use permanent tables for durable recovery requirements and transient tables for suitable short-lived data with reduced recovery guarantees.
- Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency.
- Convert all JSON numerics and booleans to unvalidated string fields before analytics.
- Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Explanation
Correct Answer
D:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. This targeted change addresses the stated technical or governance gap without discarding necessary controls.
Incorrect Answers
A:Use permanent tables for durable recovery requirements and transient tables for suitable short-lived data with reduced recovery guarantees. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
B:Select Information Schema or ACCOUNT_USAGE views based on required object scope, privileges, history and documented latency. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
C:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. Use this instead: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types.
Question 177
A Snowflake implementation review finds: A pipeline flattens every nested JSON attribute into VARCHAR columns and loses numeric or Boolean type information. The team proposes: Store evolving documents in suitable VARIANT structures while defining needed relational attributes with appropriate native types. Which platform principle most strongly supports the recommended response? Select ONE best answer.
- Tables and views live in schemas within databases; session context determines resolution of unqualified object names.
- Hybrid tables favor low-latency indexed operations and enforced relational constraints, whereas ordinary Snowflake tables are optimized for analytical workloads.
- VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
- Snowflake separates account-specific resources and regions; cross-account data access and disaster recovery require supported configuration.
Explanation
Correct Answer
C:Demonstrable success requires: Flexible payloads remain queryable and critical measures retain correct types rather than becoming ambiguous text. Applied case: A pipeline flattens every nested JSON attribute into VARCHAR columns and loses numeric or Boolean type information.
Incorrect Answers
A:Tables and views live in schemas within databases; session context determines resolution of unqualified object names. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
B:This option addresses a different Snowflake technical topic (Hybrid tables and transactional constraints) rather than the documented Structured and semi-structured data types decision.
D:Snowflake separates account-specific resources and regions; cross-account data access and disaster recovery require supported configuration. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 178
The data platform team has not yet approved changes. Current evidence indicates: A pipeline flattens every nested JSON attribute into VARCHAR columns and loses numeric or Boolean type information. Which evidence best tests the technical diagnosis before approving a disruptive change? Select ONE best answer.
- Inspect execution history before and after actions such as collect or write and compare data transfer size.
- Compare requested time window, privileges, ingestion lag and query history against a sample event.
- Inspect parsed JSON values, TYPEOF results and casts for null, numeric, Boolean and string examples.
- Check retention settings, query timestamp and a before/after row sample before restoring.
Explanation
Correct Answer
C:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. Confirm afterward that: Flexible payloads remain queryable and critical measures retain correct types rather than becoming ambiguous text.
Incorrect Answers
A:This option addresses a different Snowflake technical topic (Snowpark DataFrame execution) rather than the documented Structured and semi-structured data types decision.
B:Compare requested time window, privileges, ingestion lag and query history against a sample event. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
D:Check retention settings, query timestamp and a before/after row sample before restoring. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
Question 179
A candidate correction has been tested and the platform team requires a post-change acceptance check. Original problem: A pipeline flattens every nested JSON attribute into VARCHAR columns and loses numeric or Boolean type information. 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.
- Derived data updates at the expected operational cadence with refresh failures observable.
- Scripts target the intended database.schema.object without cross-environment ambiguity.
- Queries operate over managed table storage and pruning reduces unnecessary scan work for selective predicates.
- Flexible payloads remain queryable and critical measures retain correct types rather than becoming ambiguous text.
Explanation
Correct Answer
D:VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations. The result must be validated using the documented dataset or access context.
Incorrect Answers
A:Derived data updates at the expected operational cadence with refresh failures observable. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
B:Scripts target the intended database.schema.object without cross-environment ambiguity. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
C:Queries operate over managed table storage and pruning reduces unnecessary scan work for selective predicates. VARIANT can hold semi-structured values and path-based access, while typed columns support explicit relational validation and calculations.
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.
