Practice on Free Snowflake Snowpro-Core Dumps 2022 Updated, and Download Snowpro-core Dumps in PDF from Certspilot

1. Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)

2. Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)

3. What is the recommended Snowflake data type to store semi-structured data like JSON?

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

5. Which of the following are common use cases for zero-copy cloning? (Choose three.)

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

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

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

9. True or False: Snowflake charges additional fees to Data Providers for each Share they create.

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

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

12. Which of the following connectors are available in the Downloads section of the Snowflake Web Interface (UI)? (Choose two.)

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

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

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

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

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

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

19. Which of the following are options when creating a Virtual Warehouse? (Choose two.)

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

21. Fail-safe is unavailable on which table types? (Choose two.)

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

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

24. Which of the following commands are not blocking operations? (Choose two.)

25. Which of the following is true of Snowpipe via REST API? (Choose two.)

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

27. When can a Virtual Warehouse start running queries?

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

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

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

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

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

33. When should you consider disabling auto-suspend for a Virtual Warehouse? (Choose two.)

34. Which of the following are valid approaches to loading data into a Snowflake table? (Choose all that apply.)

35. If auto-suspend is enabled for a Virtual Warehouse, the Warehouse is automatically suspended when:

36. True or False: Multi-Factor Authentication (MFA) in Snowflake is only supported in conjunction with Single Sign-On (SSO).

37. The number of queries that a Virtual Warehouse can concurrently process is determined by (Choose two.):

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

39. What privileges are required to create a task?

40. What are the three things customer want most from their enterprise data warehouse solution? (Choose three.)

41. What are the three things customer want most from their enterprise data warehouse solution? (Choose three.)

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

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

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

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

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

47. The FLATTEN function is used to query which type of data in Snowflake?

48. The FLATTEN function is used to query which type of data in Snowflake?

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

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

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

52. True or False: It is best practice to define a clustering key on every table.

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

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

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

56. What is the lowest Snowflake edition that offers Time Travel up to 90 days?

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

58. True or False: You can resize a Virtual Warehouse while queries are running.

59. What is the most granular object that the Time Travel retention period can be defined on?

60. Which of the following statements is true of Snowflake micro-partitioning?