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
Which privileges are required for a user to restore an object? (Choose two.)
Answer: BE
Similar to dropping an object, a user must have OWNERSHIP privileges for an object to restore it. In addition, the user must have CREATE privileges on the object type for the database or schema where the dropped object will be restored.
Source: Adapted from community discussion — jtm22
For a multi-cluster virtual warehouse, which parameters are used to calculate the number of credits billed? (Choose two.)
Answer: BC
What happens when the values for both an ALLOWED_IP_LIST and a BLOCKED_IP_LIST are used in a network policy?
Answer: B
When a network policy includes values in both the allowed and blocked IP address lists, Snowflake applies the blocked IP address list first.
Source: Adapted from community discussion — jtm22
What does the orange bar on an operator represent when reviewing the Query Profile?
Answer: B
I request to please start discussion on below questions also 527 536 540 544 545 546 550 554 556 558 559 561 580 581 582 584 588 594 601 604 610 611 612 613 614
Source: Adapted from community discussion — ShagunMittal
When unloading data from Snowflake, what is the default file size of each file?
Answer: A
The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages
Source: Adapted from community discussion — bibisa
What is the abbreviated form to get all the files in the stage for the current user?
Answer: B
There is https://docs.snowflake.com/en/sql-reference/sql/list Use the abbreviated form of the command to list all the files in the stage for the current user: LS @~; Because it asks for "abbreviated form" B is correct
Source: Adapted from community discussion — bar_ser
Which features make up Snowflake's column level security? (Choose two.)
Answer: BC
Which programming languages are supported for Snowflake User-Defined Functions (UDFs)? (Choose two.)
Answer: BD
he following topics describe how you can write UDF handlers in various languages. Writing Java UDFs Develop handlers in Java to manipulate data and return scalar or tabular results. Writing JavaScript UDFs Develop handlers in JavaScript to manipulate data and return scalar or tabular results. Writing Python UDFs Develop handlers in Python to manipulate data and return scalar or tabular results. Writing SQL UDFs Develop handlers in SQL to evaluate an arbitrary SQL expression and return scalar or tabular results.
Source: Adapted from community discussion — bibisa
What is the MAXIMUM number of days that Snowflake resets the 24-hour retention period for a query result every time the result is used?
Answer: C
Each time the persisted result for a query is reused, Snowflake resets the 24-hour retention period for the result, up to a maximum of 31 days from the date and time that the query was first executed. After 31 days, the result is purged and the next time the query is submitted, a new result is generated and persisted.
Source: Adapted from community discussion — Zaaju
Which of the following statements is true of zero-copy cloning?
Answer: D
From: https://docs.snowflake.com/en/sql-reference/sql/create-clone.html -- If the COPY GRANTS keywords are used, then the new object inherits any explicit access privileges granted on the original table but does not inherit any future grants defined for the object type in the schema. If the COPY GRANTS keywords are not used, then the new object clone does not inherit any explicit access privileges granted on the original table but does inherit any future grants defined for the object type in the schema (using the GRANT … TO ROLE … ON FUTURE syntax). Answer: D
Source: Adapted from community discussion — [Removed]
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 781. 1323 questions available.
Version 1.0.0. How we source questions