We provide real SnowPro-Core exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Snowflake SnowPro-Core Exam quickly & easily. The SnowPro-Core PDF type is available for reading and printing. You can print more and practice many times. With the help of our Snowflake SnowPro-Core dumps pdf and vce product and material, you can easily pass the SnowPro-Core exam.

Online SnowPro-Core free questions and answers of New Version:

NEW QUESTION 1

How many resource monitors can be assigned at the account level?

  • A. 1
  • B. 2
  • C. 3
  • D. 4

Answer: A

NEW QUESTION 2

What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

  • A. Reader
  • B. Consumer
  • C. Vendor
  • D. Standard
  • E. Personalized

Answer: DE

NEW QUESTION 3

Which of the following objects is not covered by Time Travel?

  • A. Tables
  • B. Schemas
  • C. Databases
  • D. Stages

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

NEW QUESTION 4

Which of the following objects can be cloned? (Choose four.)

  • A. Tables
  • B. Named File Formats
  • C. Schemas
  • D. Shares
  • E. Databases
  • F. Users

Answer: ABCE

Explanation:
Which Objects Can Be Cloned?
Data Containment Objects. Databases. Schemas. Tables. Streams.
Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

NEW QUESTION 5

What is the recommended compressed file size range for continuous data loads using Snowpipe?

  • A. 8-16 MB
  • B. 16-24 MB
  • C. 10-99 MB
  • D. 100-250 MB

Answer: B

NEW QUESTION 6

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

  • A. The cloned views and the stored procedures will reference the cloned tables in the cloned database.
  • B. An error will occur, as views with qualified references cannot be cloned.
  • C. An error will occur, as stored objects cannot be cloned.
  • D. The stored procedures and views will refer to tables in the source database.

Answer: D

NEW QUESTION 7

What is true about sharing data in Snowflake? (Choose two.)

  • A. The Data Consumer pays for data storage as well as for data computing.
  • B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
  • C. A Snowflake account can both provide and consume shared data.
  • D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
  • E. The Data Consumer pays only for compute resources to query the shared data.

Answer: BC

NEW QUESTION 8

Which formats does Snowflake store unstructured data in? (Choose two.)

  • A. GeoJSON
  • B. Array
  • C. XML
  • D. Object
  • E. BLOB

Answer: DE

NEW QUESTION 9

In which layer of its architecture does Snowflake store its metadata statistics? Select one.

  • A. Storage Layer
  • B. Compute Layer
  • C. Database Layer
  • D. Cloud Service Layer

Answer: D

Explanation:
Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

NEW QUESTION 10

A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

  • A. The primary duster in the virtual warehouse
  • B. The entire Virtual Warehouse
  • C. The database the Virtual Warehouse resides in
  • D. The queries currently being run by the Virtual Warehouse

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

NEW QUESTION 11

Fail-safe is unavailable on which table types?

  • A. Temporary
  • B. Transient
  • C. Provisional
  • D. Permanent

Answer: AB

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

NEW QUESTION 12

Which of the following best describes where Snowflake’s metadata is stored?

  • A. Within the data files
  • B. Inside the Virtual Warehouses
  • C. In the Cloud Services Layer
  • D. within the drivers

Answer: C

NEW QUESTION 13

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

  • A. True
  • B. False

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/connecting.html

NEW QUESTION 14

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

  • A. JDBC
  • B. SnowSQL
  • C. Snowflake Web Interface (UI)
  • D. ODBC
  • E. PythonD18912E1457D5D1DDCBD40AB3BF70D5D

Answer: ABCDE

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

NEW QUESTION 15

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

  • A. True
  • B. False

Answer: A

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

NEW QUESTION 16
......

100% Valid and Newest Version SnowPro-Core Questions & Answers shared by Allfreedumps.com, Get Full Dumps HERE: https://www.allfreedumps.com/SnowPro-Core-dumps.html (New 605 Q&As)