Top COF-C01 Dumps Questions For Passing SnowPro Core Certification Exam

1. When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.

2. Select the different types of Internal Stages: (Choose three.)

3. Which statement best describes Snowflake tables?

4. What happens when a Data Provider revokes privileges to a Share on an object in their source database?

5. True or False: Snowpipe via RFST API can only reference External Stages as source.

6. True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

7. True or False: You can resize a Virtual Warehouse while queries are running.

8. Which of the following statements about data sharing are true? choose 2 answers

9. Which of the following statements is true of Snowflake?

10. What is the recommended method for loading data into Snowflake?

11. What is the lowest Snowflake edition that offers Time Travel up to 90 days.

12. Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

13. True or False: Users are able to see the result sets of queries executed by other users that share their same role.

14. Select the three types of tables that exist within Snowflake.

Choose 3 answers

15. Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

16. Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

17. True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

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

19. True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

20. Account-level storage usage can be monitored via:

21. True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.

22. Which statement best describes '' clustering''?

23. Snowflake is designed for which type of workloads? (Choose two.)

24. How many shares can be consumed by single Data Consumer?

25. What is the maximum compressed row size in Snowflake?

26. True or False: During data unloading, only JSON and CSV files can be compressed.

27. Which of the following statements is true of Snowflake micro-partitioning?

28. Which of the following are options when creating a virtual Warehouse? Choose 2 answers

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

30. How a Snowpipe charges calculated?

31. When can a Virtual Warehouse start running queries?

32. For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

33. When loading data into Snowflake, the COPY command supports: Choose 2 answers

34. Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

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

36. True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

37. Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

38. Which formats are supported for unloading data from Snowflake? Choose 2 answers

39. True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

40. Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

41. Which of the following statements are true about Schemas in Snowflake? (Choose two.)

42. Which of the following statements are true of Snowflake releases: (Choose two.)

43. True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

44. True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

45. If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

46. What is the most granular object that the Time Travel retention period can be defined on?

47. True or False: The COPY command must specify a File Format in order to execute.

48. What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

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

50. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

51. Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?

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

53. Which type of table corresponds to a single Snowflake session?

54. Which of the following commands are not blocking operations?

Choose 2 answers

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

56. What is the minimum duration charged when starting a virtual warehouse?

57. Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

58. Which of the following commands sets the Virtual Warehouse for a session?

59. True or False: A single database can exist in more than one Snowflake account.

60. Which of the following statements is true of data loading?