Question 611 · 1323 in bank
Which Snowflake tool would be BEST to troubleshoot network connectivity?
Show answer
Answer: D
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
Which Snowflake tool would be BEST to troubleshoot network connectivity?
Answer: D
Increasing the size of a virtual warehouse from an X-Small to an X-Large is an example of which of the following?
Answer: D
What are ways to create and manage data shares in Snowflake? (Choose two.)
Answer: AC
What is a characteristic of data micro-partitioning in Snowflake?
Answer: C
Micro-partitioning is automatically performed on all Snowflake tables. Tables are transparently partitioned using the ordering of the data as it is inserted/loaded. https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html#what-are-micro-partitions
Source: Adapted from community discussion — miadiesel
Which statement best describes Snowflake tables?
Answer: A
The best statement that describes Snowflake tables is Snowflake tables are logical representations of underlying physical data. Snowflake tables do not require that clustering keys be defined to perform optimally. However, defining clustering keys can improve the performance of queries that filter or sort the data. Snowflake tables can be owned by a user or by a role. Therefore, the correct answer is A. Snowflake tables are logical representations of underlying physical data.
Source: Adapted from community discussion — Colourseun
Users with the ACCOUNTADMIN role can execute which of the following commands on existing users?
Answer: A
According to Snowflake best practice recommendations, which system-defined roles should be used to create custom roles? (Choose two.)
Answer: CD
SYSADMIN role should be granted to custom roles after their creation. Custom account roles can be created using the USERADMIN role (or a higher role).
Source: Adapted from community discussion — sakis213
What services are provided by the cloud services layer in Snowflake? (Choose two.)
Answer: AC
A. Metadata management C. Authentication The cloud services layer in Snowflake provides several important services that are used by other parts of the system. Two of the main services provided by the cloud services layer are: A. Metadata management: The cloud services layer is responsible for managing the metadata that defines the structure and contents of databases and tables in Snowflake, including information about columns, data types, and indexes. C. Authentication: The cloud services layer is responsible for handling user authentication and authorization, ensuring that only authorized users have access to the data and metadata stored in Snowflake. Options B, D, and E refer to other parts of the Snowflake system and are not provided by the cloud services layer. Option B refers to object authorization, which is managed by the security layer in Snowflake. Option D refers to query execution, which is performed by the query processing layer. Option E refers to result caching, which can be performed by the query processing layer and the storage layer in Snowflake.
Source: Adapted from community discussion — markpumc
Which of the following commands are valid options for the VALIDATION_MODE parameter within the Snowflake COPY_INTO command? (Choose two.)
Answer: CD
Then there is an error on the question RETURN__ROWS is not a valid answer, shoud be like: RETURN_n_ROWS (e.g. RETURN_10_ROWS)
Source: Adapted from community discussion — BigDataBB
Snowflake virtual warehouses are part of which layer of the Snowflake architecture?
Answer: A
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 611. 1323 questions available.
Version 1.0.0. How we source questions