ExamGecko
Search Search Login
Home Home / Snowflake / COF-R02
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?
Which minimum Snowflake edition allows for a dedicated metadata store?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is a responsibility of Snowflake’s virtual warehouses?
Which TABLE function helps to convert semi-structured data to a relational representation?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Question 50 - COF-R02 discussion

Report
Export

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

A.
The validation_mode option is used when creating an Internal Stage
Answers
A.
The validation_mode option is used when creating an Internal Stage
B.
validation_mode=return_all_errors is a parameter of the copy command
Answers
B.
validation_mode=return_all_errors is a parameter of the copy command
C.
The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
Answers
C.
The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
D.
The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Answers
D.
The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Suggested answer: B, D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

Show Answer
asked 23/09/2024
Russell Ang
34 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

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