[Feb 15, 2025] Snowflake COF-C02 Exam Dumps Files, Q1/511: What type of query benefits the MOST from search optimization?

Join the discussion

Question 1/511

What type of query benefits the MOST from search optimization?

A. A query that includes analytical expressions

B. A query that uses equality predicates or predicates that use IN

C. A query that uses only disjunction (i.e., OR) predicates

D. A query that filters on semi-structured data types

Add Comments

Other Question (511q): Q1. What type of query benefits the MOST from search optimization?...; Q2. True or False: Reader Accounts are able to extract data from shared data objects for use o...; Q3. Which table function is used to perform additional processing on the results of a previous...; Q4. What is one of the characteristics of data shares?...; Q5. What column type does a Kafka connector store formatted information in a single column?...; Q6. Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?...; Q7. Which of the following Snowflake features provide continuous data protection automatically...; Q8. Which minimum Snowflake edition allows for a dedicated metadata store?...; Q9. What causes objects in a data share to become unavailable to a consumer account?...; Q10. What are the least privileges needed to view and modify resource monitors? (Select TWO)....; Q11. Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Da...; Q12. Which stage type can be altered and dropped?; Q13. How does Snowflake allow a data provider with an Azure account in central Canada to share ...; Q14. Which MINIMUM set of privileges is required to temporarily bypass an active network policy...; Q15. What is the purpose of a Query Profile?; Q16. Which data type can be used to store geospatial data in Snowflake?...; Q17. Which statements reflect valid commands when using secondary roles? (Select TWO)....; Q18. Which DDL/DML operation is allowed on an inbound data share?...; Q19. Which function unloads data from a relational table to JSON?...; Q20. What happens when a cloned table is replicated to a secondary database? (Select TWO)...; Q21. Which privilege is needed for a SnowFlake user to see the definition of a secure view?...; Q22. What happens when a virtual warehouse is resized?...; Q23. What does Snowflake's search optimization service support?...; Q24. What can a Snowflake user do with the information included in the details section of a Que...; Q25. What Snowflake role must be granted for a user to create and manage accounts?...; Q26. If a virtual warehouse is suspended, what happens to the warehouse cache?...; Q27. Which Snowflake architectural layer is responsible for a query execution plan?...; Q28. What activities can a user with the ORGADMIN role perform? (Select TWO)....; Q29. At what levels can a resource monitor be configured? (Select TWO)....; Q30. Which of the following can be executed/called with Snowpipe?...; Q31. A virtual warehouse is created using the following command: Create warehouse my_WH with wa...; Q32. Which stages are used with the Snowflake PUT command to upload files from a local file sys...; Q33. True or False: It is possible for a user to run a query against the query result cache wit...; Q34. True or False: An active warehouse is required to run a COPY INTO statement....; Q35. What is the minimum Snowflake edition that customers planning on storing protected informa...; Q36. What is the MOST performant file format for loading data in Snowflake?...; Q37. When unloading to a stage, which of the following is a recommended practice or approach?...; Q38. A user is loading JSON documents composed of a huge array containing multiple records into...; Q39. What are the benefits of the replication feature in Snowflake? (Select TWO)....; Q40. What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtua...; Q41. Which Snowflake partner specializes in data catalog solutions?...; Q42. What activities can a user with the ORGADMIN role perform? (Select TWO)....; Q43. Which Snowflake privilege is required on a pipe object to pause or resume pipes?...; Q44. Which of the following objects is not covered by Time Travel?...; Q45. Which data formats are supported by Snowflake when unloading semi-structured data? (Select...; Q46. Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)...; Q47. What does the worksheet and database explorer feature in Snowsight allow users to do?...; Q48. Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select T...; Q49. Which is the MINIMUM required Snowflake edition that a user must have if they want to use ...; Q50. In Snowflake, what allows users to perform recursive queries?...; Q51. Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select ...; Q52. How does Snowflake describe its unique architecture?...; Q53. What happens when an external or an internal stage is dropped? (Select TWO)....; Q54. What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtua...; Q55. A virtual warehouse's auto-suspend and auto-resume settings apply to which of the followin...; Q56. Where is Snowflake metadata stored?; Q57. What are type predicates used for?; Q58. Which stream type can be used for tracking the records in external tables?...; Q59. What command is used to export or unload data from Snowflake?...; Q60. Which actions can be performed using a resource monitor in Snowflake? (Select TWO)....; Q61. Which of the following features are available with the Snowflake Enterprise edition? (Choo...; Q62. Which type of charts are supported by Snowsight? {Select TWO)...; Q63. What is the name of the SnowSQLfile that can store connection information?...; Q64. What MINIMUM privilege is required on the external stage for any role in the GET REST API ...; Q65. Which pages are included in the Activity area of Snowsight? (Select TWO)....; Q66. Which of the following is true of Snowpipe via REST API? Choose 2 answers...; Q67. Which command removes a role from another role or a user in Snowflak?...; Q68. Which formats are supported for unloading data from Snowflake? Choose 2 answers...; Q69. True or false: it is best practice to define a clustering key on every table....; Q70. Why would a Snowflake user decide to use a materialized view instead of a regular view?...; Q71. What is the minimum Snowflake edition required to use Dynamic Data Masking?...; Q72. The effects of query pruning can be observed by evaluating which statistics? (Select TWO)....; Q73. Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. ...; Q74. Which file function gives a user or application access to download unstructured data from ...; Q75. Which minimum Snowflake edition allows for a dedicated metadata store?...; Q76. True or False: Users are able to see the result sets of queries executed by other users th...; Q77. The is the minimum Fail-safe retention time period for transient tables?...; Q78. True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small...; Q79. What is an advantage of using an explain plan instead of the query profiler to evaluate th...; Q80. What does Snowflake recommend regarding database object ownership? (Select TWO)....; Q81. Which statement accurately describes a characteristic of a materialized view?...; Q82. What is a limitation of a Materialized View?; Q83. What are characteristic of Snowsight worksheet? (Select TWO.)...; Q84. A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified o...; Q85. Which user preferences can be set for a user profile in Snowsight? (Select TWO)....; Q86. Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)...; Q87. Which Snowflake architectural layer is responsible for a query execution plan?...; Q88. How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?...; Q89. True or False: Reader Accounts are able to extract data from shared data objects for use o...; Q90. What are advantages clones have over tables created with CREATE TABLE AS SELECT statement?...; Q91. Which Snowflake feature is used for both querying and restoring data?...; Q92. Which file function generates a SnowFlake-hosted URL that must be authenticated when used?...; Q93. How often are the Account and Table master keys automatically rotated by Snowflake?...; Q94. What happens when a database is cloned?; Q95. Which Snowflake table objects can be shared with other accounts? (Select TWO)....; Q96. What is the Fail-safe retention period for transient and temporary tables?...; Q97. What does the Activity area of Snowsight allow users to do? (Select TWO)....; Q98. Which statement describes pruning?; Q99. When is the result set cache no longer available? (Select TWO)...; Q100. Which Snowflake objects track DML changes made to tables, like inserts, updates, and delet...; Q101. What is a characteristic of the Snowflake Query Profile?...; Q102. Which statements are correct concerning the leveraging of third-party data from the Snowfl...; Q103. In which hierarchy is tag inheritance possible?...; Q104. Which Snowflake tool is recommended for data batch processing?...; Q105. The is the minimum Fail-safe retention time period for transient tables?...; Q106. Which security models are used in Snowflake to manage access control? (Select TWO)....; Q107. Which file function gives a user or application access to download unstructured data from ...; Q108. What metadata does Snowflake store for rows in micro-partitions? (Select TWO)....; Q109. The Information Schema and Account Usage Share provide storage information for which of th...; Q110. How can a Snowflake user traverse semi-structured data?...; Q111. What can a user win a reader account do in Snowflake?...; Q112. Which URL type allows users to access unstructured data without authenticating into Snowfl...; Q113. What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects wer...; Q114. What is the purpose of multi-cluster virtual warehouses?...; Q115. A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend...; Q116. A user wants to add additional privileges to the system-defined roles for their virtual wa...; Q117. What action should be taken if a Snowflake user wants to share a newly created object in a...; Q118. Which stages are used with the Snowflake PUT command to upload files from a local file sys...; Q119. A user created a transient table and made several changes to it over the course of several...; Q120. Which Snowflake feature will allow small volumes of data to continuously load into Snowfla...; Q121. How long is the Fail-safe period for temporary and transient tables?...; Q122. Which query contains a Snowflake hosted file URL in a directory table for a stage named br...; Q123. If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 ...; Q124. What happens to historical data when the retention period for an object ends?...; Q125. Which command can be used to list all the file formats for which a user has access privile...; Q126. By default, which role can create resource monitors?...; Q127. What value provides information about disk usage for operations where intermediate results...; Q128. Regardless of which notation is used, what are considerations for writing the column name ...; Q129. What is a directory table in Snowflake?; Q130. Which of the following statements would be used to export/unload data from Snowflake?...; Q131. A tabular User-Defined Function (UDF) is defined by specifying a return clause that contai...; Q132. How many days is load history for Snowpipe retained?...; Q133. A Snowflake account administrator has set the resource monitors as shown in the diagram, w...; Q134. What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO <table&...; Q135. What is the purpose of the Snowflake SPLIT TO_TABLE function?...; Q136. Which command is used to unload data from a Snowflake database table into one or more file...; Q137. Which Snowflake objects track DML changes made to tables, like inserts, updates, and delet...; Q138. Which command should be used to download files from a Snowflake stage to a local folder on...; Q139. A query containing a WHERE clause is running longer than expected. The Query Profile shows...; Q140. How often are encryption keys automatically rotated by Snowflake?...; Q141. Where is Snowflake metadata stored?; Q142. What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREH...; Q143. What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-parti...; Q144. What activities can a user with the ORGADMIN role perform? (Select TWO)....; Q145. Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Da...; Q146. Which Snowflake tool is recommended for data batch processing?...; Q147. Which Snowflake layer is associated with virtual warehouses?...; Q148. To use the overwrite option on insert, which privilege must be granted to the role?...; Q149. What are best practice recommendations for using the ACCOUNTADMIN system-defined role in S...; Q150. A view is defined on a permanent table. A temporary table with the same name is created in...; Q151. Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. ...; Q152. What happens when a Data Provider revokes privileges to a Share on an object in their sour...; Q153. Which Snowflake SQL statement would be used to determine which users and roles have access...; Q154. What is a key feature of Snowflake architecture?...; Q155. True or False: Snowpipe via REST API can only reference External Stages as source....; Q156. True or False: A single database can exist in more than one Snowflake account....; Q157. Which parameter prevents streams on tables from becoming stale?...; Q158. True or False: When a user creates a role, they are initially assigned ownership of the ro...; Q159. Which of the following objects can be cloned? (Choose four.)...; Q160. Which SnowFlake edition enables data sharing only through Snowflake Support?...; Q161. What is the following SQL command used for? Select * from table(validate(t1, job_id => ...; Q162. which of the following are valid approaches to loading data into a snowflake table? select...; Q163. What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Se...; Q164. There are two Snowflake accounts in the same cloud provider region: one is production and ...; Q165. Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)...; Q166. Which statistics are displayed in a Query Profile that indicate that intermediate results ...; Q167. True or False: Snowflake supports federated authentication in all editions....; Q168. Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of:...; Q169. How often are encryption keys automatically rotated by Snowflake?...; Q170. Which semi-structured file formats are supported when unloading data from a table? (Select...; Q171. Which statement about billing applies to Snowflake credits?...; Q172. Which of the following is a valid source for an external stage when the Snowflake account ...; Q173. Where would a Snowflake user find information about query activity from 90 days ago?...; Q174. What is the default File Format used in the COPY command if one is not specified?...; Q175. A JSON document is stored in the source_colum of type VARIANT. The document has an array c...; Q176. How can a Snowflake user access a JSON object, given the following table? (Select TWO). (E...; Q177. Which command is used to start configuring Snowflake for Single Sign-On (SSO)?...; Q178. What does Snowflake recommend a user do if they need to connect to Snowflake with a tool o...; Q179. Which of the following statements describe features of Snowflake data caching? (Choose two...; Q180. Which Snowflake technique can be used to improve the performance of a query?...; Q181. How does the Access_History view enhance overall data governance pertaining to read and wr...; Q182. Which stage type can be altered and dropped?; Q183. A column named "Data" contains VARIANT data and stores values as follows: (Exhibit) How wi...; Q184. When can a Virtual Warehouse start running queries?...; Q185. Which of the following can be used when unloading data from Snowflake? (Choose two.)...; Q186. Which function can be used to convert semi-structured data into rows and columns?...; Q187. User-level network policies can be created by which of the following roles? (Select TWO)....; Q188. Which statement best describes '' clustering''?...; Q189. What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?...; Q190. In a Snowflake role hierarchy, what is the top-level role?...; Q191. Which of the following are valid methods for authenticating users for access into Snowflak...; Q192. If a virtual warehouse is suspended, what happens lo the warehouse cache?...; Q193. Which of the following significantly improves the performance of selective point lookup qu...; Q194. What technique does Snowflake use to limit the number of micro-partitions scanned by each ...; Q195. Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)...; Q196. What is the primary purpose of a directory table in Snowflake?...; Q197. Which key access control concept does Snowflake descibe as a defined level of access to an...; Q198. What does Snowflake recommend regarding database object ownership? (Select TWO)....; Q199. Which of the following statements apply to Snowflake in terms of security? (Choose two.)...; Q200. What do the terms scale up and scale out refer to in Snowflake? (Choose two.)...; Q201. When would Snowsight automatically detect if a target account is in a different region and...; Q202. Which objects together comprise a namespace in Snowflake? (Select TWO)....; Q203. When reviewing the load for a warehouse using the load monitoring chart, the chart indicat...; Q204. Assume there is a table consisting of five micro-partitions with values ranging from A to ...; Q205. What is the recommended file sizing for data loading using Snowpipe?...; Q206. How does the search optimization service help Snowflake users improve query performance?...; Q207. A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake table...; Q208. How can an administrator check for updates (for example, SCIM API requests) sent to Snowfl...; Q209. When should a multi-cluster warehouse be used in auto-scaling mode?...; Q210. True or False: Fail-safe can be disabled within a Snowflake account....; Q211. Which is the MINIMUM required Snowflake edition that a user must have if they want to use ...; Q212. Which of the following Snowflake objects can be shared using a secure share? (Select TWO)....; Q213. A user wants to access files stored in a stage without authenticating into Snowflake. Whic...; Q214. Which of the following objects can be shared through secure data sharing?...; Q215. What is the recommended compressed file size range for continuous data loads using Snowpip...; Q216. What are potential impacts of storing non-native values like dates and timestamps in a var...; Q217. What happens when an external or an internal stage is dropped? (Select TWO)....; Q218. True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunc...; Q219. What is the purpose of an External Function?; Q220. Which Snowflake partner specializes in data catalog solutions?...; Q221. Which command should be used to assign a key to a Snowflake user who needs to connect usin...; Q222. Which minimum Snowflake edition allows for a dedicated metadata store?...; Q223. What services does Snowflake automatically provide for customer that they may have been re...; Q224. Which statement accurately describes how a virtual warehouse functions?...; Q225. What is a best practice after creating a custom role?...; Q226. Which views are included in the data_sharing_usage schema? (Select TWO)....; Q227. What privilege should a user be granted to change permissions for new objects in a managed...; Q228. While running a query on a virtual warehouse in auto-scale mode, additional clusters are s...; Q229. What COPY INTO SQL command should be used to unload data into multiple files?...; Q230. What does a table with a clustering depth of 1 mean in Snowflake?...; Q231. How would a user run a multi-cluster warehouse in maximized mode?...; Q232. A clustering key was defined on a table, but It is no longer needed. How can the key be re...; Q233. Which of the following Snowflake objects can be shared using a secure share? (Select TWO)....; Q234. True or False: Fail-safe can be disabled within a Snowflake account....; Q235. The following settings are configured: (Exhibit) For how many days will the data be retain...; Q236. What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake...; Q237. What is the recommended way to change the existing file format type in my format from CSV ...; Q238. Which command can be used to load data into an internal stage?...; Q239. What happens to the shared objects for users in a consumer account from a share, once a da...; Q240. While running a query on a virtual warehouse in auto-scale mode, additional clusters are s...; Q241. When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO)....; Q242. What features does Snowflake Time Travel enable?...; Q243. The following JSON is stored in a VARIANT column called src of the CAR_SALES table: (Exhib...; Q244. A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake databas...; Q245. What is the following SQL command used for? Select * from table(validate(t1, job_id => ...; Q246. What are ways to create and manage data shares in Snowflake? (Select TWO)...; Q247. Which virtual warehouse consideration can help lower compute resource credit consumption?...; Q248. For non-materialized views, what column in Information Schema and Account Usage identifies...; Q249. The Snowflake Cloud Data Platform is described as having which of the following architectu...; Q250. What factors impact storage costs in Snowflake? (Select TWO)....; Q251. What transformations are supported when loading data into a table using the COPY INTO <...; Q252. True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse...; Q253. During periods of warehouse contention which parameter controls the maximum length of time...; Q254. What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and...; Q255. Which function returns the URL of a stage using the stage name as the input?...; Q256. How can a user get the MOST detailed information about individual table storage details in...; Q257. Which of the following SQL statements will list the version of the drivers currently being...; Q258. Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a que...; Q259. What is a machine learning and data science partner within the Snowflake Partner Ecosystem...; Q260. What does the Activity area of Snowsight allow users to do? (Select TWO)....; Q261. What does the TableScan operator represent in the Query Profile?...; Q262. True or False: It is possible for a user to run a query against the query result cache wit...; Q263. A user wants to upload a file to an internal Snowflake stage using a put command. Which to...; Q264. How can performance be optimized for a query that returns a small amount of data from a ve...; Q265. What is the MAXIMUM size limit for a record of a VARIANT data type?...; Q266. A table needs to be loaded. The input data is in JSON format and is a concatenation of mul...; Q267. How can a Snowflake user optimize query performance in Snowflake? (Select TWO)....; Q268. Which Snowflake technique can be used to improve the performance of a query?...; Q269. A Snowflake user wants to temporarily bypass a network policy by configuring the user obje...; Q270. What is the purpose of multi-cluster virtual warehouses?...; Q271. Which of the following describes a Snowflake stored procedure?...; Q272. How should a virtual warehouse be configured if a user wants to ensure that additional mul...; Q273. Which of the following is a valid source for an external stage when the Snowflake account ...; Q274. Where would a Snowflake user find information about query activity from 90 days ago?...; Q275. Which account__usage views are used to evaluate the details of dynamic data masking? (Sele...; Q276. Which of the following Snowflake capabilities are available in all Snowflake editions? (Se...; Q277. Which command can be used to stage local files from which Snowflake interface?...; Q278. Which are true of Snowflake roles?; Q279. There are two Snowflake accounts in the same cloud provider region: one is production and ...; Q280. Network policies can be set at which Snowflake levels? (Choose two.)...; Q281. If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 se...; Q282. What are value types that a VARIANT column can store? (Select TWO)...; Q283. How do secure views compare to non-secure views in Snowflake?...; Q284. Which data type can be used to store geospatial data in Snowflake?...; Q285. Which of the following objects can be shared through secure data sharing?...; Q286. What do temporary and transient tables have m common in Snowflake? (Select TWO)....; Q287. Which REST API can be used with unstructured data?...; Q288. What is the difference between a stored procedure and a User-Defined Function (UDF)?...; Q289. Which common query problems are identified by the Query Profile? (Select TWO.)...; Q290. The effects of query pruning can be observed by evaluating which statistics? (Select TWO)....; Q291. What file formats does Snowflake support for loading semi-structured data? (Choose three.)...; Q292. Which of the following describes external functions in Snowflake?...; Q293. What are ways to create and manage data shares in Snowflake? (Select TWO)...; Q294. A Snowflake user wants to temporarily bypass a network policy by configuring the user obje...; Q295. How do Snowflake data providers share data that resides in different databases?...; Q296. Which activities are managed by Slowflake's Cloud Services layer? (Select TWO)....; Q297. If 3 size Small virtual warehouse is made up of two servers, how many servers make up a La...; Q298. By default, which Snowflake role is required to create a share?...; Q299. True or False: Query ID's are unique across all Snowflake deployments and can be used in c...; Q300. When cloning a database, what is cloned with the database? (Choose two.)...; Q301. Credit charges for Snowflake virtual warehouses are calculated based on which of the follo...; Q302. A user is loading JSON documents composed of a huge array containing multiple records into...; Q303. For a multi-cluster Warehouse, the number of credits billed is calculated on:...; Q304. What is a responsibility of Snowflake's virtual warehouses?...; Q305. What feature of Snowflake Continuous Data Protection can be used for maintenance of histor...; Q306. Which statements reflect valid commands when using secondary roles? (Select TWO)....; Q307. Which copy INTO command outputs the data into one file?...; Q308. Which data types can be used in a Snowflake table that holds semi-structured data? (Select...; Q309. True or False: Snowpipe via REST API can only reference External Stages as source....; Q310. Which Snowflake object can be accessed in he FROM clause of a query, returning a set of ro...; Q311. What is the minimum Snowflake edition needed for database failover and fail-back between S...; Q312. Which of the following best describes where Snowflake's metadata is stored?...; Q313. A company needs to allow some users to see Personally Identifiable Information (PII) while...; Q314. Which of the following is the Snowflake Account_Usage.Metering_History view used for?...; Q315. In the Snowflake access control model, which entity owns an object by default?...; Q316. Which chart type is supported in Snowsight for Snowflake users to visualize data with dash...; Q317. What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake...; Q318. A virtual warehouse's auto-suspend and auto-resume settings apply to which of the followin...; Q319. Who can activate and enforce a network policy for all users in a Snowflake account? (Selec...; Q320. Which Snowflake table supports unstructured data?...; Q321. How are serverless features billed?; Q322. Which query contains a Snowflake hosted file URL in a directory table for a stage named br...; Q323. Which file function generates a Snowflake-hosted file URL to a staged file using the name ...; Q324. Which Snowflake table type persists until it is explicitly dropped. is available for all u...; Q325. Which of the following commands cannot be used within a reader account?...; Q326. The fail-safe retention period is how many days?...; Q327. When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates ...; Q328. The Snowflake Cloud Data Platform is described as having which of the following architectu...; Q329. Which data type can be used to store geospatial data in Snowflake?...; Q330. What impacts the credit consumption of maintaining a materialized view? (Choose two.)...; Q331. What are two ways to create and manage Data Shares in Snowflake? (Choose two.)...; Q332. Which of the following objects are contained within a schema? (Choose two.)...; Q333. Which of the following commands cannot be used within a reader account?...; Q334. Snowflake recommends, as a minimize, that all users with the following roles(s) should be ...; Q335. What happens when a cloned table is replicated to a secondary database? (Select TWO)...; Q336. Will data cached in a warehouse be lost when the warehouse is resized?...; Q337. Which privilege must be granted to a share to allow secure views the ability to reference ...; Q338. What operations can be performed while loading a simple CSV file into a Snowflake table us...; Q339. When should a multi-cluster warehouse be used in auto-scaling mode?...; Q340. Which of the following features, associated with Continuous Data Protection (CDP), require...; Q341. Which of the following are valid methods for authenticating users for access into Snowflak...; Q342. Which account__usage views are used to evaluate the details of dynamic data masking? (Sele...; Q343. If 3 size Small virtual warehouse is made up of two servers, how many servers make up a La...; Q344. True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small...; Q345. Which formats does Snowflake store unstructured data in? (Choose two.)...; Q346. When using SnowSQL, which configuration options are required when unloading data from a SQ...; Q347. Which of the following are benefits of micro-partitioning? (Select TWO)...; Q348. Which parameter can be set at the account level to set the minimum number of days for whic...; Q349. What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?...; Q350. Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snow...; Q351. Who can activate and enforce a network policy for all users in a Snowflake account? (Selec...; Q352. What Snowflake role must be granted for a user to create and manage accounts?...; Q353. Which of the following are examples of operations that require a Virtual Warehouse to comp...; Q354. When enabling access to unstructured data, which URL permits temporary access to a staged ...; Q355. What does SnowCD help Snowflake users to do?; Q356. What is the MINIMUM role required to set the value for the parameter ENABLE_ACCOUNT_DATABA...; Q357. Which table function should be used to view details on a Directed Acyclic Graphic (DAG) ru...; Q358. A user has unloaded data from a Snowflake table to an external stage. Which command can be...; Q359. What are characteristic of Snowsight worksheet? (Select TWO.)...; Q360. How can the Query Profile be used to troubleshoot a problematic query?...; Q361. Which TABLE function helps to convert semi-structured data to a relational representation?...; Q362. Using variables in Snowflake is denoted by using which SQL character?...; Q363. Which file formats are supported for unloading data from Snowflake? (Choose two.)...; Q364. Which function determines the kind of value stored in a VARIANT column?...; Q365. What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command a...; Q366. Which of the following are considerations when using a directory table when working with u...; Q367. What type of account can be used to share data with a consumer who does have a Snowflake a...; Q368. Which of the following are considerations when using a directory table when working with u...; Q369. Query results are stored in the Result Cache for how long after they are last accessed, as...; Q370. What are the main differences between the account usage views and the information schema v...; Q371. Which role in Snowflake allows a user to enable replication for multiple accounts?...; Q372. Which of the following statements about data sharing are true? choose 2 answers...; Q373. What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtua...; Q374. Which statement is true about running tasks in Snowflake?...; Q375. What does Snowflake recommend as a best practice for using secure views?...; Q376. A column named "Data" contains VARIANT data and stores values as follows: (Exhibit) How wi...; Q377. What are the default Time Travel and Fail-safe retention periods for transient tables?...; Q378. Which of the following describes how clustering keys work in Snowflake?...; Q379. What information is found within the Statistic output in the Query Profile Overview?...; Q380. How are network policies defined in Snowflake?...; Q381. Which of the following accurately represents how a table fits into Snowflake's logical con...; Q382. Snowflake supports the use of external stages with which cloud platforms? (Choose three.)...; Q383. What is true about sharing data in Snowflake? (Choose two.)...; Q384. What is the MINIMUM permission needed to access a file URL from an external stage?...; Q385. Which SQL command can be used to see the CREATE definition of a masking policy?...; Q386. Which Snowflake object does not consume any storage costs?...; Q387. A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load...; Q388. When is the result set cache no longer available? (Select TWO)...; Q389. How can a user MINIMIZE Continuous Data Protection costs when using large, high-churn, dim...; Q390. Which of the following statements describes a benefit of Snowflake's separation of compute...; Q391. Which of the following statements is true of Snowflake?...; Q392. A company needs to read multiple terabytes of data for an initial load as part of a Snowfl...; Q393. A user has an application that writes a new Tile to a cloud storage location every 5 minut...; Q394. How can a Snowsight user change a Standard virtual warehouse to a Snowpark-optimized virtu...; Q395. What is the purpose of multi-cluster virtual warehouses?...; Q396. How many credits does a size 3X-Large virtual warehouse consume if it runs continuously fo...; Q397. Which Snowflake edition offers the highest level of security for organizations that have t...; Q398. A user wants to access stored in a stage without authenticating into Snowflake. Which type...; Q399. What are characteristics of transient tables in Snowflake? (Select TWO)....; Q400. What are the main differences between the account usage views and the information schema v...; Q401. Which user preferences can be set for a user profile in Snowsight? (Select TWO)....; Q402. Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose...; Q403. Which command can be used to load data files into a Snowflake stage?...; Q404. Which of the following roles is recommended to be used to create and manage users and role...; Q405. Which of the following indicates that it may be appropriate to use a clustering key for a ...; Q406. What is a non-configurable feature that provides historical data that Snowflake may recove...; Q407. What can the Snowflake SCIM API be used to manage? (Select TWO)....; Q408. When loading data into Snowflake, how should the data be organized?...; Q409. Which Snowflake object contains all the information required to share a database?...; Q410. Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Da...; Q411. Secured Data Sharing is allowed for which Snowflake database objects? (Select TWO)....; Q412. When referring to User-Defined Function (UDF) names in Snowflake, what does the term overl...; Q413. If a multi-cluster warehouse is using an economy scaling policy, how long will queries wai...; Q414. Which feature is only available in the Enterprise or higher editions of Snowflake?...; Q415. What is the MINIMUM Snowflake edition that must be used in order to see the ACCESS_HISTORY...; Q416. Which of the following statements are true of Snowflake releases: (Choose two.)...; Q417. Awarding a user which privileges on all virtual warehouses is equivalent to granting the u...; Q418. What column type does a Kafka connector store formatted information in a single column?...; Q419. What is the default access of a securable object until other access is granted?...; Q420. Which command can be used to load data into an internal stage?...; Q421. A user needs to create a materialized view in the schema MYDB.MYSCHEM A. Which statements ...; Q422. True or False: The user has to specify which cluster a query will run on in multi-clusteri...; Q423. When loading data into Snowflake, the COPY command supports: Choose 2 answers...; Q424. Which command is used to unload data from a Snowflake database table into one or more file...; Q425. Which of the following are best practices for loading data into Snowflake? (Choose three.)...; Q426. Which command will unload data from a table into an external stage?...; Q427. What takes the highest precedence in Snowflake file format options, when specified in mult...; Q428. Which task privilege does a Snowflake role need in order to suspend or resume a task?...; Q429. Which data formats are supported by Snowflake when unloading semi-structured data? (Select...; Q430. How can a data provider ensure that a data consumer is going to have access to the require...; Q431. Which of the following Snowflake features provide continuous data protection automatically...; Q432. Which native data types are used for storing semi-structured data in Snowflake? (Select TW...; Q433. Which function should be used to find the query ID of the second query executed in a curre...; Q434. Which of the following describes how multiple Snowflake accounts in a single organization ...; Q435. A user has an application that writes a new Tile to a cloud storage location every 5 minut...; Q436. What is the difference between a stored procedure and a User-Defined Function (UDF)?...; Q437. A Snowflake user has been granted the create data EXCHANGE listing privilege with their ro...; Q438. Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?...; Q439. Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)...; Q440. A company's security audit requires generating a report listing all Snowflake logins (e.g....; Q441. What is used to diagnose and troubleshoot network connections to Snowflake?...; Q442. While unloading data into a stage, how can the user ensure that the output will be a singl...; Q443. Which of the following are characteristics of security in Snowflake?...; Q444. The following settings are configured: For how many days will the data be retained at the ...; Q445. Which of the following is an example of an operation that can be completed without requiri...; Q446. When a Snowflake user loads CSV data from a stage, which copy into <table> command g...; Q447. What is the MAXIMUM Time Travel retention period for a transient table?...; Q448. Which of the following accurately describes shares?...; Q449. What is the recommended file sizing for data loading using Snowpipe?...; Q450. The property mins_to_bypass_network_policy is set at which level?...; Q451. The VALIDATE table function has which parameter as an input argument for a Snowflake user?...; Q452. Which of the following commands sets the Virtual Warehouse for a session?...; Q453. What is it called when a customer managed key is combined with a Snowflake managed key to ...; Q454. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:...; Q455. Which of the following are characteristics of security in Snowflake?...; Q456. What does a Notify & Suspend action for a resource monitor do?...; Q457. A running virtual warehouse is suspended. What is the MINIMUM amount of time that the ware...; Q458. How long is Snowpipe data load history retained?...; Q459. A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake table...; Q460. True or False: During data unloading, only JSON and CSV files can be compressed....; Q461. Which command is used to remove files from either external cloud storage or an internal st...; Q462. In the Data Exchange, who can get or request data from the listings? (Select TWO)....; Q463. Which privilege must be granted by one role to another role, and cannot be revoked?...; Q464. How can staged files be removed during data loading once the files have loaded successfull...; Q465. What is the only supported character set for loading and unloading data from all supported...; Q466. Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)...; Q467. Which of the following statements describe features of Snowflake data caching? (Choose two...; Q468. Which of the following objects can be shared through secure data sharing?...; Q469. When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates ...; Q470. A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. T...; Q471. What affects whether the query results cache can be used?...; Q472. True or False: It is possible for a user to run a query against the query result cache wit...; Q473. How many credits does a size 3X-Large virtual warehouse consume if it runs continuously fo...; Q474. Which data types can be used in a Snowflake table that holds semi-structured data? (Select...; Q475. What is the minimum Snowflake edition required for row level security?...; Q476. True or False: A Virtual Warehouse consumes Snowflake credits even when inactive....; Q477. Which command is used to unload files from an internal or external stage to a local file s...; Q478. Which parameter can be used to instruct a COPY command to verify data files instead of loa...; Q479. Which user object property requires contacting Snowflake Support in order to set a value f...; Q480. When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates ...; Q481. Which object allows you to limit the number of credits consumed within a Snowflake account...; Q482. Which formats does Snowflake store unstructured data in? (Choose two.)...; Q483. Given the statement template below, which database objects can be added to a share?(Select...; Q484. For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values ...; Q485. Which commands should be used to grant the privilege allowing a role to select data from a...; Q486. When unloading data with the COPY into <location> command, what is the purpose of th...; Q487. Which features could be used to improve the performance of queries that return a small sub...; Q488. Which cache type is used to cache data output from SQL queries?...; Q489. What privileges are required to create a task?...; Q490. Which Snowflake objects track DML changes made to tables, like inserts, updates, and delet...; Q491. Which URL provides access to files in Snowflake without authorization?...; Q492. A user has an application that writes a new Tile to a cloud storage location every 5 minut...; Q493. What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)...; Q494. Which feature is only available in the Enterprise or higher editions of Snowflake?...; Q495. What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-parti...; Q496. At what levels can a resource monitor be configured? (Select TWO)....; Q497. How long is Snowpipe data load history retained?...; Q498. What is the recommended method for loading data into Snowflake?...; Q499. Which of the following objects can be directly restored using the UNDROP command? (Choose ...; Q500. What information is found within the Statistic output in the Query Profile Overview?...; Q501. Which privilege is required to use the search optimization service in Snowflake?...; Q502. Snowflake provides a mechanism for its customers to override its clustering algorithms. Th...; Q503. A permanent table and temporary table have the same name, TBLI, in a schema. What will hap...; Q504. A marketing co-worker has requested the ability to change a warehouse size on their medium...; Q505. How does Snowflake define i1s approach to Discretionary Access Control (DAC)?...; Q506. How many days is load history for Snowpipe retained?...; Q507. What feature can be used to reorganize a very large table on one or more columns?...; Q508. Which command is used to unload data from a Snowflake table into a file in a stage?...; Q509. Which task is supported by the use of Access History in Snowflake?...; Q510. What are best practice recommendations for using the ACCOUNTADMIN system-defined role in S...; Q511. If a Snowflake user decides a table should be clustered, what should be used as the cluste...

Join the discussion

Question 1/511

Add Comments

Download PDF File