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
The is the minimum Fail-safe retention time period for transient tables?
Answer: D
https://docs.snowflake.com/en/user-guide/tables-temp-transient "Transient tables are similar to permanent tables with the key difference that they do not have a Fail-safe period."
Source: Adapted from community discussion — psilvabr
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
Answer: D
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Answer: AD
A. Data in the Snowflake Data Marketplace is already formatted and ready to query, and can be personalized for specific business needs. D. Data from the Snowflake Data Marketplace is accessed through Snowflake's Secure Data Sharing technology, which allows users to access the data without copying or moving it to their own account. B and C are incorrect statements. Loading data into a cloud provider as a consumer account is not required to leverage data from the Snowflake Data Marketplace, and the data can be accessed and used in a Snowflake account without restriction. E is also an incorrect statement. Data transformations may not be required when combining Data Marketplace datasets with existing data in Snowflake, as it depends on the specific data being used and how it needs to be combined or analyzed.
Source: Adapted from community discussion — bibisa
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Answer: CD
In general, the costs are proportional to: The number of materialized views created on each base table, and the amount of data that changes in each of those materialized views when the base table changes. Any changes to micro-partitions in the base table require eventual materialized view maintenance, whether those changes are due to reclustering or DML statements run on the base table. The number of those materialized views that are clustered. Maintaining clustering (of either a table or a materialized view) adds costs. https://docs.snowflake.com/en/user-guide/views-materialized.html#effects-of-changes-to-base-tables-on-materialized-views
Source: Adapted from community discussion — SV1122
In which layer of its architecture does Snowflake store its metadata statistics?
Answer: D
What COPY INTO SQL command should be used to unload data into multiple files?
Answer: D
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
Answer: D
Fully Qualified table reference means, specifying the table name like the below, . . . The questions says, the DB containing stored procedures and regular views (reason it was told a regular view is, for secure view the table cross reference across DB needs a REFERENCE GRANT) that have a fully qualified table references. If its a not a qualified name, then the Table will be looked into the current DB, which is the DB in which the cloned SP and Views are created.
Source: Adapted from community discussion — Rajivnb
When loading data into Snowflake, how should the data be organized?
Answer: A
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
Answer: AD
Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?
Answer: A
A: SHOW GRANTS OF ROLE shows who as been granted (Correct) B: SHOW GRANTS TO ROLE show privileges granted https://docs.snowflake.com/en/sql-reference/sql/show-grants.html
Source: Adapted from community discussion — miadiesel
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 401. 1323 questions available.
Version 1.0.0. How we source questions