CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. SnowPro Core

Free SnowPro Core Exam Braindumps (page: 76)

Page 76 of 287
PDF with 1167 Questions

What happens when an external or an internal stage is dropped? (Choose two.)

  1. When dropping an external stage, the files are not removed and only the stage is dropped.
  2. When dropping an external stage, both the stage and the files within the stage are removed.
  3. When dropping an internal stage, the files are deleted with the stage and the files are recoverable.
  4. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable.
  5. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable.

Answer(s): A,D



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?

  1. All data from all of the files on the stage will be appended to the table.
  2. Only data about new customers from the new files will be appended to the table.
  3. The operation will fail with the error UNCERTAIN FILES IN STAGE.
  4. All data from only the newly-added files will be appended to the table.

Answer(s): D



Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

  1. STRIP_NULL_VALUES
  2. SKIP_BYTE_ORDER_MARK
  3. REPLACE_INVALID_CHARACTERS
  4. VALIDATION_MODE

Answer(s): D



Which of the following SQL statements will list the version of the drivers currently being used?

  1. Execute SELECT CURRENT_ODBC_CLIENT(); from the Web UI
  2. Execute SELECT CURRENT_JDBC_VERSION(); from SnowSQL
  3. Execute SELECT CURRENT_CLIENT(); from an application
  4. Execute SELECT CURRENT_VERSION(); from the Python Connector

Answer(s): C



Page 76 of 287



Post your Comments and Discuss Snowflake SnowPro Core exam with other Community members:

Anonymous commented on January 09, 2025
Testing my Snowflake knowledge
INDIA
upvote

Anonymous commented on January 09, 2025
preparing for exam
INDIA
upvote

SM commented on January 07, 2025
preparing for exam
UNITED STATES
upvote

Nidhi commented on January 07, 2025
Preparing for exam
AUSTRALIA
upvote

Pankti commented on January 03, 2025
Thanks for sharing exam questions. These are really helpful for exam preparation.
UNITED STATES
upvote

hari commented on December 23, 2024
Preparing for exam
INDIA
upvote

DD commented on December 20, 2024
Preparing for exam
Anonymous
upvote

RJ commented on December 16, 2024
Preparing exam
UNITED STATES
upvote

Anonymous commented on December 12, 2024
Very helpful and reference link also has been given.
Anonymous
upvote

Anonymous commented on December 12, 2024
Preparing or certification
Anonymous
upvote

Pss wd commented on December 11, 2024
preparing for exam
Anonymous
upvote

Mishti commented on December 08, 2024
Preparing for certification
CANADA
upvote

Uday commented on December 08, 2024
Want to appear for snowpro core
Anonymous
upvote

Ramya commented on December 05, 2024
Preparing for snowflake certificate
Anonymous
upvote

Pallavi commented on November 20, 2024
Preparing for certification
EUROPEAN UNION
upvote

MANISH DURAISWAMY commented on November 07, 2024
Good Practices sessions
Anonymous
upvote

Rakesh Debnath commented on October 27, 2024
Nice sample questions
UNITED STATES
upvote

Maya commented on October 20, 2024
It would be great if all answers are supported by reference link.
UNITED KINGDOM
upvote

Maya commented on October 20, 2024
good material
UNITED KINGDOM
upvote

Sar commented on October 15, 2024
Nice exam dumps
Anonymous
upvote

Chalumuri Chandrasekhar commented on October 08, 2024
Preparation
INDIA
upvote

Saket commented on October 07, 2024
Q 60) Will data cached in a warehouse be lost when the warehouse is resized? I think B is correct answer. Refer - https://docs.snowflake.com/en/user-guide/warehouses-considerations Decreasing the size of a running warehouse removes compute resources from the warehouse. When the computer resources are removed, the cache associated with those resources is dropped, which can impact performance in the same way that suspending the warehouse can impact performance after it is resumed.
Anonymous
upvote

Moana commented on October 04, 2024
Preperation
Anonymous
upvote

Venkat commented on September 27, 2024
Preparing for certification
Anonymous
upvote

abhijeet commented on September 22, 2024
preparing for exam
Anonymous
upvote

Sgggggg commented on September 20, 2024
Exam preparation
Anonymous
upvote

Sajetha commented on September 12, 2024
Preparing for the exam
Anonymous
upvote

Parvesh commented on September 06, 2024
Preparing for exam
Anonymous
upvote

Chanpreet Singh commented on September 03, 2024
Starting with my Certification exam Questions Journey
UNITED STATES
upvote

Rahul Patil commented on August 23, 2024
Just started
UNITED STATES
upvote

Meena commented on August 21, 2024
Just started
Anonymous
upvote

Praveen Vijay commented on August 21, 2024
Just started
AUSTRALIA
upvote

Mohammed commented on August 21, 2024
One of the hardest exams I have ever faced. But thankfully it is behind me now. I passed it yesterday. These questions helped.
UNITED STATES
upvote

madheena commented on August 09, 2024
Just started
Anonymous
upvote