Snowpro Core Exam Questions & Answers

All 100 questions

1. Q1 As an administrator, you are required to find all users that logged in to the system during the past 15 minutes. Which…
2. Q2 Which of the following are file staging commands? (Select all that apply)
3. Q3 Which of these Sampling methods does Snowflake support? (Select 2)
4. Q4 True or False: The ACCOUNT_USAGE views contain information on objects that have been deleted.
5. Q5 Which of the following table types are not protected by fail-safe storage? Select all that apply.
6. Q6 Snowflake’s approach to access control combines aspects from which of the following models? (Select 2)
7. Q7 VARIANT is used to FLATTEN hierarchical data. (True / False)
8. Q8 Multi-factor authentication can be enabled for which of the following? Select all that apply.
9. Q9 The COPY command can unload data from a table into which of the following locations? Select all that apply.
10. Q10 What is the role required to query the TABLE_STORAGE_METRICS view from the account usage schema in Snowflake?
11. Q11 Which of the following caching mechanisms in Snowflake does not require virtual warehouses to be active for it to work?
12. Q12 Suppose a multi-cluster virtual warehouse is configured with a minimum cluster count of 1 and maximum cluster count of 3. Is the…
13. Q13 Snowflake automatically and transparently maintains materialized views. (True/False)
14. Q14 When defining a clustering key which type of columns should be considered?
15. Q15 Why is Snowflake considered a SaaS (Software-as-a-Service) product?Select all that apply.
16. Q16 Which of these are unstructured data? (Select 2)
17. Q17 Scoped URL is ideal for
18. Q18 Which of the following statements is true about Snowflake’s Search Optimization Service?
19. Q19 The COPY command allows the following options for selecting files for loading data from a stage. Select all that apply.
20. Q20 What value does the CURRENT_CLIENT function return when called from an application using a JDBC driver to connect?
21. Q21 True or False: Using the views in the INFORMATION_SCHEMA, you can access the history of usage that occurred 5 minutes ago.
22. Q22 If an account has federated authentication enabled. Can Snowflake admins still maintain user IDs and passwords in Snowflake?
23. Q23 What does OVERWRITE parameter do with INSERT command?
24. Q24 Which of the following commands are File staging commands? (Select all that apply)
25. Q25 What is the primary benefit of using clustering keys in Snowflake?
26. Q26 You are unloading data from a multi-gigabyte table to an external stage; which of the following statements regarding the exported file(s) are…
27. Q27 Which of the following statement about MFA is correct? Select all that apply.
28. Q28 Snowflake’s network policies can be used to allow and block access based on IP addresses in all Snowflake editions.
29. Q29 Which of the following SQL functions is used to generate a pre-signed URL for accessing unstructured data in Snowflake?
30. Q30 How long do results remain in the Query results cache?
31. Q31 The FLATTEN function in Snowflake must be explicitly joined using a LATERAL keyword in queries.
32. Q32 Which of the following statements about column-level security features in Snowflake is correct?
33. Q33 To implement row-level security, what type of policies should be configured?
34. Q34 Which of the following are serverless features provided by Snowflake?
35. Q35 Which of the Snowflake editions provides a federated authorization feature?
36. Q36 Which of the following illustration represents the least well-clustered table?
37. Q37 Which services are managed by Snowflake's cloud services layer? (Select all that apply)
38. Q38 True or False: The functions provided in INFORMATION_SCHEMA can be used to view account-level information.
39. Q39 Snowflake supports the secured access of unstructured data files in cloud storage. What types of URLs are available to access files in…
40. Q40 True/False: If you use a specific virtual warehouse to load data into a table, you must use the same virtual warehouse to…
41. Q41 True/False: Snowflake customers can control the format using which Snowflake stores the data for a table.
42. Q42 You have a dashboard that connects to Snowflake via JDBC. The dashboard is refreshed hundreds of times per day. The data is…
43. Q43 What type of metadata is maintained for each micro-partition? Select all that apply.
44. Q44 If the query result cache for a query is not used by any future query, what is the duration after which it…
45. Q45 You are an account administrator tasked with creating a trial account with one of Snowflake's data integration partners. What should you do…
46. Q46 When a database or a schema is cloned, which of the following objects will NOT be cloned?
47. Q47 What is the default compression method used by Snowflake while unloading data?
48. Q48 When should a clustering key typically be avoided in Snowflake?
49. Q49 Consider a database with the name MARKETING. The database has a table called CUSTOMER in the PUBLIC schema. The CUSTOMER table has…
50. Q50 Which of the following statement describe micro-partitions correctly?
51. Q51 In a federated Snowflake environment, can a user still log into Snowflake using their Snowflake credentials?
52. Q52 Which of the following can be used to find the query ID of the most recent query executed in the current session?Select…
53. Q53 Multi-factor authentication can be enabled for which of the following? Select all that apply.
54. Q54 A stored procedure has been set up as a stored procedure with owner's rights. A system administrator runs the stored procedure. Which…
55. Q55 Which of the following statements is true about the Search Optimization Service in Snowflake?
56. Q56 Select the type of function that is used to execute an action in the system or return information about the system.
57. Q57 Direct data sharing can only be done with accounts in the same region and the same cloud provider. (TRUE/FALSE)
58. Q58 Snowflake allows which two of the following approaches for loading data?
59. Q59 Which one is not the Snowflake System-Defined role?
60. Q60 Which of the following is NOT a type of internal stage in Snowflake?
61. Q61 Which of the following statement is true when sharing data with an organization that does not have a Snowflake account?
62. Q62 True or False: When unloading data, each exported file is 16MB, and this configuration cannot be changed.
63. Q63 What is the default execution context for Stored Procedures in Snowflake if the execution context (caller or owner) is not explicitly specified?
64. Q64 True or False: The data in the views in the INFORMATION_SCHEMA is real-time.
65. Q65 The closer the ratio of scanned micro-partitions and columnar data is to the ratio of actual data selected, the more efficient is…
66. Q66 Which of the following Snowflake editions support database failover and failback between Snowflake accounts, thus providing business continuity and disaster recovery? Select…
67. Q67 Suppose you have an auto-scaling mode setup with a Standard policy. In what situation does Snowflake spin up an additional cluster?
68. Q68 Which of the following statements correctly describe Search Optimization in Snowflake? Select all that apply.
69. Q69 What is the primary purpose of the query profile in Snowflake?
70. Q70 You need to see the history of all queries executed in the last 60 minutes. Which of the following method should you…
71. Q71 True or False: A share must have at least one consumer added.
72. Q72 Snowflake stores which of the following metadata about data in a micro-partition. Select all that apply.
73. Q73 When loading data using COPY INTO <table> command, it is a must that the data files have the same number and order…
74. Q74 What is the minimum Snowflake edition that supports federated authentication?
75. Q75 Which of the following commands can be used to remove all rows from a table without deleting the table structure in Snowflake?
76. Q76 When a table is cloned in Snowflake, the load history metadata from the original table is also copied to the clone.
77. Q77 Which Snowflake edition provides dedicated servers and a separate environment for companies dealing with highly sensitive data?
78. Q78 Which of these are not supported by the Search Optimization Service? (Select all that apply)
79. Q79 Inserting data into a table in Snowflake without specifying column names requires that the number and order of values match the table's…
80. Q80 Which of the following will help reduce query queuing on a virtual warehouse?Select two answers.
81. Q81 Which of the following can be used to access an element within an array in a Snowflake VARIANT column?
82. Q82 Which of the following requirements can be fulfilled by only a secure UDF? Select all that apply.
83. Q83 What is the primary benefit of introducing a clustering key on a table in Snowflake?
84. Q84 When sharing with a non-Snowflake user, the reader account belongs to which account?
85. Q85 If a user wants to create a table in Snowflake without any Fail-safe protection but with the ability for a 1-day Time…
86. Q86 A cloned database or schema in Snowflake will automatically inherit the privileges of the parent database or schema.
87. Q87 Using the INFORMATION_SCHEMA you can view information on account-level objects such as roles, warehouses, and databases.
88. Q88 True or False: The data provider is responsible for and pays for the compute costs of a reader account.
89. Q89 Which data type in Snowflake is specifically designed for storing and querying semi-structured data?
90. Q90 The Query Processing Layer can run multiple compute clusters (virtual warehouses) simultaneously. Which statement is true regarding how the compute clusters access…
91. Q91 Which of the following statements about Snowflake's "table storage metrics" views is true?
92. Q92 During a weekly release cycle, which of the following accounts may be updated on the second day of release?
93. Q93 Which of the following terms may be used to describe Snowflake?Select all that apply.
94. Q94 True or False: Resource monitors can manage a single virtual warehouse, a collection of virtual warehouses, or the entire Snowflake account.
95. Q95 Select the type of function that returns one value per invocation (one value per row).
96. Q96 Which of the following scaling policies aims to minimize query queuing?
97. Q97 Which of the following statements regarding built-in roles' privileges in Snowflake are true?Select all that apply.
98. Q98 As the database administrator, you defined new clustering keys for a large table. So, while Snowflake re-clusters data, what should you expect?…
99. Q99 Which of the following statements accurately describe Snowflake's micro-partitioning architecture? (Choose two.)
100. Q100 Which view type doesn't use some of the internal Snowflake optimizations?