New COF-C02 SnowPro Core Certification Exam Dumps – Good Study Materials For Best Practices

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

2. True or False: You can define multiple columns within a clustering key on a table.

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

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

5. which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

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

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

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

9. True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

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

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

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

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

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

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

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

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

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

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

20. On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers

21. True or False: All Snowflake table types include fail-safe storage.

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

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

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

25. What is the minimum Snowflake edition that provides data sharing?

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

27. How long is Snowpipe data load history retained?

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

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

30. Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answers

31. What privileges are required to create a task?

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

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

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

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

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

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

38. What command is used to load files into an Internal Stage within Snowflake?

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

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

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

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

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

44. What happens when a virtual warehouse is resized?

45. Which statements are true of micro-partitions? Choose 2 answers

46. Which Snowflake partner specializes in data catalog solutions?

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

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

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

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

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

52. What is a key feature of Snowflake architecture?

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

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

55. True or False: Once created, a micro-partition will never be changed.

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

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

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

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

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

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

62. Which are true of Snowflake roles?

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

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

65. Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

66. Which statement best describes Snowflake tables?

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

data.

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

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

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

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

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

73. True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.

74. A user is preparing to load data from an external stage

Which practice will provide the MOST efficient loading performance?

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

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

77. The FLATEEN function is used to query which type of data in Snowflake?

78. Which of the following is true of Snowpipe via REST API? Choose 2 answers

79. Which statement about billing applies to Snowflake credits?

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

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

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

83. What is a limitation of a Materialized View?

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

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

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

87. Select the three types of tables that exist within Snowflake. Choose 3 answers

88. Which of the following are common use cases for zero-copy cloning? Choose 3 answers

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

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

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

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

93. Which of the following items does the Cloud services Layer manage? Choose 4 answers

94. If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?

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

Which statements will provide this access?

A)

B)

C)

D)

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

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

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

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

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