Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?

The column name is case-insensitive but element names are case-sensitive.

The column name and element names are both case-sensitive.

The column name and element names are both case-insensitive.

The column name is case-sensitive but element names are case-insensitive.

The column name is case-insensitive but element names are case-sensitive.

What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

There are multiple SOL UDFs with the same names and the same number of arguments.

There are multiple SQL UDFs with the same names and the same number of argument types.

There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

There are multiple SQL UDFs with different names but the same number of arguments or argument types.

Which SQL command can be used to verify the privileges that are granted to a role?

SHOW GRANTS TO ROLE <Role Name>

SHOW GRANTS ON ROLE <Role Name>

SHOW GRANTS TO ROLE <Role Name>

SHOW GRANTS FOR ROLE <Role Name>

There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?

Create a data share from the production account to the non-production account.

Clone the data from the production account to the non-production account.

Create a data share from the production account to the non-production account.

Create a subscription in the production account and have it publish to the non-production account.

Create a reader account using the production account and link the reader account to the non-production account.

Which privilege is required to use the search optimization service in Snowflake?

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>

GRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>

GRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>

GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>

GRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE <role>

User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.What will happen if User2 tries to access the query history?

If User2 has the ACCOUNTADMIN role they will be able to see the results.

If User2 has the sysadmin role they will be able to see the results.

If User2 has the securityadmin role they will be able to see the results.

If User2 has the ACCOUNTADMIN role they will be able to see the results.

User2 will be unable to view the result set of the query executed by User1.

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

What does the TableScan operator represent in the Query Profile?

The access to data stored in stage objects

The list of values provided with the VALUES clause

The records generated using the TABLE (GENERATOR (...)) construct

What activities can a user with the ORGADMIN role perform? (Select TWO).

Create an account for an organization.

View usage information for all accounts in an organization.

Create an account for an organization.

Edit the account data for an organization.

Delete the account data for an organization.

View usage information for all accounts in an organization.

Select all the data in tables for all accounts in an organization.

How are network policies defined in Snowflake?

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect to Snowflake.

They are a set of rules that define the network routes within Snowflake.

They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect to Snowflake.

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

Use the GET_ABSOLUTE_PATH function.

Use the DESCRIBE STAGE command.

Use the GET_ABSOLUTE_PATH function.

Use the GET_STAGE_LOCATION function.

Which statement accurately describes Snowflake's architecture?

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

It uses a local data repository for all compute nodes in the platform.

It is a blend of shared-disk and shared-everything database architectures.

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

It reorganizes loaded data into internal optimized, compressed, and row-based format.

Which use case does the search optimization service support?

Conjunctions (AND) of multiple equality predicates

Disjuncts (OR) in join predicates

LIKE/ILIKE/RLIKE join predicates

Join predicates on VARIANT columns

Conjunctions (AND) of multiple equality predicates

What are characteristics of transient tables in Snowflake? (Select TWO).

Transient tables can be cloned to permanent tables.

Transient tables persist until they are explicitly dropped.

Transient tables have a Fail-safe period of 7 days.

Transient tables can be cloned to permanent tables.

Transient tables persist until they are explicitly dropped.

Transient tables can be altered to make them permanent tables.

Transient tables have Time Travel retention periods of 0 or 1 day.

What will happen if a Snowflake user increases the size of a suspended virtual warehouse?

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

The provisioning of new compute resources for the warehouse will begin immediately.

The warehouse will remain suspended but new resources will be added to the query acceleration service.

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?

No, because ownership of a table does not include the ability to change masking policies

Yes, because a table owner has full control and can unset masking policies.

Yes, because masking policies only apply to cloned tables.

No, because masking policies must always reference specific access roles.

No, because ownership of a table does not include the ability to change masking policies

Which of the following describes how clustering keys work in Snowflake?

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

A Windows server file share on Azure

An FTP server with TLS encryption

A Windows server file share on Azure

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

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Snowflake COF-C02 Practice Test 12

Question

Snowflake COF-C02 Practice Tests

Practice Tests