How long can a data consumer who has a pre-signed URL access data files using Snowflake?

• A.Indefinitely
• B.Until the result_cache expires
• C.Until the expiration time is exceeded
• D.Until the retention_time is met

Comment: *

Name: *

Email: *

Verification: *

What is the default File Format used in the COPY command if one is not specified?

• A.CSV
• B.Parquet
• C.JSON
• D.XML

Comment: *

Name: *

Email: *

Verification: *

What is the purpose of configuring the scale factor parameter when using the Query Acceleration Service?

• A.It increases the default selectivity of any filter parameters when the query is accelerated.
• B.It is used when there are not enough partitions in a table to accelerate the query.
• C.It controls costs by setting an upper bound on the amount of compute resources a warehouse can use for query acceleration.
• D.It is a concurrency control tool used to avoid unnecessary scaling up when the query is accelerated and the warehouse is running in Maximized mode.

Comment: *

Name: *

Email: *

Verification: *

To use the overwrite option on insert, which privilege must be granted to the role?

• A.truncate
• B.DELETE
• C.UPDATE
• D.SELECT

Comment: *

Name: *

Email: *

Verification: *

What happens to foreign key constraints when a table is cloned to another database?

• A.All referenced tables will be cloned.
• B.The cloned table will reference the primary key in the source table
• C.The cloned table will lose all references to the primary key.
• D.The cloned table will lose all references to the foreign and primary keys.

Comment: *

Name: *

Email: *

Verification: *