Pass the COF-R02 SnowPro Core Recertification Exam with New COF-R02 Exam Dumps

1. What privileges are required to create a task?

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

3. Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

4. When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

5. True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.

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

7. What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

8. What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

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

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

11. If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

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

13. True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.

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

15. True or False: Snowflake supports federated authentication in all editions.

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

17. True or False: Snowflake charges a premium for storing semi-structured data.

18. True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

19. True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

20. The PUT command: (Choose two.)

21. How a Snowpipe charges calculated?

22. True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

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

24. True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

25. The number of queries that a Virtual Warehouse can concurrently process is determined by: Choose 2 answers

26. True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

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

28. Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

29. True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

30. True or False: Data Providers can share data with only the Data Consumer.

31. True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

32. True or False: It is possible to load data into Snowflake without creating a named File Format object.

33. True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

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

35. True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

36. Which interfaces can be used to create and/or manage Virtual Warehouses?

37. When can a Virtual Warehouse start running queries?

38. Which of the following DML commands isn’t supported by Snowflake?

39. Which of the following are true of multi-cluster Warehouses? Select all that apply below.

40. Which of the following statement is true of Snowflake?

41. True or False: Pipes can be suspended and resumed.

42. Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

43. Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

44. The Query History in the Snowflake Web Interface (UI) is kept for approximately:

45. A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

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

47. When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

48. What are the three layers that make up Snowflake’s architecture? Choose 3 answer

49. Which of the following objects can be cloned? (Choose four.)

50. True or False: An active warehouse is required to run a COPY INTO statement.

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

52. Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

53. Which of the following roles is recommended to be used to create and manage users and roles?

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

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

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

57. Which of the following terms best describes Snowflake’s database architecture?

58. Which of the following objects is not covered by Time Travel?

59. Which of the following statements would be used to export/unload data from Snowflake?

60. Which of the following are options when creating a Virtual Warehouse?

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

62. True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

63. Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

64. True or False: You can query the files in an External Stage directly without having to load the data into a table.

65. True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

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

67. What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answers

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

83. What happens when a virtual warehouse is resized?

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

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

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. What is the default File Format used in the COPY command if one is not specified?

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

89. What features does Snowflake Time Travel enable?

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

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

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

93. Which statement about billing applies to Snowflake credits?

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

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

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

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

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

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

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