Snowflake COF-C02 Practice Test - Questions Answers, Page 27
List of questions
Related questions
Question 261

How can a user improve the performance of a single large complex query in Snowflake?
Explanation:
Scaling up the virtual warehouse in Snowflake involves increasing the compute resources available for a single warehouse, which can improve the performance of large and complex queries by providing more CPU and memory resources.References:Based on general cloud data warehousing knowledge as of 2021.
Question 262

Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
Explanation:
Multi-Factor Authentication (MFA) token caching is typically supported for clients that maintain a persistent connection or session with Snowflake, such as the ODBC driver and Python connector, to reduce the need for repeated MFA challenges.References:Based on general security practices in cloud services as of 2021.
Question 263

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?
Explanation:
The Snowpark API allows developers to create User-Defined Functions (UDFs) in various languages, including Python, which is known for its ease of use and wide adoption in data-related tasks.References:Based on general programming and cloud data service knowledge as of 2021.
Question 264

What is the MAXIMUM size limit for a record of a VARIANT data type?
Explanation:
The maximum size limit for a record of a VARIANT data type in Snowflake is 16MB. This allows for storing semi-structured data types like JSON, Avro, ORC, Parquet, or XML within a single VARIANT column.References:Based on general database knowledge as of 2021.
Question 265

What is the name of the SnowSQLfile that can store connection information?
Explanation:
The SnowSQL file that can store connection information is named 'config'. It is used to store user credentials and connection details for easy access to Snowflake instances.References:Based on general database knowledge as of 2021.
Question 266

A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).
Explanation:
With the create data EXCHANGE listing privilege, a Snowflake user can modify the properties of listings and submit them for approval or publishing on the Data Exchange. This allows them to manage and share data sets with consumers effectively.References:Based on general data exchange practices in cloud services as of 2021.
Question 267

What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
Explanation:
Snowflake provides Multi-Factor Authentication (MFA) support as an integrated feature, powered by the Duo Security service.This service is managed completely by Snowflake, and users do not need to sign up separately with Duo1
Question 268

Which user object property requires contacting Snowflake Support in order to set a value for it?
Explanation:
The user property 'MINS TO BYPASS MFA' in Snowflake allows temporary bypass of MFA for a user, which can be set by an account administrator without contacting Snowflake Support2.
Question 269

Which file format will keep floating-point numbers from being truncated when data is unloaded?
Explanation:
The Parquet file format is known for preserving the precision of floating-point numbers when data is unloaded, preventing truncation of the values3.
Question 270

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
Explanation:
Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer.This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance
Question