Which type of workload is recommended for Snowpark-optimized virtual warehouses?

Workloads that have large memory requirements

Workloads with ad hoc analytics

Workloads that have large memory requirements

Workloads with unpredictable data volumes for each query

Workloads that are queried with small table scans and selective filters

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO <table> command when loading data from a JSON file into a table?

It removes the outer array structure and loads separate rows of data

It flattens multiple arrays into a single array.

It removes the outer array structure and loads separate rows of data

It transforms a pivoted table into an array.

It tokenizes each data string using the defined delimiters.

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?

Add a clustering key to the table

Add a limit clause to the query.

Add a Dynamic Data Masking policy to the table.

Which command should be used to assign a key to a Snowflake user who needs to connect using key pair authentication?

ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';

ALTER USER jsmith SET RSA_P8_KEY='MIIBIjANBgkqh...';

ALTER USER jsmith SET ENCRYPTED_KEY='MIIBIjANBgkqh...';

ALTER USER jsmith SET RSA_PRIVATE_KEY='MIIBIjANBgkqh...';

ALTER USER jsmith SET RSA_PUBLIC_KEY-MIIBIjANBgkqh...';

Secured Data Sharing is allowed for which Snowflake database objects? (Select TWO).

User-Defined Table Functions (UDTFs)

What is the purpose of the use of the VALIDATE command?

To see all errors from a previously run COPY INTO <table> statement

To view any queries that encountered an error

To verify that a SELECT query will run without error

To prevent a put statement from running if an error occurs

To see all errors from a previously run COPY INTO <table> statement

What is the primary purpose of using a masking policy in Snowflake?

To protect sensitive data from unauthorized access when queries are run.

To automatically encrypt sensitive data when data is stored in Snowflake.

To protect multiple columns that have different data types in a given table.

To protect both column-level and row-level data.

What happens when a table or schema with a standard retention period is dropped?

The object is retained for the data retention period.

The object is immediately removed from the system.

The object is instantaneously moved to Fail-safe.

The object is retained but all associated data is immediately purged.

The object is retained for the data retention period.

How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?

Create a data share for a test data consumer account and check if the secure view data is appearing as expected.

Log in to the data consumer account and check if the secure view data is appearing as expected.

Create a data share for a test data consumer account and check if the secure view data is appearing as expected.

Query the secure view from a consumer account by setting the share_restrictions parameter.

Simulate querying the secure view by setting the simulated_data_sharing_consumer session parameter.

How does the search optimization service improve query performance?

By creating a persistent data structure

By optimizing the use of micro-partitions

When working with table MY_TABLE that contains 10 rows, which sampling query will always return exactly 5 rows?

SELECT * FROM MY_TABLE SAMPLE (5 ROWS);

SELECT * FROM MY_TABLE SAMPLE SYSTEM (5);

SELECT * FROM MY_TABLE SAMPLE BERNOULLI (5);

SELECT * FROM MY_TABLE SAMPLE (5 ROWS);

SELECT * FROM MY_TABLE SAMPLE SYSTEM (1) SEED (5);

What does the Remote Disk I/O statistic in the Query Profile indicate?

Time when the query processing was blocked by remote disk access.

Time spent reading from the result cache.

Time spent reading from the virtual warehouse cache.

Time when the query processing was blocked by remote disk access.

The level of network activity between the Cloud Services layer and the virtual warehouse.

How can the outer array structure of a semi-structured file be removed?

Use the parameter strip_outer_array = true in a COPY INTO <table> command.

Set the file format to eliminate any outer array structure before initiating the COPY INTO <table> command.

Filter the outer array structure using a PUT command with the include_outer_array = false parameter.

Use the FLATTEN command with the outer_array = false parameter.

What virtual warehouse configuration should be used when processing a large number of complex queries?

Increase the number of warehouse clusters.

Run the warehouse in auto-scale mode.

Increase the size of the warehouse.

Increase the number of warehouse clusters.

What best practice recommendations will help prevent timeouts when using the PUT command to load large data sets? (Select TWO).

Compress the files before loading.

Increase the PARALLEL option value.

Compress the files before loading.

Use a semi-structured file format.

Increase the PARALLEL option value.

Load the data into a table stage.

What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).

It is automatically granted to the role that creates a database object within the schema.

It allows a role to manage grants on the schema.

It is automatically granted to the role that creates a database object within the schema.

It allows a role to manage grants on the schema.

It can be transferred from one role to another for a specific schema.

It grants the ability to query data from the schema.

It must be granted to a role in order to alter warehouse settings.

Who can access the data published in a Data Exchange?

Only the users that the data provider has invited to the Data Exchange

Only the data provider who published the data

Any Snowflake user, regardless of their role or permissions

Any user who has been provided with a unique Data Exchange URL

Only the users that the data provider has invited to the Data Exchange

A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?

Run the UNDROP command against the table.

Clone the table schema as it existed before the table was dropped.

Clone the database as it existed before the table was dropped.

Recreate the table and reload the data.

Run the UNDROP command against the table.

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

What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?

Become a Premium Member for full access

Unlock Premium Member

Snowflake COF-C02 Practice Test 18

Question

Snowflake COF-C02 Practice Tests

Practice Tests