SnowPro Core Exam COF-C02 Dumps Updated to V16.02 – Read COF-C02 Free Dumps (Part 1, Q1-Q40) First to Check the Quality

1. The fail-safe retention period is how many days?

2. True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

3. How would you determine the size of the virtual warehouse used for a task?

4. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

5. What is the default File Format used in the COPY command if one is not specified?

6. True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

7. True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

8. True or False: A Virtual Warehouse can be resized while suspended.

9. True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.

10. What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

11. True or False: Fail-safe can be disabled within a Snowflake account.

12. True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

13. A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

14. Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

15. Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

16. Which of the following are benefits of micro-partitioning? (Select TWO)

17. What is the minimum Snowflake edition required to create a materialized view?

18. What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

19. Which feature is only available in the Enterprise or higher editions of Snowflake?

20. Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

21. During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

22. Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

23. Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

24. A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

25. What is the default character set used when loading CSV files into Snowflake?

26. A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

27. Which cache type is used to cache data output from SQL queries?

28. What is a key feature of Snowflake architecture?

29. What is a limitation of a Materialized View?

30. What features does Snowflake Time Travel enable?

31. Which statement about billing applies to Snowflake credits?

32. What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

33. When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse.

According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

A. Use multi-clustered warehousing to scale out warehouse capacity.

B. Scale up the warehouse size to allow Queries to execute faster.

C. Stop and start the warehouse to clear the queued queries

D. Migrate some queries to a new warehouse to reduce load

E. Limit user access to the warehouse so fewer queries are run against it.

34. Which of the following objects can be shared through secure data sharing?

35. Which of the following commands cannot be used within a reader account?

36. A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

37. Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

38. Which command is used to unload data from a Snowflake table into a file in a stage?

39. How often are encryption keys automatically rotated by Snowflake?

40. What are value types that a VARIANT column can store? (Select TWO)