Which of the following statements describes a schema in Snowflake?

A logical grouping of objects that belongs to a single database

A logical grouping of objects that belongs to multiple databases

A named Snowflake object that includes all the information required to share a database

A uniquely identified Snowflake account within a business entity

What is a responsibility of Snowflake's virtual warehouses?

Permanent storage of micro-partitions

Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)

Authentication and access control

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

The size of the virtual warehouse

The length of time the warehouse is running

The number of active users assigned to the warehouse

The size of the virtual warehouse

The length of time the warehouse is running

The duration of the queries that are executed

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Secure User-Defined Functions (UDFs)

How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Which statement describes how Snowflake supports reader accounts?

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

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

Directory tables store data file metadata.

Directory tables do not have their own grantable privileges.

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

How would a user run a multi-cluster warehouse in maximized mode?

Set the minimum Clusters and maximum Clusters settings to the same value.

Configure the maximum clusters setting to 'Maximum.'

Turn on the additional clusters manually after starting the warehouse.

Set the minimum Clusters and maximum Clusters settings to the same value.

Set the minimum clusters and maximum clusters settings to different values.

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

Information Schema -> TABLE_STORAGE_METRICS

Information Schema -> TABLE_HISTORY

Information Schema -> TABLE_FUNCTION

Information Schema -> TABLE_STORAGE_METRICS

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

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1 WHERE ..

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the task definition CREATE TASK mytask .... AS call stored_proc1(); call stored_proc2();

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

A user has a standard multi-cluster warehouse auto-scaling policy in place.Which condition will trigger a cluster to shut-down?

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

What is cached during a query on a virtual warehouse?

The columns in the result set of the query

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

Running EXPLAIN and SHOW commands

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 data3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the shareBased on this configuration what is true of the reader account?

The reader account compute will be billed to the provider account.

The reader account will automatically use the Standard edition of Snowflake.

The reader account compute will be billed to the provider account.

The reader account can clone data the provider has shared, but cannot re-share it.

The reader account can create a copy of the shared data using CREATE TABLE AS...

Which of the following can be used when unloading data from Snowflake? (Choose two.)

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.

Use the ENCODING file format option to change the encoding from the default UTF-8.

The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.

By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.

Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

It does not return from the command until the warehouse has finished changing its size.

The warehouse size does not change until all queries currently running in the warehouse have completed.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

The warehouse size does not change until the warehouse is suspended and restarted.

It does not return from the command until the warehouse has finished changing its size.

Which of the following are characteristics of security in Snowflake?

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Account and user authentication is only available with the Snowflake Business Critical edition.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.Which command will show all privileges granted to that schema?

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

SHOW GRANTS ON ROLE DATA_SCIENCE

SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

SHOW GRANTS TO USER INQUISITIVE_PERSON

SHOW GRANTS OF ROLE DATA_SCIENCE

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

In the metadata of the pipe for 64 days

In the metadata of the target table for 14 days

In the metadata of the pipe for 14 days

In the metadata of the target table for 64 days

In the metadata of the pipe for 64 days

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.How does Snowflake recommend maximizing the load performance?

Produce the largest files possible, reducing the overall number of files to process.

Use auto-ingest Snowpipes to load large files in a serverless model.

Produce the largest files possible, reducing the overall number of files to process.

Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The columns most actively used in the select filters.

The columns that are queried in the select clause.

The columns with very high cardinality.

The columns with many different values.

The columns most actively used in the select filters.

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Grant the MANAGE GRANTS global privilege.

Grant the OWNERSHIP privilege on the schema.

Grant the OWNERSHIP privilege on the database.

Grant the MANAGE GRANTS global privilege.

Grant ALL privileges on the schema.

A materialized view should be created when which of the following occurs? (Choose two.)

The query consumes many compute resources every time it runs.

The results of the query do not change often and are used frequently.

There is minimal cost associated with running the query.

The query consumes many compute resources every time it runs.

The base table gets updated frequently.

The query is highly optimized and does not consume many compute resources.

The results of the query do not change often and are used frequently.

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

SELECT on tables used by the secure view

Snowflake COF-C02 Practice Test 6 - Free Online Exam Prep & Questions

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A.

Bytes sent over network

B.

Percentage scanned from cache

C.

Partitions total

D.

Bytes spilled to local storage

E.

Partitions scanned

Snowflake COF-C02 Practice Test 6

Question

Snowflake COF-C02 Practice Tests

Practice Tests