QUESTION 116
Which cache type is used to cache data output from SQL queries?

QUESTION 117
When should you consider disabling auto-suspend for a Virtual Warehouse? Choose 2 answers

QUESTION 118
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

QUESTION 119
When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

QUESTION 120
Which of the following statements is true of Snowflake micro-partitioning?

QUESTION 121
True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

QUESTION 122
What is the recommended compressed file size range for continuous data loads using Snowpipe?

QUESTION 123
True or False: A single database can exist in more than one Snowflake account.

QUESTION 124
What is the minimum Snowflake edition required for row level security?

QUESTION 125
Select the three types of tables that exist within Snowflake. Choose 3 answers

QUESTION 126
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

QUESTION 127
Which of the following roles is recommended to be used to create and manage users and roles?

QUESTION 128
Which formats does Snowflake store unstructured data in? (Choose two.)

QUESTION 129
Which of the following is true of Snowpipe via REST API? Choose 2 answers

QUESTION 130
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

QUESTION 131
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

QUESTION 132
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

QUESTION 133
Which of the following statements are true of Snowflake releases: (Choose two.)

QUESTION 134
User-level network policies can be created by which of the following roles? (Select TWO).

QUESTION 135
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are: Choose 2 answers

QUESTION 136
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

QUESTION 137
What features that are part of the Continuous Data Protection (CDP) feature set in Snowflake do not require additional configuration? (Choose two.)

QUESTION 138
Which copy INTO command outputs the data into one file?

QUESTION 139
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)