When regularly unloading similarly formatted semi-structured data, where should copy options be specified?
Correct Answer: B
The correct answer is B. In a named file format . When data is regularly loaded or unloaded using the same format settings, Snowflake recommends defining those settings in a named file format. This avoids repeating the same file format options in every COPY command and reduces operational overhead. Why B is correct: A named file format stores reusable format options, such as file type and formatting behavior. For semi- structured data, named file formats can define options for formats such as JSON, Avro, ORC, Parquet, or XML. Example: CREATE FILE FORMAT my_json_format TYPE = JSON COMPRESSION = AUTO; COPY INTO @my_stage/output/ FROM my_table FILE_FORMAT = my_json_format; Why the other options are incorrect: A). A table definition defines table columns and properties, not unload formatting options. C). A named stage can include a file format reference, but the reusable copy/file parsing settings themselves are defined in a named file format. D). Copy options can be specified directly in the COPY command, but that is less efficient for repeated, similarly formatted unload operations. Official Snowflake documentation reference: Snowflake documentation explains that named file formats are reusable database objects that define format options for loading and unloading data. Reference: Snowflake Documentation - CREATE FILE FORMAT; Snowflake Documentation - Data unloading; Snowflake Documentation - COPY INTO < location > ; SnowPro Core Study Guide - Data Loading and Unloading.
Question 357
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
Correct Answer: D,E
Secure sharing in Snowflake allows users to share specific objects with other Snowflake accounts without physically copying the data, thus not consuming additional storage. Tables and Secure User Defined Functions (UDFs) are among the objects that can be shared using this feature. Materialized views, sequences, and procedures are not shareable objects in Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide Snowflake Documentation on Secure Data Sharing1
Question 358
To use the overwrite option on insert, which privilege must be granted to the role?
Correct Answer: B
To use the overwrite option on insert in Snowflake, the DELETE privilege must be granted to the role. This is because overwriting data during an insert operation implicitly involves deleting the existing data before inserting the new data. Understanding the Overwrite Option: The overwrite option (INSERT OVERWRITE) allows you to replace existing data in a table with new data. This operation is particularly useful for batch-loading scenarios where the entire dataset needs to be refreshed. Why DELETE Privilege is Required: Since the overwrite operation involves removing existing rows in the table, the executing role must have the DELETE privilege to carry out both the deletion of old data and the insertion of new data. Granting DELETE Privilege: To grant the DELETE privilege to a role, an account administrator can execute the following SQL command: sqlCopy code GRANT DELETE ON TABLE my_table TO ROLE my_role;
Question 359
What objects can be cloned within Snowflake? (Select TWO).
Correct Answer: A,E
In Snowflake,cloningis available for certain types of objects, allowing quick duplication without copying data: Schemas: These can be cloned, enabling users to replicate entire schema structures, including tables and views, for development or testing. Internal named stages: These stages, used to store data files within Snowflake, can also be cloned, preserving configurations for data loading. Users and external objects (like external stages or tables) cannot be cloned due to their dependency on external data and configurations outside Snowflake.
Question 360
What AUTHENTICATION_METHODS value should be selected for the Single Sign-On, or SSO, login option to appear when creating a Snowflake authentication policy?
Correct Answer: C
The correct answer is C. SAML . In Snowflake, Single Sign-On is commonly implemented using federated authentication through a SAML 2.0 identity provider. When creating an authentication policy, including SAML in the allowed AUTHENTICATION_METHODS enables SSO-based login options. Why C is correct: SAML represents SAML-based federated authentication. This is the authentication method associated with SSO login in Snowflake. Example concept: CREATE AUTHENTICATION POLICY sso_policy AUTHENTICATION_METHODS = ( ' SAML ' ); Why the other options are incorrect: A). PASSWORD allows username and password authentication, not SSO. B). KEYPAIR allows key-pair authentication, commonly used for service accounts and applications. D). OAUTH allows OAuth-based authentication, but the SSO login option in this context is associated with SAML. Official Snowflake documentation reference: Snowflake documentation describes authentication policies as controlling allowed authentication methods, including password, SAML, OAuth, and key-pair authentication. SAML is used for federated SSO authentication. Reference: Snowflake Documentation - Authentication policies; Snowflake Documentation - Federated authentication and SSO; SnowPro Core Study Guide - Security and Access Control.
