When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

A.

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.

An error will occur, as views with qualified references cannot be cloned.

C.

An error will occur, as stored objects cannot be cloned.

D.

The stored procedures and views will refer to tables in the source database.

A virtual warehouse is created using the following command:

Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;

The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

A.

Increase the warehouse size from Medium to 2XL.

B.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

C.

Configure the warehouse to a multi-cluster warehouse.

D.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

What is the minimum Snowflake edition required to use Dynamic Data Masking?

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake (VPC)

What is the default file size when unloading data from Snowflake using the COPY command?

A.

5 MB

B.

8 GB

C.

16 MB

D.

32 MB

Which of the following describes the Snowflake Cloud Services layer?

A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)

A.

CONTENT

B.

PATH

C.

BYTE_SIZE

D.

INDEX

E.

DATATYPE

Snowflake supports the use of external stages with which cloud platforms?(Choose three.)

A.

Amazon Web Services

B.

Docker

C.

IBM Cloud

D.

Microsoft Azure Cloud

E.

Google Cloud Platform

F.

Oracle Cloud

Which of the following is a data tokenization integration partner?

A.

Protegrity

B.

Tableau

C.

DBeaver

D.

SAP

A user has unloaded data from a Snowflake table to an external stage. Which command can be used to verify if data has been uploaded to the external stage named my_stage?

A.

view @my_stage

B.

list @my_stage

C.

show @my_stage

D.

display @my_stage

Which Snowflake architectural layer is responsible for a query execution plan?

A.

Compute

B.

Data storage

C.

Cloud services

D.

Cloud provider

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

A.

Business Critical Edition

B.

Standard Edition

C.

Virtual Private Snowflake (VPS)

D.

Enterprise Edition

What actions will prevent leveraging of the ResultSet cache? (Choose two.)

A.

Removing a column from the query SELECT list

B.

Stopping the virtual warehouse that the query is running against

C.

Clustering of the data used by the query

D.

Executing the RESULTS_SCAN() table function

E.

Changing a column that is not in the cached query