2023 Easy Success Snowflake COF-C02 Exam in First Try [Q153-Q177]

NO.153 Which of the following commands sets the Virtual Warehouse for a session?

NO.154 During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

NO.155 Which command can be used to load data files into a Snowflake stage?

NO.156 Which of the following statements describes a schema in Snowflake?

NO.157 Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

NO.158 When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

NO.159 Which Snowflake tool would be BEST to troubleshoot network connectivity?

NO.160 Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

NO.161 Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

NO.162 What is true about sharing data in Snowflake? (Choose two.)

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

NO.164 When is the result set cache no longer available? (Select TWO)

NO.165 Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

NO.166 Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

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

NO.168 Fail-safe is unavailable on which table types?

NO.169 True or False: It is possible to load data into Snowflake without creating a named File Format object.

NO.170 The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

NO.171 Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

NO.172 Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

NO.173 Which command sets the Virtual Warehouse for a session?

NO.174 Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

NO.175 Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

NO.176 Which of the following are true of multi-cluster Warehouses? Select all that apply below.

NO.177 Which of the following statements would be used to export/unload data from Snowflake?