Snowflake COF-C02 Practice Test - Questions Answers, Page 36

The Snowflake command to unload the result of a query to a single file isCOPY INTO <internal stage> with SINGLE = TRUEfollowed by aGETcommand to download the file.This command unloads the query result into a single file in the specified internal stage

In a managed access schema, the schema owner retains the OWNERSHIP privilege of any tables added to the schema.This means that while object owners have certain privileges over the objects they create, only the schema owner can manage privilege grants on these objects1.

When using the ALLOW_CLIENT_MFA_CACHING parameter, a cached Multi-Factor Authentication (MFA) token is valid for up to 4 hours.This allows for continuous, secure connectivity without users needing to respond to an MFA prompt at the start of each connection attempt to Snowflake within this timeframe2.

The factors that impact storage costs in Snowflake include the account type (Capacity or On Demand) and the cloud region used by the account.These factors determine the rate at which storage is billed, with different regions potentially having different rates3.

The SECURITYADMIN role in Snowflake can manage any object grant globally, including modifying and revoking grants.This role has the necessary privileges to oversee and control access to all securable objects within the Snowflake environment4.

The GOVERNANCE_VIEWER role in the ACCOUNT_USAGE schema provides visibility into policy-related information within Snowflake.This role is specifically designed to access views that display object metadata and usage metrics related to governance12.

The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT.These data types support the storage and querying of semi-structured data, allowing for the creation of complex, nested data structures

Once an internal stage is dropped in Snowflake, it cannot be recovered or restored using Time Travel or UNDROP commands.The only option is to recreate the dropped stage

In a regular schema within Snowflake, the object owner has the privilege to grant object privileges.The object owner is typically the role that created the object or to whom the ownership of the object has been transferred78.

References = [COF-C02] SnowPro Core Certification Exam Study Guide