Get the Most Updated COF-C02 Snowflake Core Certification Dumps: Prepare For COF-C02 Exam with Online Resource

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

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

3. What is the purpose of an External Function?

4. 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?

5. What happens when a virtual warehouse is resized?

6. What features does Snowflake Time Travel enable?

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

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

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

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

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

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

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

14. Which Snowflake partner specializes in data catalog solutions?

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

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

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

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

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

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

21. What is a limitation of a Materialized View?

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

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

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

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

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

27. 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?

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

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

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

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

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

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

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

35. 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?

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

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

38. How long is Snowpipe data load history retained?

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

Which statements will provide this access?

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

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

42. 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?

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

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

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

46. 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?

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

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

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

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

51. Which statement about billing applies to Snowflake credits?

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

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

54. 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?

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

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

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

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

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

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

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

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

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

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

65. What is a key feature of Snowflake architecture?

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

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

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

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

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

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

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

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

74. Which stage type can be altered and dropped?

75. 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?

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

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

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

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

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

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

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

83. 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?

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

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

86. 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?

87. 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?

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

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

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

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

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

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

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

95. 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?

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

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

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

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

100. What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)