ExamGecko
Home / Snowflake / COF-C02
Ask Question

Snowflake COF-C02 Practice Test - Questions Answers, Page 27

Question list
Search

Question 261

Report
Export
Collapse

How can a user improve the performance of a single large complex query in Snowflake?

Scale up the virtual warehouse.
Scale up the virtual warehouse.
Scale out the virtual warehouse.
Scale out the virtual warehouse.
Enable standard warehouse scaling.
Enable standard warehouse scaling.
Enable economy warehouse scaling.
Enable economy warehouse scaling.
Suggested answer: A

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.

asked 23/09/2024
Colin Mabe
41 questions

Question 262

Report
Export
Collapse

Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).

GO driver
GO driver
Node.js driver
Node.js driver
ODBC driver
ODBC driver
Python connector
Python connector
Spark connector
Spark connector
Suggested answer: C, D

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.

asked 23/09/2024
Spencer Karenbauer
37 questions

Question 263

Report
Export
Collapse

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Swift
Swift
JavaScript
JavaScript
Python
Python
SQL
SQL
Suggested answer: C

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.

asked 23/09/2024
VIVEKANANDAN BALARAMAN
37 questions

Question 264

Report
Export
Collapse

What is the MAXIMUM size limit for a record of a VARIANT data type?

8MB
8MB
16MB
16MB
32MB
32MB
128MB
128MB
Suggested answer: B

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.

asked 23/09/2024
Rajeev R Kumar
36 questions

Question 265

Report
Export
Collapse

What is the name of the SnowSQLfile that can store connection information?

history
history
config
config
snowsqLcnf
snowsqLcnf
snowsql.pubkey
snowsql.pubkey
Suggested answer: B

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.

asked 23/09/2024
Volkan Ozsoy
34 questions

Question 266

Report
Export
Collapse

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).

Rename listings.
Rename listings.
Delete provider profiles.
Delete provider profiles.
Modify listings properties.
Modify listings properties.
Modify incoming listing access requests.
Modify incoming listing access requests.
Submit listings for approval/publishing.
Submit listings for approval/publishing.
Suggested answer: C, E

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.

asked 23/09/2024
Florence Li
39 questions

Question 267

Report
Export
Collapse

What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

Duo Security
Duo Security
OAuth
OAuth
Okta
Okta
Single Sign-On (SSO)
Single Sign-On (SSO)
Suggested answer: A

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

asked 23/09/2024
Mike van den Berg
37 questions

Question 268

Report
Export
Collapse

Which user object property requires contacting Snowflake Support in order to set a value for it?

DISABLED
DISABLED
MINS TO BYPASS MFA
MINS TO BYPASS MFA
MINS TO BYPASS NETWORK POLICY
MINS TO BYPASS NETWORK POLICY
MINS TO UNLOCK
MINS TO UNLOCK
Suggested answer: B

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.

asked 23/09/2024
Ruben Dallibor
36 questions

Question 269

Report
Export
Collapse

Which file format will keep floating-point numbers from being truncated when data is unloaded?

CSV
CSV
JSON
JSON
ORC
ORC
Parquet
Parquet
Suggested answer: D

Explanation:

The Parquet file format is known for preserving the precision of floating-point numbers when data is unloaded, preventing truncation of the values3.

asked 23/09/2024
VEDA VIKASH Matam Shashidhar
37 questions

Question 270

Report
Export
Collapse

In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

Cloud Services
Cloud Services
Database Storage
Database Storage
Query Processing
Query Processing
Metadata Management
Metadata Management
Suggested answer: B

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

asked 23/09/2024
Yohane Phompho
33 questions
Total 716 questions
Go to page: of 72