SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
What is a key feature of Snowflake architecture?
Answer: C
Different queries goes in different cluster a single query is processed in a single cluster. Multi cluster is for "Concurrency"
Source: Adapted from community discussion — BigDataBB
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Answer: BE
BE A - False - To share data in a region, you must have an account in that region in order to replicate data. If you have more than one account, all accounts must belong to the same organization B - True - To share data in a region, you must have an account in that region in order to replicate data. If you have more than one account, all accounts must belong to the same organization C - True, but not relevant to Data Marketplace D - false - When you publish a listing in a remote region, you can either allow all accounts in your organization to fulfill listing requests or explicitly add individual accounts as providers. Only the listing owner can specify who can fulfill listing requests. E - True - For free listings, you must replicate data to each of the selected regions before publishing the listing. For standard listings, you do not need to replicate the data to each region until a consumer requests it. https://docs.snowflake.com/en/user-guide/data-exchange-managing-data-listings.html#considerations-for-creating-a-listing-in-a-remote-region-and-replicating-data
Source: Adapted from community discussion — scoob
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Answer: B
To optimize the number of parallel operations for a load, we recommend aiming to produce data files roughly 100MB to 250MB in size, compressed. Splitting large files into a greater number of smaller files distributes the load among the servers in an active warehouse and increases performance. https://community.snowflake.com/s/article/faq-does-snowflake-have-a-recommended-file-size-for-loading
Source: Adapted from community discussion — newbie2020
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
Answer: A
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no queries have been executed previously? (Choose three.)
Answer: BCD
B,C,D are the answers. Min uses the Global cache / Service layer cache, hence it does not require the WH to execute query. So, A can be eliminated from answers.
Source: Adapted from community discussion — Sk1020
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
Answer: C
Querying the ACCESS_HISTORY View This Account Usage view can be used to query the access history of Snowflake objects (e.g. table, view, column) within the last 365 days (1 year).
Source: Adapted from community discussion — kjdfsafc87456
Which feature is only available in the Enterprise or higher editions of Snowflake?
Answer: A
What are the three layers that make up Snowflake's architecture? (Choose three.)
Answer: ACD
Will data cached in a warehouse be lost when the warehouse is resized?
Answer: A
https://docs.snowflake.com/en/user-guide/warehouses-considerations.html#scaling-up-vs-scaling-out. At the "tip" it states: ... which CAN impact performance ... "Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed."
Source: Adapted from community discussion — William_20
Which semi-structured file formats are supported when unloading data from a table? (Choose two.)
Answer: DE
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 321. 1323 questions available.
Version 1.0.0. How we source questions