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
A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?
Answer: A
https://docs.snowflake.com/en/sql-reference/operators-query INTERSECT Returns rows from one query’s result set which also appear in another query’s result set, with duplicate elimination.
Source: Adapted from community discussion — tennyalad
A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?
Answer: B
Similar to the other table types (transient and permanent), temporary tables belong to a specified database and schema; however, because they are session-based, they aren’t bound by the same uniqueness requirements. This means you can create temporary and non-temporary tables with the same name within the same schema. However, note that the temporary table takes precedence in the session over any other table with the same name in the same schema. https://docs.snowflake.com/en/user-guide/tables-temp-transient
Source: Adapted from community discussion — miomio123
Which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
Answer: A
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
Answer: C
What is the name of the SnowSQL file that can store connection information?
Answer: B
SnowSQL supports multiple configuration files that allow organizations to define base values for connection parameters, default settings, and variables while allowing individual users to customize their personal settings in their own /.snowsql/config files. https://docs.snowflake.com/en/user-guide/snowsql-config
Source: Adapted from community discussion — miomio123
Which of the following objects is not covered by Time Travel?
Answer: D
How do secure views compare to non-secure views in Snowflake?
Answer: A
Which type of join will list all rows in the specified table, even if those rows have no match in the other table?
Answer: D
When unloading data to an external stage, what is the MAXIMUM file size supported?
Answer: B
By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. 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. https://docs.snowflake.com/en/user-guide/data-unload-considerations#
Source: Adapted from community discussion — miomio123
How long does Snowflake retain information in the ACCESS_HISTORY view?
Answer: D
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 871. 1323 questions available.
Version 1.0.0. How we source questions