Free COF-C02 Exam Dumps Preview

Which Snowflake object does not consume any storage costs?

Which function generates a Snowflake hosted file URL to a staged file using the stage name and relative file path as inputs?

While loading data from a JSON file, what enables the removal of the outer array structure from the file and loads the records into separate table rows?

Which Snowflake keywords help retrieve data without the need to completely scan a table? (Choose two.)

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

What type of query will benefit from the query acceleration service?

Which role is responsible for managing the billing and credit data within Snowflake?

Snowflake charges a premium for storing semi-structured data.

What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Choose two.)

If DATA_RETENTION_TIME_IN_DAYS = 7 and MAX_DATA_EXTENSION_TIME_IN_DAYS = 8 are set.

How many days will pass before a stream becomes stale?

Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?

What is the MINIMUM Snowflake edition required to use the query acceleration service?

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

How would a user execute a series of SQL statements using a task?

Which function is used to retrieve the filename for a file stored on a stage?

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

How can a Snowflake user validate data that is unloaded using the COPY INTO command?

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

Who can create network policies within Snowflake? (Select TWO).

What happens when a value in a single row of a large table is updated?

Which command will indicate whether a materialized view is being used in a query?

Which of the following terms best describes Snowflake's database architecture?

What is the order of precedence (highest to lowest) of network policies when applied at the account, user, and security integrations layers?

Which REST API can be used with unstructured data?

Which Snowflake privilege is required on a pipe object to pause or resume pipes?

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

What are characteristics of Snowflake network policies? (Choose two.)

What is the abbreviated form to get all the files in the stage for the current user?

What can a Snowflake user do in the Admin area of Snow right?

Using which object-level parameters will help limit query processing and concurrency slowdowns? (Choose two.)

How can a user get the MOST detailed information about individual table storage details in Snowflake?

What command would a user execute to load unstructured data files into a Snowflake internal stage?

When would creating and using a standard view be preferable to using a materialized view?

What is an advantage of using database roles instead of granting privileges on objects directly to a share in Snowflake?

Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?

When sharing data in Snowflake, what privileges does a Provider need to grant along with a share? (Choose two.)

Masking policies are created at what level in Snowflake?

What is the recommended Snowflake data type to store semi-structured data like JSON?

When loading data into Snowflake, how should the data be organized?

Which Snowflake layer is associated with virtual warehouses?

What identi ers are supported when creating a Snowflake account hostname? (Choose two.)

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Users are able to see the result sets of queries executed by other users that share their same role.

A Snowflake user is investigating a slow-running query using the Query Profile.

Which metric would be a reason to increase the size of the virtual warehouse?

If there is queueing in the virtual warehouse load monitoring chart, what should a Snowflake user do?

When setting up a resource monitor for a virtual warehouse, at what interval are used credits reset?

When unloading data from Snowflake using the COPY INTO <location> command, what is a key consideration for handling NULL values?

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

How should a Snowflake use configure a virtual warehouse to be in Maximized mode?

What will prevent unauthorized access to a Snowflake account from an unknown source?

What type of query benefits the MOST from search optimization?

How does the search optimization service improve query performance?

The MAXIMUM size for a serverless task run is equivalent to what size virtual warehouse?

Which object can be used to query the data loading history for the last 365 days for a Snowflake account?

A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:

1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share

Based on this configuration what is true of the reader account?

A query against which table will provide details about bytes consumed by active, Time Travel, and Fail-safe storage?

Which command will allow users to query data from files in cloud storage without ingesting the data ?

Which Snowflake URL type allows users or applications to download or access files directly from Snowflake stage without authentication?

Which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

What happens to foreign key constraints when a table is cloned to another database?

Which table type is no longer available after the close of the session and therefore has no Fail-safe or Time Travel recovery option?

What are the correct settings for column and element names, regardless of which notation is used while accessing elements in a JSON object?

What happens when a Data Provider revokes privileges to a Share on an object in their source database?

Which multi-cluster virtual warehouse setting will help process queued queries as quickly as possible?

Which database objects can be shared with Secure Data Sharing? (Choose two.)

Which statement will execute a stored procedure?

What strategies can be used to optimize the performance of a virtual warehouse? (Choose two.)

Which use case will always cause an exploding join in Snowflake?

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

What privileges or user roles are required to get or request access to data that is available in the Snowflake Marketplace? (Select TWO).

A Snowflake user has been granted the CREATE DATA EXCHANGE LISTING privilege with their role.

Which tasks can this user now perform on the Data Exchange? (Choose two.)

What is a fundamental characteristic of Snowflake micro-partitions?

How is Single Sign-On (SSO) authentication used in Snowflake?

In Snowpipe, what is the default behavior of the ON_ERROR COPY option?

Which Snowflake data governance feature supports the tracking of sensitive data for compliance, discovery, protection, and resource usage?

What Snowflake object records Data Manipulation Language (DML) changes so that actions can be taken using the changed data?

What does a Query Profile provide in Snowflake?

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used.

The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

An external stage many_stage contains many directories including one, app_files that contains CSV files

How can all the CSV files from this directory be moved into table my_table without scanning files that are not needed?

Using which copy option when unloading data allows users to include a Universally Unique Identi er (UUID) in the names of unloaded les?

Which Snowflake database object can be shared with other accounts?

A size Small standard virtual warehouse running in auto-suspend mode is used for a production Business Intelligence (BI) reporting environment. The BI reports generate quickly in the early morning, but as the day progresses and there are more users, it takes longer to run the reports.

How can this situation be addressed?

Which command line parameter value can be pre-specified as an environment variable in SnowSQL?

AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

Which commands can a Snowflake user execute to specify a cluster key for a table? (Choose two.)

While unloading data into a stage, how can the user ensure that the output will be a single file?

What is the MINIMUM Snowftake edition that supports database replication?

At what level can the ALLOW_CLIENT_MFA_CACHING parameter be set?

Which Snowflake table type persists until it is explicitly dropped. is available for all users with relevant privileges (across sessions).
and has no Fail-safe period?

Which table is designed to store a catalog of stage files in cloud storage?

In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?

How are network policies defined in Snowflake?

Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

Which statement describes how Snowflake supports reader accounts?

What is the default character set used when loading CSV files into Snowflake?

Which table function will identify data that was loaded using COPY INTO <table> statements and also identify data loaded using Snowpipe?

How long is the Fail-safe period for recovering historical data from permanent tables?