Updated SnowPro Core Certification Exam COF-C02 Dumps (V11.02) – Download to Start Learning

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).

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)

41. A user has an application that writes a new Tile to a cloud storage location every 5 minutes.

What would be the MOST efficient way to get the files into Snowflake?

42. Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

43. A user has 10 files in a stage containing new customer data.

The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new

customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

44. A user has unloaded data from Snowflake to a stage.

Which SQL command should be used to validate which data was loaded into the stage?

45. What happens when a cloned table is replicated to a secondary database? (Select TWO)

46. Which data types does Snowflake support when querying semi-structured data? (Select TWO)

47. Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

48. A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option.

What does the STRIP_OUTER_ARRAY file format do?

49. What are the default Time Travel and Fail-safe retention periods for transient tables?

50. What is a best practice after creating a custom role?

51. Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

52. Will data cached in a warehouse be lost when the warehouse is resized?

53. Which Snowflake partner specializes in data catalog solutions?

54. What is the MOST performant file format for loading data in Snowflake?

55. Which copy INTO command outputs the data into one file?

56. Where would a Snowflake user find information about query activity from 90 days ago?

57. Which Snowflake technique can be used to improve the performance of a query?

58. User-level network policies can be created by which of the following roles? (Select TWO).

59. Which command can be used to load data into an internal stage?

60. What happens when an external or an internal stage is dropped? (Select TWO).

61. How long is Snowpipe data load history retained?

62. In which use cases does Snowflake apply egress charges?

63. Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

64. Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

65. Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?

66. In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

67. A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

68. When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

69. Which stage type can be altered and dropped?

70. Which command can be used to stage local files from which Snowflake interface?

71. What is the recommended file sizing for data loading using Snowpipe?

72. Which services does the Snowflake Cloud Services layer manage? (Select TWO).

73. What data is stored in the Snowflake storage layer? (Select TWO).

74. In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

75. What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

76. What is a responsibility of Snowflake's virtual warehouses?

77. Which of the following compute resources or features are managed by Snowflake? (Select TWO).

78. What happens when a virtual warehouse is resized?

79. A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data.

Will the developer be able to modify the table to read the masked data?

80. Which of the following describes how clustering keys work in Snowflake?

81. What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

82. Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

83. Which data type can be used to store geospatial data in Snowflake?

84. What can be used to view warehouse usage over time? (Select Two).

85. Which Snowflake feature is used for both querying and restoring data?

86. A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.

Which application will the Snowflake users need to install on their devices in order to connect with MFA?

87. Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

88. What tasks can be completed using the copy command? (Select TWO)

89. What feature can be used to reorganize a very large table on one or more columns?

90. What SQL command would be used to view all roles that were granted to user.1?

91. Which of the following can be executed/called with Snowpipe?

92. What Snowflake role must be granted for a user to create and manage accounts?

93. When unloading to a stage, which of the following is a recommended practice or approach?

94. When is the result set cache no longer available? (Select TWO)

95. Which of the following describes external functions in Snowflake?

96. What are ways to create and manage data shares in Snowflake? (Select TWO)

97. A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days.

Which of the following statements will return the required information?

98. Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

99. What is the purpose of an External Function?

100. A user created a new worksheet within the Snowsight Ul and wants to share this with teammates How can this worksheet be shared?