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 will be the output of the below query against the table name gold_data? select * from gold_data tablesample (100);
Answer: C
Correct answer is : C https://docs.snowflake.com/en/sql-reference/constructs/sample Return an entire table, including all rows in the table: SELECT * FROM testtable TABLESAMPLE (100);
Source: Adapted from community discussion — bar_ser
Select the different types of Internal Stages: (Choose three.)
Answer: ABC
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
Answer: C
Answer should be C (14 days) As per docs - Query History page available under Activity Menu on Web UI, holds query data for 14 days. And you can Query_history view available in Account_Usage schema holds query data for 365 days https://docs.snowflake.com/en/user-guide/ui-snowsight-activity#query-history https://docs.snowflake.com/en/sql-reference/account-usage/query_history
Source: Adapted from community discussion — Prajdeo
A Snowflake query took 40 minutes to run. The results indicate that ‘Bytes spilled to local storage’ was a large number. What is the issue and how can it be resolved?
Answer: B
What is the MOST efficient way to load streaming data into Snowflake?
Answer: B
The MOST efficient way to load streaming data into Snowflake is to use Snowpipe (option B). Snowpipe is a native, automated data ingestion service within Snowflake that can continuously load data from various sources in near real-time.
Source: Adapted from community discussion — junpal
Which COPY INTO statement accurately describes how to unload data from a Snowflake table?
Answer: C
"You can use the OBJECT_CONSTRUCT function combined with the COPY command to convert the rows in a relational table to a single VARIANT column and unload the rows into a file." https://docs.snowflake.com/en/user-guide/data-unload-considerations
Source: Adapted from community discussion — OTE
What command is used to download data from a Snowflake stage?
Answer: C
GET Downloads data files from one of the following Snowflake stages to a local directory/folder on a client machine: Named internal stage. Internal stage for a specified table. Internal stage for the current user. Typically, this command is executed after using the COPY INTO command to unload data from a table into a Snowflake stage.
Source: Adapted from community discussion — MultiCloudIronMan
By default, which role has privileges to create tables and views in an account?
Answer: C
What does Snowflake recommend as a best practice for using secure views?
Answer: D
The correct answer is D. Do not expose the sequence-generated column(s). Snowflake recommendation: 1) Do not expose the sequence-generated column as part of the view. 2) Use randomized identifiers (e.g. generated by UUID_STRING) instead of sequence-generated values. 3) Programmatically obfuscate the identifiers. https://docs.snowflake.com/en/user-guide/views-secure#sequence-generated-columns
Source: Adapted from community discussion — BobFar
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
Answer: A
Temporary and Transient Tables¶ To help manage the storage costs associated with Time Travel and Fail-safe, Snowflake provides two table types, temporary and transient, which do not incur the same fees as standard (i.e. permanent) tables: Transient tables can have a Time Travel retention period of either 0 or 1 day. Temporary tables can also have a Time Travel retention period of 0 or 1 day; however, this retention period ends as soon as the table is dropped or the session in which the table was created ends. Transient and temporary tables have no Fail-safe period. As a result, the maximum
Source: Adapted from community discussion — MultiCloudIronMan
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 811. 1323 questions available.
Version 1.0.0. How we source questions