What can be shared when the SECURE_OBJECTS_ONLY property is set to FALSE?
Correct Answer: A
The correct answer is A. View . In Snowflake data sharing, secure objects are normally required when sharing views or functions because secure objects prevent sensitive underlying query details from being exposed. However, when the SECURE_OBJECTS_ONLY property is set to FALSE, non-secure views can be shared. Why A is correct: A view can be shared when SECURE_OBJECTS_ONLY = FALSE. This setting relaxes the requirement that only secure views be included. Why the other options are incorrect: B). Stored procedures are not standard objects shared through Snowflake secure data sharing in the same way as tables and views. C). Storage integration access is not shared as a database object through a Snowflake share. D). UDF sharing has security restrictions, and the safest exam answer here is a view when SECURE_OBJECTS_ONLY is disabled. Official Snowflake documentation reference: Snowflake documentation explains that shares can include database objects such as tables and views. Secure object requirements apply to certain shared objects, and the SECURE_OBJECTS_ONLY property controls whether only secure objects are allowed. Reference: Snowflake Documentation - Secure Data Sharing; Snowflake Documentation - Shares; Snowflake Documentation - SECURE_OBJECTS_ONLY; SnowPro Core Study Guide - Data Protection and Governance.
Question 277
Which copy INTO command outputs the data into one file?
Correct Answer: B
The COPY INTO command in Snowflake can be configured to output data into a single file by setting the MAX_FILE_NUMBER option to 1. This option limits the number of files generated by the command, ensuring that only one file is created regardless of the amount of data being exported. References: [COF-C02] SnowPro Core Certification Exam Study Guide Snowflake Documentation on Data Unloading
Question 278
A user is setting up Snowpipe automation to load data from an Amazon S3 bucket into Snowflake. The user wants Snowflake to automatically start loading files as soon as new ones are added to the bucket. Which steps are required to configure this automation using cloud messaging? Select TWO.
Correct Answer: A,D
For Snowpipe auto-ingest on Amazon S3, cloud event notifications are configured so Snowflake is notified when new files arrive. The pipe must also be created with AUTO_INGEST = TRUE. Why A and D are correct: Amazon S3 event notifications can publish file arrival events through Amazon SNS/SQS integration, and Snowpipe uses those notifications when AUTO_INGEST is enabled. Reference: Snowflake Documentation - Snowpipe auto-ingest on Amazon S3; CREATE PIPE. ==
Question 279
What are streams used for in Snowflake?
Correct Answer: B
The correct answer is B. To track DML changes that have been made to tables . A stream is a Snowflake object used for change data capture. It records changes made to a source table so those changes can be consumed later by SQL logic, usually as part of an incremental processing pipeline. Why B is correct: Streams track DML changes such as: INSERT UPDATE DELETE They also expose metadata columns such as: METADATA$ACTION METADATA$ISUPDATE METADATA$ROW_ID These columns help identify the type of change and the affected row. Why the other options are incorrect: A). Tasks execute scheduled SQL and can be used to run data pipelines. Streams track the changes consumed by those pipelines. C). File formats define how staged files are interpreted during loading or unloading. Streams are unrelated to file format definitions. D). Caching is handled by Snowflake result cache and warehouse cache mechanisms, not by streams. Official Snowflake documentation reference: Snowflake documentation describes streams as objects that record DML changes made to tables, including inserts, updates, and deletes. Reference: Snowflake Documentation - Streams; Snowflake Documentation - Change data capture; SnowPro Core Study Guide - SQL and Snowflake Objects. ==
Question 280
What information is included in the output of an EXPLAIN_PLAN?
Correct Answer: D
The correct answer is D. The total number of micro-partitions that the operation will reference . In Snowflake, EXPLAIN or EXPLAIN USING returns the logical execution plan for a SQL statement. The plan can include information about the operations Snowflake expects to perform, such as table scans, filters, joins, and estimated partitions involved in the query. Why D is correct: The explain plan can show partition-related information for table scan operations, including the number of partitions that may be scanned. This is useful for understanding how well Snowflake can prune micro- partitions. Why the other options are incorrect: A). EXPLAIN_PLAN does not provide a guaranteed predicted query runtime. Actual execution time depends on warehouse size, load, caching, pruning, and other runtime factors. B). EXPLAIN_PLAN does not directly state the number of credits the query will consume. Credit consumption is based mainly on warehouse runtime and size. C). EXPLAIN_PLAN describes the execution plan, not the actual result data type returned by the query. Official Snowflake documentation reference: Snowflake documentation explains that the EXPLAIN command displays the logical execution plan for a SQL statement. Query plans can include details about operations such as scans, joins, filters, and partitions. Reference: Snowflake Documentation - EXPLAIN; Snowflake Documentation - Query Profile and query optimization; SnowPro Core Study Guide - Performance Optimization. ==
