ExamGecko
Search Search Login
Home Home / Snowflake / COF-C02

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

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
Which minimum Snowflake edition allows for a dedicated metadata store?
How can the outer array structure of a semi-structured file be removed?
Who can access the data published in a Data Exchange?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
What virtual warehouse configuration should be used when processing a large number of complex queries?
Which Query Profile metrics will provide information that can be used to improve query performance? (Select TWO).
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How does the search optimization service improve query performance?
When unloading data, which combination of parameters should be used to differentiate between empty strings and NULL values? (Select TWO).

Question 261

Report
Export
Collapse

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

A.
Scale up the virtual warehouse.
A.
Scale up the virtual warehouse.
Answers
B.
Scale out the virtual warehouse.
B.
Scale out the virtual warehouse.
Answers
C.
Enable standard warehouse scaling.
C.
Enable standard warehouse scaling.
Answers
D.
Enable economy warehouse scaling.
D.
Enable economy warehouse scaling.
Answers
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.

Question 262

Report
Export
Collapse

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

A.
GO driver
A.
GO driver
Answers
B.
Node.js driver
B.
Node.js driver
Answers
C.
ODBC driver
C.
ODBC driver
Answers
D.
Python connector
D.
Python connector
Answers
E.
Spark connector
E.
Spark connector
Answers
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.

Question 263

Report
Export
Collapse

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

A.
Swift
A.
Swift
Answers
B.
JavaScript
B.
JavaScript
Answers
C.
Python
C.
Python
Answers
D.
SQL
D.
SQL
Answers
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.

Question 264

Report
Export
Collapse

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

A.
8MB
A.
8MB
Answers
B.
16MB
B.
16MB
Answers
C.
32MB
C.
32MB
Answers
D.
128MB
D.
128MB
Answers
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.

Question 265

Report
Export
Collapse

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

A.
history
A.
history
Answers
B.
config
B.
config
Answers
C.
snowsqLcnf
C.
snowsqLcnf
Answers
D.
snowsql.pubkey
D.
snowsql.pubkey
Answers
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.

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

A.
Rename listings.
A.
Rename listings.
Answers
B.
Delete provider profiles.
B.
Delete provider profiles.
Answers
C.
Modify listings properties.
C.
Modify listings properties.
Answers
D.
Modify incoming listing access requests.
D.
Modify incoming listing access requests.
Answers
E.
Submit listings for approval/publishing.
E.
Submit listings for approval/publishing.
Answers
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.

Question 267

Report
Export
Collapse

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

A.
Duo Security
A.
Duo Security
Answers
B.
OAuth
B.
OAuth
Answers
C.
Okta
C.
Okta
Answers
D.
Single Sign-On (SSO)
D.
Single Sign-On (SSO)
Answers
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

Question 268

Report
Export
Collapse

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

A.
DISABLED
A.
DISABLED
Answers
B.
MINS TO BYPASS MFA
B.
MINS TO BYPASS MFA
Answers
C.
MINS TO BYPASS NETWORK POLICY
C.
MINS TO BYPASS NETWORK POLICY
Answers
D.
MINS TO UNLOCK
D.
MINS TO UNLOCK
Answers
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.

Question 269

Report
Export
Collapse

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

A.
CSV
A.
CSV
Answers
B.
JSON
B.
JSON
Answers
C.
ORC
C.
ORC
Answers
D.
Parquet
D.
Parquet
Answers
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.

Question 270

Report
Export
Collapse

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

A.
Cloud Services
A.
Cloud Services
Answers
B.
Database Storage
B.
Database Storage
Answers
C.
Query Processing
C.
Query Processing
Answers
D.
Metadata Management
D.
Metadata Management
Answers
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

Total 716 questions
Go to page: of 72
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms