Free certification test prep

QUESTION 90
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

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

QUESTION 92
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers

QUESTION 93
Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?
Select one.

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

QUESTION 95
What is the minimum Snowflake edition that provides data sharing?

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

QUESTION 97
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

QUESTION 98
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

QUESTION 99
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

QUESTION 100
Which of the following are common use cases for zero-copy cloning?
Choose 3 answers

QUESTION 101
When can a Virtual Warehouse start running queries?

QUESTION 102
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers

QUESTION 103
The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

QUESTION 104
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

QUESTION 105
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

QUESTION 106
Which statement best describes ” clustering”?

QUESTION 107
True or False: The COPY command must specify a File Format in order to execute.