SnowPro Core COF-C02 Real Exam Questions and Answers FREE Updated on Oct 16, 2023
COF-C02 Ultimate Study Guide - PracticeVCE
NEW QUESTION # 256
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
- B. The validation_mode option is used when creating an Internal Stage
- 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. validation_mode=return_all_errors is a parameter of the copy command
Answer: A,D
NEW QUESTION # 257
Which type of table corresponds to a single Snowflake session?
- A. Permanent
- B. Provisional
- C. Translent
- D. Temporary
Answer: D
NEW QUESTION # 258
Which Snowflake URL type is used by directory tables?
- A. Pre-signed
- B. Virtual-hosted style
- C. Scoped
- D. File
Answer: D
NEW QUESTION # 259
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
- A. MONITOR
- B. OPERATE
- C. USAGE
- D. MODIFY
Answer: B
NEW QUESTION # 260
Which of the following statements describes a schema in Snowflake?
- A. A logical grouping of objects that belongs to multiple databases
- B. A logical grouping of objects that belongs to a single database
- C. A named Snowflake object that includes all the information required to share a database
- D. A uniquely identified Snowflake account within a business entity
Answer: B
NEW QUESTION # 261
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A. STRIP_NULL_VALUES
- B. SKIP_BYTE_ORDER_MARK
- C. VALIDATION_MODE
- D. REPLACE_INVALID_CHARACTERS
Answer: C
Explanation:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
NEW QUESTION # 262
What is the purpose of an External Function?
- A. To call code that executes outside of Snowflake
- B. To run a function in another Snowflake database
- C. To share data in Snowflake with external parties
- D. To ingest data from on-premises data sources
Answer: A
Explanation:
https://docs.snowflake.com/en/sql-reference/external-functions.html
NEW QUESTION # 263
Which copy INTO command outputs the data into one file?
- A. MAX_FILE_NUMBER=1
- B. MULTIPLE=FAISE
- C. SINGLE=TRUE
- D. FILE_NUMBER=1
Answer: C
NEW QUESTION # 264
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
- A. Parquet
- B. XML
- C. ORC
- D. JSON
- E. Avro
Answer: A,D
Explanation:
Semi-structured
JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file&text=Delimited%20(CSV%2C%20TSV%2C%20etc.)
NEW QUESTION # 265
In which use cases does Snowflake apply egress charges?
- A. Query result retrieval
- B. Loading data into Snowflake
- C. Database replication
- D. Data sharing within a specific region
Answer: D
NEW QUESTION # 266
Snowflake provides a mechanism for its customers to override its clustering algorithms.
This method is:
- A. Clustering keys
- B. Micro-partitions
- C. Key partitions
- D. Clustered partitions
Answer: A
NEW QUESTION # 267
What are value types that a VARIANT column can store? (Select TWO)
- A. OBJECT
- B. ARRAY
- C. CLOB
- D. STRUCT
- E. BINARY
Answer: A,B
Explanation:
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics%20of%20a%20VARIANT,a%20VARIANT%20is%2016%20MB.
NEW QUESTION # 268
Which of the following are common use cases for zero-copy cloning? Choose 3 answers
- A. Data backups
- B. Point in time snapshots
- C. Performance optimization
- D. Quick provisioning of Dev and Test/QA environments
Answer: A,B,D
NEW QUESTION # 269
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
- A. Snowflake requires a user to configure an IAM user to connect to the database.
- B. All data in Snowflake is compressed.
- C. Snowflake leverages a Role-Based Access Control (RBAC) model.
- D. Snowflake can run within a user's own Virtual Private Cloud (VPC).
- E. All data in Snowflake is encrypted.
Answer: C,D
NEW QUESTION # 270
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 271
Which of the following statements would be used to export/unload data from Snowflake?
- A. EXPORT TO @stage
- B. COPY INTO @stage
- C. INSERT INTO @stage
- D. EXPORT_TO_STAGE (stage = > @Wage, select = > 'select * from t1);
Answer: B
NEW QUESTION # 272
......
Ultimate Guide to Prepare COF-C02 Certification Exam for SnowPro Core: https://www.practicevce.com/Snowflake/COF-C02-practice-exam-dumps.html
Use Real COF-C02 Dumps - Snowflake Correct Answers: https://drive.google.com/open?id=16pnS4R3PKwn3tVseDOD7C4oUL432mydq