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?