Practice Free COF-C02 Exam Online Questions
User-level network policies can be created by which of the following roles? (Select TWO).
- A . ROLEADMIN
- B . ACCOUNTADMIN
- C . SYSADMIN
- D . SECURITYADMIN
- E . USERADMIN
Which command can be used to load data files into a Snowflake stage?
- A . JOIN
- B . COPY INTO
- C . PUT
- D . GET
When unloading to a stage, which of the following is a recommended practice or approach?
- A . Set SINGLE: = true for larger files
- B . Use OBJECT_CONSTRUCT ( * ) when using Parquet
- C . Avoid the use of the CAST function
- D . Define an individual file format
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A . 4
- B . 8
- C . 16
- D . 32
What happens when a database is cloned?
- A . It does not retain any privileges granted on the source object.
- B . It replicates all granted privileges on the corresponding source objects.
- C . It replicates all granted privileges on the corresponding child objects.
- D . It replicates all granted privileges on the corresponding child schema objects.
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
- A . The number of queries executed
- B . The number of active users assigned to the warehouse
- C . The size of the virtual warehouse
- D . The length of time the warehouse is running
- E . The duration of the queries that are executed
Which statement describes pruning?
- A . The filtering or disregarding of micro-partitions that are not needed to return a query.
- B . The return of micro-partitions values that overlap with each other to reduce a query’s runtime.
- C . A service that is handled by the Snowflake Cloud Services layer to optimize caching.
- D . The ability to allow the result of a query to be accessed as if it were a table.
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
- A . The cloned views and the stored procedures will reference the cloned tables in the cloned database.
- B . An error will occur, as views with qualified references cannot be cloned.
- C . An error will occur, as stored objects cannot be cloned.
- D . The stored procedures and views will refer to tables in the source database.
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
- A . SELECT SUM (ORDER_AMT) FROM SALES;
- B . SELECT AVG(ORDER_QTY) FROM SALES;
- C . SELECT MIN(ORDER_AMT) FROM SALES;
- D . SELECT ORDER_AMT * ORDER_QTY FROM SALES;
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
- A . The columns that are queried in the select clause.
- B . The columns with very high cardinality.
- C . The columns with many different values.
- D . The columns most actively used in the select filters.