SnowPro Core Certification Exam (COF-C02) Free Questions - Part 7
Question No : 91) Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
A. ORC
B. XML
C. Avro
D. Parquet
E. JSON
Question No : 92) What is the MOST performant file format for loading data in Snowflake?
A. CSV (Unzipped)
B. Parquet
C. CSV (Gzipped)
D. ORC
Question No : 93) A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
A. The primary cluster in the virtual warehouse
B. The entire virtual warehouse
C. The database in which the virtual warehouse resides
D. The Queries currently being run on the virtual warehouse
Question No : 94) What happens when a cloned table is replicated to a secondary database? (Select TWO)
A. A read-only copy of the cloned tables is stored.
B. The replication will not be successful.
C. The physical data is replicated
D. Additional costs for storage are charged to a secondary account
E. Metadata pointers to cloned tables are replicated
Question No : 95) How would you determine the size of the virtual warehouse used for a task?
A. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
B. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
C. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
D. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
Question No : 96) What happens when a virtual warehouse is resized?
A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
B. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
D. Users who are trying to use the warehouse will receive an error message until the resizing is complete
Question No : 97) Which stage type can be altered and dropped?
A. Database stage
B. External stage
C. Table stage
D. User stage
Question No : 98)
In which use cases does Snowflake apply egress charges?
A. Data sharing within a specific region
B. Query result retrieval
C. Database replication
D. Loading data into Snowflake
Question No : 99) What is the recommended file sizing for data loading using Snowpipe?
A. A compressed file size greater than 100 MB, and up to 250 MB
B. A compressed file size greater than 100 GB, and up to 250 GB
C. A compressed file size greater than 10 MB, and up to 100 MB
D. A compressed file size greater than 1 GB, and up to 2 GB
Question No : 100) A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?
A. Organize files into logical paths
B. Store the files on the external stage to ensure caching is maintained
C. Use pattern matching for regular expression execution
D. Load the data in one large file
Question No : 101) Which of the following statements describes a schema in Snowflake?
A. A logical grouping of objects that belongs to a single database
B. A logical grouping of objects that belongs to multiple databases
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
Question No : 102) Which of the following is the Snowflake Account_Usage.Metering_History view used for?
A. Gathering the hourly credit usage for an account
B. Compiling an account's average cloud services cost over the previous month
C. Summarizing the throughput of Snowpipe costs for an account
D. Calculating the funds left on an account's contract
Question No : 103) How would a user run a multi-cluster warehouse in maximized mode?
A. Configure the maximum clusters setting to "Maximum."
B. Turn on the additional clusters manually after starting the warehouse.
C. Set the minimum Clusters and maximum Clusters settings to the same value.
D. Set the minimum clusters and maximum clusters settings to different values.
Question No : 104) A materialized view should be created when which of the following occurs? (Choose two.)
A. There is minimal cost associated with running the query.
B. The query consumes many compute resources every time it runs.
C. The base table gets updated frequently.
D. The query is highly optimized and does not consume many compute resources.
E. The results of the query do not change often and are used frequently.
Question No : 105) 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
COF-C02 Answers