Question 1 · 1323 in bank
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
Show answer
Answer: B
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
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
Answer: B
Which statement best describes `clustering`?
Answer: A
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html In Snowflake, as data is inserted/loaded into a table, clustering metadata is collected and recorded for each micro-partition created during the process. Snowflake then leverages this clustering information to avoid unnecessary scanning of micro-partitions during querying, significantly accelerating the performance of queries that reference these columns.
Source: Adapted from community discussion — Sundarr
What is the most granular object that the Time Travel retention period can be defined on?
Answer: D
The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."
Source: Adapted from community discussion — blazingliverbird
Which task is supported by the use of Access History in Snowflake?
Answer: C
Which feature of Snowflake’s Continuous Data Protection (CDP) has associated costs?
Answer: A
When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
Answer: B
Answer is B Scoped URL: Encoded URL that permits temporary access to a staged file without granting privileges to the stage. The URL expires when the persisted query result period ends (i.e. the results cache expires), which is currently 24 hours. Source: https://docs.snowflake.com/en/user-guide/unstructured-intro#:~:text=Scoped%20URL,granting%20privileges%20to%20the%20stage.
Source: Adapted from community discussion — VenkataPhaniPavanKumar
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Answer: D
Maybe metadata cus it's the only thing which is separate from data ABC are all about data, not separate from the data D
Source: Adapted from community discussion — 0e504b5
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database. Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
Answer: A
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
Answer: C
Which function can be used with the COPY INTO [LOCATION] statement to convert rows from a relational table to a single VARIANT column, and to unload rows into a JSON file?
Answer: C
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 1. 1323 questions available.
Version 1.0.0. How we source questions