SnowPro Core Certification Exam Questions Online

1. True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

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

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

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

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

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

Warehouse?

7. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

8. What command is used to load files into an Internal Stage within Snowflake? Select one.

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

10. Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

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

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

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

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

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

16. Which are true of Snowflake roles?

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

Select one.

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

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

20. Which object allows you to limit the number of credits consumed within a Snowflake account?

Select one.

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

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

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

24. True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

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

26. Which item in the Data Warehouse migration process does not apply in Snowflake>

27. When can a Virtual Warehouse start running queries?

28. When creating a user it is advisable sable to: Choose 2 answers

29. When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved: Select one.

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

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

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

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

34. The PUT command: (Choose two.)

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

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

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

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

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

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

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

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

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

Choose 2 answers

44. When creating a user it is advisable sable to: Choose 2 answers

45. True or False: When Snowflake is configured to use Single Sign-on (sso), Snowflake receive the usernames and credentials from the sso service and loads them into the customer’s Snowflake account.

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

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

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

49. Which of the following statements are true of Snowflake data loading? Choose 3 answers

50. True or false: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

51. which of the following are valid approaches to loading data into a snowflake table? select

all the below that apply.

52. As a best practice, clustering keys should only be defined on tables of which minimum size?

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

54. In which layer of its architecture does Snowflake store its metadata statistics?

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

56. Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)? Choose 2 answers

57. A Virtual Warehouse’s auto-suspend and auto-resume settings apply to:

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

59. When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:

60. Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

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

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

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

64. Fail-safe is unavailable on which table types?

65. Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:

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

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

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

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

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

71. True or False: When data share is established between a Data Provider and a data Consumer, the Data Consumer can extend that data share to other Data Consumers.

72. Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

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

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

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

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

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

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

79. True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

80. Which of the following statements is true of zero-copy cloning?