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 user executes the following SQL query: create table SALES_BKP like SALES; What are the cost implications for processing this query?
Answer: C
Snowflake SQL provides “CREATE TABLE LIKE” statement to create a new table with just the structure of the existing table without copying the data. So I think it's C
Source: Adapted from community discussion — halol
True or False: A single database can exist in more than one Snowflake account.
Answer: B
A database is a logical grouping of schemas. Each database belongs to a single Snowflake account. A schema is a logical grouping of database objects (tables, views, etc.). Each schema belongs to a single database.
Source: Adapted from community discussion — Sundarr
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
Answer: A
I believe the correct answer is A. REFRESH is a parameter for ALTER PIPE https://docs.snowflake.com/en/sql-reference/sql/alter-pipe.html It is NOT a parameter for CREATE [OR REPLACE] Pipe. https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html Further recreating a pipe resets history: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#label-snowpipe-management-recreate-pipes "Load History The load history for Snowpipe operations is stored in the metadata of the pipe object. When a pipe is recreated, the load history is dropped. In general, this condition only affects users if they subsequently execute an ALTER PIPE … REFRESH statement on the pipe. Doing so could load duplicate data from staged files in the storage location for the pipe if the data was already loaded successfully and the files were not deleted subsequently."
Source: Adapted from community discussion — jjordan
What is the maximum length of time travel available in the Snowflake Standard Edition?
Answer: A
What happens when an external or an internal stage is dropped? (Choose two.)
Answer: AD
For an internal stage, all of the files in the stage are purged from Snowflake, regardless of their load status. This prevents the files from continuing to using storage and, consequently, accruing storage charges. However, this also means that the staged files cannot be recovered after a stage is dropped. For an external stage, only the stage itself is dropped; any data files in the referenced external location (Amazon S3, Google Cloud Storage, or Microsoft Azure) are not removed. https://docs.snowflake.com/en/sql-reference/sql/drop-stage.html#drop-stage
Source: Adapted from community discussion — SV1122
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my_table FROM @my_stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files. If the user runs the same COPY INTO command what will happen?
Answer: D
Copy into not reload the same file more times if you don't set force = true https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#reloading-files - Reloading Files Add FORCE = TRUE to a COPY command to reload (duplicate) data from a set of staged data files that have not changed (i.e. have the same checksum as when they were first loaded).
Source: Adapted from community discussion — BigDataBB
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Answer: D
VALIDATION_MODE: This instructs the command to validate the data files instead of loading them into target tables and allows you to perform the dry run to ensure the fail-safe delivery of data.Dec
Source: Adapted from community discussion — SV1122
Which of the following SQL statements will list the version of the drivers currently being used?
Answer: C
Which Snowflake technique can be used to improve the performance of a query?
Answer: A
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
Answer: C
Once a database is created (in a consumer account) from a share, all the shared objects are accessible to users in the consumer account: https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#what-is-a-share
Source: Adapted from community discussion — miadiesel
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 481. 1323 questions available.
Version 1.0.0. How we source questions