Practice Free COF-C02 Exam Online Questions
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- A . Cloud services layer
- B . Compute layer
- C . Storage layer
- D . Cloud agnostic layer
Which of the following are best practices for loading data into Snowflake? (Choose three.)
- A . Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
- B . Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
- C . Enclose fields that contain delimiter characters in single or double quotes.
- D . Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
- E . When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
- F . Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.
Which native data types are used for storing semi-structured data in Snowflake? (Select TWO)
- A . NUMBER
- B . OBJECT
- C . STRING
- D . VARCHAR
- E . VARIANT
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
- A . Resource monitor
- B . Account_usage. query_history
- C . Information_schema.warehouse_load_history
- D . Information schema.warehouse metering history
Which Snowflake tool would be BEST to troubleshoot network connectivity?
- A . SnowCLI
- B . SnowUI
- C . SnowSQL
- D . SnowCD
What is the following SQL command used for?
Select * from table(validate(t1, job_id => ‘_last’));
- A . To validate external table files in table t1 across all sessions
- B . To validate task SQL statements against table t1 in the last 14 days
- C . To validate a file for errors before it gets executed using a COPY command
- D . To return errors from the last executed COPY command into table t1 in the current session
For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?
- A . 10
- B . 50
- C . 64
- D . 256
What is a best practice after creating a custom role?
- A . Create the custom role using the SYSADMIN role.
- B . Assign the custom role to the SYSADMIN role
- C . Assign the custom role to the PUBLIC role
- D . Add__CUSTOM to all custom role names
In the Snowflake access control model, which entity owns an object by default?
- A . The user who created the object
- B . The SYSADMIN role
- C . Ownership depends on the type of object
- D . The role used to create the object
Which features make up Snowflake’s column level security? (Select TWO).
- A . Continuous Data Protection (CDP)
- B . Dynamic Data Masking
- C . External Tokenization
- D . Key pair authentication
- E . Row access policies