Which Snowflake table objects can be shared with other accounts? (Select TWO).

User-Defined Table Functions (UDTFs)

How can a Snowflake administrator determine which user has accessed a database object that contains sensitive information?

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

Review the granted privileges to the database object.

Review the row access policy for the database object.

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

How can a Snowflake user traverse semi-structured data?

Insert a colon (:) between the VARIANT column name and any first-level element.

Insert a colon (:) between the VARIANT column name and any second-level element.

Insert a double colon (: :) between the VARIANT column name and any first-level element.

Insert a double colon (: :) between the VARIANT column name and any second-level element.

What is the purpose of the Snowflake SPLIT TO_TABLE function?

To split a string and flatten the results into rows

To count the number of characters in a string

To split a string into an array of sub-strings

To split a string and flatten the results into rows

To split a string and flatten the results into columns

Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?

Multi-Factor Authentication (MFA)

A Snowflake account has activated federated authentication.What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?

The user will be unable to enter a password.

The user will encounter an error, and will not be able to log in.

The user will be able to log into Snowflake successfully.

After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

How do secure views compare to non-secure views in Snowflake?

There are no performance differences between secure and non-secure views.

Secure views execute slowly compared to non-secure views.

Non-secure views are preferred over secure views when sharing data.

Secure views are similar to materialized views in that they are the most performant.

There are no performance differences between secure and non-secure views.

How can a Snowflake user post-process the result of SHOW FILE FORMATS?

Create a CURSOR for the command.

Put it in the FROM clause in brackets.

Assign the command to RESULTSET.

When should a multi-cluster virtual warehouse be used in Snowflake?

When queuing is delaying query execution on the warehouse

When there is significant disk spilling shown on the Query Profile

When dynamic vertical scaling is being used in the warehouse

When there are no concurrent queries running on the warehouse

How does the Snowflake search optimization service improve query performance?

It improves the performance of equality searches.

It improves the performance of range searches.

It defines different clustering keys on the same source table.

It improves the performance of all queries running against a given table.

It improves the performance of equality searches.

It improves the performance of equality searches: The service optimizes the performance of queries that use equality search conditions (e.g., WHERE column = value). It creates and maintains a search index on the table's columns, which significantly speeds up the retrieval of rows based on those equality search conditions. This optimization is particularly beneficial for large tables where traditional scans might be inefficient for equality searches. By using the Search Optimization Service, Snowflake can leverage the search indexes to quickly locate the rows that match the search criteria without scanning the entire table. References: Snowflake Documentation: Search Optimization Service at Snowflake Documentation

What compute resource is used when loading data using Snowpipe?

Snowpipe uses compute resources provided by Snowflake.

Snowpipe uses virtual warehouses provided by the user.

Snowpipe uses an Apache Kafka server for its compute resources.

Snowpipe uses compute resources provided by Snowflake.

Snowpipe uses cloud platform compute resources provided by the user.

What is one of the characteristics of data shares?

Data shares utilize secure views for sharing view objects.

Data shares support full DML operations.

Data shares work by copying data to consumer accounts.

Data shares utilize secure views for sharing view objects.

Data shares are cloud agnostic and can cross regions by default.

Which SQL statement will require a virtual warehouse to run?

INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam*,20000,* Finance');

SELECT COUNT{*) FROM TBL_EMPLOYEE;

ALTER TABLE TBL_EMPLOYEE ADD COLUMN EMP_REGI0N VARCHAR(20);

INSERT INTO TBL_EMPLOYEE(EMP_ID, EMP_NAME, EMP_SALARY, DEPT) VALUES(1,'Adam*,20000,* Finance');

CREATE OR REPLACE TABLE TBL_EMPLOYEE ( EMP_ID NUMBER, EMP_NAME VARCHAR(30), EMP_SALARY NUMBER, DEPT VARCHAR{20) );

Which statement accurately describes how a virtual warehouse functions?

Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

Increasing the size of a virtual warehouse will always improve data loading performance.

Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.

Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.

All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.

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

View usage information for all accounts in the organization.

Enable database replication for an account in the organization.

Create information_schema in a database

View usage information for all accounts in the organization.

Enable database cloning for an account in the organization.

Enable database replication for an account in the organization.

View micro-partition information for all accounts in the organization.

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

Performing aggregate calculations

What consideration should be made when loading data into Snowflake?

The number of data files that are processed in parallel is determined by the virtual warehouse.

Create small data files and stage them in cloud storage frequently.

Create large data files to maximize the processing overhead for each file.

The number of load operations That run in parallel can exceed the number of data files to be loaded.

The number of data files that are processed in parallel is determined by the virtual warehouse.

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

What happens when a Snowflake user changes the data retention period at the schema level?

Become a Premium Member for full access

Unlock Premium Member

Snowflake COF-C02 Practice Test 11

Question

Snowflake COF-C02 Practice Tests

Practice Tests