NEW QUESTION 29
The kafka connector creates one pipe for each partition in a Kafka topic.

NEW QUESTION 30
Which feature provides the capability to define an alternate cluster key for a table with an existing cluster key?

NEW QUESTION 31
What does Percentage scanned from cache in the query profile signify?

NEW QUESTION 32
The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

NEW QUESTION 33
This privilege applies to only shared databases. It grants ability to enable roles other than the owning role to access a shared database.
Which is that role?

NEW QUESTION 34
Which command can be run to list all shares that have been created in your account or are available to consume by your account

NEW QUESTION 35
While loading data into a table from stage, which are the valid copyOptions

NEW QUESTION 36
What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

NEW QUESTION 37
You have created a table as below
CREATE TABLE SNOWFLAKE_BLOG(BLOG_ID NUMBER, BLOG_CONTENT VARCHAR,BLOG_AUTHOR VARCHAR,BLOG_CREATE_DATE TIMESTAMP );
Now you want to cluster it by BLOG_AUTHOR and BLOG_CREATE_DATE.
Which command below will you choose?

NEW QUESTION 38
Data replication in snowflake helps in

NEW QUESTION 39
You are running a large join on snowflake. You ran it on a medium warehouse and it took almost an hour to run. You then tried to run the join on a large warehouse but still the performance did not improve.
What may be the most possible cause of this.

NEW QUESTION 40
What are some of the characteristics of result set caches? (Choose three.)

NEW QUESTION 41
Which role in Snowflake allows a user to administer users and manage all database objects?

NEW QUESTION 42
Which statement is true about clustering key?

NEW QUESTION 43
How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)