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: 38)

Page 37 of 287
PDF with 1268 Questions

What transformations are supported in a CREATE PIPE ... AS COPY `¦ FROM (`¦) statement? (Choose two.)

  1. Data can be filtered by an optional WHERE clause.
  2. Incoming data can be joined with other tables.
  3. Columns can be reordered.
  4. Columns can be omitted.
  5. Row level access can be defined.

Answer(s): C,D


Reference:

https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html



Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

  1. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
  2. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
  3. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
  4. A user cannot specify a default warehouse when using the ODBC driver.
  5. The default virtual warehouse size can be changed at any time.

Answer(s): C



Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

  1. INSERT
  2. PUT
  3. GET
  4. COPY

Answer(s): D


Reference:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html



The Snowflake Cloud Data Platform is described as having which of the following architectures?

  1. Shared-disk
  2. Shared-nothing
  3. Multi-cluster shared data
  4. Serverless query engine

Answer(s): C






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

SnowPro Core Discussions & Posts