New Year Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Select the different types of Internal Stages: (Choose three.)

A.

Named Stage

B.

User Stage

C.

Table Stage

D.

Schema Stage

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

A.

The Pipe load history is reset to empty

B.

The REFRESH parameter is set to TRUE

C.

Previously loaded files will be ignored

D.

All of the above

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

A.

True

B.

False

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

A.

4

B.

16

C.

32

D.

128

True or False: You can query the files in an External Stage directly without having to load the data into a table.

A.

True

B.

False

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

A.

Each Snowflake account can be hosted in a different cloud vendor and region.

B.

Each Snowflake account must be hosted in a different cloud vendor and region

C.

All Snowflake accounts must be hosted in the same cloud vendor and region

D.

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

What Snowflake role must be granted for a user to create and manage accounts?

A.

ACCOUNTADMIN

B.

ORGADMIN

C.

SECURITYADMIN

D.

SYSADMIN

What are the default Time Travel and Fail-safe retention periods for transient tables?

A.

Time Travel - 1 day. Fail-safe - 1 day

B.

Time Travel - 0 days. Fail-safe - 1 day

C.

Time Travel - 1 day. Fail-safe - 0 days

D.

Transient tables are retained in neither Fail-safe nor Time Travel

How would you determine the size of the virtual warehouse used for a task?

A.

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B.

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C.

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D.

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule