Practice Free COF-C02 Exam Online Questions
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
What is the default character set used when loading CSV files into Snowflake?
- A . UTF-8
- B . UTF-16
- C . ISO S859-1
- D . ANSI_X3.A
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
- A . Whether or not it is also a secure view
- B . How often the underlying base table is queried
- C . How often the base table changes
- D . Whether the materialized view has a cluster key defined
- E . How often the materialized view is queried
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- A . True
- B . False
Which of the following describes external functions in Snowflake?
- A . They are a type of User-defined Function (UDF).
- B . They contain their own SQL code.
- C . They call code that is stored inside of Snowflake.
- D . They can return multiple rows for each row received
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
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?
- A . The explain plan output is available graphically.
- B . An explain plan can be used to conduct performance analysis without executing a query.
- C . An explain plan will handle queries with temporary tables and the query profiler will not.
- D . An explain plan’s output will display automatic data skew optimization information.
What are common issues found by using the Query Profile? (Choose two.)
- A . Identifying queries that will likely run very slowly before executing them
- B . Locating queries that consume a high amount of credits
- C . Identifying logical issues with the queries
- D . Identifying inefficient micro-partition pruning
- E . Data spilling to a local or remote disk
Which stream type can be used for tracking the records in external tables?
- A . Append-only
- B . External
- C . Insert-only
- D . Standard